Skip to content

Find ETF overlap in your Interactive Brokers portfolio

Three or four ETFs can hold mostly the same companies. After importing your IBKR positions, MEDGE looks inside each fund, shows how much they overlap by weight and which companies you really own the most of, through all your funds at once.

Compare the funds of a portfolio like an IBKR one

This is the free ETF overlap tool, filled in with the four US ETFs of the example. Swap any fund, add up to four, and select a cell for the holdings two funds share.

Funds to compare (2 to 4)

VOOVTIQQQSCHD
Overlap by weight for each pair of funds
VOOVTIQQQSCHD
VOO—
VTI—
QQQ—
SCHD—

Overlap by weight. Tap a cell for the holdings two funds have in common.

VOO and VTI: 86.0% overlap by weight

501 holdings appear in both. They are 99.8% of VOO (504 holdings compared) and 87.9% of VTI (999).

Holding in commonIn VOOIn VTI
Apple Inc7.59%6.19%
Microsoft Corp6.28%5.18%
NVIDIA Corp6.61%4.66%
Amazon.com Inc4.12%3.37%
Meta Platforms Inc2.56%2.34%
Alphabet Inc2.22%1.67%
Berkshire Hathaway Inc1.67%1.75%
Broadcom Inc2.17%1.46%
Alphabet Inc1.82%1.35%
Tesla Inc2.26%1.31%
JPMorgan Chase & Co1.35%1.27%
Eli Lilly & Co1.22%1.31%
Visa Inc (Class A)1.09%1.11%
Exxon Mobil Corp0.95%0.96%
UnitedHealth Group Inc0.93%0.89%
  • VOO: 506 holdings, report of Dec 2024.
  • VTI: 3,601 holdings, report of Mar 2025; the 1,000 largest compared, 96% of the fund.
  • QQQ: 104 holdings, report of Feb 2025 (holdings of QQQM, same index).
  • SCHD: 101 holdings, report of Feb 2025.

Overlap, look-through and correlation

Overlap by weight is the part of two funds made of the same securities in the same proportions: for every company held by both, take the smaller of its two weights and add them up. Two funds with 70% overlap put most of the money in the same places.

Look-through goes one step further: it spreads each ETF into its holdings, weighted by the ETF’s share of your portfolio, and adds up the same company across all funds. Correlation is a different thing: two funds can move together while holding different companies, for example two markets hit by the same shock.

Worked example: four popular US ETFs

A portfolio an IBKR account in the United States might hold: 40% VOO, 25% VTI, 20% QQQ, 15% SCHD. The holdings come from each fund’s latest report on file.

PairOverlap by weightHoldings in commonLargest in common
VOO · VTI86%501Apple Inc, Microsoft Corp, NVIDIA Corp
VOO · QQQ49%85Apple Inc, NVIDIA Corp, Microsoft Corp
VTI · QQQ41%93Apple Inc, Microsoft Corp, NVIDIA Corp
VOO · SCHD7%44Home Depot Inc/The, AbbVie Inc, Chevron Corp
VTI · SCHD7%61AbbVie Inc, Home Depot Inc/The, Chevron Corp
QQQ · SCHD6%6Cisco Systems, Inc., PepsiCo, Inc., Texas Instruments Inc.

The companies you own the most of, through all four funds

CompanyWeight in the portfolioThrough
Apple Inc6.49%VOO · VTI · QQQ
NVIDIA Corp5.40%VOO · VTI · QQQ
Microsoft Corp5.34%VOO · VTI · QQQ
Amazon.com Inc3.65%VOO · VTI · QQQ
Meta Platforms Inc2.37%VOO · VTI · QQQ
Broadcom Inc2.03%VOO · VTI · QQQ
Alphabet Inc1.82%VOO · VTI · QQQ
Tesla Inc1.79%VOO · VTI · QQQ
Alphabet Inc1.56%VOO · VTI · QQQ
Cisco Systems Inc1.27%VOO · VTI · QQQ · SCHD

Seen inside the funds: 100% of the portfolio. The ten largest companies make up 32% of it. Holdings from each fund’s Form N-PORT filed with the SEC, via MarketStack; reports dated Dec 2024, Mar 2025, Feb 2025.

What the numbers say

  • VOO and VTI overlap by 86%: much of one fund duplicates the other.
  • 10 of the ten largest companies come through at least three different funds, such as Apple Inc.
  • Four ETFs, yet the ten largest companies make up 32% of the portfolio.

UCITS ETFs and European listings

Fund holdings in MEDGE come from Form N-PORT, the report US-registered funds file with the SEC. European UCITS ETFs do not file it, so in a portfolio imported from a European IBKR account they count as single positions in the look-through.

You can still compare two UCITS funds through the US-listed ETFs that track the same indices, in the free overlap tool, as long as you read the result as an approximation of the index, not of the fund.

How to do it in MEDGE

  1. 1Import the positions from Interactive Brokers and open the analysis.
  2. 2Look through the funds. The look-through panel of the analysis shows the largest companies and countries across all your ETFs, with the share of the portfolio it could see inside.
  3. 3Compare two portfolios on the Compare page: Holdings in common shows the overlap between them, pair by pair.
  4. 4Check a single pair without an account in the free ETF overlap tool.
Open the free overlap tool

How overlap and look-through are calculated

Overlap by weight between two funds: for every security held by both, take the smaller of its two weights, and add them up. 100% means the same securities in the same proportions; 0% means nothing in common.

Look-through: each ETF is replaced by its holdings, each weighted by the fund’s weight in the portfolio times the holding’s weight in the fund, and the same company is added up across funds. Share classes of one company (such as Alphabet A and C) stay separate, as in the reports. Holdings come from each fund’s latest Form N-PORT on file; funds without a report count as single positions, and the share of the portfolio seen inside the funds is shown.

Questions

How do I check ETF overlap in my IBKR portfolio?

Import the positions into MEDGE and open the analysis: the look-through panel shows the companies you hold through several funds. For two funds at a time, the free ETF overlap tool works without an account.

Is overlap the same as correlation?

No. Overlap counts the same securities held by two funds. Correlation measures whether their returns move together, which can happen with completely different holdings.

Does it work with UCITS ETFs like VWCE or CSPX?

Not for the look-through: their holdings are not in the SEC reports MEDGE uses, so they count as single positions. Backtests, risk and stress tests work normally for them.

How recent are the holdings?

Each fund’s latest Form N-PORT on file, whose date is shown next to the result. Funds report quarterly, with a delay.

Related

MEDGE Capital is not affiliated with Interactive Brokers. Interactive Brokers, IBKR, Client Portal and PortfolioAnalyst are trademarks of their owners. Educational content: not financial advice and not an investment recommendation. Risk disclaimer.