How to See Inside Your ETFs: A UK Investor's Guide to ETF Look-Through

TL;DR

ETF look-through is the process of disaggregating a fund into its constituent stocks, so you know what you actually own rather than just the wrapper.
UK investors face specific challenges: UCITS Key Information Documents (KIDs) disclose only top-10 holdings, JustETF truncates at 10, and Vanguard's full holdings PDFs are updated monthly with a two-week lag — meaning manual look-through requires multiple data sources.
Invormed automates look-through across your entire UK portfolio, aggregating holdings across ISA, SIPP, and GIA accounts and surfacing concentration risk at the individual stock level.

What is ETF look-through analysis?

ETF look-through is the analytical process of decomposing a fund into its underlying securities and aggregating those positions as if you held each stock directly. Rather than recording "I own VWRP", look-through says: "I own 0.43% Apple, 0.39% Microsoft, 0.31% Nvidia" — and so on across every constituent.

The term is borrowed from institutional portfolio management, where regulators and risk teams routinely require look-through for fund-of-funds and multi-asset structures. For a retail investor, the motivation is simpler: if you hold three ETFs, you may be far more concentrated in a handful of US megacap technology stocks than any individual line item suggests. Look-through makes that visible.

At its core, the calculation is: your ETF weight × each constituent's weight within the ETF = effective direct exposure. Run this for every ETF in a portfolio, sum across overlapping stocks, and you have a true stock-level view.

Why UK investors especially need it

In the United States, SEC regulation requires ETFs to publish their full holdings daily. UK and EU investors operate under a different regime.

Under UCITS rules, the Key Information Document (KID) discloses only the top-10 holdings — sufficient for a basic risk summary, wholly inadequate for overlap analysis. Full holdings are technically available via fund factsheets, but publication frequency, formatting, and accessibility vary significantly by provider. Vanguard publishes full holdings CSVs monthly; iShares publishes them more frequently but across inconsistent file formats; some smaller UCITS providers publish quarterly PDFs with no machine-readable alternative.

JustETF, the most commonly referenced free tool for UK ETF data, caps its holdings view at 10 constituents in its free tier and 20 in its premium tier. For an index like the FTSE All-World, which holds approximately 3,700 stocks, this is statistically close to useless for overlap detection.

The practical result: a UK investor holding both VWRP (Vanguard FTSE All-World) and VUSA (Vanguard S&P 500) may believe they hold two diversified funds. The reality, explored below, is considerably more concentrated than that framing implies.

A worked example — what's actually inside `VWRP`?

VWRP tracks the FTSE All-World Index, which covers large and mid-cap equities across developed and emerging markets. The key numbers (approximate as of early 2026, sourced from Vanguard's published factsheet):

Metric	Value
Number of holdings	~3,700
US weight	~65%
Top-10 weight	~18%
Emerging markets weight	~11%
Ongoing charge figure (OCF)	0.22%

The top-10 positions are essentially the S&P 500's largest constituents: Apple, Microsoft, Nvidia, Amazon, Alphabet (A & C shares), Meta, Tesla, Berkshire Hathaway, Broadcom. These are the same names that dominate VUSA, SWDA (iShares Core MSCI World), HMWO (HSBC MSCI World), and EQQQ (Invesco Nasdaq-100).

A portfolio of VWRP alone therefore carries ~18% of its value in 10 stocks. That is not inherently dangerous — FTSE All-World is one of the broadest indices available — but it is the baseline from which overlap compounds when additional ETFs are added.

The overlap problem: `VWRP` + `VUSA`, or `SWDA` + `EQQQ`

Scenario 1: VWRP + VUSA

An investor holding VWRP (80% of portfolio) and VUSA (20%) believes they have a core global fund supplemented by US exposure. Running look-through:

VWRP at 80% weight: ~52% effective US exposure in portfolio terms (80% × 65%)
VUSA at 20% weight: ~20% effective US exposure (20% × ~99%)
Combined US exposure: approximately 72% of the total portfolio

At the stock level, Apple's effective weight across both funds is roughly: (80% × 4.5%) + (20% × 7.0%) = 3.6% + 1.4% = 5.0% in Apple alone. The same arithmetic applies to the other US megacaps. The investor has not diversified; they have doubled down on a subset of the portfolio they may have intended to complement.

Numbers are illustrative using approximate index weights as of early 2026.

Scenario 2: SWDA + EQQQ

SWDA tracks MSCI World (developed markets only, ~1,400 holdings, ~70% US). EQQQ tracks the Nasdaq-100. The Nasdaq-100's top holdings are a subset of MSCI World's top holdings: every position in EQQQ also appears in SWDA.

Holding SWDA (70%) + EQQQ (30%) means the Nasdaq-100 component amplifies positions that already exist in the core. Effective Nvidia weight, for instance, could exceed 4–5% of the total portfolio despite the investor believing EQQQ is a modest "growth tilt". Look-through makes this precise; intuition alone does not.

Numbers are illustrative using approximate index weights as of early 2026.

How to run your own look-through

This is a HowTo process with two routes: manual and automated.

Manual route

Step 1 — Inventory your ETFs and weights

List every ETF you hold across all accounts (ISA, SIPP, GIA). Record the ticker, current value, and that value as a percentage of your total portfolio.

Step 2 — Download full holdings files

For each ETF:

Vanguard funds (VWRP, VUSA, VFEM): Go to the fund page on vanguard.co.uk, navigate to "Portfolio data", download the monthly holdings CSV.
iShares funds (SWDA, CSPX, EIMI): Go to ishares.com/uk, find the fund, click "Holdings" tab, export to CSV. iShares updates holdings daily.
Invesco funds (EQQQ): Go to invesco.com/uk, find the ETF, download holdings from the "Portfolio" section.
HSBC funds (HMWO, HUKX): Holdings are available on hsbcassetmanagement.com, typically updated monthly.

Step 3 — Normalise the data

Each provider uses different column structures. At minimum you need: ISIN or ticker, security name, portfolio weight (%). Strip any cash or derivative lines.

Step 4 — Scale and aggregate in Excel

For each security across all funds:

Effective weight = SUM(ETF_portfolio_weight × security_fund_weight)

Sort descending by effective weight. Your top-20 single-stock exposures are now visible.

Step 5 — Identify concentration risk

Flag any single stock above 2% effective weight, any sector above 30%, and total US exposure above your intended allocation.

This process takes 60–90 minutes for a three-ETF portfolio and needs repeating whenever you rebalance or holdings files are updated.

Automated route (Option B)

Invormed performs this calculation continuously across your linked ISA, SIPP, and GIA accounts, pulling provider holdings files on your behalf and surfacing look-through exposure at the stock, sector, and geography level. No spreadsheets required.

What to do with the insight

Look-through is an input, not an instruction. Once you have a clear stock-level view, three questions structure the response:

Is your US tech concentration intentional?

If you hold VWRP and are comfortable with ~65% US and ~18% in 10 stocks, no action is required. Many investors are. But if you added VUSA believing it was additive rather than amplifying, that warrants a rebalance toward a genuinely diversifying complement — VFEM (Vanguard FTSE Emerging Markets), VERX (Vanguard FTSE Developed Europe ex UK), or a UK-tilted fund like VUKE.

Do you have meaningful single-stock positions you did not choose?

A single-stock exposure above 3% effective weight is worth examining, particularly if it sits inside a tax-advantaged wrapper where direct stock selection would be more efficient. Some investors choose to hold individual positions in Apple or Microsoft alongside index funds — look-through clarifies whether this is additive or redundant.

When does it not matter?

For a single-fund portfolio — VWRP only, or SWDA only — look-through confirms what the factsheet already tells you. The analysis becomes valuable when you hold two or more ETFs, or when you combine ETFs with individual stocks or active funds.

Concentration thresholds are personal. A common institutional heuristic sets individual security limits at 5% and sector limits at 30–35%. These are reference points, not rules — but they provide a consistent basis for making decisions rather than relying on intuition about fund names.

FAQ

What does ETF look-through mean?

ETF look-through means decomposing an ETF into its underlying individual stocks, so you can see your real economic exposure at the security level rather than at the fund level. It reveals whether your "diversified" multi-fund portfolio is actually concentrated in a small number of stocks.

How do I see the stocks inside `VWRP`?

Download the full holdings CSV from vanguard.co.uk's fund page for VWRP (updated monthly). The file lists all ~3,700 constituent stocks with their portfolio weights. Multiply each weight by your VWRP allocation to get your effective exposure to each security.

Do `VWRP` and S&P 500 ETFs like `VUSA` overlap?

Yes, significantly. VWRP allocates approximately 65% to US equities, and its top holdings are the same large-cap US stocks that make up most of VUSA. Adding VUSA to a VWRP portfolio increases US concentration and amplifies single-stock positions in names like Apple, Microsoft, and Nvidia, rather than providing genuine diversification.

Why is ETF look-through harder for UK investors than US investors?

US ETFs disclose full holdings daily under SEC rules. UK and EU UCITS funds are only required to publish top-10 holdings in the KID, with full holdings available in separate factsheets on varying schedules. Free tools like JustETF cap holdings display, making comprehensive overlap analysis dependent on manually sourcing provider CSV files.

What is ETF overlap and how is it measured?

ETF overlap measures what proportion of two funds' weights are allocated to common holdings. A simple measure is: for each security held in both funds, sum the lower of the two weights. A high overlap score means the funds are largely tracking the same underlying stocks. SWDA and HMWO, both tracking MSCI World, have near-complete overlap.

How often should I run ETF look-through?

Index weights drift as markets move and indices rebalance, but the overall composition of broad market ETFs changes slowly. Running look-through quarterly, or when you make a significant trade, is sufficient for most self-directed investors. The more frequently you need it, the more the case for an automated tool.

Does ETF look-through work for bond ETFs or multi-asset funds?

The same principle applies — you can decompose a gilt ETF into its constituent issues, or a corporate bond ETF into individual issuers. Multi-asset funds (e.g., Vanguard LifeStrategy) hold other funds, requiring recursive look-through: decompose the fund into its constituent ETFs, then look through each ETF to the underlying securities. This is significantly more complex manually but is the only way to understand true exposure in a fund-of-funds structure.

See inside your ETFs — try Invormed free