Portfolio Risk Analyzer

Overview

This skill performs a comprehensive, portfolio-level risk analysis. It goes beyond individual position risk to quantify systemic and correlated risks across the entire portfolio.

Core Features:

• Value at Risk (VaR): Calculates 95% and 99% VaR using Parametric, Historical, and Monte Carlo methods.
• Max Drawdown Analysis: Identifies historical and potential future maximum drawdowns.
• Correlation Matrix: Visualizes how positions move in relation to each other, highlighting diversification benefits or weaknesses.
• Stress Testing: Simulates portfolio performance during historical market crises (e.g., 2008 GFC, 2020 COVID crash, 2022 rate hikes).
• Concentration Risk: Identifies over-concentration in specific sectors, factors, or individual positions.
• Beta Calculation: Measures portfolio volatility relative to benchmarks (SPY, QQQ).

When to Use This Skill

Explicit Triggers:

• "Analyze the risk of my portfolio."
• "What is my portfolio's Value at Risk?"
• "How would my portfolio perform in another 2008-style crash?"
• "Am I too concentrated in the tech sector?"
• "Calculate the max drawdown of my holdings."
• User asks about "portfolio risk," "drawdown," "VaR," "correlation," "stress test," or "concentration."

Implicit Triggers:

• User is concerned about a market downturn.
• User is adding a new large position and wants to understand its impact on overall portfolio risk.
• User is reviewing their overall asset allocation.

Workflow

Step 1: Ingest Portfolio Data

The analysis requires the current portfolio holdings, typically from a CSV or JSON file.

Input Format (portfolio.json):

{
  "positions": [
    { "ticker": "AAPL", "quantity": 100, "avg_price": 150.00 },
    { "ticker": "TSLA", "quantity": 50, "avg_price": 200.00 },
    { "ticker": "SPY", "quantity": 200, "avg_price": 400.00 }
  ],
  "cash": 25000
}

Step 2: Execute the Risk Analysis Script

The portfolio-risk-analyzer CLI tool runs the full analysis suite.

portfolio-risk-analyzer run \
  --portfolio path/to/portfolio.json \
  --benchmark SPY

The script performs the following calculations:

1. Fetches historical price data for all positions.
2. Calculates daily returns for each position and the total portfolio.
3. VaR:
   • Parametric: Assumes normal distribution of returns.
   • Historical: Uses the actual distribution of historical returns.
   • Monte Carlo: Simulates thousands of possible future return paths.
4. Max Drawdown: Finds the largest peak-to-trough decline in the portfolio's history.
5. Correlation: Computes the correlation matrix for all positions.
6. Stress Tests: Re-prices the portfolio based on the returns of historical crisis periods.
7. Concentration: Calculates weights by position, sector, and factor.

Step 3: Analyze the Output