EquationDB

Morning briefing

For portfolio managers, heads of trading, desk strategists

Everything a PM checks before the open — tape, breadth, outliers, rating changes and the earnings calendar — in seven one-line queries instead of six screens and a spreadsheet.

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

  1. The tape in one row

    Index moves, the VIX and market breadth side by side, so you know the regime before you look at a single name.

    GET SPY@close, SPY@ret, QQQ@ret, IWM@ret, $VIX@close, $BRD.A50@close, $BRD.ADR@close
    Try it →
  2. Sector scoreboard

    Index and sector ETFs ranked by yesterday's move, with week, month and RSI context for positioning.

    GET refs SELECT symbol, name, close, ret, roc(5) AS wk, roc(21) AS mo, rsi(14) SORT ret DESC
    Try it →
  3. Breadth, then and now

    Percent above the 50- and 200-day, advancers, new highs and lows, oversold share: today versus yesterday and last week.

    GET market SELECT symbol, name, close, close[-1] AS prev, close[-5] AS week_ago
    Try it →
  4. What was truly unusual

    Only the events that sit in the top 5% of each stock's own history, so a 3% gap in a utility outranks a routine one in a momentum name.

    EVENTS * IN top500 LAST 1d WHERE rarity >= 95 SORT rarity DESC
    Try it →
  5. Cross-sectional outliers

    Names that moved more than three standard deviations from the rest of the market, with gap and relative volume attached.

    GET top500 SELECT symbol, sector, ret, gap_pct, rvol(20) AS rv, cs_z(ret) AS z WHERE abs(z) > 3 SORT z
    Try it →
  6. Rating changes, last three days

    Every upgrade and downgrade across the top 500, with the old and new rating, to catch before the morning call.

    RATINGS IN top500 LAST 3d WHERE action IN ('upgrade', 'downgrade') SORT date DESC
    Try it →
  7. This week's reporters

    The earnings calendar with consensus EPS and revenue, soonest first, so no position walks into a report by accident.

    EARNINGS IN top500 NEXT 1w
    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