EquationDB

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.

  1. 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
    Try it →
  2. 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
    Try it →
  3. USDJPY volatility report

    Realized volatility on several windows, its percentile against history and the current regime for the yen.

    ANALYZE volatility USDJPY
    Try it →
  4. GBPUSD drawdowns

    The deepest declines in sterling, how long each lasted and how long recovery took.

    ANALYZE drawdowns GBPUSD
    Try it →
  5. 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 25
    Try it →
  6. Biggest 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
    Try it →

Run it on your own question

Sign in and press Try it on any step, or ask for a short demo on your data.

Request a trial

More financial markets use cases