Factor & cross-sectional research
For quant PMs, factor and risk teams
Ranks, z-scores and sector-relative percentiles are computed across the whole universe inside the query. Momentum, value, quality and low-volatility screens take one line and return in milliseconds.
- Financial markets
- 7 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.
12-1 momentum leaders
The textbook 12-month-minus-1-month momentum factor, ranked across the top 500.
GET top500 SELECT symbol, sector, roc(252) - roc(21) AS mom12_1, rank(mom12_1) AS rk WHERE rk <= 25 SORT rk
Value + quality + momentum
Three factors as plain filters: cheap (P/E under 20), profitable (ROE above 15%) and rising (positive six-month return), strongest momentum first.
GET top500 SELECT symbol, sector, pe, roe, roc(126) AS m6 WHERE pe > 0 AND pe < 20 AND roe > 15 AND roc(126) > 0 SORT m6 DESC
Low-volatility anomaly
The calmest decile of the market that is still in an uptrend, the core of a defensive sleeve.
GET top500 SELECT symbol, sector, natr(14) AS vol, cs_pct(natr(14)) AS vol_pct WHERE vol_pct <= 10 AND close > sma(200) SORT vol
Sector-neutral quality
Top-quintile free-cash-flow yield and ROIC measured against each company's own sector, so no sector bias sneaks in.
GET top500 SELECT symbol, sector, fcf_yield, roic WHERE fcf_yield > pctl(80) OVER sector AND roic > pctl(80) OVER sector SORT fcf_yield DESC
Sector-neutral momentum
The strongest 10% of each sector over six months, momentum without a hidden sector bet.
GET top500 SELECT symbol, sector, roc(126) AS m6 WHERE roc(126) > pctl(90) OVER sector SORT m6 DESC
Short-term reversal
This week's biggest losers relative to the cross-section, the raw input for a one-week reversal factor.
GET top500 SELECT symbol, sector, roc(5) AS r5, cs_z(roc(5)) AS z WHERE z < -2 SORT z
Multi-factor scorecard
Momentum, trend, low-vol, value, quality and size percentiles plus a composite and style box for every tech stock.
ANALYZE rank sector('Technology')
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
- Finding alphaQuant researchers, systematic PMs
- Quant research in SQL & MLQuant researchers, data scientists, risk teams used to SQL and Python
- Discovery & backtestingQuant researchers, systematic strategy teams
- Relationships & contagionRisk managers, macro and relative-value PMs
- Themes & supply chainThematic investors, sector analysts and anyone mapping who sells to whom