Comprehensive portfolio analysis using Alpaca MCP Server integration to fetch holdings and positions, then analyze asset allocation, risk metrics, individual stock positions, diversification, and generate rebalancing recommendations. Use when user requests portfolio review, position analysis, risk assessment, performance evaluation, or rebalancing suggestions for their brokerage account.
88%
Does it follow best practices?
Run evals on this skill
Adds up to 20 points to the overall score
Low
Low-risk findings worth noting
Analyze and manage investment portfolios by integrating with Alpaca MCP Server to fetch real-time holdings data, then performing comprehensive analysis covering asset allocation, diversification, risk metrics, individual position evaluation, and rebalancing recommendations. Generate detailed portfolio reports with actionable insights.
The full brokerage analysis uses Alpaca's API through MCP for live portfolio data. The portfolio-holdings-review workflow provides a limited offline allocation review from CSV or saved Alpaca positions JSON. It reports gross holdings weights and per-position unrealized P&L; account-wide risk analysis uses the full brokerage workflow.
Invoke this skill when the user requests:
For a local USD equity holdings snapshot without credentials, read
references/csv-holdings-review.md and run scripts/review_csv.py with an explicit
source timestamp. Use the bundled fictional CSV to verify offline execution.
This produces gross allocation and per-position unrealized P&L only; it cannot
measure account exposure, leverage or historical performance. Keep personal
holdings and reports local. Do not fetch brokerage data or continue the full
workflow for this limited mode. Ask Navigator for "review my portfolio from CSV"
to select portfolio-holdings-review. The recommendation does not read the file:
provide the real input path and source timestamp to the CLI before review.
Saved Alpaca positions JSON can use --input-format alpaca-json for the same
limited calculations; it does not fetch broker data. Both formats follow the
shared output schema in assets/holdings-review.schema.json.
The full brokerage analysis requires Alpaca MCP Server to be configured and connected. The MCP server provides access to:
MCP Server Tools Used:
get_account_info - Fetch account equity, buying power, cash balanceget_positions - Retrieve all current positions with quantities, cost basis, market valueget_portfolio_history - Historical portfolio performance dataIf Alpaca MCP Server is not connected, inform the user and provide setup instructions from references/alpaca-mcp-setup.md.
Run the connection check from the repository root. Use paper credentials first; never paste credentials into a report or commit them to the repository.
export ALPACA_API_KEY="<alpaca-key-id>"
export ALPACA_SECRET_KEY="<alpaca-secret-key>"
export ALPACA_PAPER="true"
uv run python skills/portfolio-manager/scripts/check_alpaca_connection.pyThe command writes a redacted diagnostic summary to stdout and returns zero only when the account and positions endpoints succeed. It does not create a report file or place orders.
Use Alpaca MCP Server tools to gather current portfolio information when available. In scheduled Hermes jobs, MCP tools may not be exposed even when Alpaca credentials are present; in that case, use the Alpaca REST API directly with ALPACA_API_KEY, ALPACA_SECRET_KEY, and ALPACA_PAPER.
Read references/alpaca-data-fetch.md (section "Step 1 detail: account, positions and portfolio history requests") when fetching data. It holds the MCP tool and REST fallback endpoints and headers for steps 1.1 to 1.3.
Scheduled-job fallback discipline:
Alpaca REST fallback rather than MCP.ALPACA_PAPER=true to choose paper endpoint; otherwise use live endpoint.long_market_value > equity.gross_long_exposure = long_market_value / equity, cash_pct = cash / equity, and explicitly flag margin-funded portfolios when gross exposure is materially above 100% or cash is negative. Do not let sector weights look benign by using only gross-long denominator when the account is levered.kanchi-dividend-review-monitor rather than treating dividend review as a narrative-only section. Also build tax-planning input for kanchi-dividend-us-tax-accounting when account-location notes are requested; label it degraded if account type or holding-period windows are unavailable.Data Validation:
For core-portfolio-weekly, follow
references/position-reconciliation.md
to compare complete broker and ACTIVE / PARTIALLY_CLOSED memory snapshots using
scripts/reconcile_positions.py. Generate the JSON and Markdown reconciliation
reports. A saved complete Alpaca positions list can be converted with
scripts/normalize_alpaca_positions.py, explicitly supplying the verified account
alias, aware capture time and --confirm-complete. This offline conversion needs
no prices and does not verify those assertions; full memory export/account
attribution is still manual. Stop allocation and rebalance review if can_continue is false or if
snapshot completeness, account attribution or freshness cannot be established.
Keep discrepancies for manual resolution; never place orders or modify theses
through reconciliation. This is an offline, manually prepared gate; existing
weekly replay fixtures do not yet execute it.
For each position in the portfolio, gather additional market data and fundamentals:
2.1 Current Market Data:
2.2 Fundamental Data: Use WebSearch or available market data APIs to fetch:
2.3 Technical Analysis:
Perform comprehensive portfolio analysis using frameworks from reference files:
Read references/asset-allocation.md for allocation frameworks
Analyze current allocation across multiple dimensions:
By Asset Class:
By Sector:
By Market Cap:
By Geography:
Output Format (illustrative values):
Read references/report-section-templates.md (section "Asset Allocation output template") for the asset allocation output template.
Read references/diversification-principles.md for diversification theory
Evaluate portfolio diversification quality:
Position Concentration:
Sector Concentration:
Correlation Analysis:
Number of Positions:
Output (illustrative values):
Read references/report-section-templates.md (section "Diversification Assessment output template") for the diversification output template.
Read references/portfolio-risk-metrics.md for risk measurement frameworks
Calculate and interpret key risk metrics:
Volatility Measures:
Downside Risk:
Risk Concentration:
Tail Risk:
Output (illustrative values):
Read references/report-section-templates.md (section "Risk Assessment output template") for the risk assessment output template.
Evaluate portfolio performance using available data:
Absolute Returns:
Time-Weighted Returns (if history available):
Position-Level Performance:
Output (illustrative values):
Read references/report-section-templates.md (section "Performance Review output template") for the performance review output template.
For key positions (top 10-15 by portfolio weight), perform detailed analysis:
Read references/position-evaluation.md for position analysis framework
For each significant position:
4.1 Current Thesis Validation:
4.2 Valuation Assessment:
4.3 Technical Health:
4.4 Position Sizing:
4.5 Action Recommendation:
Output per position (illustrative values):
Read references/report-section-templates.md (section "Per-position output template") for the per-position output template.
Read references/rebalancing-strategies.md for rebalancing approaches
Generate specific rebalancing recommendations:
5.1 Identify Rebalancing Triggers:
5.2 Develop Rebalancing Plan:
Positions to TRIM:
Positions to ADD:
Cash Deployment:
5.3 Prioritization: Rank rebalancing actions by priority:
Output (illustrative values):
Read references/report-section-templates.md (section "Rebalancing Recommendations output template") for the rebalancing output template.
Create comprehensive markdown report saved to repository root:
Filename: portfolio_analysis_YYYY-MM-DD.md
Report Structure: Read references/report-section-templates.md (section "Step 6: Portfolio Analysis Report structure") for the full report structure, from Executive Summary to Appendix.
Be prepared to answer follow-up questions: Read references/follow-up-and-advanced.md (section "Step 7 detail: Interactive Follow-up") when answering follow-up questions. It holds the common questions with answer guidance.
This skill includes reference allocation models for different investor profiles:
Read references/target-allocations.md for detailed models:
Each model includes:
Use these as comparison benchmarks when user hasn't specified their allocation strategy.
If user's target allocation is unknown, assess appropriate risk profile based on:
Read references/risk-profile-questionnaire.md for assessment framework
Tone and Style:
Data Presentation:
Recommendation Clarity:
Visual Descriptions:
Read references/resource-index.md to decide which reference file to load. It holds the per-file When/Contains index.
If Alpaca MCP Server is not connected:
portfolio-holdings-review and the
documented CSV or saved-position contract in references/csv-holdings-review.md.If API returns incomplete data:
If position data seems stale:
If user has no positions:
Read references/follow-up-and-advanced.md (section "Advanced Features") when the user asks for tax-loss harvesting, dividend income, correlation or scenario analysis.
Read references/follow-up-and-advanced.md (section "Example Queries") for example queries grouped by analysis type.
Include in all reports:
This analysis is for informational purposes only and does not constitute financial advice. Investment decisions should be made based on individual circumstances, risk tolerance, and financial goals. Past performance does not guarantee future results. Consult with a qualified financial advisor before making investment decisions.
Data accuracy depends on Alpaca API and third-party market data sources. Verify critical information independently. Tax implications are estimates only; consult a tax professional for specific guidance.
tradermonty/claude-trading-skills
a627d17
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.