EquationDB

Pairs & relative value

For stat-arb desks, relative-value and market-neutral PMs

Hedge ratio, half-life, cointegration test and live spread z-score in one call. Candidate pairs come from a nightly correlation graph instead of a brute-force search.

  • 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. Full pairs diagnostic

    Hedge ratio, spread z-score, half-life, ADF statistic and the current signal for Coca-Cola versus PepsiCo.

    ANALYZE pairs KO VS PEP
    Try it →
  2. Payment networks

    The same diagnostic on Visa versus Mastercard, a textbook relative-value pair.

    ANALYZE pairs V VS MA
    Try it →
  3. Find the natural partner

    JPMorgan's closest co-movers by 60-day correlation, with 250-day correlation and beta, as pair candidates.

    GRAPH NEIGHBORS OF JPM LIMIT 10
    Try it →
  4. Who leads whom

    Cross-correlations at daily lags for every pair of large oil producers: is there a leader to trade the laggards against?

    ANALYZE lead_lag (XOM, CVX, COP, OXY, EOG)
    Try it →
  5. Bank covariance and factors

    Annualized covariance of the big six banks and its principal components: how much is one common factor.

    ANALYZE covariance (JPM, BAC, C, WFC, GS, MS)
    Try it →
  6. Cheapest bank on a z-score

    Banks ranked by 20-day price z-score, to spot the member that has lagged its group.

    GET top500 SELECT symbol, industry, zscore(close, 20) AS z, rsi(14) WHERE industry LIKE '%bank%' SORT z
    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