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.
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
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
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
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)
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
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
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
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
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
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
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
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)
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
- Due diligence on one companyFundamental analysts, PMs, credit and PE associates
- Financial statement analysisFundamental analysts, credit analysts, private-equity and long/short equity teams
- Morning briefingPortfolio managers, heads of trading, desk strategists
- Momentum & trend followingCTAs, trend followers, growth PMs
- Mean reversion & short-term reversalShort-term traders, stat-arb desks
- Event-driven tradingEvent-driven PMs, special-situations traders