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
Stand-ins for TQQQ — ProShares UltraPro QQQ
| Substitute | Correlation | Book overlap | Fee vs TQQQ | Assets | Wash-sale read | |
|---|---|---|---|---|---|---|
| MGC Vanguard Mega Cap Index Fund | 0.943 | — | -81bp | $6B | different index | Compare |
| VOO Vanguard 500 Index Fund | 0.931 | — | -85bp | $500.4B | different index | Compare |
| SPY SPDR S&P 500 ETF Trust | 0.929 | — | -79bp | $818.3B | different index | Compare |
| VTI Vanguard Total Stock Market Index Fund | 0.922 | — | -85bp | $428.1B | different index | Compare |
| TMFC MOTLEY FOOL 100 INDEX ETF | 0.910 | — | -88bp | $958M | different index | Compare |
| SPYI NEOS S&P 500(R) HIGH INCOME ETF | 0.877 | — | -88bp | $1.8B | 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