Fund Manager

Portfolio VaR Report for the Board β€” Generated in 2 Minutes

2-3 days β†’ 2 minutes for board risk reportFinance & Trading4 min read

Key Takeaway

My AI agent generates a complete risk report β€” VaR, CVaR, Sharpe ratios, and historical stress tests across equities, crypto, DeFi, and prediction markets β€” formatted for board presentation in under 2 minutes.

The Problem

Every quarter, the board asks the same question: "What's our risk exposure?"

And every quarter, the answer involves two days in Excel. Pulling prices. Calculating returns. Running Monte Carlo. Formatting tables. Making it look presentable. Then someone asks "what about crypto?" and you start over because it wasn't in the model.

PyratzLabs isn't a traditional portfolio. We have US equities (TSLA, NVDA, PLTR, GOOGL), Japanese equities, French equities, crypto holdings, DeFi positions, and prediction market bets. Try getting Excel to correlate all of that into a coherent risk number.

I needed one command. One report. Every asset class. Board-ready.

The Solution

Warren, my CFO agent, uses the Risk Metrics Calculation skill to generate institutional-grade risk reports across all sub-portfolios. Daily VaR, weekly VaR, CVaR (expected shortfall), Sharpe ratios, Sortino ratios, maximum drawdown analysis, and historical stress scenarios β€” all in one pass.

The output is a formatted markdown report that drops straight into the board pack. No Excel. No manual formatting. Two minutes.

The Process

The config defines the portfolio structure and risk parameters:

yamlShow code
# portfolio-risk-config.yaml
portfolio:
  equities_us:
    holdings: [TSLA, NVDA, PLTR, GOOGL]
    weights: [0.25, 0.30, 0.25, 0.20]
    allocation_pct: 35
  equities_jp:
    holdings: [7203.T, 6758.T, 9984.T]  # Toyota, Sony, SoftBank
    weights: [0.40, 0.35, 0.25]
    allocation_pct: 15
  equities_fr:
    holdings: [MC.PA, AI.PA, BN.PA]  # LVMH, Air Liquide, Danone
    weights: [0.50, 0.30, 0.20]
    allocation_pct: 15
  crypto:
    holdings: [BTC, ETH, SOL]
    weights: [0.50, 0.30, 0.20]
    allocation_pct: 10
  defi:
    protocols: [aave_v3, morpho, eigenlayer]
    allocation_pct: 10
  prediction_markets:
    platforms: [polymarket, kalshi]
    allocation_pct: 15

risk_parameters:
  var_confidence: [0.95, 0.99]
  var_horizon: [1, 5, 21]  # daily, weekly, monthly
  method: historical_simulation
  lookback_days: 756  # 3 years
  stress_scenarios:
    - name: "COVID Crash (Mar 2020)"
      period: ["2020-02-20", "2020-03-23"]
    - name: "FTX Collapse (Nov 2022)"
      period: ["2022-11-06", "2022-11-14"]
    - name: "SVB Crisis (Mar 2023)"
      period: ["2023-03-08", "2023-03-15"]

Warren fetches price data, calculates returns, and runs the full risk suite:

pythonShow code
# Core risk calculation pipeline
from risk_engine import PortfolioRisk

risk = PortfolioRisk(config='portfolio-risk-config.yaml')
risk.fetch_data()       # Pull all price histories
risk.calculate()        # Run VaR, CVaR, Sharpe, Sortino, drawdown
risk.stress_test()      # Apply historical scenarios
risk.generate_report()  # Format for board pack

The output report:

View details
══════════════════════════════════════════════════════
         PYRATZLABS PORTFOLIO RISK REPORT
              Q1 2026 β€” Board Pack
══════════════════════════════════════════════════════

PORTFOLIO VALUE-AT-RISK
─────────────────────────────────────────────────────
                    Daily VaR    Weekly VaR    Monthly VaR
                    (95%)        (99%)         (99%)
─────────────────────────────────────────────────────
US Equities         -1.8%        -5.2%         -11.4%
JP Equities         -1.4%        -4.1%          -8.7%
FR Equities         -1.2%        -3.5%          -7.3%
Crypto              -4.6%       -12.8%         -26.1%
DeFi                -5.1%       -14.2%         -28.8%
Pred. Markets       -2.8%        -7.4%         -15.2%
─────────────────────────────────────────────────────
TOTAL PORTFOLIO     -2.1%        -6.0%         -12.7%
─────────────────────────────────────────────────────
CVaR (Expected Shortfall):
  Daily (95%):  -3.4%
  Weekly (99%): -9.8%

The Results

MetricManual ProcessAgent Process
Time to generate2-3 days2 minutes
Asset classes coveredEquities only (usually)All 6 sub-portfolios
Stress scenarios"We should add those"3 built-in, extensible
Update frequencyQuarterlyOn-demand
Formatting for board2 hours in PowerPointAuto-generated
Sharpe ratio by bookRarely calculatedAlways included
CVaR includedNever (too complex in Excel)Standard
CostCFO's sanityCompute only

The Sharpe ratio comparison was revealing: prediction markets (1.82) were our most risk-efficient book. Crypto (0.64) was the worst. That changed the allocation conversation.

Try It Yourself

  1. Sign up for Mr.Chief and install the risk-metrics-calculation skill
  2. Define your portfolio structure in YAML β€” supports any mix of asset classes
  3. Run warren risk-report β€” fetches data, calculates everything, formats the output
  4. Export to markdown (board pack) or pipe to the table-image skill for Telegram/Slack
  5. Schedule weekly via cron for continuous risk monitoring

Risk management isn't about avoiding risk. It's about knowing exactly how much risk you're carrying β€” and being able to explain it in two minutes, not two days.


The board doesn't want to hear about your spreadsheet. They want to hear about their money.

VaRrisk-managementboard-reportingportfolioCVaR

Want results like these?

Start free with your own AI team. No credit card required.

Portfolio VaR Report for the Board β€” Generated in 2 Minutes β€” Mr.Chief