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

last_rating_action

Action taken in the most recent rating change. Common values: `upgrades`, `downgrades`, `initiates_coverage_on`, `maintains`, `reiterates`, `assumes`, `reinstates`, `suspends`.

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

At a glance

Typetext
GroupAnalyst ratings
CategoryUpgrades & downgrades
Update cadencehourly
Universeall tickers
Historynone — live row only, not historized (no as-of reads)
Nullableyes — NULL where not applicable

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 scan /v2/scan

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

Live — the whole market, ranked by this column
curl -G "https://api.tickerbot.io/v2/scan" \
  --data-urlencode "q=last_rating_action IS NOT NULL" \
  -d "order=last_rating_action" -d "columns=last_rating_action" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-08-18, trimmed)
{
 "as_of": "2026-08-18T00:24:23.455Z",
 "query": {
  "q": "last_rating_action IS NOT NULL",
  "limit": 2,
  "order": "last_rating_action",
  "dir": "desc",
  "fields": [
   "last_rating_action"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "AAXJ",
   "name": "iShares MSCI All Country Asia ex Japan ETF",
   "asset_class": "stocks",
   "asset_type": "ETF",
   "price": 117.185,
   "day_change_pct": 0.0119,
   "gap_pct": 0.0145,
   "relative_volume": null,
   "market_cap": null,
   "last_rating_action": "upgrades"
  },
  {
   "ticker": "ABBV",
   "name": "ABBVIE INC.",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 250.245,
   "day_change_pct": 0.0031,
   "gap_pct": 0.0001,
   "relative_volume": null,
   "market_cap": 440825077916,
   "last_rating_action": "upgrades"
  }
 ]
}

Same grammar on scan and webhooks. This column is live-tense only — it isn't historized, so ?asof= reads and series pulls don't carry it.

Related signals — Upgrades & downgrades