ETF Overlap and Look-Through Analysis: Hidden Concentration

Overlap is the invisible position in a multi-ETF portfolio. Here is how look-through analysis measures shared holdings, sector concentration and factor tilts — and where the data fails.

2026-11-12 · 8 min read

Key takeaways

  • Funds with different names and different indices can hold nearly identical top positions, so look-through rather than labels is what measures real concentration.
  • Look-through means mapping every holding to a single security identifier and aggregating weights, sectors and factors across all funds using one classification standard.
  • Holdings data always lags, and sampling or synthetic replication means published lists are approximations, not the portfolio.
  • Cutting overlap costs money through spreads, commissions and realised gains, so the usual fix is gradual rebalancing rather than one clean-up trade.

What ETF overlap really measures

A portfolio can hold five ETFs from five providers, tracking five different indices, and still be a concentrated bet on the same twenty companies. Nothing in the fund names tells you this. Only the underlying holdings do.

ETF overlap is the degree to which two or more funds own the same securities. Look-through analysis is the process of opening each fund, aggregating every position by weight, and measuring the result as if you owned the stocks directly. For anyone building a multi-fund portfolio — a DIY investor with a core-satellite mix, or an adviser combining model portfolios from different providers — it is the difference between knowing your real exposure and assuming it.

The stakes are practical. A global equity ETF, a US large-cap ETF and a quality-factor ETF sold as three separate building blocks may share the same core mega-cap names at the top of each fund. The positions are not diversified simply because they sit in different wrappers.

Why category labels hide overlap

Fund categories are a short-hand for style, size and region. They are not a portfolio. Two funds can share a category like "US large blend" and still differ by hundreds of holdings and by several percentage points in sector weight.

Labels also hide overlap across categories. Consider a portfolio built from:

  • a US total-market ETF
  • an S&P 500 index ETF
  • a technology sector ETF
  • a "quality" or "growth" factor ETF

Four categories, four indices, four different marketing stories. In practice the first three all draw their top holdings from the same handful of mega-caps, and the fourth does as well, because most quality and growth screens are cap-weighted on top of a large-cap universe.

Index basis matters more than the label

Two funds tracking "the US market" can hold a different number of securities and weight them differently. The S&P 500 index contained 503 constituents as of 30 October 2026, with the top ten companies accounting for 37.3% of index weight and the largest single company at 7.7% (S&P Dow Jones Indices factsheet).

A total-market fund looks like the diversifying answer — until you check. The Vanguard Total Stock Market ETF (VTI) held 3,519 stocks as of 30 September 2026, and its top ten positions were still 36.1% of net assets, at a 0.03% expense ratio (Vanguard fund factsheet, SEC summary prospectus).

Read those two numbers together. The fund with 3,519 holdings and the index with 503 have almost identical top-ten concentration. Adding the total-market fund next to a large-cap fund does not dilute the concentration you were trying to reduce; it duplicates it.

How to run a look-through analysis

The method is mechanical, and it works with a spreadsheet. The work is in the data hygiene, not the maths.

  1. Download the current holdings file for every fund. Providers publish these as CSV or XLSX, usually with weights, sector, country and a security identifier.
  2. Choose one identifier. ISIN is the most portable; CUSIP and ticker collide across share classes and exchanges. Map everything to a single field before aggregating.
  3. Normalise weights. Some files show weights as a percentage of the equity sleeve, others of total net assets including cash and futures. Convert to a common base or your totals will not sum correctly.
  4. Aggregate by security, then by sector and country. The simple check is the share of the whole portfolio sitting in each of the top ten or twenty names across all funds.
  5. Repeat the exercise on a common classification standard. If one fund reports under GICS and another under ICB, relabel before comparing; otherwise you will read a classification difference as a real tilt.
  6. Note the dates. Funds publish holdings on different schedules, so no snapshot is truly simultaneous.

A worked comparison

Two funds, both core US equity, both cheap — and far more similar than the labels suggest. Figures come from each provider's latest published disclosure, which are not as-of the same date:

Latest published disclosure Vanguard Total Stock Market ETF (VTI) iShares Core S&P 500 ETF (IVV)
Number of equity holdings 3,519 505
Top ten as % of net assets 36.1% roughly 36%
Largest single holding about 7.1% about 7.5%
Stated expense ratio 0.03% 0.03%
Sleeve labelled "technology" about 43% (ICB) about 36% (GICS-based)

Sources: Vanguard factsheet and iShares fund page, with the iShares factsheet. Both funds are used here purely as illustrations of the method, not as recommendations. Holdings-based figures change with markets and disclosure dates, so check the current files before relying on them.

The technology gap in that last row is the most instructive number in the table. Part of it is a real difference in the underlying universe. Part of it is classification: Alphabet sits in "technology" under one widely used scheme and in "communication services" under the other. If you do not harmonise the standard, you will "discover" a sector tilt that does not exist and miss the one that does.

Where the data breaks down

Look-through is only as good as the disclosure behind it, and disclosure has hard limits.

  • Lag and frequency. In the US, funds report portfolio holdings on Form N-PORT quarterly, filed no later than 60 days after quarter-end, and only the third month of each fiscal quarter is made public (SEC Form N-PORT, N-PORT data sets). A December quarter-end file can be public in February. Overlap measured then may not describe the fund today.
  • Sampling and optimisation. Many large index funds do not hold every index constituent. They hold a representative subset, so the published list is an approximation of index exposure rather than a replica.
  • Share classes. Dual-class structures mean the same company appears twice under two identifiers. Fail to consolidate and you understate single-company risk.
  • Derivatives and cash collateral. Synthetic or partially swapped funds, securities lending programmes and cash equitisation can leave exposures that never appear in a holdings list of ordinary shares. On lending specifically, see our guide to how ETF securities lending works.
  • Classification drift. Sector schemes are revised over time, and providers timestamp their data differently. Any sector comparison is approximate.
  • Funds of funds and multi-asset wrappers. Look-through into a fund that itself holds ETFs requires a second pass, and some wrappers disclose only top-level positions.

What look-through still cannot tell you

It will not tell you how two funds behave together in a drawdown, because correlation is not the same as shared holdings. It will not standardise factor definitions — "value" or "quality" means what each provider's methodology says it means, and those definitions vary (our explainer on factor ETFs covers how differently they are built). And it says nothing about currency exposure, which sits on top of everything else.

Regulatory limits are not diversification

It is tempting to assume that because a fund is regulated, its concentration has been capped at a level that protects you. That is not what the rules do.

In the EU, a UCITS may not invest more than 10% of assets in transferable securities of a single issuer, and holdings above 5% must not together exceed 40% of net assets — the "5/10/40" rule. Index-tracking UCITS that replicate a recognised index may go to 20% per issuer, and 35% in exceptional circumstances (Central Bank of Ireland guidance, UCITS financial indices).

In the US, a regulated investment company must meet quarterly tests: at least 50% of assets in cash, government securities, other RICs and securities limited to 5% per issuer, and no more than 25% of assets in any single issuer (26 CFR 1.851-2).

Read carefully and you see the point. These are issuer-level floors designed for tax and fund status, not a ceiling on how concentrated your personal portfolio becomes when you stack several funds that each pass the test on their own.

Risks and costs

  • Duplication risk. The main cost of unrecognised overlap is unintended single-stock and single-sector risk, and a portfolio whose return is driven by fewer companies than you think.
  • Trading costs. Consolidating funds means selling. That means paying the bid-ask spread and any commission on exit, in addition to the entry costs you already paid. Spreads and depth vary widely by fund (execution cost guide).
  • Tax. In taxable accounts, selling to remove overlap can realise gains. Rules and rates are jurisdiction-specific: wash-sale rules apply in the US, while several European jurisdictions — Germany included — treat accumulating and distributing funds differently. Our ETF rebalancing guide sets out thresholds and tax mechanics.
  • Ongoing cost. Every retained fund charges its own expense ratio, and stacked products can also carry underlying fund costs; see TER vs total cost of ownership.
  • Tracking and rebalancing drag. Overlapping funds rebalance on different schedules, which can create small unintended trades inside each fund (index rebalancing dates).
  • Data risk. Acting on stale holdings data can produce a fix for a problem that has already resolved, or miss a new one.

Bottom line

ETF overlap is measured, not assumed. Pull the holdings files, map to one identifier, harmonise the classification standard, and aggregate across every fund in the portfolio. Do it at the security level first — the top ten or twenty names by combined weight — then at sector and country level.

What you are looking for is not a score but a decision: whether the extra funds in the portfolio add an exposure you do not already own, or simply add a fee on top of the same companies. If they duplicate, fixing it is a cost-benefit question about spreads, commissions and taxes, and it is usually better handled in stages than in one trade.

This article is for information and education only. It is not investment advice and does not take into account your personal situation. Read the full disclaimer.

Follow the shortlist

Comparing ETFs on cost, liquidity and structure? Our global ETF and stock research watchlist is tracked daily. Premium members get the full list, the reasoning behind every entry and updates when entries change.

See premium access

Information and education only, not investment advice.

Related