Back to blog
InvestingUnited States

How to calculate ETF overlap from fund holdings

3 min read14 November 2026By FinTarget Team

Use two fictional US ETFs to calculate overlap by holding count and by weight, then see what the shared holdings represent in one account.

In this article

ETF overlap is the set of investments that two exchange-traded funds hold in common. A count tells you how many holdings are shared. A comparison by weight accounts for the size of each position. The distinction matters because a position that makes up 1% of one fund and 15% of another counts once in each list.

Match holdings from the same date

US ETFs that rely on SEC Rule 6c-11 disclose their prior business day’s portfolio holdings on their websites each business day. A holdings file shows the positions and their weights as of its stated date. A fact sheet that lists only the largest positions can describe part of the overlap. A full calculation requires full lists for both funds.

Match the same securities across the lists. A ticker can require extra context if the files cover several exchanges, so use a common security identifier when both files provide one. Different share classes can represent exposure to the same company through different securities. If your calculation combines those classes, label it as company overlap and combine their weights within each fund before comparing.

Calculate the shared weight

Suppose fictional ETF A holds North Company at 45%, South Company at 25% and East Company at 30%. Fictional ETF B holds North at 15%, South at 25% and West Company at 60%. Assume each fund holds exactly those three shares, with no cash or other positions.

The two shared holdings are North and South. Each fund shares two out of its three names with the other. If you divide shared names by all four distinct names in the combined list, the result is 50%. That percentage uses a different denominator from two out of three, so a count-based comparison benefits from saying which denominator it uses.

One way to calculate overlap by weight is to take the smaller weight for each shared holding and add them. North contributes 15 percentage points, the smaller of 45% and 15%. South contributes 25 points because both funds hold 25%. Total overlap by this method is 40%. East and West each contribute zero because each appears in only one fund. You can also add up the full weights of the shared names within each fund. Together North and South are 70% of ETF A and 40% of ETF B. Those two percentages answer how much of each fund sits in names the other also holds.

Calculate what the account actually holds

Suppose your fictional account has USD 6,000 in ETF A and USD 4,000 in ETF B. North represents 45% of USD 6,000 plus 15% of USD 4,000. Those positions add to USD 3,300, or 33% of the account. South represents 25% of each holding, so its exposure is USD 2,500, or 25% of the account. Together the two shared companies make up 58% of this account. The 40% figure describes the overlap between the funds under the smaller-weight method. The 58% figure describes the combined exposure of a specific account.

A low overlap score can still coincide with exposure to the same industry if each fund holds different companies in that industry. The holdings calculation answers a question about identical securities or issuers, depending on how you matched them. If you run it again after the weights change, the holdings date and the account values let you explain why the overlap and account exposure moved.

Put it into practice

Record your holdings, dividends, income and expenses in FinTarget. Free to get started, with no bank connection.

Get started free