๐Ÿ”Ž Portfolio Look-Through & Overlap Tool

ETF Overlap & True Concentration Risk Screener

Think you are diversified? Most retail investors unknowingly hold the same 5 mega-cap tech stocks across multiple index funds. Run a live look-through analysis across your ETFs to expose single-stock concentration, sector tilts, and duplicative expense drag.

โš–๏ธ Select Your ETF Allocation (Up to 6)

Add ETFs and set your target weights. Real-time look-through calculates your true single-stock and sector exposure.

Allocation Total:
100%
Executive Summary (Equal Allocation)

Analyzing Portfolio Allocation...

Calculating --%

Analyzing look-through constituent overlap, fee drag, and single-stock concentration...

Top 5 Concentration --%
Top 10 Concentration --%
Unique Holdings --
Blended Fee --%
Largest Shared Holdings

๐Ÿ”„ Pairwise ETF Overlap & Redundancy Analysis

Calculating...

High overlap between two funds means you are paying multiple expense ratios for virtually the same underlying companies.

๐Ÿ” True Underlying Stock Exposure (Look-Through)

Your real aggregate ownership in single stocks after multiplying your ETF allocations by each fund's holdings.

Concentration Heatmap (Top Holdings)
High (>6%) Moderate (3%โ€“6%) Diversified (<3%)
Detailed Holdings Breakdown
Stock / Company Effective Weight Contributing ETFs

๐Ÿ“Š Sector Exposures vs Broad Market Benchmark (VTI)

Shows where your ETF combination is heavily overweight (concentrated tilt) or underweight compared to the total US stock market.

Save & Share This Portfolio Analysis

Bookmark this URL or share with friends to load these exact ETFs and weights.

๐Ÿ“ฅ Free Portfolio Matrix (PDF) One-Page Reference โ€ข Instant PDF

Download the Ideal Low-Overlap ETF Model Portfolios Guide

Discover proven low-overlap ETF combinations, 3-fund asset splits, and common high-overlap duplication traps across Vanguard, Schwab, and iShares.

  • โœ“ 5 proven low-overlap model portfolios
  • โœ“ High-overlap duplication traps to avoid
  • โœ“ 3 golden rules of portfolio diversification

โœ‰ Includes the free Buck by Buck personal finance newsletter. Instant download unlocked immediately. Unsubscribe anytime with 1 click.

Why Multiple ETFs Often Fail to Provide Diversification

Modern retail investors frequently construct portfolios by adding popular funds: a core S&P 500 ETF, a high-growth tech fund, and a dividend appreciation ETF. While this feels like holding three distinct assets, market-cap weighting means these funds frequently purchase the exact same underlying companies.

1. Accidental Mega-Cap Exposure

If you allocate 50% to VOO and 50% to QQQ, your effective allocation to Apple, Microsoft, and NVIDIA exceeds 20% of your entire portfolio.

2. Duplicative Expense Ratios

Holding VOO (0.03% expense ratio) alongside SPY (0.09%) or SPLG (0.02%) generates zero diversification benefits while forcing redundant rebalancing.

3. False Sense of Security

Holding 5 or 6 funds does not protect against market drawdowns when all 5 funds share identical top constituents that dictate 60% of total performance.

๐Ÿ“š Research Deep Dive

The Magnificent 7 & AI Bubble Trap: Are You Overexposed?

Learn how market-cap weighting concentrates over 37% of your capital into 7 tech companies when pairing VOO, QQQ, and semiconductor funds, and how to stress-test your portfolio.

Read Analysis โ†’
Looking for Our Model Portfolios?

Explore Recommended Index Funds & Brokerage Equivalents

Browse our curated list of 10 low-cost index funds across Vanguard and Fidelity with fee benchmarks and automation guides.

View Low-Cost Funds & ETFs →
โ“ Common Questions

Frequently Asked Questions About ETF Overlap

Direct answers on portfolio concentration, index fund duplication, and look-through methodology.

What is ETF look-through analysis?

ETF look-through analysis examines the actual underlying individual stocks owned inside each ETF in your portfolio. Rather than treating an ETF as a single asset, it multiplies your fund allocation by each constituent stock weighting to calculate your true effective ownership in individual companies.

Why is ETF overlap dangerous for retail investors?

High ETF overlap creates the illusion of diversification while actually magnifying single-stock concentration and expense drag. For example, owning both VOO (S&P 500) and QQQ (Nasdaq 100) concentrates over 25% of your total capital into just five mega-cap tech stocks, leaving you vulnerable to sharp drawdowns in those specific companies.

How do you calculate overlap percentage between two ETFs?

Pairwise overlap is calculated by summing the minimum shared weight of each identical stock held by both funds: SUM(min(Weight_fundA, Weight_fundB)). If two funds hold the exact same stocks at the same proportions, their overlap is 100%.

How often are the ETF constituent holdings and overlap weights updated?

Holdings data and portfolio weights are synchronized directly with official quarterly SEC regulatory filings and fund provider disclosures across Vanguard, BlackRock iShares, Charles Schwab, and Invesco.

View all resources
๐Ÿ’ฌ Reader Discussion & Notes

Discussion ๐ŸŸข Open for Discussion

What ETFs are in your portfolio right now, and what was your highest overlap pairing?

โšก The author reads every submission and typically replies within 24 hours.