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.
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
Energy seasonality
Month-by-month behavior of the energy sector ETF, for timing a sector overweight.
ANALYZE seasonality XLE SINCE 2005-01-01
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
Day-of-week effect
Average return, win rate and volatility of the NASDAQ-100 by weekday over five years.
ANALYZE dayofweek QQQ
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
Streak statistics
Current and longest up/down streaks and what the next day did after streaks of each length.
ANALYZE streaks SPY
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
- Morning briefingPortfolio managers, heads of trading, desk strategists
- Momentum & trend followingCTAs, trend followers, growth PMs
- Mean reversion & short-term reversalShort-term traders, stat-arb desks
- Event-driven tradingEvent-driven PMs, special-situations traders
- Earnings tradingEarnings traders, fundamental L/S analysts
- Volatility & regime tradingVolatility traders, options desks, risk-premia PMs