1.7 – How to Track ETF Exposure in Excel
- Compounding Investor
- Jul 27
- 12 min read
Updated: Jul 28
Track What Your ETFs Really Own
Most investors know which Exchange Traded Funds (ETFs) they own.
A portfolio containing ten different ETFs may appear highly diversified, yet beneath the surface those funds can contain hundreds of overlapping holdings, repeated sector exposures and concentrated positions in the same companies.
Without tracking ETF exposure properly, many investors unknowingly build portfolios that are less diversified than they believe.
This is one of the most common blind spots uncovered through the Investor Progression Model.
Early-stage investors typically focus on individual holdings—recording how many ETFs they own, how much each is worth and whether the portfolio is growing.
As investors become more structured, they begin looking beyond the fund names themselves. They start measuring what those funds actually contain, how exposures combine across multiple accounts and whether their overall portfolio reflects the investment strategy they intended to build.
The most advanced investors recognise that diversification isn’t created by owning more funds.
It is created by understanding the underlying exposures those funds collectively produce.
Tracking ETF exposure transforms a spreadsheet from a simple portfolio record into a decision-making system.
Instead of asking:
“How many ETFs do I own?”
Structured investors ask:
“What businesses, sectors, countries and investment themes am I actually exposed to?”
That shift fundamentally changes how investment decisions are made.
In this guide you’ll learn how to build an Excel-based ETF exposure tracking system that reveals hidden overlap, measures true diversification and helps you progress towards becoming a more disciplined, structured long-term investor.
Understand Your Portfolio Before You Diversify
Don’t assume more ETFs create more diversification.
Start by understanding your portfolio’s underlying exposure.
Complete the Free Investor Assessment to identify your Investor Progression Model stage and discover whether your investments are genuinely diversified—or simply own the same companies through different funds.
Build your portfolio with confidence by understanding what you actually own, not just what appears on your brokerage statement.
Only takes 2-minutes • manually reviewed • delivered within 24 hours
Who This Guide Is For
This guide is designed for investors who already own one or more ETFs and want to understand what sits beneath the surface of their portfolio.
Whether you invest through index funds, global equity ETFs, sector funds, dividend ETFs or thematic products, understanding your true exposure becomes increasingly important as your portfolio grows.
It is particularly valuable for investors who:
own multiple ETFs across different accounts
want to identify hidden overlap between funds
are unsure whether their portfolio is genuinely diversified
want to reduce concentration risk before it becomes a problem
are building a structured long-term investment process rather than simply accumulating more investments
If you’ve ever wondered whether adding another ETF is genuinely improving diversification—or simply buying more of the same underlying companies—this guide will help you answer that question with confidence.
What You'll Learn | |
Hidden ETF Exposure | Why owning multiple ETFs doesn’t automatically create diversification. |
The ETF Exposure Gap | How unseen overlap can distort your portfolio without you realising it. |
Practical Excel Tracking | How to build an ETF exposure tracker that reveals your true portfolio composition. |
Why understanding underlying exposures is a key step in progressing from simply owning investments to managing them systematically. | |
How tracking ETF exposure helps reduce concentration risk, improve diversification and build a more resilient long-term portfolio. |
Contents
Why ETF Diversification Can Be Misleading
The ETF Exposure Gap
Why Fund Names Don’t Tell The Full Story
The Different Types of ETF Exposure Every Investor Should Track
How to Build an ETF Exposure Spreadsheet in Excel
Identifying Hidden Overlap Between ETFs
Tracking Sector, Geographic and Company Concentration
Real Investor Case Study (Brazil 🇧🇷)
What The Review Revealed
The Real Issue
What Changed
Common ETF Exposure Mistakes
Quick ETF Exposure Audit
Who This Guide Is For
Who This Guide Is Not For
Frequently Asked Questions
Explore The Full Framework
Related Articles
Final Thought
Why ETF Diversification Can Be Misleading
Exchange Traded Funds have transformed investing. They offer low costs, broad diversification and access to almost every market, sector and investment strategy imaginable.
As a result, many investors naturally assume that owning more ETFs creates a better-diversified portfolio. Unfortunately, this isn’t always true.
Two ETFs with completely different names may own many of the same underlying companies.
Global equity funds often hold similar large-cap stocks.
Dividend ETFs frequently overlap with quality or value funds.
Even regional ETFs can contain businesses that generate revenue across the same global markets.
On the surface, your portfolio may appear highly diversified.
Beneath the surface, your exposure may be far more concentrated than you realise.
Understanding that difference is one of the key characteristics of a Structured Compounder.
The ETF Exposure Gap
On the surface, ETF investing appears simple. You buy a collection of diversified funds, spread your money across different markets and assume your portfolio is well balanced.
But fund names rarely tell the whole story.
The same companies, sectors and countries often appear repeatedly across multiple ETFs, creating concentrations that remain invisible unless you analyse the underlying holdings. This is what I call The ETF Exposure Gap.
The graphic below illustrates the difference between tracking the ETFs you own and understanding the exposures they collectively create.
Closing the ETF Exposure Gap changes the way investors think about diversification.
Instead of counting the number of ETFs in a portfolio, Structured Compounders measure the businesses, sectors, countries and themes their capital is actually invested in. Every new ETF purchase is evaluated according to how it changes total portfolio exposure—not simply whether it adds another fund.
That shift transforms ETF tracking from a list of investments into a framework for making better long-term allocation decisions.
Why Fund Names Don’t Tell The Full Story
ETF names describe investment objectives. They don’t describe portfolio exposure.
A Global Equity ETF.
A Technology Leaders ETF.
An Innovation ETF.
Three different names.
Potentially many of the same underlying holdings.
Looking only at fund names makes it easy to believe every new ETF adds diversification.
In reality, many simply increase existing exposure to companies you already own indirectly.
Understanding what sits beneath every fund allows investors to distinguish genuine diversification from duplicated exposure.
That’s why Structured Compounders analyse portfolios at the underlying holding level—not simply at the fund level.
The Different Types of ETF Exposure Every Investor Should Track
Company overlap is only one part of the picture. A complete ETF exposure review should consider multiple dimensions of portfolio risk.
At a minimum, investors should understand:
Company Exposure – The underlying businesses held across every ETF.
Sector Exposure – How much capital is allocated to industries such as technology, healthcare or financials.
Geographic Exposure – The countries and regions where investments are concentrated.
Asset Allocation – The balance between equities, bonds, property, commodities and cash.
Investment Style Exposure – Growth, value, quality, dividend, small-cap or other investment factors.
Currency Exposure – The currencies that ultimately influence portfolio returns.
Looking across all of these exposures provides a much more accurate picture of diversification than counting the number of ETFs held.
How to Build an ETF Exposure Spreadsheet in Excel
Building an ETF exposure tracker is far simpler than many investors expect. The objective isn’t to recreate the fact sheet for every ETF. It is to understand how the underlying exposures combine across your entire portfolio.
Begin by listing every ETF you own.
Next, record the percentage allocation of each ETF within your portfolio.
For each fund, capture the key underlying exposures that matter to your investment process, such as major holdings, sector allocations, geographic allocations and asset class weightings.
Once these exposures are combined across every ETF, hidden patterns quickly begin to emerge.
Companies that appear repeatedly become obvious.
Regional biases become easier to identify.
Instead of reviewing each ETF independently, Excel allows you to analyse your portfolio as one connected investment system.
Identifying Hidden Overlap Between ETFs
Hidden overlap occurs when multiple ETFs own many of the same underlying companies. The duplication often develops gradually.
An investor purchases a global ETF.
Later they add a technology ETF.
Then a quality ETF.
Finally a dividend ETF.
Each purchase appears to increase diversification.
In reality, every fund may continue increasing exposure to many of the same businesses.
Without measuring underlying holdings, investors can unintentionally build concentrated portfolios while believing they have reduced risk.
This is why reviewing ETF overlap should become part of every structured portfolio review—not simply something checked when buying a new fund.
Tracking Sector, Geographic and Company Concentration
Diversification is created through exposure—not fund count.
A portfolio containing eight ETFs could still derive most of its performance from a small number of sectors, countries or companies.
Understanding concentration requires looking beyond individual investments and reviewing the portfolio as a whole.
Ask questions such as:
Which companies appear most frequently across my ETFs?
Which sectors represent the largest proportion of my portfolio?
Am I overly dependent on one country or region?
Has market performance gradually increased concentration without me noticing?
These are the questions that separate portfolio administration from portfolio management.
Structured Compounders don’t simply own diversified funds.
They understand exactly where their portfolio risk originates—and review those exposures regularly as part of a disciplined long-term investment process.
Discover What Your ETF Portfolio Is Really Exposed To
Most investors know which ETFs they own. They know:
The names of their funds
How much each ETF is worth
Their overall portfolio value
The number of ETFs they hold
Yet many still cannot answer some of the most important questions about their portfolio.
Which companies appear repeatedly across my ETFs?
Am I genuinely diversified or simply buying more of the same investments?
Where is my portfolio actually concentrated?
What stage of the Investor Progression Model am I currently at?
What should I focus on next to become a better long-term investor?
Owning multiple ETFs doesn’t automatically create diversification.
The Free Investor Assessment helps identify:
hidden overlap within your investment portfolio
diversification blind spots affecting long-term performance
your current Investor Progression Model stage
opportunities to build a more resilient portfolio
practical next steps towards becoming a Structured Compounder
Because understanding what your ETFs own is far more valuable than simply knowing which ETFs you own.
Start the Free Investor Assessment to discover what your dashboard really reveals.
Only takes 2-minutes • manually reviewed • delivered within 24 hours
Real Investor Case Study (Brazil 🇧🇷): When Different ETFs Create The Same Portfolio
A finance manager from Rio de Janeiro, had spent years building what she believed was a carefully diversified ETF portfolio. She followed a simple investment rule:
Never buy two ETFs that appeared to do the same thing.
Instead of purchasing multiple global equity funds, she deliberately selected ETFs with different names, investment objectives and themes. If a fund appeared different, she assumed it would add a new source of diversification.
By avoiding obvious duplication, she believed each new investment made her portfolio stronger.
An ETF exposure review challenged that assumption.
What The Review Revealed
Rather than analysing the ETF names, Mariana mapped the underlying holdings, sector allocations and geographic exposures of every fund into a simple Excel spreadsheet.
The results were unexpected.
Although each ETF had a different investment objective, many of them owned the same dominant global companies.
Several funds also increased exposure to identical sectors, particularly technology, despite being marketed around completely different investment themes.
When viewed as a single portfolio, much of that diversification disappeared.
The Real Issue
The Investor hadn’t duplicated ETFs. She had duplicated exposure.
Every investment decision had been based on how the ETF was described rather than what it actually contained.
The marketing, objectives and investment themes all appeared different, making the portfolio feel increasingly diversified with every purchase.
Yet beneath the surface, many of those funds were allocating capital to the same businesses and sectors.
The portfolio had become diversified by narrative rather than by underlying exposure.
What Changed
Rather than comparing ETF names, Mariana began comparing portfolio exposure. Before adding any new ETF, she first assessed how it would change the existing portfolio.
Instead of asking:
“Is this ETF different?”
she began asking:
“Does this ETF genuinely improve my portfolio?”
Sometimes the answer was yes.
Sometimes a fund that appeared unique added almost no new exposure at all.
By shifting her focus from products to underlying exposures, every investment decision became more intentional.
She stopped thinking about building a collection of ETFs and started thinking about building a portfolio.
That transition—from selecting investments to deliberately managing portfolio exposure—is one of the defining characteristics of a Structured Compounder.
Common ETF Exposure Mistakes
Many ETF investors believe diversification is achieved simply by owning more funds. In reality, diversification depends on the underlying exposures those funds create when combined as a single portfolio.
Some of the most common mistakes include:
assuming different ETF names automatically mean different holdings
buying multiple funds that repeatedly own the same companies
overlooking sector concentration created across several ETFs
believing global funds provide balanced geographic exposure without checking the underlying allocations
adding new ETFs without considering how they change the overall portfolio
reviewing each ETF independently rather than analysing the portfolio as one connected investment system
Avoiding these mistakes isn’t about finding the “perfect” ETF. It’s about understanding how every investment contributes to your portfolio as a whole.
Quick ETF Exposure Audit
Before purchasing your next ETF, ask yourself these five questions:
✓ Do I know my portfolio’s largest underlying company exposures?
✓ Have I measured my combined sector allocations across every ETF?
✓ Could two of my ETFs own many of the same businesses?
✓ Would a new ETF genuinely improve diversification, or simply increase existing exposure?
✓ Am I selecting ETFs—or deliberately building portfolio exposure?
If you answered “No” to two or more questions, your portfolio may contain hidden exposures that deserve closer review.
Who This Guide Is For
This guide is designed for investors who already invest in ETFs and want to move beyond simply tracking fund performance.
It will be particularly valuable if you:
own multiple ETFs across one or more investment accounts
invest in global, sector, dividend or thematic ETFs
want to understand what your portfolio actually owns
are concerned about hidden concentration or unintended overlap
want to make more deliberate long-term investment decisions
Whether you’re managing a $10,000 portfolio or a seven-figure investment portfolio, understanding underlying exposure is one of the foundations of effective portfolio management.
Who This Guide Is NOT For
This guide is unlikely to be useful if you:
only invest in a single ETF and have no intention of expanding your portfolio
are looking for recommendations about which ETF to buy next
want short-term trading strategies or market predictions
believe diversification is measured purely by the number of funds you own
This article focuses on understanding portfolio exposure, not selecting individual investments.
Discover What Your ETF Portfolio Is Really Exposed To
Most ETF investors know the funds they own. They can see:
ETF names
Portfolio value
Investment performance
Asset allocation
Yet many still cannot answer some of the most important questions about their portfolio.
Which companies appear repeatedly across my ETFs?
Where is my portfolio actually concentrated?
Am I genuinely diversified or simply buying more of the same businesses?
What stage of the Investor Progression Model am I currently at?
What should I change to become a more structured long-term investor?
Your portfolio may already appear well diversified.
But owning different ETFs isn’t the same as understanding your underlying exposure.
The Free Investor Assessment helps identify:
hidden portfolio exposures that aren’t immediately visible
your current Investor Progression Model stage
diversification blind spots affecting long-term decisions
opportunities to build a more structured investment system
practical next steps towards becoming a Structured Compounder
Because the strongest portfolios aren’t built by collecting more ETFs.
They’re built by understanding exactly what those ETFs own.
Takes Less Than 2-Minutes
FAQ
How many ETFs should I own?
There is no ideal number. Some investors achieve excellent diversification with a single global ETF, while others require several funds to achieve specific investment objectives.
The important question isn’t how many ETFs you own—it’s whether each one adds meaningful exposure to your portfolio.
Can two completely different ETFs own the same companies?
Yes. Many ETFs with different names, themes or investment objectives still allocate significant weight to the same large global companies.
This is why reviewing underlying holdings is far more valuable than relying on fund names alone.
How often should I review ETF exposure?
For most long-term investors, reviewing exposure once or twice a year is sufficient. You should also review your portfolio whenever making a significant new investment or changing your long-term asset allocation.
Do I need specialist software?
No. A well-designed Excel spreadsheet can provide a clear view of company, sector and geographic exposure while allowing you to tailor the analysis to your own investment process.
Explore The Full Framework
The Investor Progression Model White Paper |
This guide forms part of the Compounding Investor Progression Model—a framework designed to help investors move from reactive decision-making towards a repeatable, structured investment process. Inside the white paper you’ll discover: ✓ The four investor types ✓ Why most investors plateau ✓ The five dimensions of investor progression ✓ How Structured Compounders build repeatable systems ✓ The research behind the Investor Assessment |
⬇ READ THE WHITE PAPER ⬇ |
Related Articles
Continue Building Your Portfolio Management System
Build a complete Excel portfolio tracker that forms the foundation of a structured investment process.
Learn which portfolio metrics provide meaningful insights beyond simple investment returns.
Understand how to measure asset allocation properly and ensure your portfolio remains aligned with your long-term investment strategy.
Discover how a structured portfolio review helps identify hidden risks, concentration and weaknesses before they affect long-term performance.
Final Thought
Many investors believe diversification is something they buy. In reality, diversification is something they understand.
Owning several ETFs may create the appearance of a balanced portfolio, but appearances can be deceptive. Different fund names, investment themes and marketing objectives often mask surprisingly similar underlying exposures.
The investors who compound wealth most effectively don’t simply collect investments—they understand how those investments work together.
That’s why Structured Compounders think beyond products and focus on exposure.
Every ETF should have a clear purpose within the portfolio. Every new investment should improve the portfolio rather than simply increase its size. Every review should answer a simple but powerful question:
“What does my portfolio actually own?”
When you can answer that with confidence, diversification stops being an assumption and becomes a measurable part of your investment process.
Comments