Workspace /C5 Scenario Analysis
C5

Scenario Analysis

Stress an option book: reprice every position in full across a grid of spot moves and volatility shifts at a horizon you choose, and see which scenarios hurt most.

Learning focus: an option book's value is not linear in the spot price, so the Greeks describe small moves well but only full revaluation shows what a large move, a volatility shock and the passage of time do together.

Market today
%
%
%
Scenarios
days
%
%
pts
pts

Each range must be a whole number of steps, up to 10 each way.

Positions
InstrumentSideQtyStrikeT (yrs)Vol %ValueDeltaRemove
−461.50−56.95
−337.2843.05
n/a1,400.0014.00

Long positions add value and written (or short) positions subtract it. Each option has its own strike, expiry and volatility; leave Vol % blank to use the market volatility. The default is a written at-the-money straddle made delta-neutral with 14 shares.

Worst scenario
−1,447.08
spot −20%, vol +10 pts
Best scenario
406.74
spot 0%, vol −10 pts
Value today
601.22
Time only (7 days)
31.31
theta × days ≈ 30.70
Delta–gamma estimate
−1,573.68
for spot −20% now
Full revaluation
−1,368.29
full − estimate = 205.39
Delta
0.11
Gamma
−7.8576
Vega (per 1% vol)
−39.29
Scenario grid

Each cell is the profit or loss from repricing every position in full at that spot and volatility after the horizon; hover a cell for its value.

Profit or loss by volatility shift (rows) and spot move (columns)
Vol shift \ spot−20%−15%−10%−5%0%+5%+10%+15%+20%
+10 pts−1,447−997−648−427−347−403−576−838−1,166
+5 pts−1,400−906−508−250−158−228−432−733−1,095
0 pts−1,375−840−384−7731−61−310−656−1,053
−5 pts−1,367−805−2888922089−222−616−1,038
−10 pts−1,366−797−235237407205−181−606−1,036
Named scenarios
ScenarioSpot moveVol shift (pts)P&L
Crash−20%+10−1,447.08
Rally+10%−5−221.76
Vol crush0%−10406.74

Three common stresses at the same horizon, valued in full whatever the grid range.

Profit or loss against spot

With volatility unchanged, the dashed delta–gamma parabola tracks the full revaluation for small moves and drifts away for large ones; the third line adds the time decay over the horizon.