FX: volatility & risk
For fX risk managers, options traders and treasury
How much currencies move, when they get stressed, and how deep their drawdowns run.
- Financial markets
- 6 steps
- Runs on live data
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.
Realized volatility of the majors
Short-, medium- and long-run realized volatility side by side: a 20-day figure well above the 1-year one flags a pair in a stressed phase.
GET fx.majors SELECT symbol, rv_cc(20) AS vol_20d, rv_cc(60) AS vol_60d, rv_cc(252) AS vol_1y, atr(14), natr(14) SORT vol_20d DESC
EURUSD volatility regimes
Two years of EURUSD with 20-day realized volatility and a calm / normal / stressed label per day.
GET EURUSD SELECT close, rv_cc(20) AS vol_20d, CASE WHEN rv_cc(20) < 5 THEN 'calm' WHEN rv_cc(20) < 9 THEN 'normal' ELSE 'stressed' END AS regime LAST 2y
USDJPY volatility report
Realized volatility on several windows, its percentile against history and the current regime for the yen.
ANALYZE volatility USDJPY
GBPUSD drawdowns
The deepest declines in sterling, how long each lasted and how long recovery took.
ANALYZE drawdowns GBPUSD
Emerging-market volatility this year
Annualized volatility and the worst and best days this year for twenty emerging-market currencies, from daily bars.
SELECT symbol, stddev(ret) * sqrt(252) * 100 AS vol_pct, min(ret) AS worst_day, max(ret) AS best_day FROM bars WHERE symbol IN ('USDTRY', 'USDMXN', 'USDZAR', 'USDBRL', 'USDINR', 'USDCNY', 'USDIDR', 'USDKRW', 'USDPLN', 'USDHUF', 'USDCZK', 'USDCLP', 'USDCOP', 'USDTHB', 'USDPHP', 'USDSGD', 'USDHKD', 'USDILS', 'USDEGP', 'USDNGN') AND timestamp >= '2026-01-01' GROUP BY symbol HAVING count(*) > 50 ORDER BY vol_pct DESC LIMIT 25Biggest EURUSD days since 2019
The 20 largest daily moves in EURUSD: most line up with central-bank meetings and macro shocks.
SELECT timestamp, close, ret FROM bars WHERE symbol = 'EURUSD' AND timestamp >= '2019-01-01' ORDER BY abs(ret) DESC LIMIT 20
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
- Global & emerging markets: Dubai vs USEM funds, Gulf allocators, global macro PMs
- FX: market snapshotFX traders, macro desks and treasury teams
- FX: trend & momentumFX trend followers and systematic macro
- FX: dollar & cross-assetCross-asset allocators and macro strategists
- FX: backtests & seasonalitySystematic FX traders