Is My Portfolio Diversified? How to Find Hidden Overlap
Owning many tickers is not the same as owning many bets. Here is how to find the overlap hiding in your ETFs and stocks, and how many independent positions you really have.
ResourcesGuide
How to Analyze Your Stock Portfolio: The 6 Checks Professionals Run
Returns tell you what happened. These six checks tell you why, and what could happen next: concentration, overlap, crash exposure, a fair benchmark, efficiency and dead weight.
Key takeaways
- Looking at total return alone hides most of what matters: how much risk you took to get it.
- Check six things: concentration, hidden overlap, crash exposure, a risk-matched benchmark, efficiency and weak holdings.
- Twelve stocks that move together behave like one or two bets, not twelve.
- Compare yourself with a risk-matched benchmark built from the same kinds of assets, not automatically with the S&P 500.
- Re-run the checks whenever you add a position or the market regime shifts.
In this article
- Why your return number is not an analysis
- Check 1: Concentration
- Check 2: Hidden overlap and correlation
- Check 3: Crash exposure
- Check 4: A benchmark that matches your risk
- Check 5: Efficiency (the efficient frontier)
- Check 6: Dead weight
- How often should you analyze your portfolio?
- Doing it by hand vs. with a tool
Why your return number is not an analysis
Most investors “analyze” a portfolio by looking at one number: how much it is up. That number answers the least useful question. A portfolio that gained 20% by holding three volatile tech stocks is not the same as one that gained 20% across uncorrelated assets. The first one got lucky with risk it may not know it is carrying.
Professional risk teams start from the other end. Before they ask how much a portfolio made, they ask how it is built: where the risk sits, what moves together, and what happens in a bad year. Here are the six checks they run, and how to run them yourself.
Check 1: Concentration
The question: how much of your money rides on a single stock, sector or theme?
List every holding with its weight. Then group them: by sector, by country and by theme (AI, energy, rates). Many portfolios look diversified by ticker count and are concentrated by theme. Five semiconductor names, a Nasdaq ETF and a cloud stock are, in practice, one bet on the same cycle.
Rule of thumb: if one position or one theme could fall 40% and change your life plans, it is too big for your risk tolerance, however good the company is.
Check 2: Hidden overlap and correlation
The question: how many truly independent positions do you have?
Overlap comes in two forms. Direct overlap is owning the same company several times, for example Apple on its own plus inside an S&P 500 ETF plus inside a tech ETF. Statistical overlap is owning different companies whose prices move together. Both mean you have fewer real bets than you think.
To measure the second kind, build a correlation matrix of daily or weekly returns over at least one to three years. Pairs above roughly 0.7 tend to rise and fall together. Clusters of highly correlated holdings should be judged as a single position when you think about risk.
Check 3: Crash exposure
The question: what would your current holdings have done in the last real crashes?
Replay your portfolio, with today’s weights, through past stress periods. The point is not to predict the next crash. It is to find out, before it happens, which positions drive your losses and whether anything you own actually cushions them.
| Stress period | S&P 500 peak to trough (approx.) | What to look for in your portfolio |
|---|---|---|
| Global financial crisis, 2007–09 | −57% | Leverage, banks, cyclicals, small caps |
| COVID crash, Feb–Mar 2020 | −34% | Travel, energy, anything priced for perfection |
| Rate-hike bear market, 2022 | −25% | Long-duration growth stocks and long bonds falling together |
If your portfolio would have fallen far more than the index in all three, you are taking more risk than a passive investor, and the next check tells you whether you are being paid for it.
Check 4: A benchmark that matches your risk
The question: are your returns the result of skill, or just of taking more risk?
Comparing every portfolio with the S&P 500 is convenient and often misleading. A conservative portfolio will usually lag it in bull markets and look like a failure when it is doing its job. An aggressive one can beat it simply by holding more volatile stocks.
The fair comparison is a risk-matched benchmark: replace each holding with the index fund for its kind of asset (Nasdaq-100 for large tech, S&P 500 for broad large caps, small-cap, bond or international indexes for the rest), weighted like your portfolio. If you do not beat it after fees and taxes over several years, the passive version of your own bets would likely have served you as well.
Check 5: Efficiency (the efficient frontier)
The question: could the same holdings give you more expected return for the same risk, or the same return for less?
Harry Markowitz’s efficient frontier, the work behind his 1990 Nobel Prize, maps every possible mix of a set of assets by expected return and volatility. The frontier is the set of mixes where you cannot improve one without worsening the other. Most hand-built portfolios sit below it, which means a re-weighting of what you already own could do better on paper.
Treat the result as a direction, not a precise answer: the inputs are estimates from history. But a portfolio far below the frontier is a strong sign that position sizes were set by habit rather than by design.
Check 6: Dead weight
The question: which holdings add risk without adding return or protection?
Score every position on its contribution, not its story. Useful labels: wealth generating (drives returns), wealth preserving (steadies the portfolio), prospect (a small bet with a thesis) and risky (high volatility, weak fundamentals, and no clear role). The last group is where most of the easy improvement hides.
How often should you analyze your portfolio?
Run the full set of checks at least once a quarter, and again whenever you add or remove a position, after a large market move, or when the broader backdrop changes, for example when credit conditions tighten. Between full reviews, watching concentration and your largest positions is usually enough.
Doing it by hand vs. with a tool
Every check above can be done in a spreadsheet with price history and some patience. The trade-off is time: a careful pass over a 15-stock portfolio takes most of a weekend, and it is out of date the next time you trade.
| Spreadsheet | Exent | |
|---|---|---|
| Time per review | Hours | About a minute from a screenshot |
| Correlation matrix | Manual, needs price data | Included |
| Crash replays (2008, 2020, 2022 and more) | Manual | Included |
| Risk-matched benchmark | Hard to build | Included |
| Efficient frontier | Needs a solver | Included |
| Plain-English explanation | You write it | Included |
Frequently asked questions
Concentration and overlap together. Most painful losses come from owning more of one risk than you realized, not from any single bad stock.
There is no fixed number. What matters is how many independent bets you hold. Twenty stocks in one sector can be less diversified than eight across uncorrelated areas plus a broad index fund.
Yes, with a spreadsheet and free price history you can run every check in this guide. Tools mainly save time and remove calculation errors.
Only if your portfolio looks like the S&P 500. Otherwise compare it with a risk-matched benchmark: the index funds that match each of your holdings, weighted like your portfolio.
Run all six checks in about a minute.
Upload a screenshot of your holdings and see your concentration, overlap, crash exposure and risk-matched benchmark.
Check my portfolioLimited offer$1.95 for unlimited checks· unlimited checks
Educational content, not investment advice. Examples are illustrative; past performance does not guarantee future results.