You own five ETFs. You think you're diversified. But what if 60% of your money is sitting in the same 10 stocks?
This is the ETF overlap problem — and it's far more common than most investors realize. If you hold SPY and VOO, for example, you essentially own the same fund twice. If you hold QQQ alongside a growth ETF like VUG, you're doubling down on the same mega-cap tech names.
An ETF overlap tool makes this invisible risk visible in seconds. In this guide, we'll show you exactly how to find and fix portfolio overlap — and introduce a free ETF overlap calculator that does the heavy lifting for you.
What Is ETF Overlap?
ETF overlap occurs when two or more ETFs in your portfolio hold the same underlying stocks. Since most ETFs track broad indices, this happens more often than you'd expect.
Here's a quick example:
| ETF Pair | Approximate Overlap |
|---|---|
| SPY & VOO | ~99% (both track S&P 500) |
| QQQ & VGT | ~75% (tech-heavy overlap) |
| VTI & SPY | ~80% (S&P 500 is a subset of total market) |
| SCHD & VYM | ~40% (both dividend-focused) |
When overlap is high, you're concentrating risk rather than spreading it. You're also paying two expense ratios for what is essentially one position.
Why ETF Portfolio Overlap Matters
Concentration Risk
If Apple makes up 7% of three different ETFs you own, your actual Apple exposure could be 15-20% of your total portfolio. A single stock's bad earnings report hits you three times as hard.
False Diversification
Owning 5 ETFs with 80% overlap is not meaningfully different from owning 1 ETF. You feel diversified, but the math says otherwise.
Unnecessary Costs
Every ETF charges an expense ratio. If two funds hold the same stocks, you're paying double fees for duplicate exposure. Even small differences — 0.03% vs 0.09% — compound over decades.
Tax Inefficiency
Overlapping positions can create wash sale complications if you're harvesting tax losses. Selling one ETF at a loss while holding a substantially identical one in another ETF can invalidate the deduction. Our ETF tax harvesting tool can help identify these situations.
How to Compare ETF Holdings and Find Overlap
Step 1: Pick Your ETFs
Start with the ETFs you currently own. Common combinations that create hidden overlap:
- S&P 500 + Total Market (SPY + VTI): ~80% overlap because the S&P 500 makes up the bulk of the total US market
- Nasdaq 100 + Tech Sector (QQQ + VGT): ~75% overlap since QQQ is already tech-dominated
- Multiple dividend ETFs (SCHD + VYM + DVY): 30-50% overlap in dividend aristocrats
Step 2: Use an ETF Overlap Calculator
Manually comparing holdings across ETFs is tedious. Each ETF can hold hundreds or thousands of stocks. That's why tools exist.
The MarketXLS ETF Overlap Calculator lets you:
- Compare any two ETFs instantly from a database of 3,300+ funds
- See exact overlap percentage based on shared holdings
- View the overlapping stocks with their weight in each fund
- Identify concentration risks before they become problems
Just enter two ticker symbols and get results in seconds — no signup required.
Step 3: Evaluate the Results
Here's how to interpret overlap percentages:
- 0-20% overlap: Good diversification. These ETFs complement each other well.
- 20-50% overlap: Moderate. Worth reviewing, but may be acceptable depending on your strategy.
- 50-80% overlap: High. You're paying for significant duplication. Consider consolidating.
- 80%+ overlap: Essentially the same fund. Drop one and save on fees.
Real-World Example: Auditing a 4-ETF Portfolio
Let's say you hold this common portfolio:
- VOO (Vanguard S&P 500) — 40%
- QQQ (Nasdaq 100) — 25%
- VGT (Vanguard Info Tech) — 20%
- VTI (Vanguard Total Market) — 15%
Running these through the ETF overlap calculator:
- VOO vs VTI: ~80% overlap. VTI contains all of VOO plus small/mid-caps.
- QQQ vs VGT: ~75% overlap. Both are dominated by Apple, Microsoft, Nvidia.
- VOO vs QQQ: ~40% overlap. The top QQQ holdings are also top S&P 500 holdings.
The result? Your "4-fund portfolio" is really a tech-heavy bet on the same 20 mega-cap stocks. Apple alone might represent 12-15% of your combined holdings.
The fix: Replace VGT (it's redundant with QQQ), reduce VOO or VTI to one position, and add a truly uncorrelated asset — international stocks (VXUS), bonds (BND), or a small-cap value fund (VBR).
Common ETF Pairs and Their Overlap
Here are frequently combined ETFs and what you should know:
Nearly Identical (80%+)
- SPY vs VOO vs IVV: All track the S&P 500. Pick the cheapest (VOO at 0.03%).
- QQQ vs QQQM: Same index, QQQM is cheaper. No reason to hold both.
High Overlap (50-80%)
- VTI vs VOO: Total market includes S&P 500. VTI gives you small/mid-cap exposure too.
- QQQ vs VGT: Heavy tech overlap. QQQ adds consumer discretionary (Amazon, Tesla).
Moderate Overlap (20-50%)
- SPY vs SCHD: Some overlap in large-cap dividend payers, but different strategies.
- QQQ vs ARKK: Some growth overlap, but ARKK is more speculative.
Low Overlap (Under 20%)
- SPY vs VXUS: Domestic vs international — minimal overlap.
- QQQ vs BND: Equities vs bonds — zero overlap.
Want to check a specific pair? Use the ETF overlap tool to get exact numbers.
Beyond Overlap: Comparing ETFs Head-to-Head
Once you've identified overlap, you need to decide which fund to keep. That requires a deeper comparison of expense ratios, returns, volatility, and holdings weight.
Our ETF comparison tool lets you compare any two ETFs side-by-side across all these metrics. For example, comparing SPY vs QQQ shows you exactly where they differ beyond just holdings overlap.
If you're not sure which ETFs to compare, start with the ETF screener to filter 3,300+ ETFs by category, expense ratio, returns, and more.
ETF Overlap for Mutual Fund Investors
If you hold mutual funds — or a mix of ETFs and mutual funds — overlap is equally important. Many mutual funds track the same indices as popular ETFs.
For example, VFIAX (Vanguard 500 Index Admiral) holds the exact same stocks as VOO. If you own both in different accounts, you have 100% overlap.
Use the Mutual Fund Overlap Calculator to check overlap between mutual funds, or between a mutual fund and an ETF.
How to Fix ETF Portfolio Overlap
Once you've identified overlap, here's your action plan:
1. Consolidate Duplicate Positions
If two ETFs overlap by 80%+, keep the one with the lower expense ratio and sell the other.
2. Replace Overlapping Funds with Complements
Instead of holding three US large-cap funds, swap one for international (VXUS), bonds (BND), or REITs (VNQ).
3. Use a Core-Satellite Approach
Hold one broad market ETF as your core (VTI or VOO), then add satellite positions in truly different asset classes or strategies.
4. Recheck Quarterly
Holdings change. New stocks enter indices, weights shift. Run the ETF overlap calculator every quarter to stay on track.
Explore More FundXLS Tools
- ETF Comparison Tool — Compare any two ETFs side-by-side on returns, fees, holdings, and risk metrics
- Mutual Fund Comparison Tool — Check overlap and compare mutual funds the same way
- Fund Overlap Calculator — Works for both ETFs and mutual funds to catch hidden portfolio duplication
- Mutual Fund Screener — Filter 7,000+ mutual funds by performance, fees, category, and more
Start Finding Overlap in Your Portfolio
Hidden ETF overlap is one of the easiest portfolio problems to fix — once you can see it. Most investors have no idea how much duplication they're carrying until they check.
Try the free ETF Overlap Calculator →
Enter any two ETF tickers and get instant overlap analysis. No signup, no cost — just clarity on what you actually own.
