Single Stock Concentration
Deep analysis of exposure to individual stocks through direct holdings and ETF positions
As of
Total Tracked Exposure
$4.19M
27 stocks monitored across 22 ETFs + Mutual Funds
Direct Holdings
$1.87M
ETF Exposure
$1.40M
๐
Direct Holdings
$1.87M
Individual stock positions
๐
Hidden in ETFs
$1.40M
Exposure through ETF holdings
โ
Largest Position
XOM
$513K (0.94%)
Magnificent Seven
MAG7Total MAG7 Exposure
$1.23M
% of Portfolio
2.25%
Direct / ETF Split
18% / 82%
๐ Top 10 Exposures
Direct Holdings
ETF Exposure
๐ฏ Exposure Breakdown
Complete Position Analysis
All Tracked Stocks
| # | Stock | Direct $ | ETF Exposure | Composition | Total $ | % Portfolio | Risk |
|---|---|---|---|---|---|---|---|
| TOTAL | - | - | - | - |
Methodology
๐ก Data Source
ETF holdings weights pulled from fund prospectuses via BDS formula. Data refreshes automatically when Excel file is opened.
๐งฎ Calculation
ETF/MF Exposure = ฮฃ (Your Position ร Stock Weight). Total Exposure = Direct Holdings + ETF/MF Exposure. Covers 22 ETFs + Mutual Funds.
โ ๏ธ Risk Thresholds
Positions flagged at >3% (watch), >5% (warning), >10% (high risk). No current positions exceed warning threshold.