1.90-Day Oil-Price-Shock Scenario Model
Scenario Matrix Dashboard · 2026
A macro research analyst generated a 90-day oil-price-shock scenario model to replace a manual, seven-step scripting workflow. The dashboard summarizes 48 historical shock clusters since 1987, showing a median historical magnitude of +17.4% and a high scenario Day-90 premium of +50.6%. The High scenario models a full closure with a +62.9% magnitude, a 287-day half-life, and a peak spread of $28.78, resulting in a Brent Day 90 value of 150.59. The model automatically filtered out 4 unstable exponential-fit values, demonstrating how a modern bi tool handles data hygiene.
What it shows:
How to automate scenario modeling and data filtering for risk management.
#scenario-modeling#risk-management#data-hygiene
