XRT
SPDR S&P Retail ETF
stock NYSE ETF

OP, I've been following your stuff. I've come to the concern that *ONLY* knowing what was created/redeemed at the *END OF THE DAY* may be how they are hiding a lot!

Your spreadsheet (and Richard Newton's) shows how much excess creation or redemption, one or the other, was in excess at the end of the day but maybe there were a lot more creations/redemptions in the middle of the day, see?
man boobs and regional formal have both discussed the rate of creation/redemption within a day as much higher. They look at creation units/day from [https://www.etf.com/XRT](https://www.etf.com/XRT) \> Tradability. The value is currently creation units/day = 135. If you take a creation unit size of 50,000 shares at a time, that is 6.75m shares/day. If the end of day "outstanding" number has 1m creations more than the day before, perhaps that is really 6.75m creations AND 5.75m redemptions that happened during the day that didn't show up at EOD. Each of those creations may have been "like kind" and the redemptions are used as locates.
I'm trying to find the historical value of creation unit/day if you may know where to find it. You seem to be well versed! 😇 It's probably not there (surprise!) and maybe just daily volume will help.
enjoy the weekend!

OP, I've been following your stuff. I've come to the concern that *ONLY* knowing what was created/redeemed at the *END OF THE DAY* may be how they are hiding a lot!

Your spreadsheet (and Richard Newton's) shows how much excess creation or redemption, one or the other, was in excess at the end of the day but maybe there were a lot more creations/redemptions in the middle of the day, see?
man boobs and regional formal have both discussed the rate of creation/redemption within a day as much higher. They look at creation units/day from [https://www.etf.com/XRT](https://www.etf.com/XRT) \> Tradability. The value is currently creation units/day = 135. If you take a creation unit size of 50,000 shares at a time, that is 6.75m shares/day. If the end of day "outstanding" number has 1m creations more than the day before, perhaps that is really 6.75m creations AND 5.75m redemptions that happened during the day that didn't show up at EOD. Each of those creations may have been "like kind" and the redemptions are used as locates.
I'm trying to find the historical value of creation unit/day if you may know where to find it. You seem to be well versed! 😇 It's probably not there (surprise!) and maybe just daily volume will help.
enjoy the weekend!