Fund Overlap Analyzer

Some of the most commonly held ETF pairings have surprisingly high overlap. Understanding these common pitfalls can help you avoid accidental concentration.

High-overlap combinations:

• VOO + VTI (approximately 85% overlap) — VTI holds the total US market, and VOO holds the S&P 500. Since the S&P 500 represents roughly 85% of total US market cap, these two funds are nearly identical. If you own both, you're barely adding any small-cap exposure from VTI that VOO doesn't already cover.
• QQQ + VOO (approximately 45% overlap) — The Nasdaq 100 is heavily weighted toward large-cap tech, and the S&P 500 also has significant tech exposure. Every stock in QQQ is also in VOO. Combining them overweights tech at the expense of financials, energy, and utilities.
• VTI + SCHD (approximately 30% overlap) — SCHD focuses on high-dividend stocks from the Dow Jones US Dividend 100. Many of these are large-cap value stocks that VTI also holds, though at lower weights.
• SPY + IVV + VOO (approximately 99% overlap) — All three track the S&P 500. Holding more than one of these is pure redundancy with no diversification benefit. Choose the one with the lowest expense ratio (VOO or IVV at 0.03%) and move on.

Lower-overlap combinations:

• VTI + VXUS (minimal overlap) — US total market paired with international stocks. Since VXUS excludes all US-listed companies, overlap is essentially zero by design.
• VOO + VNQ (minimal overlap) — S&P 500 paired with a REIT fund. REITs are a distinct asset class with different return drivers, so overlap is very low.

Key takeaway: Before adding a new ETF to your portfolio, run it through an overlap analysis. If the new fund overlaps more than 50% with something you already own, you probably don't need it.

Fund overlap is calculated by comparing the holdings lists of two funds and measuring how much of each fund's weight is invested in the same stocks. There are several methods, but the most widely used is the minimum weight overlap method.

The minimum weight method:

• For each stock that appears in both funds, take the smaller of the two weights. This represents the overlapping portion.
• Sum up all the minimum weights. The total is the overlap percentage.
• Example: Fund A holds Apple at 7% and Fund B holds Apple at 5%. The overlapping weight is 5% (the minimum). If Microsoft is 6% in Fund A and 4% in Fund B, the overlap for Microsoft is 4%. Add up all shared holdings this way to get total overlap.

Effective portfolio weight:

• When you assign a portfolio weight to each fund (e.g., 50% VTI and 50% QQQ), the effective weight of any stock is: (fund weight x holding weight in fund), summed across all funds that hold it.
• Example: If you put 50% in VTI (where Apple is 7%) and 50% in QQQ (where Apple is 12%), your effective Apple exposure is (0.50 x 7%) + (0.50 x 12%) = 9.5% of your total portfolio.

What the number means: An overlap of 40% between two funds means that 40% of the portfolio weight is invested in stocks held by both funds. The remaining 60% in each fund is in stocks unique to that fund. Higher overlap means the two funds behave more similarly and provide less diversification benefit when combined.

There is no universal threshold, but general guidelines can help you evaluate whether your overlap is problematic.

Overlap thresholds:

• Under 20% overlap — Minimal overlap. The two funds provide genuinely different exposures and meaningfully diversify each other. This is the ideal range for fund pairings.
• 20-40% overlap — Moderate overlap. There's some redundancy, but the funds still provide distinct exposure. Acceptable if each fund serves a clear purpose in your portfolio (e.g., one for growth, one for dividends).
• 40-60% overlap — High overlap. Question whether you need both funds. You're paying two expense ratios for largely similar exposure.
• Over 60% overlap — Excessive. Consider consolidating into one fund. The diversification benefit of holding both is minimal.

How to reduce overlap:

• Replace redundant funds — If you hold both VOO and VTI, pick one and sell the other. They're nearly identical.
• Add truly different asset classes — International stocks (VXUS), bonds (BND), REITs (VNQ), and commodities have low overlap with US equity funds by design.
• Use complementary funds — Instead of pairing two large-cap funds, pair a large-cap fund with a small-cap fund (VB) or a value fund (VTV) with a growth fund (VUG).
• Check before you buy — Run the overlap analysis before adding any new fund to your portfolio. If overlap exceeds 40%, you probably don't need it.

Important caveat: Some overlap is unavoidable and even acceptable. The goal is not zero overlap everywhere — it's to be aware of your actual concentration so you can make informed decisions rather than accidentally betting your portfolio on five mega-cap tech stocks.

Overlap and correlation are related but measure fundamentally different things. You need both to fully understand how your funds interact.

Fund overlap measures how much two funds hold the same underlying securities:

• It is a static, holdings-based metric. You can calculate it by comparing holdings lists at a point in time.
• Two funds with 80% overlap hold mostly the same stocks. They will almost certainly move in the same direction on any given day.
• Overlap answers: “Am I paying for the same stocks twice?”

Correlation measures how two funds' returns move together over time:

• It is a dynamic, returns-based metric. You calculate it from historical price data, typically over 1-3 years of daily or monthly returns.
• Correlation ranges from -1 (perfect inverse) to +1 (perfect lock-step). A correlation of 0 means no linear relationship.
• Two funds can have low overlap but high correlation if they are exposed to the same macro factors (e.g., a US large-cap growth fund and a European large-cap growth fund hold different stocks but may move together during global sell-offs).
• Correlation answers: “Will these funds crash at the same time?”

Why you need both: High overlap almost always implies high correlation. But low overlap does not guarantee low correlation. Two sector ETFs (e.g., tech and semiconductors) might not share many individual stocks but still move in lock-step because they respond to the same industry trends. For true diversification, look for funds with both low overlap and low correlation.

ETF overlap creates a hidden trap for tax-loss harvesting because of the IRS wash sale rule. If you sell an ETF at a loss and buy a “substantially identical” security within 30 days (before or after), the loss is disallowed.

The problem with overlapping funds:

• The IRS has never explicitly defined “substantially identical” for ETFs. However, if you sell VOO (S&P 500 from Vanguard) and immediately buy IVV (S&P 500 from iShares), most tax professionals would consider that a wash sale — they track the identical index.
• High-overlap swaps are risky — Selling VTI and buying VOO (which overlap roughly 85%) is a gray area. They track different indexes, but the holdings are nearly identical. Aggressive tax filers might attempt it, but conservative advisors would flag it.
• Low-overlap swaps are safer — Selling VTI and buying SCHD (approximately 30% overlap) is much safer for tax-loss harvesting because the funds have meaningfully different compositions and track different indexes.

Best practices for tax-loss harvesting with ETFs:

• Keep overlap under 50% for harvest pairs. The further apart the holdings, the safer the swap.
• Use different index providers — Swapping between an S&P 500 fund and a Russell 1000 fund gives you similar large-cap exposure with a different enough index to be defensible.
• Track which funds hold what — Before harvesting, check whether the replacement fund holds the same stocks you just sold. This overlap analyzer helps you identify safe harvest pairs.
• Document your reasoning — If the IRS questions a swap, having evidence that the funds track different indexes with meaningfully different holdings strengthens your position.

Key takeaway: Know your overlap before you harvest. Swapping between highly overlapping funds might save you on capital gains taxes but cost you more if the IRS disallows the loss.

Building a low-overlap ETF portfolio starts with thinking in terms of asset classes and exposures rather than fund names. Each fund should fill a distinct role.

A framework for minimal overlap:

• Core allocation (60-70%) — One broad market fund for your primary equity exposure. VTI (total US), VT (total world), or a target-date fund. This is your foundation. You do not need more than one core fund.
• International diversifier (15-25%) — VXUS (total international) or a mix of VEA (developed) and VWO (emerging markets). These have zero overlap with US-focused funds by design.
• Fixed income (10-30%) — BND (total bond market), TIPS, or a short-term treasury fund. Bonds have zero equity overlap and provide genuine diversification in downturns.
• Optional tilts (0-15%) — If you want to overweight a specific factor (value, small-cap, dividend, real estate), add one targeted fund. Understand that this will create some overlap with your core fund — that is intentional, not accidental.

Common mistakes to avoid:

• Stacking multiple US large-cap funds — VOO + VTI + QQQ + SCHD gives you four funds with massive overlap in mega-cap stocks. Pick one broad fund and one tilt fund at most.
• Confusing more funds with more diversification — A portfolio of VTI + VXUS + BND (three funds) is more diversified than VOO + VTI + QQQ + SPY + IVV (five funds). Number of funds is irrelevant; distinct exposure is what matters.
• Ignoring sector concentration — Even within a single broad market fund like VTI, technology stocks can represent 30%+ of the weight. Adding a tech-heavy ETF on top doubles down on that concentration.

The golden rule: Before adding any fund, ask “What does this give me that I don't already own?” If you can't answer clearly, you probably don't need it.

Effective concentration measures how much of your total portfolio is invested in individual stocks after accounting for the weights of each fund and the holdings within those funds. It reveals your true single-stock exposure.

How to calculate it:

• For each fund, multiply the fund's weight in your portfolio by each holding's weight within the fund. This gives you the effective weight of that holding from that particular fund.
• If the same stock appears in multiple funds, sum its effective weights across all funds to get the total effective portfolio weight.
• Example: You hold 60% VTI and 40% QQQ. Apple is 6.5% of VTI and 9% of QQQ. Your effective Apple weight is (0.60 x 6.5%) + (0.40 x 9%) = 3.9% + 3.6% = 7.5% of your total portfolio.

Why it matters:

• Single-stock risk — If your top effective holding is over 5%, a 20% drop in that one stock would cost you more than 1% of your total portfolio. For mega-cap tech holdings that can move 5-10% on earnings, this is material risk.
• Top-10 concentration — If your top 10 effective holdings represent more than 25-30% of your total portfolio, your diversification is weaker than you might think. Many “diversified” portfolios have 40%+ in just 10 stocks.
• Sector concentration — When your top effective holdings are all in the same sector (e.g., technology), your portfolio is exposed to sector-specific risks even if you own dozens of funds.

Benchmarks: A truly diversified equity portfolio should have no single stock above 3-4% effective weight and the top 10 below 20-25% combined. If you exceed these thresholds, consider whether the concentration is intentional or accidental.