EquationDB

Mean reversion & short-term reversal

For short-term traders, stat-arb desks

Oversold is relative. EquationDB compares each stock with its own history through adaptive percentiles and tells you the exact price that triggers a signal tomorrow, before it fires.

  • 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. Two-day RSI washouts in uptrends

    The short-term washout list: extreme two-day RSI inside a long-term uptrend.

    GET top500 WHERE rsi(2) < 5 AND close > sma(200) SELECT symbol, sector, close, rsi(2), dist_high(252) SORT rsi(2)
    Try it →
  2. Stretched in ATR terms

    Stocks more than 2.5 ATRs below their 20-day average, a volatility-adjusted measure of how far the rubber band is pulled.

    GET top500 SELECT symbol, (close - sma(20)) / atr(14) AS stretch, rsi(14) WHERE stretch < -2.5 AND close > sma(200) SORT stretch
    Try it →
  3. Oversold for this stock

    RSI below the stock's own 5th percentile of the past year, so a low-vol utility and a high-beta chip stock are judged on their own terms.

    GET top500 WHERE rsi(14) < pctl(5) AND close > sma(200) SELECT symbol, sector, rsi(14), dist_high(252)
    Try it →
  4. About to trigger

    Every stock within 1% of the close that pushes RSI below 30 tomorrow, with the exact trigger price for order entry.

    PRICE FOR rsi(14) = 30 IN top500 WHERE dist < 1
    Try it →
  5. The classic rule, fully costed

    Short-term mean reversion in uptrends with stops, costs and a 10-slot portfolio against SPY.

    BACKTEST LONG IN top500 SINCE 2015-01-01 ENTER WHEN rsi(2) < 10 AND close > sma(200) EXIT WHEN close > sma(5) STOP 8% COST 5 bps MAX 10
    Try it →
  6. How stretched is it now?

    KO's current z-score against its 20-day mean and what followed similar stretches in its own history.

    ANALYZE mean_reversion KO
    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