Fund Overlap Tool: Why Hidden Portfolio Overlap Is Costing You Money

M
MarketXLS Team
Published
Fund overlap tool showing hidden portfolio duplication

Here's something most investors never check: how much of their portfolio is the same stocks held through different funds.

You might own 6 funds and think you're well-diversified. But if those funds share 60% of the same holdings, you're essentially paying 6 expense ratios for a portfolio that behaves like 2 or 3 funds.

This is portfolio overlap — and it's one of the most common, most expensive, and easiest-to-fix mistakes in investing. A fund overlap tool reveals it in seconds.

What Is Fund Overlap?

Fund overlap happens when two or more funds in your portfolio hold the same underlying securities. It applies to both ETFs and mutual funds.

Some overlap is obvious:

  • VOO and VFIAX are the same portfolio (S&P 500), just different wrappers
  • SPY and IVV track the same index from different providers

But much overlap is hidden:

  • VTI (total market) contains all of VOO (S&P 500) within it — about 80% overlap
  • QQQ (Nasdaq 100) overlaps ~40% with SPY because the biggest Nasdaq stocks are also in the S&P 500
  • FXAIX (Fidelity S&P 500) and VTSAX (Vanguard Total Market) share about 80% of holdings

Without a fund overlap calculator, you'd need to manually compare hundreds of holdings line by line. That's why tools exist.

The Real Cost of Fund Overlap

You're Paying Multiple Fees for the Same Stocks

If Apple is in 4 of your 6 funds, you're paying 4 expense ratios on that Apple position. Even at low-cost index fund rates, this adds up across your entire portfolio.

Your Risk Is Concentrated, Not Diversified

The whole point of owning multiple funds is diversification. But if they all hold the same top 20 stocks, a downturn in those stocks hits every fund simultaneously. Your "diversified" portfolio drops as if it were one concentrated bet.

Tax Harvesting Gets Complicated

Selling one fund at a loss while holding a substantially identical fund triggers wash sale rules, invalidating your tax deduction. The more overlap between your funds, the harder it is to harvest losses cleanly.

The ETF tax harvesting tool and mutual fund tax harvesting tool can help navigate these situations.

How to Check Fund Overlap

For ETFs

Use the ETF Overlap Calculator:

  1. Enter two ETF tickers (e.g., SPY and QQQ)
  2. Get instant overlap percentage
  3. See which stocks are shared and their weights in each fund

The tool covers 3,300+ ETFs and works instantly — no account required.

For Mutual Funds

Use the Mutual Fund Overlap Calculator:

  1. Enter two mutual fund tickers (e.g., VFIAX and VTSAX)
  2. Get the same detailed overlap analysis
  3. Works across 7,000+ mutual funds

For Mixed Portfolios (ETFs + Mutual Funds)

Many investors hold both — maybe ETFs in a taxable brokerage and mutual funds in a 401k. Both overlap calculators can help you check across fund types.

Real-World Overlap Examples

Let's audit a common portfolio:

The "set it and forget it" portfolio:

  • VTSAX (Vanguard Total Stock Market) — IRA
  • VOO (Vanguard S&P 500 ETF) — Taxable
  • FXAIX (Fidelity 500 Index) — 401k
  • QQQ (Nasdaq 100 ETF) — Taxable

Overlap analysis:

PairOverlap
VTSAX vs VOO~80%
VOO vs FXAIX~99%
VTSAX vs FXAIX~80%
QQQ vs VOO~40%

The verdict: Three of four funds are essentially the same thing (large-cap US equities). This investor thinks they have 4 diversified positions. In reality, they have one large-cap US bet and a tech-heavy tilt.

The fix:

  1. Pick one S&P 500 / total market fund across all accounts
  2. Replace duplicates with truly different asset classes:
    • International stocks (VXUS or VTIAX)
    • Bonds (BND or VBTLX)
    • Small-cap value (VBR or VSIAX)
    • REITs (VNQ)

A Framework for Interpreting Overlap

Overlap %What It MeansAction
0-15%Excellent diversificationKeep both funds
15-30%Good complementAcceptable for most portfolios
30-50%Moderate overlapReview — is the overlap intentional?
50-75%High overlapLikely redundant — consider consolidating
75%+Near-duplicateDefinitely redundant — drop one

Common Sources of Unintentional Overlap

Multiple Accounts, Same Strategy

Your 401k, IRA, and taxable account each have a "large-cap US" fund. Together, they triple your exposure to the same stocks.

Solution: Treat all accounts as one portfolio. Use different asset classes in different accounts based on tax efficiency.

"Diversifying" Within the Same Category

Owning 3 dividend ETFs (SCHD + VYM + DVY) feels diversified but creates 30-50% overlap. These funds all fish in the same pond of dividend-paying large-caps.

Solution: Pick the one dividend fund you like best. Add diversification through different categories, not more funds in the same category. Use the ETF comparison tool to pick the winner.

Target-Date Funds + Individual Funds

If your 401k has a target-date fund (which already holds US stocks, international stocks, and bonds), adding an S&P 500 fund on the side creates significant overlap with the equity portion of the target-date fund.

Solution: Either use the target-date fund exclusively, or build your own allocation from scratch. Don't mix both.

Total Market + S&P 500

VTI and VOO overlap about 80% because the S&P 500 constitutes the vast majority of the total US market by capitalization. You're not getting much additional diversification from the extra small and mid-cap stocks.

Solution: Pick one. VTI if you want the small/mid-cap exposure. VOO if you want pure large-cap.

How to Build a Low-Overlap Portfolio

A well-constructed portfolio should have minimal overlap between positions. Here's an example:

AllocationFundOverlap With Others
40% US Large-CapVTICore position
20% InternationalVXUS<5% overlap with VTI
15% US BondsBND0% overlap with equity
10% Small-Cap ValueVBR~15% overlap with VTI
10% REITsVNQ~5% overlap with VTI
5% International BondsBNDX0% overlap with BND

Total portfolio overlap: minimal. Each position adds genuinely different exposure. Run any pair through the fund overlap calculator to verify.

Checking Overlap Regularly

Portfolio overlap isn't a one-time check. Fund holdings change as indices reconstitute, stocks enter or exit benchmarks, and active managers adjust positions.

Quarterly review: Run your fund pairs through the overlap calculator when you rebalance. It takes 5 minutes and can prevent drift into unintentional concentration.

Beyond Overlap: Finding Better Funds

If you discover overlap and need to replace a fund, these tools can help:

Explore More FundXLS Tools

Check Your Portfolio Overlap Now

Fund overlap is one of the easiest portfolio problems to diagnose and fix. You might be surprised by how much duplication is hiding in your holdings.

Try the Free Fund Overlap Calculator →

Enter any two fund tickers — ETFs or mutual funds — and get instant overlap analysis. See shared holdings, overlap percentage, and concentration risks. No signup required.

Important Disclaimer

The information provided in this article is for educational and informational purposes only and should not be construed as investment advice, a recommendation, or an offer to buy or sell any securities. MarketXLS is a financial data platform and is not a registered investment advisor, broker-dealer, or financial planner. Always conduct your own research and consult with a qualified financial professional before making any investment decisions. Past performance is not indicative of future results. Trading and investing involve substantial risk of loss.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
MarketXLS provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

Professional Trader

Meet The Ultimate Excel Solution for Investors

Live Streaming Prices in your Excel
All historical (intraday) data in your Excel
Real time option greeks and analytics in your Excel
Leading data service for Investment Managers, RIAs, Asset Managers
Easy to use with formulas and pre-made sheets