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.
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)
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
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)
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)
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
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
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