EquationDB

Seasonality & calendar effects

For seasonal traders, macro PMs, quant researchers

Monthly, weekday and streak statistics with win rates and best/worst years in one call, and any calendar condition can be tested against the baseline.

  • 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. S&P 500 by calendar month

    Mean, median and win rate for each month since 2000, with the best and worst year.

    ANALYZE seasonality SPY SINCE 2000-01-01
    Try it →
  2. Energy seasonality

    Month-by-month behavior of the energy sector ETF, for timing a sector overweight.

    ANALYZE seasonality XLE SINCE 2005-01-01
    Try it →
  3. Dubai seasonality

    Emaar's monthly pattern over its full history, a different calendar from US markets (takes up to ~7 s).

    ANALYZE seasonality EMAAR.AE
    Try it →
  4. Day-of-week effect

    Average return, win rate and volatility of the NASDAQ-100 by weekday over five years.

    ANALYZE dayofweek QQQ
    Try it →
  5. After a Friday selloff

    Whether index and sector ETFs recover the following week after dropping more than 1% on a Friday.

    OUTCOMES AFTER day_of_week() = 5 AND ret < -1 IN refs SINCE 2010-01-01 FWD 1d, 5d
    Try it →
  6. Streak statistics

    Current and longest up/down streaks and what the next day did after streaks of each length.

    ANALYZE streaks SPY
    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