A portfolio can hold many tickers and still depend on the same small group of companies, sectors, countries, or market factors. This guide explains how to check portfolio overlap, estimate concentration risk, and turn a holdings list into an underlying-exposure worksheet you can revisit after each rebalance or major portfolio change.
Overview
Portfolio diversification is not measured by ticker count alone. Owning an individual technology company, a broad-market ETF, and a technology-sector ETF may look like three separate positions, but all three could give you meaningful exposure to the same underlying companies. The same issue can appear across funds that track different indexes, retirement accounts held at different providers, or stock and option positions in the same issuer.
Portfolio concentration risk is the possibility that one company, industry, factor, geography, fund provider, or market outcome has a larger effect on total results than intended. Concentration is not automatically wrong. An investor may deliberately hold a substantial position in an employer, a domestic market, dividend stocks, or a particular investment theme. The risk arises when the exposure is accidental, poorly understood, or inconsistent with the investor's time horizon and ability to withstand losses.
A useful audit asks six questions:
- How much of the portfolio is linked to each individual company?
- How much is linked to each sector or industry?
- Which positions share the same style or factor exposure, such as growth, value, size, momentum, or high yield?
- How much is exposed to one country, currency, or region?
- Do several funds hold the same top companies?
- Are multiple funds or products tied to the same issuer, index methodology, or liquidity risk?
The goal is not to eliminate overlap. It is to identify it, decide whether it is intentional, and size positions accordingly.
How to estimate portfolio overlap
Start with the current market value of every investment, including taxable accounts, retirement accounts, cash alternatives, restricted stock, and any material exposure outside the main brokerage account. Record the ticker, number of shares, market value, fund name, and account location. Use current holdings files or fund factsheets where available rather than relying on an old purchase list.
Calculate each position's portfolio weight with this formula:
Position weight = position market value ÷ total portfolio market value × 100
For an ETF or mutual fund, estimate your look-through exposure to a company by multiplying the fund weight by your position weight. For example, if an ETF represents 20% of the portfolio and a company represents 6% of that ETF, the portfolio's indirect exposure is approximately 1.2%. Add any direct holding in the same company to estimate total exposure.
Look-through company exposure = fund portfolio weight × company weight inside the fund
Repeat this calculation for each fund's largest holdings. You do not need to map every small position to find the most important overlaps. Begin with direct stocks and the top 10 holdings of each fund, then expand the review if a company or sector appears repeatedly.
| Risk type | What to group | Warning sign to investigate |
|---|---|---|
| Single-stock | Direct shares plus indirect fund exposure | One issuer becomes a large share of total assets without a deliberate reason |
| Sector | Holdings classified in the same sector or industry | Several funds appear diversified but rely on the same business cycle |
| Factor | Growth, value, size, momentum, quality, income, or low volatility traits | Positions may fall together during a style rotation |
| Geographic | Country, region, currency, and domicile exposure | International labels obscure a heavy allocation to one market |
| Issuer | Fund sponsor, bank, counterparty, or product provider | Operational or product-specific exposure is repeated across accounts |
| Top-10 overlap | Largest holdings across all funds | The same companies dominate multiple supposedly different ETFs |
There is no universal concentration threshold suitable for every investor. Instead, set review bands in advance. For example, you might flag any company, sector, or country that exceeds a personally chosen percentage of the portfolio, then require a written reason for keeping it above that level. The threshold should reflect your goals, income stability, liquidity needs, tax constraints, and tolerance for drawdowns.
Inputs and assumptions for an overlap worksheet
A simple spreadsheet can make ETF overlap analysis repeatable. Create one row for each direct security and each fund. Include these columns:
- Holding: ticker or fund name.
- Market value: use a consistent valuation date across accounts.
- Portfolio weight: market value divided by total portfolio value.
- Asset class: equity, bond, cash, commodity, cryptocurrency, or another category.
- Sector and geography: record the fund's stated classifications and note that classifications can differ by provider.
- Top holdings: enter the largest holdings and their fund weights from the latest available factsheet.
- Factor or strategy label: broad market, value, growth, dividend, small-cap, leveraged, covered-call, or another relevant description.
- Review note: state whether the exposure is intentional and what would cause you to reduce it.
Use the latest available fund holdings, but record the date. Holdings can change because of rebalancing, index reconstitution, mergers, corporate actions, or portfolio-manager decisions. A fund's name also does not guarantee that its actual exposure matches your assumption, particularly when the strategy uses derivatives, cash, foreign listings, or alternative classifications.
For correlation, treat historical relationships as context rather than a promise. Assets that behaved differently in one period can move together in another, especially during broad market stress. Concentration analysis should therefore combine numerical exposure with an explanation of what could drive each holding's returns.
Worked examples
Assume an investor has a $100,000 portfolio consisting of a $35,000 broad-market ETF, a $20,000 technology-sector ETF, a $15,000 individual technology company, a $15,000 international ETF, and $15,000 in short-term assets.
The direct company position is 15% of the portfolio. Suppose the broad-market ETF has a 5% position in that company and the technology ETF has a 9% position. The estimated indirect exposure is:
- Broad-market ETF: 35% × 5% = 1.75%.
- Technology ETF: 20% × 9% = 1.80%.
- Direct holding: 15%.
- Estimated total company exposure: 18.55%.
The investor may still accept that exposure, but the result is materially different from viewing the three securities as unrelated positions. The same worksheet can reveal sector overlap. If the broad-market ETF and international ETF also hold large technology allocations, the portfolio's technology exposure may be substantially higher than the investor's direct sector ETF suggests.
A second example involves geography. An international fund may include several countries, while a separate emerging-market fund and individual foreign stocks may increase exposure to one region. Grouping by country and currency can show whether the apparent global allocation is actually concentrated in a narrower set of markets.
After finding overlap, possible responses include reducing a direct position, replacing a narrowly focused fund with a broader one, directing new contributions toward an underrepresented asset, or keeping the position while documenting why the concentration is acceptable. Selling is not the only solution; taxes, transaction costs, spreads, and account restrictions matter.
When to recalculate
Run the overlap review at least quarterly if your portfolio contains multiple funds, and repeat it after adding a new ETF, changing a target allocation, or making a large individual-stock purchase. Recalculate sooner after a sharp price move because a position can become concentrated through appreciation even when no new shares are purchased.
Also update the worksheet after fund reconstitutions, mergers, changes in index methodology, or a material change in a fund's strategy. Review the latest holdings and factsheets rather than assuming that last quarter's composition still applies. Changes in interest rates, economic conditions, or market leadership can also alter the practical importance of factor and sector exposures, even when the ticker list is unchanged.
Make the process part of your regular quarterly portfolio rebalance checklist. Keep a dated copy of the worksheet and record three decisions: which overlaps were intentional, which exceeded your review band, and what action—if any—you will take. Investors assessing international exposure can pair this review with an international investing checklist, while those planning for downturns may find a portfolio drawdown plan useful.
The most effective concentration check is a habit, not a one-time calculation. Count underlying exposures, not just tickers; use consistent market values; question assumptions; and size positions according to the risk you are actually willing to carry.