# Etf Portfolio

> Portfolio analysis for a mix of ETFs. Use when the user has multiple ETFs and wants to understand overlap, hidden concentration, factor exposure, or overall risk across the combined portfolio.

- Skill: `daringanitch/etf-portfolio` (Agent Skill)
- Install (CLI): `npx skillmds@latest add daringanitch/etf-portfolio`
- Raw SKILL.md: https://api.skillmd.com/api/skills/daringanitch/etf-portfolio/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: daringanitch (https://skillmd.com/u/daringanitch)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/daringanitch/etf-portfolio

---


Analyze the ETF portfolio provided. The key insight ETF investors miss: owning multiple ETFs does not mean you're diversified — you may be tripling down on the same stocks without knowing it.

**1. UNPACK THE HOLDINGS**
For each ETF, identify:
- Top 10 holdings and weights
- Sector breakdown
- Factor tilt

**2. HIDDEN CONCENTRATION**
- Which single stocks appear across multiple ETFs? List them with combined effective weight
- Flag any stock where combined exposure across all ETFs exceeds 5% of the total portfolio
- Example: owning QQQ + VGT + SOXX = NVDA appears in all three; effective weight may be 15%+ of portfolio

**3. OVERLAP MATRIX**
Build a simple overlap table showing % holdings shared between each ETF pair:

| | ETF A | ETF B | ETF C |
|-|-------|-------|-------|
| ETF A | — | X% | X% |
| ETF B | X% | — | X% |
| ETF C | X% | X% | — |

If any pair >60% overlap: flag as redundant — investor is paying two expense ratios for one position.

**4. FACTOR EXPOSURE**
What is the net factor tilt of the combined portfolio?
- Growth / Value / Momentum / Quality / Size / Yield
- Is this intentional or accidental?

**5. SECTOR CONCENTRATION**
Combined sector weights across all ETFs. What sectors are over/underweight vs a simple S&P 500 benchmark?

**6. MACRO SENSITIVITY**
How does the combined portfolio behave in:
- Rates +100bps
- Recession
- Dollar +10%
- Tech selloff (>20% drawdown in mega-cap tech)

**7. COST DRAG**
Weighted average expense ratio across the portfolio. If >0.20%, identify where the cost is coming from and whether a cheaper equivalent exists.

**8. CONSOLIDATION RECOMMENDATIONS**
Which ETFs are redundant and can be eliminated?
Which single ETF could replace two or more positions?
What's missing entirely?

Output a risk heat map and 2–3 specific rebalancing recommendations with reasoning.