Right. My bad.

My version of it would have given you wrong results as it would have started at 0 whenever the date changed.

Good job figuring...

Have you tried using partition by in your second one instead of order by? That is:

SUM(Quantity) OVER (PARTITION BY EffectiveDate ORDER BY Holder RANGE UNBOUNDED PRECEDING) AS TQuantity

you may...