Risk management & stress testing
For cROs, risk managers, PMs
VaR, CVaR, crisis replays and Monte Carlo on any basket, computed from stored daily bars in milliseconds. Answer the risk committee's question during the meeting.
- Financial markets
- 6 steps
- Runs on live data
Built for
How EquationDB answers it
Each step is one query on live data. Run them in order, or open any one and adapt it: change the symbol, the station, the dates or the filter.
Portfolio VaR and CVaR
Historical and parametric VaR and CVaR at 95/99%, volatility, drawdown, beta and worst days of a weighted book.
ANALYZE risk (AAPL, MSFT, JNJ, XOM) WITH weights='0.4,0.3,0.2,0.1'
Crisis replay
Return and max drawdown through the dot-com bust, 2008, 2011, 2015–16, 2018 Q4, COVID, 2022 and 2025, versus QQQ.
ANALYZE stress NVDA WITH bench=QQQ
The deepest drawdowns
The S&P 500's ten worst peak-to-trough episodes with depth, time to trough and time to recover.
ANALYZE drawdowns SPY
A quarter of simulated paths
Bootstrap price percentiles three months out and the probability of a ±5% or ±10% move.
ANALYZE montecarlo TSLA WITH days=63
Weekly tail shape
Histogram of weekly returns with skew, kurtosis and semi-deviations: how fat the left tail really is.
ANALYZE distribution SPY WITH freq=w
Mega-cap risk dashboard
Beta, daily range as a percent of price, and distance from the peak for every company above $200B.
GET top500 SELECT symbol, sector, beta, natr(14) AS atr_pct, drawdown() AS dd WHERE mcap > 200e9 SORT atr_pct DESC
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.
More financial markets use cases
- Portfolio construction & hedgingPMs, allocators, overlay managers
- Credit & distress early warningCredit analysts, distressed-debt funds, lenders
- Single symbol deep-diveAnalysts, portfolio managers and traders researching one name
- Due diligence on one companyFundamental analysts, PMs, credit and PE associates
- Financial statement analysisFundamental analysts, credit analysts, private-equity and long/short equity teams
- Morning briefingPortfolio managers, heads of trading, desk strategists