- Home
- Skills
- Finance & Accounting
- AI Portfolio Analysis Assistant – Holdings & Allocation Repo
Works with the AI Agents you already use
AI Portfolio Analysis Assistant – Holdings & Allocation Repo
Automates portfolio normalization, allocation mapping, and concentration audits from messy investment data.
$39.99
AI Portfolio Analysis Assistant – Holdings & Allocation Repo
Example session with this skill installed
Analyze these holdings for concentration and sector risk: AAPL (10 shares, $2300), MSFT (5 shares, $2100), VTI (50 shares, $13500), and $1500 cash. Use a Quick Snapshot.
- Read your context and instructions
- Compiled the ai portfolio analysis
I have processed your holdings across 4 positions. Total portfolio value is calculated at $19,400.00 USD based on the supplied prices and quantities.
Portfolio Analysis Report: Quick Snapshot
Valuation date: Not provided
Base currency: USD
Data coverage: 100% of holdings included
Executive Summary
The portfolio is dominated by a broad market ETF (VTI), representing nearly 70% of total value. Technology exposure is significant due to concentrated positions in AAPL and MSFT, which together account for over 22% of the total portfolio.
Holdings Breakdown
| Security | Type | Market Value | Weight | Sector |
|---|---|---|---|---|
| VTI | ETF | $13,500.00 | 69.59% | Total Market |
| AAPL | Equity | $2,300.00 | 11.86% | Technology |
| MSFT | Equity | $2,100.00 | 10.82% | Technology |
| Cash | Cash | $1,500.00 | 7.73% | N/A |
Concentration & Risk Observations
- Top 3 Concentration: 92.27% (Including VTI).
- Single Stock Exposure: AAPL and MSFT represent a combined 22.68% weight.
Sector Note: While VTI provides broad diversification, the individual equity selections add a heavy tilt toward large-cap technology.
- Cash Position: 7.73% liquidity is available for rebalancing or fees.
Next steps
- Provide a target allocation to calculate specific rebalancing trades.
- Supply cost basis data if you require an unrealized gain/loss analysis.
- Request a Full Portfolio Report for geographic and account-level breakdown.
Connects securely to your tools. The creator never sees your data.
About this skill
Manual portfolio tracking is error-prone and tedious. Spreadsheets often hide significant concentration risks, currency mismatches, and sector overlaps that investors miss. Skillora automates the normalization and auditing of disparate investment data to provide a clear view of true market exposure.
What it does
- Data normalization converts messy broker exports, CSVs, or pasted tables into structured, comparable holdings.
- Allocation mapping categorizes assets by sector, geography, and security type based on provided classifications.
- Concentration auditing calculates top position weights and the Herfindahl-Hirschman Index (HHI) to surface hidden risks.
- Data quality checks identifies duplicates, missing prices, inconsistent formats, and valuation gaps before analysis.
- Rebalancing arithmetic compares current weights against user-defined targets to calculate required value adjustments.
How it works
- Input data by pasting a table, uploading a CSV/XLSX, or providing manual holding details.
- Define analysis mode such as a Quick Snapshot, Full Portfolio Report, or Concentration Audit.
- Review the report to see normalized tables, weight distributions, and evidence-based risk observations.
Frameworks & tools
This skill functions as a standalone logic layer for processing financial data structures. It uses standard arithmetic for portfolio metrics and requires no external API connections unless the user requests price lookups.
Why this beats prompting it yourself
Generic prompts often hallucinate missing prices or fail to reconcile mixed currencies. This skill enforces strict data validation, ensuring weights always sum to 100% and identifying unclassified holdings rather than guessing their sector.
Use cases
- Auditing a messy export from multiple brokerage accounts for total exposure.
- Identifying sector concentration across a mix of individual stocks and ETFs.
- Calculating the arithmetic difference between current holdings and a target model.
- Performing a data quality audit on a legacy investment spreadsheet.
Known limitations
This tool provides arithmetic analysis and education, not regulated investment advice. It cannot execute trades, access live accounts, or guarantee the accuracy of third-party market data.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.
Provides arithmetic and observations only. No trade execution or live account access. Requires user-supplied target weights for rebalancing. Cannot annualize returns without specific date data.
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 buying a skill.
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 16 days ago
Permissions
No special permissions declared or detected