EquationDB

Single symbol deep-dive

For analysts, portfolio managers and traders researching one name

Everything worth knowing about one stock, one query at a time: returns, drawdowns and volatility, technicals, events and what followed them, earnings, dividends and total return, valuation, statements, options, analysts, and how it stacks up against the market. Every query uses AAPL; replace it (and XLK, its sector ETF) to research any other symbol.

  • Financial markets
  • 12 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. Returns over every period

    Return over 1 day, 1 week, 1, 3 and 6 months, year to date, 1, 3 and 5 years, each with its percentile rank within the top 500, so you can see at a glance where the stock leads and where it lags. For the calendar pattern, follow with ANALYZE seasonality AAPL.

    ANALYZE returns AAPL
    Try it →
  2. Every drawdown

    The deepest peak-to-trough declines with their dates, depth, days to the bottom and days to recover, plus the current drawdown. The quickest way to size what holding this stock has actually felt like.

    ANALYZE drawdowns AAPL
    Try it →
  3. Volatility and ranges

    Realized volatility from 5 days to 1 year, each against its own last 3 years (pctl_3y), with ATR and the expected daily range. Tells you whether today is calm or stormy for this name.

    ANALYZE volatility AAPL
    Try it →
  4. Technicals snapshot

    Momentum, trend, distance from the 52-week high and low, volatility, trend strength and relative volume in one row. Follow with ANALYZE levels AAPL for support and resistance sorted by distance.

    GET AAPL SELECT close, rsi(14), sma(50), sma(200), dist_high(252), dist_low(252), atr(14), natr(14), adx(14), rvol(20)
    Try it →
  5. Event history, rarest first

    Six months of detected events (crosses, breakouts, gaps, RSI extremes, patterns), most unusual for this stock first, each with what followed and its historical impact. To test one signal on this stock's whole history: OUTCOMES AFTER rsi(14) CROSS BELOW 30 IN AAPL SINCE 2010-01-01 FWD 5d, 20d.

    EVENTS * IN AAPL LAST 6mo SORT rarity DESC
    Try it →
  6. Earnings: beats, misses and reactions

    Five years of reports: EPS and revenue against estimates, the surprise, the price reaction and the 5- and 20-day drift after it. For the averages (typical move, up rate, drift) run ANALYZE earnings_moves AAPL.

    EARNINGS AAPL LAST 5y
    Try it →
  7. Total return vs price return

    Five years of closes with dividends reinvested. Run it again without ADJ total for price return: the gap between the two is what the dividends added. The cash dividends themselves: DIVIDENDS AAPL LAST 5y; the split history: SPLITS AAPL.

    GET AAPL SELECT close LAST 5y ADJ total
    Try it →
  8. Valuation and analyst targets over time

    A year of the price next to its P/E, the average analyst target and the rating score, day by day: is the stock getting cheaper or dearer, and are analysts following it up or down?

    GET AAPL SELECT close, pe, price_target, analyst_score LAST 1y
    Try it →
  9. Financial statements trend

    Ten fiscal years of revenue, growth, net margin and free cash flow, newest first. Use period <> 'FY' for the last quarters instead.

    FINANCIALS AAPL WHERE period = 'FY' SELECT period_end, revenue, revenue_yoy, net_margin, fcf LIMIT 10
    Try it →
  10. Options snapshot

    30- and 90-day implied volatility, the term structure, 25-delta skew, the expected move to the expiry nearest 30 days and to the first expiry at least a week out, put/call open interest and max pain. The full term structure per expiry: ANALYZE options_summary AAPL.

    GET AAPL SELECT close, iv30, iv90, iv_term, iv_skew25, exp_move_pct, exp_move_week_pct, pcr_oi, max_pain
    Try it →
  11. Analyst rating changes

    Every upgrade, downgrade and maintained rating in six months, by firm, with the old and new grade. Insider buying and selling over the year: INSIDERS AAPL LAST 1y SORT value DESC.

    RATINGS AAPL LAST 6mo
    Try it →
  12. Against SPY and its sector

    The stock next to the market and its sector ETF: returns over several periods, volatility, drawdown, Sharpe, RSI and distance from the 52-week high. For beta, alpha and up/down capture: ANALYZE beta AAPL WITH bench=SPY; through past crises: ANALYZE stress AAPL WITH bench=SPY.

    ANALYZE compare (AAPL, SPY, XLK)
    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