RebalancingFlow: see what the big preferred ETFs are doing in your names

By Filip Madzharov, CAIA · · 4 min read

First published in Heard on the Trading Floor

Preferred stocks are a strange corner of the market. Hundreds of issues, most of them $25 par, many trading a few tens of thousands of shares a day. And a handful of ETFs (PFF, PGX, FPE, PFFA, PFFD, PFXF, VRP) that between them hold a large share of the float in a lot of those names.

When one of those funds trims a position, adds a new issue, or drops one on an index change, it doesn’t happen in a single print. It happens over days, in size that dwarfs the normal tape. If you’re on the other side of that without knowing it, you watch your position drift for no visible reason and go looking for news that doesn’t exist.

The odd thing is that the information is public. Every one of these funds publishes its full holdings, daily, on the issuer’s website. Almost nobody diffs those files day over day. So I built something that does.

What Flow Desk does

rebalancingflow.ofmcapital.com

. Free, no login.

  • Pulls each fund’s published holdings file, hourly, and more often around the time issuers usually publish.

  • Diffs the latest file against the previous reporting date.

  • Shows every change: increases, decreases, brand-new positions, full removals. For each row: quantity change, estimated notional, and the change as a percentage of the fund’s position.

  • Puts a link to the issuer’s source file on every row, so you verify the number yourself rather than trust mine.

You can look at a single day or step back through the calendar (history runs back to January). You can view all changes across all funds, only new and removed positions, activity aggregated across ETFs, or fund by fund.

How I actually use it

Three things, mostly.

  1. Check my own names. If I hold a thinly traded preferred and PFF has been cutting it by 0.2% of the position every day for a week, that’s steady supply I’m competing with. It changes how I exit, or whether I add.

  2. Watch “New & removed”. A new position is usually an index addition or a new issue getting picked up. A removal is usually a deletion, a call, or a maturity. Either way, the flow tends to run ahead of the price fully adjusting.

  3. Use “Across ETFs” to separate index from fund. If three funds are selling the same name on the same day, that’s mechanical and index-driven. If only one is, it’s a fund-specific decision and worth thinking about differently.

Who this is for

  • Smaller preferred and baby bond holders who don’t have a desk feeding them flow and are currently trading blind against passive money.

  • Preferred and hybrid desk traders and market makers sizing around rebalance dates and creation/redemption activity.

  • Income, CEF and fund managers who want to know what is entering and leaving the indices their benchmarks track.

  • Quants and researchers who want a clean daily holdings-change dataset for this corner of the market. Nobody sells this cheaply.

What it isn’t

It’s a side project. It was built quickly and the code is, to put it kindly, vibe-coded. The tool only knows what the issuers publish, which is typically the previous day’s book, and issuer files are occasionally late or wrong. Nothing on the site is investment advice. If a row matters to your P&L, click the evidence link and check the source.

Where I’d like to take it, and with whom

I didn’t build this to sell it. I built it because I wanted it, and I’m publishing it because I think a lot of people in this corner may find it useful.

I’m happy to open-source the code and develop this with anyone who trades preferreds, builds tools, or both. Some things I’d like help thinking about:

  • Alerts: get pinged when a name on your watchlist shows up in a fund’s changes.

  • Index rebalance calendars and projected adds/deletes ahead of the event.

  • Matching flow to price and volume impact: how much of a day’s volume was one fund?

  • Export and API for people who want to run their own analysis.

  • Whatever I haven’t thought of. The best ideas will come from people using it for something I didn’t intend.

If you’re interested, reply, DM me, or email me. Ideas, bug reports, feature requests, code, all welcome. If enough people care, this can become a proper community tool that helps everyone from a retail holder with three positions to a desk running a book.

rebalancingflow.ofmcapital.com

This is OFM Capital’s own research, published for information only. It is not investment advice or an offer of any kind. We may hold positions in the securities mentioned.