ETF PROAI

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

Fund to harvestTry:IVVQQQAGG
Stand-ins for VNQ — Vanguard Real Estate Index Fund
SubstituteCorrelationBook overlapFee vs VNQAssetsWash-sale read
USRT iShares Core U.S. REIT ETF0.95768%-4bp$3.7Bdifferent indexCompare
XLRE State Street Real Estate Select Sector SPDR ETF0.98060%-3bp$7.7Bdifferent indexCompare
REET iShares Global REIT ETF0.92762%+2bp$4.7Bdifferent indexCompare
FREL Fidelity MSCI Real Estate Index ETF0.981—-4bp$1Bdifferent indexCompare
SCHH Schwab U.S. REIT ETF0.977—-5bp$7.3Bdifferent indexCompare
DFAR Dimensional US Real Estate ETF0.964—-12bp$1.2Bdifferent indexCompare

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-10-02 (1,104 funds with dated records). Fund details retrieved: 2026-09-02 to 2026-10-04. Data dates vary by fund; these are not live quotes. Flow totals include available records only; missing coverage is not evidence of zero flow.

THE DESK BRIEF

Flows, fee cuts, and closure risk on the funds you watch — every trading morning.