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)
| VOO | VTI | QQQ | SCHD | |
|---|---|---|---|---|
| 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 common | In VOO | In VTI |
|---|---|---|
| Apple Inc | 7.59% | 6.19% |
| Microsoft Corp | 6.28% | 5.18% |
| NVIDIA Corp | 6.61% | 4.66% |
| Amazon.com Inc | 4.12% | 3.37% |
| Meta Platforms Inc | 2.56% | 2.34% |
| Alphabet Inc | 2.22% | 1.67% |
| Berkshire Hathaway Inc | 1.67% | 1.75% |
| Broadcom Inc | 2.17% | 1.46% |
| Alphabet Inc | 1.82% | 1.35% |
| Tesla Inc | 2.26% | 1.31% |
| JPMorgan Chase & Co | 1.35% | 1.27% |
| Eli Lilly & Co | 1.22% | 1.31% |
| Visa Inc (Class A) | 1.09% | 1.11% |
| Exxon Mobil Corp | 0.95% | 0.96% |
| UnitedHealth Group Inc | 0.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.
| Pair | Overlap by weight | Holdings in common | Largest in common |
|---|---|---|---|
| VOO · VTI | 86% | 501 | Apple Inc, Microsoft Corp, NVIDIA Corp |
| VOO · QQQ | 49% | 85 | Apple Inc, NVIDIA Corp, Microsoft Corp |
| VTI · QQQ | 41% | 93 | Apple Inc, Microsoft Corp, NVIDIA Corp |
| VOO · SCHD | 7% | 44 | Home Depot Inc/The, AbbVie Inc, Chevron Corp |
| VTI · SCHD | 7% | 61 | AbbVie Inc, Home Depot Inc/The, Chevron Corp |
| QQQ · SCHD | 6% | 6 | Cisco Systems, Inc., PepsiCo, Inc., Texas Instruments Inc. |
The companies you own the most of, through all four funds
| Company | Weight in the portfolio | Through |
|---|---|---|
| Apple Inc | 6.49% | VOO · VTI · QQQ |
| NVIDIA Corp | 5.40% | VOO · VTI · QQQ |
| Microsoft Corp | 5.34% | VOO · VTI · QQQ |
| Amazon.com Inc | 3.65% | VOO · VTI · QQQ |
| Meta Platforms Inc | 2.37% | VOO · VTI · QQQ |
| Broadcom Inc | 2.03% | VOO · VTI · QQQ |
| Alphabet Inc | 1.82% | VOO · VTI · QQQ |
| Tesla Inc | 1.79% | VOO · VTI · QQQ |
| Alphabet Inc | 1.56% | VOO · VTI · QQQ |
| Cisco Systems Inc | 1.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
- 1Import the positions from Interactive Brokers and open the analysis.
- 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.
- 3Compare two portfolios on the Compare page: Holdings in common shows the overlap between them, pair by pair.
- 4Check a single pair without an account in the free ETF 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.