Single Stock Concentration
Deep analysis of exposure to individual stocks through direct holdings and ETF positions
As of January 29, 2026
Total Tracked Exposure
$4.19M
22 stocks monitored across 26 ETFs
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 | - | - | - | - |
Weight vs. Gain/Loss
Risk Map
Portfolio Weight vs. Gain/Loss %
Methodology
๐ก Data Source
ETF holdings weights pulled from fund prospectuses via BDS formula. Data refreshes automatically when Excel file is opened.
๐งฎ Calculation
ETF Exposure = ฮฃ (Your ETF Position ร Stock Weight in ETF). Total Exposure = Direct Holdings + ETF Exposure. Covers 26 ETFs across your portfolio.
โ ๏ธ Risk Thresholds
Positions flagged at >3% (watch), >5% (warning), >10% (high risk). No current positions exceed warning threshold.