← tickerbot.io
View as markdown

recent_downgrade

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

definition
EXISTS (SELECT 1 FROM analyst_events WHERE ticker = t.ticker AND action = 'downgrades' AND timestamp >= NOW() - INTERVAL '7 days')

Swap YOUR_KEY for a key from /dashboard/keys. Responses are real captures from 2026-09-18, trimmed.

Every ticker matching this signal /v2/signals/{signal}

Live — every ticker where it fires now
curl "https://api.tickerbot.io/v2/signals/recent_downgrade" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-09-18, trimmed)
{
 "as_of": "2026-09-18T14:41:11.408Z",
 "signal": "recent_downgrade",
 "condition": null,
 "universe": null,
 "count": 2,
 "results": [
  {
   "ticker": "ACN",
   "name": "Accenture PLC",
   "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-07-04" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-09-18, trimmed)
{
 "as_of": "2026-06-20",
 "signal": "recent_downgrade",
 "condition": null,
 "universe": null,
 "count": 2,
 "results": [
  {
   "ticker": "ACN",
   "name": "Accenture PLC",
   "value": true
  },
  {
   "ticker": "ADBE",
   "name": "Adobe Inc.",
   "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.

The whole market, filtered on it /v2/scan

Live — the whole market, filtered on this signal
curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{ "q": "recent_downgrade" }'
Response (sampled 2026-09-18, trimmed)
{
 "as_of": "2026-09-18T14:41:12.449Z",
 "query": {
  "q": "recent_downgrade",
  "limit": 2,
  "order": "change_1d_pct",
  "dir": "desc",
  "fields": [],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "MARA",
   "name": "MARA Holdings, Inc. Common Stock",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 12.505,
   "change_1d_pct": 7.431271477663231,
   "gap_pct": 4.0808,
   "relative_volume": 0.4121,
   "market_cap": 4264744238
  },
  {
   "ticker": "TTRX",
   "name": "Turn Therapeutics Inc. Common Stock",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 14.265,
   "change_1d_pct": 3.2199710564399444,
   "gap_pct": -0.1447,
   "relative_volume": 0.1761,
   "market_cap": 416644898
  }
 ]
}
As-of — the same scan at a past date
curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{ "q": "recent_downgrade", "asof": "2026-07-04" }'
Response (sampled 2026-09-18, trimmed)
{
 "as_of": "2026-06-20",
 "query": {
  "q": "recent_downgrade",
  "asof": "2026-06-20",
  "interval": "auto",
  "limit": 2,
  "order": "change_1d_pct",
  "dir": "desc",
  "fields": [],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "DOMO",
   "name": "Domo, Inc. Class B Common Stock",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 2.42,
   "change_1d_pct": 20.999999999999996,
   "gap_pct": 0.49999999999998934,
   "relative_volume": 3.7480118459370155,
   "market_cap": 98030916
  },
  {
   "ticker": "RKT",
   "name": "Rocket Companies, Inc.",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 14.42,
   "change_1d_pct": 9.077155824508315,
   "gap_pct": 1.9288956127080106,
   "relative_volume": 1.923792283589634,
   "market_cap": 30247528647
  }
 ]
}
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.

Its history /v2/series

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-09-18, trimmed)
{
 "as_of": "2026-09-18T14:41:16.288Z",
 "interval": "1d",
 "tickers": [
  "AAPL",
  "MSFT"
 ],
 "columns": [
  "close",
  "recent_downgrade"
 ],
 "count": 6,
 "series": {
  "AAPL": [
   {
    "t": "2026-09-15",
    "close": 331.34,
    "recent_downgrade": false
   },
   {
    "t": "2026-09-16",
    "close": 332.41,
    "recent_downgrade": false
   },
   {
    "t": "2026-09-17",
    "close": 337.002,
    "recent_downgrade": false
   }
  ],
  "MSFT": [
   {
    "t": "2026-09-15",
    "close": 497.12,
    "recent_downgrade": false
   },
   {
    "t": "2026-09-16",
    "close": 490.3,
    "recent_downgrade": false
   },
   {
    "t": "2026-09-17",
    "close": 497.75,
    "recent_downgrade": false
   }
  ]
 }
}

Its firings /v2/events

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 "from=2026-02-24" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-09-18, trimmed)
{
 "as_of": "2026-09-18T14:41:16.522Z",
 "query": {
  "kind": "signal",
  "tickers": null,
  "universe": null,
  "since": "2026-02-10T00:00:00.000Z",
  "until": null,
  "limit": 2,
  "signal": "recent_downgrade",
  "transition": "enter"
 },
 "count": 2,
 "results": [
  {
   "ticker": "UGP",
   "ts": "2026-09-17T20:00:00.000Z",
   "kind": "signal",
   "payload": {
    "signal": "recent_downgrade",
    "transition": "enter",
    "price": 7.566,
    "definition_version": 6
   }
  },
  {
   "ticker": "S",
   "ts": "2026-09-17T20:00:00.000Z",
   "kind": "signal",
   "payload": {
    "signal": "recent_downgrade",
    "transition": "enter",
    "price": 23.179,
    "definition_version": 6
   }
  }
 ]
}

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

Related signals — Upgrades & downgrades