The Market Risk Blueprint 2026 Practical Workbook: Bridging Theory and Implementation
From Theory to the Desk. Master the Mechanics of Market Risk.
Stop reading about risk and start modeling it. The definitive Google Sheets “Workbench” for aspiring Market Risk Analysts/Associates.
The Practical Gap
Most candidates can define a Greek or explain VaR in an interview. Very few can explain how those numbers are actually generated, monitored, and reported.
When an interviewer asks, “Walk me through a 97.5% Expected Shortfall calculation,” or “What causes a desk to fail a PLAT test under FRTB?”—this workbook gives you the hands-on experience to answer with the confidence of an insider.
What’s Inside the Workbook
This is a fully functional, interactive Google Sheets environment built using industry-aligned logic. The workbook is organized into five Parts designed to simulate a professional risk environment:
- Part 1: Portfolio & Market Data Aggregation Learn how raw inventory (Equities and Fixed Income) is consolidated into a total Market Value and mapped against historical price and yield distributions.
- Part 2: VaR & Expected Shortfall (ES) Engine Execute a 1-day 99% VaR and 97.5% ES calculation. See exactly how the Expected Shortfall captures the severity of the tail while VaR only identifies the threshold.
- Part 3: Sensitivities & Limit Monitoring Translate positions into Equity Delta and PV01. Manage a live dashboard where you investigate limit breaches and monitor utilization percentages.
- Part 4: The FRTB “PLAT” Sandbox Master the advanced P&L Attribution Test. Interact with Spearman’s Correlation and KS Statistics to see what determines if a desk stays on the Internal Models Approach (IMA).
- Part 5: Stress Testing Narrative & Shocks Apply a forward-looking “Black Swan” narrative. Move the sliders to shock the market and watch as the total Stress P&L cascades across the portfolio.
Why You Need This Standalone Workbook
- Interactive Learning: Every formula is transparent. You can see the “plumbing” of how risk data flows from market prices to regulatory reports.
- Interview-Ready “Whys”: Each tab includes a focus on the specific “Why” questions interviewers use to trip up candidates.
- Modern Risk Dynamics: Aligned with FRTB requirements and realistic market shocks for today’s equity and rate environments.
The “Why” Behind the Math
“In risk management, the math is the easy part. Understanding what the math is telling you about the portfolio is what gets you hired. This workbook teaches you the intuition behind the metrics.”