Why a separate stock can be the same exposure
An S&P 500 ETF holds shares in its index constituents; a Nasdaq-100 ETF holds shares in its own constituents. Many large companies appear in both indexes. If you own either ETF and add one of its holdings directly, you increase your exposure to that company rather than introducing an entirely new one. If you own both ETFs, the same company may already reach you through two funds.
The size of that overlap changes as ETF holdings and portfolio values change. Look up each fund’s current holdings and weights on the issuer’s website rather than assuming every index ETF has the same composition. Check the fund’s actual holdings: an ETF may track an index with modifications or use a different weighting method.
Overlap is not automatically a problem. The question is whether the resulting company and sector weights match the concentration you intended to take on.
Calculate your effective stock weight
Put every holding on the same denominator: the market value of your entire portfolio. For stock A, add its direct holding to the portion held through each ETF:
Effective weight of stock A = (direct value of A + Σ[ETF value × A’s weight in that ETF]) ÷ total portfolio value.
ETF weights and effective portfolio weights are fractions in this formula. Multiply the result by 100 to express it as a percentage. Use ETF holdings from the same approximate date as your portfolio values; otherwise, the answer is only an approximation.
Consider a hypothetical US$20,000 portfolio: US$10,000 in an S&P 500 ETF, US$6,000 in a Nasdaq-100 ETF, and US$4,000 in other holdings. Suppose stock A is 6% of the first ETF and 8% of the second. Your existing exposure is (US$10,000 × 0.06) + (US$6,000 × 0.08) = US$1,080, or 5.4% of the portfolio. The remaining US$4,000 matters to the denominator even if none of it contains A.
Now suppose you add US$1,000 of A using new cash. Your exposure becomes US$2,080, but the portfolio also grows to US$21,000. A’s effective weight becomes US$2,080 ÷ US$21,000 ≈ 9.9%. If you instead fund the purchase by selling US$1,000 of another holding, the portfolio remains US$20,000 and A’s effective weight becomes 10.4%, assuming the holding sold contained no A. Selling part of an ETF that holds A requires a further adjustment because you also remove some indirect exposure.
This is a look-through calculation, not a claim that you directly own the ETF’s underlying shares. It measures the economic exposure you have through the fund.
Check sector double exposure, too
Company overlap is only one layer. Adding a stock in a sector already prominent in your ETFs increases your exposure to that sector even if the specific company is not in either fund.
To estimate a sector’s total weight, use the same approach: multiply each ETF’s share of your portfolio by that ETF’s sector weight, then add the market value of directly held stocks in the sector. Divide the total by portfolio value. For a proposed purchase, recalculate both the sector’s dollar exposure and the portfolio denominator.
Sector labels are useful but imperfect. Two companies in the same sector can have different businesses, while companies in different sectors can respond to similar economic forces. Check sector weights alongside company overlap, not as a substitute for it.
Measure concentration with weights and HHI
Start with the largest effective company weight. It is easy to interpret: if stock A is 9.9% of your portfolio after a purchase, roughly US$9.90 of every US$100 of portfolio value is exposed to A, through direct holdings and ETFs combined.
For a portfolio-wide measure, calculate the Herfindahl-Hirschman index (HHI) from look-through company weights:
HHI = Σ(wᵢ²), where each wᵢ is a company’s fraction of the total portfolio. With percentage weights instead, the conventional scale runs from 0 to 10,000. State which scale you use; the two versions differ by a factor of 10,000.
For example, a hypothetical two-company portfolio split 50%/50% has an HHI of 0.50² + 0.50² = 0.50, or 5,000 using percentage weights. A hypothetical four-company portfolio split equally has an HHI of 4 × 0.25² = 0.25, or 2,500. On this measure, the first portfolio is more concentrated.
Effective number of equally weighted holdings = 1 ÷ HHI, when HHI uses fraction weights. That gives two for the 50%/50% example and four for the four-company example. It is a description of weight concentration, not a count of distinct risks or a guarantee of diversification.
A complete look-through HHI requires constituent-level weights for every fund and direct holding. If some holdings cannot be identified, an HHI calculated from only the known companies is incomplete. An ETF counted as a single holding gives a different answer: it measures concentration among your account’s holdings, not among the underlying companies. For a separate view of sector concentration, calculate HHI using sector weights and label it sector HHI.
Size an added position from the resulting exposure
A proposed trade’s dollar amount is not the same as the resulting company weight. The latter depends on existing ETF overlap, how you fund the purchase, and the portfolio’s value after the trade. Pick a hypothetical maximum effective weight for your own scenario, then work backward to see what purchase size would reach it. This is a measurement exercise, not a recommended limit.
If the purchase uses new cash, let P be current portfolio value, E be existing look-through exposure to stock A, T be the chosen target weight as a decimal, and x be the new stock purchase in dollars. Assuming other prices and ETF weights do not change:
(E + x) ÷ (P + x) = T, so x = (TP − E) ÷ (1 − T), provided T is below 1.
Using the hypothetical portfolio above, P = US$20,000 and E = US$1,080. For an illustrative 8% target, x = (0.08 × US$20,000 − US$1,080) ÷ 0.92 ≈ US$565. That figure is not a suggested trade; it shows why adding US$1,000 of a stock already present in ETFs produces more than an 8% effective weight in this example.
If you fund a purchase by selling another holding that contains no A, the portfolio denominator stays at P, and the corresponding equation is x = TP − E. If you sell an ETF that contains A, reduce E by the A exposure removed through that sale before calculating the result. Round-number calculations also omit price moves, transaction costs, and changes in ETF composition.
Make the pre-trade check practical
Before placing any order, write down the direct stock value, each ETF’s current weight in that stock, the proposed trade amount, and the funding source. Recalculate effective company and sector weights for the whole portfolio, then check the largest weight and look-through HHI. Finally, consider execution conditions such as estimated spread, order size relative to daily volume, and potential market impact: diversification and trading cost are different questions.
PreTrAIde’s free portfolio concentration checker shows HHI and largest weight. Its position size calculator and trading cost calculator address other parts of the pre-trade check. Do not assume an HHI calculation looks through ETF constituents unless you have supplied or verified the underlying company weights; an account-level measure alone cannot reveal hidden stock overlap.
PreTrAIde’s PreTrade analysis evaluates a basket of one or more stocks before an order is placed and returns a GO, NO-GO, or MODIFY verdict with risk and execution reasoning. Its portfolio breakdowns include sectors, and its quantitative layer includes HHI. Those verdicts are decision support, not investment recommendations. PreTrAIde does not place orders; you decide whether and how to trade through your own broker.