Stress Scenarios & the Loss Distribution (Histogram)
This lesson is part of the course
In this lesson
You run four hypothetical stress scenarios on the fund's positions, compare the worst one with the 10-day VaR, bin 250 days of P&L with COUNTIFS and chart the distribution as a histogram.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Daily Returns & Volatility: From NAV to σ Locked
- Historical VaR: PERCENTILE.INC at 95 % and 99 % Locked
- Parametric VaR: NORM.S.INV × σ × Value Locked
- Scaling VaR to 10 Days (√t) & Checking Limits Locked
- Expected Shortfall (CVaR): The Average Loss Beyond VaR Locked
- Portfolio VaR with Correlations: Covariance Matrix & MMULT Locked
- Backtesting VaR: Exceptions, Traffic Light & Kupiec Test Locked
- Stress Scenarios & the Loss Distribution (Histogram) Locked