ETF overlap calculator: how much do your funds hold in common?
Choose two to four ETFs to see how much of them is the same securities in the same proportions, how many holdings they share and which large ones. The holdings come from each fund’s own report, with its date.
Funds to compare (2 to 4)
| VOO | QQQ | |
|---|---|---|
| VOO | — | |
| QQQ | — |
Overlap by weight. Tap a cell for the holdings two funds have in common.
VOO and QQQ: 49.3% overlap by weight
85 holdings appear in both. They are 49.3% of VOO (504 holdings compared) and 94.7% of QQQ (104).
| Holding in common | In VOO | In QQQ |
|---|---|---|
| Apple Inc | 7.59% | 9.52% |
| NVIDIA Corp | 6.61% | 7.96% |
| Microsoft Corp | 6.28% | 7.68% |
| Amazon.com Inc | 4.12% | 5.81% |
| Meta Platforms Inc | 2.56% | 3.79% |
| Tesla Inc | 2.26% | 2.76% |
| Alphabet Inc | 2.22% | 2.59% |
| Broadcom Inc | 2.17% | 4.01% |
| Alphabet Inc | 1.82% | 2.48% |
| Costco Wholesale Corp | 0.81% | 2.98% |
| Netflix Inc | 0.76% | 2.68% |
| Cisco Systems Inc | 0.47% | 1.63% |
| PepsiCo Inc | 0.42% | 1.35% |
| Linde PLC | 0.40% | 1.42% |
| Advanced Micro Devices Inc | 0.39% | 1.04% |
- VOO: 506 holdings, report of Dec 2024.
- QQQ: 104 holdings, report of Feb 2025 (holdings of QQQM, same index).
Overlap of popular ETF pairs
| Pair | Overlap by weight | Holdings in common | Reports |
|---|---|---|---|
| VOO vs VTI | 86.0% | 501 | Dec 2024 · Mar 2025 |
| VOO vs IVV | 82.0% | 469 | Dec 2024 · Jun 2026 * |
| SPY vs VOO | 82.0% | 469 | Jun 2026 · Dec 2024 * |
| VTI vs ITOT | 76.5% | 855 | Mar 2025 · Jun 2026 * |
| VOO vs QQQ | 49.3% | 85 | Dec 2024 · Feb 2025 |
| SPY vs QQQ | 49.0% | 88 | Jun 2026 · Feb 2025 * |
| BND vs AGG | 41.6% | 445 | — · May 2025 |
| VOO vs SCHD | 7.2% | 44 | Dec 2024 · Feb 2025 |
| TLT vs IEF | 1.1% | 1 | Aug 2026 · Aug 2026 |
| IEF vs TIP | 0.9% | 1 | Aug 2026 · Jul 2026 |
| TLT vs SHY | 0.7% | 1 | Aug 2026 · Aug 2026 |
| IEF vs SHY | 0.7% | 1 | Aug 2026 · Aug 2026 |
| SPY vs TLT | 0.1% | 1 | Jun 2026 · Aug 2026 |
Each fund’s latest available report; SPY and QQQ through IVV and QQQM, which track the same indexes. * Reports more than three months apart: weights and constituents change over time, so part of the difference comes from the dates. Source: the fund's Form N-PORT portfolio report filed with the SEC, via MarketStack.
How overlap is measured
For every security held by both funds the calculator takes the smaller of its two weights, and adds them up:
overlap = Σ min(weight in A, weight in B)
If one fund holds a company at 7% and the other at 3%, that company adds 3% to the overlap. The result is the share of each fund that could be swapped for the other without changing anything. Two further figures complete the picture: how much of each fund is in securities the other also owns, whatever their weight, and the number of holdings in common.
Among the pairs above, the overlap ranges from 0.1% (SPY and TLT) to 86.0% (VOO and VTI).
Securities are matched by ISIN, the code that identifies each security, so two share classes of the same company count as different holdings. Very large funds report thousands of holdings; the calculator compares the 1,000 largest of each, which covers almost all of an equity fund and says how much when it does not.
ETF overlap: questions
What is ETF overlap?
ETF overlap is the part of two funds made of the same securities. Measured by weight, it is the sum, over the holdings both funds own, of the smaller of the two weights: 100% means identical portfolios, 0% means nothing in common.
How do I use the ETF overlap calculator?
Choose two to four ETFs. The calculator shows the overlap by weight for each pair; tap a pair to see how many holdings they share, what share of each fund those holdings are, and the largest ones they have in common.
Where do the holdings come from?
From the fund's Form N-PORT portfolio report filed with the SEC, via MarketStack. US funds file it monthly and it is published with a delay, so the holdings are those of the latest report available, whose date is shown for each fund. European-listed funds are not covered.
Which popular ETF pair overlaps the most?
Among the pairs in the table, VOO and VTI overlap the most: 86.0% by weight, with 501 holdings in common.
Is a high overlap bad?
Not in itself: it means the two funds give you largely the same exposure. It matters when you hold both expecting diversification, or when the overlap concentrates the portfolio in a few large companies held through several funds.
Why do SPY and QQQ show the holdings of another fund?
SPY and QQQ are unit investment trusts and do not file the portfolio report these figures come from. The calculator uses IVV for SPY and QQQM for QQQ: each tracks the same index, so the holdings are very close, and the page says so.
More free tools
Source: Holdings: the fund's Form N-PORT portfolio report filed with the SEC, via MarketStack. Figures are historical and descriptive; they are not forecasts and not investment advice. MEDGE Capital does not recommend buying or selling any instrument. Risk disclaimer.