EquationDB

Portfolio construction & hedging

For pMs, allocators, overlay managers

Optimize weights, measure beta and find hedges from the same query line. Clusters show concentration that a sector label hides.

  • 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. Four ways to weight

    Minimum-variance, maximum-Sharpe, risk-parity and equal weights side by side with expected return and volatility.

    ANALYZE optimize (AAPL, MSFT, NVDA, JPM, XOM, JNJ, KO)
    Try it →
  2. Beta and capture versus QQQ

    Beta, alpha, R², up and down capture, and how much of each return came from the market.

    ANALYZE beta (AAPL, MSFT, NVDA, TSLA, META) WITH bench=QQQ
    Try it →
  3. Correlation of the ten largest

    The correlation matrix of today's ten largest companies, picked by a subquery, so it stays current.

    ANALYZE correlation (GET top500 SELECT symbol SORT mcap DESC LIMIT 10)
    Try it →
  4. Natural hedges

    The ten stocks that moved most opposite to Tesla over 60 days: candidate hedges that are not an index short.

    GRAPH NEIGHBORS OF TSLA VIA anticorr LIMIT 10
    Try it →
  5. Contribution by holding

    Return, volatility, Sharpe and each position's contribution for a custom-weighted basket.

    ANALYZE basket (AAPL, MSFT, NVDA, GOOGL, AMZN) WITH weights='0.3,0.25,0.2,0.15,0.1'
    Try it →
  6. Hidden concentration

    Groups of stocks that trade as one, whatever their sector label: the concentration your risk report may miss.

    GRAPH CLUSTERS IN top500 MIN 0.75 LIMIT 10
    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