Holdings overlap analysis · SEC EDGAR + issuer data Updated daily

Methodology

ETF Overlap Tool measures how much two ETFs actually hold in common — not by comparing names or categories, but by comparing every underlying position in each fund. This page explains exactly how we compute it.

The two metrics we report

Every overlap page shows two complementary numbers, because "overlap" can mean two different things:

  • Weight overlap — the share of a portfolio that is genuinely duplicated. For each security held by both funds, we take the smaller of its two weights and add those up:
    Weight overlap = Σ min(weight in A, weight in B)
    If VOO holds Apple at 7.1% and VTI holds it at 6.2%, the shared, overlapping exposure is 6.2%. Summed across all common holdings, this is the single most useful number for answering "how similar are these two funds?"
  • Count overlap — the share of distinct holdings the funds have in common, regardless of weight:
    Count overlap = shared holdings ÷ total unique holdings
    Two funds can share many tickers (high count overlap) while still differing a lot by weight, or vice-versa. Reading both numbers together tells the real story.

How holdings are matched

Funds report the same company in inconsistent ways — different tickers across exchanges, listing classes, or naming conventions, and some issuer files carry no ISIN at all. To avoid under-counting overlap, we resolve each position to a single canonical security before comparing, in this order of confidence:

  1. ISIN or CUSIP. A small alias table lists ISINs that refer to the same line (for example a company that re-domiciled and received a new ISIN while some issuer files still carry the old one); aliased ISINs are treated as equal.
  2. Ticker plus listing currency, with a check that the two names are compatible. A bare ticker is never used on its own, because the same ticker means different companies on different exchanges.
  3. Normalised name plus listing currency or issuer country, only when exactly one candidate fits.
  4. Normalised name only, ignoring country and currency, as a final fallback for the same line described two ways (a Canadian company reported under its Toronto listing by one issuer and its New York listing by another). Because a name is weak evidence, this pass is deliberately strict: the match is refused if the two weights differ by more than five times, if the candidate carries a different known ISIN or CUSIP, if the two rows have different tickers in the same currency, or if nothing besides the name supports it. Every match made this way is flagged name_only in our data and written to a review log with both rows in full, so it can be checked by hand.

Two holdings that resolve to the same security are treated as the same position, even if the source files label them differently. Each share class remains a separate security (Alphabet A and C are two lines, as they are in the funds).

Weights

Weights are the issuer's own figures against the full fund and are never rescaled: if a fund's equity lines add up to 99% the remaining 1% is cash, currency forwards or futures, and that remainder is left out of the overlap. iShares files publish the weight column rounded to two decimals, which puts hundreds of small positions at exactly 0.01% and some at 0.00%; for iShares funds we therefore derive each weight from the market value column (market value divided by the sum of market value of every line in the file, including cash and derivatives, which is the fund's net assets). This reproduces the published column to within rounding and gives the same full-fund basis as the Vanguard files. The published column is kept as a cross-check: any difference above 0.005 percentage points is logged as a parsing error. SPDR is the one exception: in the SSGA files the "Percent of Fund" column is market value divided by the market value of the equity lines only, so the equity lines sum to exactly 100% and cash and index futures are listed without a percentage. We use those figures as published. Cash is typically 0.2 to 0.3% of net assets in the SPDR MSCI World fund, and the fund equitises it with index futures of about the same size, so the difference against a net-asset basis is a few tenths of a percentage point at most.

Sampled funds

Some funds track their index by optimised sampling rather than full replication (for example Vanguard's FTSE All-World UCITS ETF, which holds roughly 3,750 equity lines against 4,264 index constituents per Vanguard's factsheet as at 31 July 2026, the same date as the holdings file). The holdings count we show is what the fund actually holds, which for a sampled fund is smaller than the index. Fund and overlap pages say so where the issuer describes the fund as sampled. This is also the main reason a fully replicated fund can hold names that a sampled fund tracking a broader index does not: those names are simply not in the sampled portfolio.

What we exclude

We exclude cash and cash-equivalent lines (for example "US DOLLAR" entries and securities-lending cash collateral) from the overlap calculation. Two funds both holding a fraction of a percent in cash is not a meaningful shared investment, and including it would slightly inflate every overlap figure. We compare invested positions only.

Sectors, concentration & diversification

Sector weights are computed by us, bottom-up: each holding carries the GICS sector label from the issuer's holdings file, and we sum holding weights per sector. Label variants from different issuers (for example "Communication" and "Communication Services") are mapped to the eleven standard GICS sectors. Because this is a roll-up of the holdings file rather than the issuer's own factsheet, the figures can differ slightly from what the issuer publishes. Where a holdings file omits a sector, we backfill it from authoritative sector-fund membership (the Select Sector SPDR family). Holdings that still have no sector are excluded from the sector tilt, and when they exceed 5% of a fund's weight the overlap page says so next to the tilt table. We also report portfolio concentration (the combined weight of each fund's top holdings) and a simple diversification read derived from how concentrated and how overlapping the two funds are.

Data sources & freshness

Holdings come, in order of preference, from direct issuer feeds (Vanguard, iShares, State Street/SPDR), then SEC EDGAR N-PORT filings as an authoritative fallback, and a commercial provider for long-tail coverage. Each ETF and overlap page shows the "as-of" date of the underlying holdings: this is the date the issuer's file refers to, not the date we downloaded it. Most feeds are daily; Vanguard publishes month-end holdings, so a Vanguard fund compared with a daily-updated fund can show a slightly lower overlap than two funds with the same as-of date. See our Data Sources page for the full hierarchy.

Limitations

Holdings are point-in-time snapshots and change as funds trade and rebalance; figures may lag a fund's live portfolio. AUM figures are approximate. Overlap analysis describes composition, not future performance. Nothing here is investment advice — see our Disclaimer.

Last reviewed: September 14, 2026.