Most investors know which ETFs they own. Far fewer understand what they actually own. Learn how to build an Excel ETF exposure tracker that uncovers hidden overlap, measures true diversification and helps you make more structured long-term investment decisions.

Most investors record what they own—but far fewer understand what those holdings reveal about portfolio risk. Learn which allocation metrics and categories every investor should track in Excel, from asset class and geography to sector exposure, individual holdings and investment vehicles, so your spreadsheet becomes a true portfolio management system rather than just a record of investments.

Many investors believe they are diversified because they own multiple shares, funds or ETFs. The reality is often very different. This guide reveals the hidden diversification problems that can exist inside apparently well-balanced portfolios, including ETF overlap, concentration risk, sector dependency, geographic bias and correlated holdings that increase risk without investors realising it.

Many investors believe they own a diversified portfolio because they hold multiple ETFs. In reality, they often own the same companies repeatedly through overlapping funds. This hidden duplication can increase concentration risk, distort allocation decisions, and create a false sense of diversification. In this guide, we show how to identify ETF overlap, measure its impact on your portfolio, and understand why Structured Compounders actively monitor overlap while Conservative

Many investors believe they are diversified when their portfolio is actually becoming increasingly concentrated. A handful of successful holdings, sector exposure, ETF overlap, and allocation drift can quietly create hidden risk beneath the surface. In this guide, you’ll learn how Reactive Investors and Structured Compounders manage portfolio weightings differently—and how to identify whether your portfolio has become overweight without you realising it.

Most investors don’t control their portfolio allocation — they drift into it. This guide shows how to build a simple Excel allocation spreadsheet to track weightings, manage risk, and stay aligned with your investment strategy.