ETF Overlap Explained: How to Find Duplicate Holdings in Your Portfolio

Owning five ETFs does not necessarily give you five sources of diversification. One fund may hold the whole U.S. market, another the S&P 500 and a third the Nasdaq-100—then all three send a large part of every dollar to NVIDIA, Apple, Microsoft, Amazon and Alphabet.

That does not make any fund bad. It means the portfolio contains an unmeasured tilt. The investor sees three ticker symbols; the account may see the same ten companies three times.

ETF overlap analysis fixes the mismatch by looking through each wrapper to the underlying holdings. The simplest useful result is not “these funds share 85 stocks.” It is how much of the portfolio lands in the same stocks after fund allocations and holding weights are combined.

This guide shows the formulas, a worked VOO/VTI example using official Vanguard holdings, and a repeatable audit for the Portfolio Tracker. It does not tell you to sell an overlapping fund. Overlap can be accidental duplication or an intentional tilt—the numbers reveal which one you own.

Educational information for a U.S. audience, not personalized investment or tax advice. Fund holdings and weights change. Selling can create taxes and trading costs.

Three overlap questionsCount, weight and total portfolio exposure

“How much do these ETFs overlap?” can mean three different things.

Count overlap is intuitive and often misleading. If two four-stock funds share A and B, the count score is 50%. But if one fund puts 70% in the shared names and the other puts 30% there, those repeated holdings do not have equal economic importance.

Weighted overlap is more informative. For each shared holding, take the smaller of its two fund weights and add the results. The score ranges from 0% for no shared exposure to approximately 100% for funds with the same holdings at the same weights.

Look-through exposure is the decision number. It includes how much of each ETF you actually own. A 5% satellite fund and a 60% core fund should not influence the portfolio audit equally.

A four-stock example50% by name, 30% by weight

Assume Fund A owns A 40%, B 30%, C 20% and D 10%. Fund B owns A 10%, B 20%, E 40% and F 30%.

Both the 50% and 30% answers are correct. They answer different questions. The first says half the smaller fund's names appear in both. The second says 30 percentage points can be paired security by security at their lower weights. The final formula says the investor's actual portfolio is 28% exposed to company A.

This is why overlap websites can show different numbers without one being mathematically wrong. Some divide shared names by Fund A, some by Fund B, some by the smaller list, and some compare assets by weight. Never quote an overlap percentage without its definition and holdings date.

VOO plus VTIThousands of extra names, the same giants on top

Vanguard says VOO tracks the S&P 500 and reported 505 holdings as of July 31, 2026. VTI seeks the broad investable U.S. market and reported 3,515 holdings. Those descriptions sound radically different—and they are different below the largest companies.

At the top, the official pages listed the same ten companies: NVIDIA, Apple, Microsoft, Amazon, both public Alphabet share classes, Broadcom, Micron, Meta and Tesla. Because both funds are capitalization weighted, those shared companies receive the largest allocations in both.

Those ten names alone create a 31.87% lower bound on weighted overlap: add the smaller displayed weight for each pair. It is a lower bound because hundreds of additional VOO companies also appear inside VTI. The snapshots are one month apart, so 31.87% is an illustration from the current official pages, not an exact same-day full-portfolio score.

The 50/50 blend places 34.09% in those ten positions. Adding VOO to VTI did not add a new asset class. It raised the portfolio's weight in the S&P 500 segment relative to owning VTI alone. That can be a valid large-cap tilt, but it should be named as such.

Our VOO vs VTI comparison explains what VTI adds below the shared giants. The overlap audit answers the next question: whether those extra holdings change the investor's total exposure enough to serve the plan.

The same company can hide behind different labels

Ticker matching is only the first pass. A robust audit normalizes the data.

Alphabet appears as GOOGL and GOOG because it has multiple listed share classes. They are separate securities, but both represent equity in Alphabet. A company-level concentration report should aggregate them; a tax-lot or voting-rights report may need to keep them separate.

Similar problems occur with:

• ticker changes and mergers;
• ordinary shares versus depositary receipts;
• dual listings in different currencies;
• funds that hold another ETF instead of its constituents;
• futures or swaps that replicate an index without listing every stock;
• cash and collateral that reduce reported equity weights;
• securities identified differently across providers.

Use stable identifiers such as CUSIP, ISIN or a maintained security master where available. For a personal review, company name plus ticker and manual confirmation is usually enough—but “BRK.B,” “BRK-B” and “BRK/B” should not become three companies because three data files use different punctuation.

Holdings overlap is not return correlation

Two funds can share no individual securities and still move together. A U.S. technology ETF and a semiconductor ETF may respond to the same rates, growth expectations and AI spending cycle. Conversely, two funds can share names but assign them different weights and behave differently.

Neither replaces the other. Holdings overlap can change at reconstitution or with market prices. Correlation depends on frequency and lookback window. A sound review uses holdings to describe current exposure and returns to test how those exposures behaved under stress.

Also distinguish sector labels from economic drivers. Two data providers can classify the same company differently after a methodology change. Look through the headline category when a handful of mega-cap businesses dominate both funds.

When overlap is intentionalA tilt, a tax decision or an account constraint

Overlap is not automatically a problem.

The bad version is accidental: a new fund is purchased because its ticker and marketing theme look different, while the top holdings are already the largest positions in the portfolio. The investor pays another spread and gains little new exposure.

Before selling, calculate capital gains, holding period, account type and transaction costs. Rebalancing with contributions or dividends may reduce duplication without realizing gains. This is where portfolio math and tax advice separate; a cleaner chart is not always worth an immediate taxable trade.

The portfolio-level calculationFund weights come first

Suppose the account is 60% VTI, 25% VOO and 15% QQQ. A tool that compares VOO and QQQ in isolation ignores that VTI is the largest source of the same mega-cap exposure.

For each company:

portfolio exposure = Σ (portfolio allocation to fund × company weight inside fund)

Do that for every ETF, then add directly owned shares. Aggregate share classes when the decision concerns company concentration. Finally group by sector, country, market-cap band and asset class.

The Portfolio Tracker is the natural home for fund allocations, current values and target weights. Use the Asset Allocation Calculator to define the policy mix first. Overlap analysis should support that policy, not become a game of minimizing every repeated ticker.

A seven-step ETF overlap audit

Repeat after a major contribution, fund change or scheduled rebalance. Monthly holdings can move without requiring monthly action. The purpose is to catch structural drift, not to trade every index update.

Frequently asked questions

What is ETF overlap?

ETF overlap is the portion of two or more funds invested in the same underlying securities. It can be measured by shared names, shared weights or the investor's combined look-through exposure.

Is owning VOO and VTI bad?

Not inherently. VTI already contains the large companies that dominate VOO, so adding VOO mostly creates a large-cap/S&P 500 tilt. That may be intentional; it is not a new independent asset class.

What is a good ETF overlap percentage?

There is no universal threshold. A high score is expected between two S&P 500 trackers and suspicious when the investor bought the second fund for diversification. Judge it against the intended role and portfolio limits.

Why do ETF overlap tools disagree?

They may use different holdings dates, ticker normalization, share-class treatment and denominators. Some count names; others sum weights. Read the methodology before comparing scores.

Do more ETFs always mean more diversification?

No. More wrappers can repeat the same companies and sectors. Diversification comes from distinct underlying exposures, not the number of ticker symbols on the statement.

Should I sell an overlapping ETF?

Not automatically. First measure the actual exposure, purpose, unrealized gain, account type and alternatives such as redirecting new contributions. Tax consequences can outweigh a small improvement in portfolio neatness.

Sources and methodology

• Vanguard VOO product page supplies the fund objective, 0.03% expense ratio, holding count and displayed holdings used here.
• Vanguard VTI product page supplies the broad-market objective, 0.03% expense ratio, holding count and displayed holdings.
• Vanguard states that diversification does not ensure a profit or protect against loss on its investment products page.
• Weighted-overlap and look-through examples are reproduced in drafts/etf-overlap-explained-numbers.mjs. The VOO and VTI top-holding snapshots have different official as-of dates, so the 31.87% top-ten figure is explicitly a lower-bound illustration, not a same-day full-portfolio score. Holdings change and should be downloaded again before acting.

Add every account to the Portfolio Tracker, record why each fund exists, and calculate what the wrappers own together. A portfolio becomes diversified when its underlying exposures are different—not when its ticker list becomes longer.