View as markdown
Concepts › Signals › Analyst ratings › Upgrades & downgrades

recent_downgrade

At least one analyst downgraded the ticker in the last 7 days.

Watch this signal live on real tickers: Open in Explore →

At a glance

Definition
EXISTS (SELECT 1 FROM analyst_events WHERE ticker = t.ticker AND action = 'downgrades' AND timestamp >= NOW() - INTERVAL '7 days')
Typestate (boolean)
GroupAnalyst ratings
CategoryUpgrades & downgrades
Update cadence15 min
Intervals1d
Universeall tickers
Historyrecent only (forward-only from first computation)
Firingcontinuous

Individual firm actions: rating changes, initiations, and price-target changes.

Query it

Every applicable form factor, grouped by endpoint family. Swap YOUR_KEY for the value from /dashboard/keys. Response payloads are real captures, sampled 2026-08-18 and trimmed — your run's values and dates will differ.

Use signals /v2/signals/{signal}

One signal across the market: who matches now, who matched then, and a push when someone starts. Docs →

Live — every ticker where it fires now
curl "https://api.tickerbot.io/v2/signals/recent_downgrade" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-08-18, trimmed)
{
 "as_of": "2026-08-18T00:25:32.540Z",
 "signal": "recent_downgrade",
 "condition": null,
 "universe": null,
 "count": 2,
 "results": [
  {
   "ticker": "ACH",
   "name": "Accendra Health, Inc.",
   "value": true
  },
  {
   "ticker": "ACVA",
   "name": "ACV Auctions Inc.",
   "value": true
  }
 ]
}
As-of — the same read at a past date
curl "https://api.tickerbot.io/v2/signals/recent_downgrade?asof=2026-05-20" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-08-18, trimmed)
{
 "as_of": "2026-05-20",
 "signal": "recent_downgrade",
 "condition": null,
 "universe": null,
 "count": 2,
 "results": [
  {
   "ticker": "AARD",
   "name": "Aardvark Therapeutics, Inc. Common Stock",
   "value": true
  },
  {
   "ticker": "ALLE",
   "name": "Allegion Public Limited Company",
   "value": true
  }
 ]
}
Subscribe — webhook when a ticker starts matching
curl -X POST "https://api.tickerbot.io/v2/signals/recent_downgrade/subscribe" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{"target_url": "https://example.com/hooks/tickerbot"}'

Returns 201 with the created webhook — the same shape as GET /v2/webhooks/{id}, plus a one-time signing_secret for HMAC verification.

Use scan /v2/scan

The whole market through a WHERE clause — this signal composed freely with any other column. Docs →

Live — the whole market, filtered on this signal
curl -G "https://api.tickerbot.io/v2/scan" \
  --data-urlencode "q=recent_downgrade" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-08-18, trimmed)
{
 "as_of": "2026-08-18T00:25:32.944Z",
 "query": {
  "q": "recent_downgrade",
  "limit": 2,
  "order": "day_change_pct",
  "dir": "desc",
  "fields": [],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "ACH",
   "name": "Accendra Health, Inc.",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 1.07,
   "day_change_pct": 0.1252,
   "gap_pct": 0.0118,
   "relative_volume": null,
   "market_cap": 73128683
  },
  {
   "ticker": "LQDA",
   "name": "Liquidia Corporation Common Stock",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 76.825,
   "day_change_pct": 0.032,
   "gap_pct": -0.0159,
   "relative_volume": null,
   "market_cap": 6663041846
  }
 ]
}
As-of — the same scan at a past date
curl -G "https://api.tickerbot.io/v2/scan" \
  --data-urlencode "q=recent_downgrade" \
  -d "asof=2026-05-20" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-08-18, trimmed)
{
 "as_of": "2026-05-20",
 "query": {
  "q": "recent_downgrade",
  "asof": "2026-05-20",
  "interval": "auto",
  "limit": 2,
  "order": "day_change_pct",
  "dir": "desc",
  "fields": [],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "BTM",
   "name": "Bitcoin Depot Inc. Class A Common Stock",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 0.718,
   "day_change_pct": 27.531083481349917,
   "gap_pct": -0.5328596802841726,
   "relative_volume": 3.314899502523333,
   "market_cap": 48696883
  },
  {
   "ticker": "OTLK",
   "name": "Outlook Therapeutics, Inc. Common Stock",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 0.273,
   "day_change_pct": 19.527145359019276,
   "gap_pct": -0.394045534150606,
   "relative_volume": 1.43218409031197,
   "market_cap": 1128072
  }
 ]
}
Subscribe — webhook on a market-wide condition
curl -X POST "https://api.tickerbot.io/v2/scan/subscribe" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{"q": "recent_downgrade", "target_url": "https://example.com/hooks/tickerbot"}'

Returns 201 with the created webhook object; deliveries carry the tickers matching the condition at each evaluation.

Use series /v2/series

Its history over time, on one aligned grid. Docs →

History — the column on an aligned time grid
curl "https://api.tickerbot.io/v2/series?tickers=AAPL,MSFT&columns=close,recent_downgrade" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-08-18, trimmed)
{
 "as_of": "2026-08-18T00:25:34.713Z",
 "interval": "1d",
 "tickers": [
  "AAPL",
  "MSFT"
 ],
 "columns": [
  "close",
  "recent_downgrade"
 ],
 "count": 6,
 "series": {
  "AAPL": [
   {
    "t": "2026-08-12",
    "close": 302.25,
    "recent_downgrade": true
   },
   {
    "t": "2026-08-13",
    "close": 305.26,
    "recent_downgrade": true
   },
   {
    "t": "2026-08-14",
    "close": 305.93,
    "recent_downgrade": true
   }
  ],
  "MSFT": [
   {
    "t": "2026-08-12",
    "close": 492.43,
    "recent_downgrade": false
   },
   {
    "t": "2026-08-13",
    "close": 496.88,
    "recent_downgrade": false
   },
   {
    "t": "2026-08-14",
    "close": 495.4,
    "recent_downgrade": false
   }
  ]
 }
}

Use events /v2/events

The flag as a timeline: each edge as a point event, and the spans it stayed true. Docs →

Firings — every enter edge as a point event
curl -G "https://api.tickerbot.io/v2/events" \
  -d "kind=signal" -d "signal=recent_downgrade" -d "transition=enter" -d "since=2026-01-10" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-08-18, trimmed)
{
 "as_of": "2026-08-18T00:25:34.858Z",
 "query": {
  "kind": "signal",
  "tickers": null,
  "universe": null,
  "since": "2026-01-10T00:00:00.000Z",
  "until": null,
  "limit": 2,
  "signal": "recent_downgrade",
  "transition": "enter"
 },
 "count": 2,
 "results": [
  {
   "ticker": "TMUS",
   "ts": "2026-08-14T20:00:00.000Z",
   "kind": "signal",
   "payload": {
    "signal": "recent_downgrade",
    "transition": "enter",
    "price": 182.533,
    "definition_version": 6
   }
  },
  {
   "ticker": "SSTI",
   "ts": "2026-08-14T20:00:00.000Z",
   "kind": "signal",
   "payload": {
    "signal": "recent_downgrade",
    "transition": "enter",
    "price": 6.165,
    "definition_version": 6
   }
  }
 ]
}
Spans — when it was true for one ticker (TMUS)
curl "https://api.tickerbot.io/v2/signals/recent_downgrade/TMUS/events" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-08-18, trimmed)
{
 "as_of": "2026-08-18T00:25:34.995Z",
 "ticker": "TMUS",
 "signal": "recent_downgrade",
 "count": 1,
 "events": [
  {
   "started_at": "2026-08-14T20:00:00.000Z",
   "ended_at": "2026-08-15T20:00:00.000Z",
   "start_price": 182.533,
   "end_price": 182.533,
   "definition_version": 6
  }
 ]
}

Same grammar on scan, series, and webhooks; state reads take ?asof= for point-in-time answers.

Related signals — Upgrades & downgrades