EquationDB

Sector & industry rotation

For sector rotators, multi-asset PMs, ETF strategists

Relative rotation, multi-horizon returns, dispersion and sector-relative leaders from the same engine. One line answers where money is moving.

  • 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. Relative rotation graph

    RS-ratio, RS-momentum and quadrant (leading, weakening, lagging, improving) for all eleven sector ETFs versus SPY.

    ANALYZE rotation (XLK, XLE, XLF, XLV, XLU, XLI, XLY, XLP, XLB, XLRE, XLC)
    Try it →
  2. Sector momentum versus SPY

    One-, three- and six-month returns with the three-month excess over SPY.

    GET refs SELECT symbol, name, roc(21) AS m1, roc(63) AS m3, roc(126) AS m6, roc(63) - SPY@roc(63) AS vs_spy, rsi(14) WHERE symbol != '$VIX' SORT m3 DESC
    Try it →
  3. Returns and percentiles

    1-day to 5-year returns for each sector with their percentile rank inside the top 500.

    ANALYZE returns (XLK, XLE, XLF, XLV, XLU, XLI, XLY, XLP, XLB, XLRE, XLC)
    Try it →
  4. Stock-picker's market or macro market?

    Cross-sectional dispersion now versus history plus a herding test: high means selection pays, low means everything moves together.

    ANALYZE dispersion (XLK, XLE, XLF, XLV, XLU, XLI, XLY, XLP, XLB, XLRE, XLC)
    Try it →
  5. Leaders inside every sector

    The top 10% of each sector by three-month return, the stock-level expression of a sector view.

    GET top500 SELECT symbol, sector, roc(63) AS m3 WHERE roc(63) > pctl(90) OVER sector SORT sector
    Try it →
  6. Golden crosses on sector ETFs

    Which sector ETFs actually rewarded a 50/200-day golden cross since 2005, one row per ETF and horizon.

    OUTCOMES AFTER golden_cross IN refs SINCE 2005-01-01 GROUP BY symbol
    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