- Home
- Skills
- Trading & Investing
- Portfolio Exposure & Concentration Auditor
Works with the AI Agents you already use
Portfolio Exposure & Concentration Auditor
Audit portfolio exports to identify hidden concentration risks, exposure imbalances, and data quality issues.
$9.99
Portfolio Exposure & Concentration Auditor
Example session with this skill installed
Audit this portfolio: 40% AAPL, 30% MSFT, 20% VTI (Total Stock Market ETF), 10% Cash. Currency is USD. Identify concentration risks.
- Read your context and instructions
- Compiled the portfolio exposure
I have reviewed the supplied portfolio consisting of 4 holdings with a total reported weight of 100%.
Portfolio Exposure & Concentration Audit
1. Scope and Data Quality
- Valuation Date: Not provided.
- Scope: 3 equity instruments and 1 cash position.
Data Quality: Weights reconcile exactly to 100%. Sector and regional classifications for VTI are noted as unavailable for look-through; analysis treats VTI as a single asset class unit.
2. Exposure Breakdown
| Holding | Weight | Asset Class | Sector | Region |
|---|---|---|---|---|
| AAPL | 40.0% | Equity | Technology | North America |
| MSFT | 30.0% | Equity | Technology | North America |
| VTI | 20.0% | Equity (Fund) | Diversified | North America |
| Cash | 10.0% | Cash | N/A | North America |
Summary Metrics:
- Top 2 Holdings: 70.0% (AAPL, MSFT)
- Technology Sector: 70.0% (Excluding VTI contribution)
- US Equity Total: 90.0%
3. Concentration Flags
High Issuer Concentration (Critical): AAPL and MSFT combined represent 70% of the portfolio. A significant drawdown in either specific stock will materially impact the total portfolio value.
Sector Overweight (High): Technology exposure is at least 70%. The portfolio is highly sensitive to tech-sector volatility and regulatory changes affecting software/hardware issuers.
Missing Look-Through (Medium): VTI represents 20% of the portfolio. While diversified, its underlying holdings likely include AAPL and MSFT, further increasing the effective concentration in these names.
4. Risk-Review Checklist
- Look-through: Obtain top 10 holdings of VTI to calculate true aggregate exposure to AAPL/MSFT.
- Correlation: Assess if AAPL and MSFT movements are highly correlated in recent market cycles.
- Rebalancing: Determine if a maximum single-stock cap (e.g., 10% or 15%) is required.
Next steps
- Provide the top holdings for VTI to finalize the aggregate concentration calculation.
- Define a scenario assumption (e.g., "15% drop in Tech sector") to see the impact on total value.
- Confirm if the 10% cash balance is intended for tactical deployment or emergency reserves.
Connects securely to your tools. The creator never sees your data.
About this skill
Portfolio data often arrives as a fragmented mess of tickers, weights, and market values spread across different regions and sectors. This skill audits your portfolio exports to identify hidden concentration risks and exposure imbalances without relying on external market data or manual spreadsheets.
What it does
- Data validation checks for inconsistent units, duplicate holdings, and weight reconciliation errors.
- Exposure calculation breaks down your portfolio by holding, sector, asset class, region, and currency.
- Concentration flagging highlights material risks where a single issuer, sector, or region dominates the allocation.
- Scenario analysis runs impact assessments based on user-supplied assumptions to model potential drawdown or volatility.
- Risk checklists generates a tailored review covering liquidity, leverage, tax, and rebalancing priorities.
How it works
- Import data by pasting a holdings list, ticker export, or market value spreadsheet.
- Review the scope to confirm valuation dates, field mappings, and any missing look-through data for funds.
- Analyze the report to see mathematical breakdowns of exposure and specific concentration flags.
- Iterate with scenarios by providing hypothetical market shifts to see directional impact on your specific weights.
Frameworks & tools
This skill is framework-agnostic and processes raw text, CSV-style data, or markdown tables. It uses deterministic calculation logic for weights and sums.
Why this beats prompting it yourself
Generic prompts often hallucinate missing weights or fail to reconcile currency mismatches across multi-asset portfolios. This skill enforces strict arithmetic consistency and ensures that overlapping dimensions, like sector and geography, are treated as separate views rather than additive totals.
Use cases
- Auditing a brokerage export for unintentional sector or regional overlap.
- Checking for currency mismatches between assets and spending requirements.
- Running hypothetical stress tests on current holdings before a rebalance.
- Validating the data quality of a client-provided holdings list for accuracy.
Known limitations
Does not provide real-time market pricing or automated look-through for fund internals unless you supply the underlying data. It cannot execute trades or provide personalized investment advice.
Requires manual data input; no live price feeds. Cannot perform fund look-through without underlying data. Limits analysis to supplied fields. No trade execution.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 27 days ago
Permissions
No special permissions declared or detected