Tax-Loss Harvest Finder
Sell the loss, keep the exposure. For any fund, ranked stand-ins that track the same market — scored on a year of price correlation, holdings overlap, and fee — with a flag when two funds follow the same index and a swap could look substantially identical.
Correlation computed on ~250 shared sessions per pair · not tax advice — the flag is a heuristic, your compliance desk has the final word
| Substitute | Correlation | Book overlap | Fee vs QYLD | Assets | Wash-sale read | |
|---|---|---|---|---|---|---|
| MGC Vanguard Mega Cap Index Fund | 0.813 | 58% | -54bp | $6B | different index | Compare |
| XLK Technology Select Sector SPDR Fund | 0.809 | 58% | -52bp | $127.3B | different index | Compare |
| DYNF BLACKROCK US EQUITY FACTOR ROTATION ETF | 0.822 | 54% | -61bp | $42B | different index | Compare |
| SPY SPDR S&P 500 ETF Trust | 0.807 | 55% | -52bp | $809.2B | different index | Compare |
| VV Vanguard Morningstar Large-Cap ETF | 0.809 | 54% | -57bp | $37.4B | different index | Compare |
| VOO Vanguard 500 Index Fund | 0.810 | 53% | -58bp | $500.4B | different index | Compare |
RANKED BY CORRELATION, FEE, AND OVERLAP · “SAME INDEX” PAIRS ARE FLAGGED BECAUSE THE IRS HAS NEVER DEFINED “SUBSTANTIALLY IDENTICAL” — MOST DESKS TREAT SAME-INDEX SWAPS AS OFF-LIMITS AND DIFFERENT-INDEX SWAPS AS DEFENSIBLE
Cached coverage for 2,133 funds. Latest price/flow record dates: 2024-08-23 to 2026-09-30 (1,104 funds with dated records). Fund details retrieved: 2026-09-02 to 2026-10-02. Data dates vary by fund; these are not live quotes. Flow totals include available records only; missing coverage is not evidence of zero flow.