Concepts › Signals › Analyst ratings › Upgrades & downgrades
last_rating_firm
Name of the firm that issued the most recent rating action.
Watch this signal live on real tickers: Open in Explore →
At a glance
| Type | text |
| Group | Analyst ratings |
| Category | Upgrades & downgrades |
| Update cadence | hourly |
| Universe | all tickers |
| History | none — live row only, not historized (no as-of reads) |
| Nullable | yes — 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_firm IS NOT NULL" \
-d "order=last_rating_firm" -d "columns=last_rating_firm" \
-H "Authorization: Bearer YOUR_KEY"Response (sampled 2026-08-18, trimmed)
{
"as_of": "2026-08-18T00:24:23.509Z",
"query": {
"q": "last_rating_firm IS NOT NULL",
"limit": 2,
"order": "last_rating_firm",
"dir": "desc",
"fields": [
"last_rating_firm"
],
"full": false,
"universe": null,
"asset_class": null
},
"count": 2,
"results": [
{
"ticker": "ACB",
"name": "Aurora Cannabis Inc. Common Shares",
"asset_class": "stocks",
"asset_type": "CS",
"price": 3.62,
"day_change_pct": -0.0163,
"gap_pct": -0.0109,
"relative_volume": null,
"market_cap": 232981024,
"last_rating_firm": "Zuanic & Associates"
},
{
"ticker": "LIEN",
"name": "Chicago Atlantic BDC, Inc. Common Stock",
"asset_class": "stocks",
"asset_type": "CS",
"price": 9.49,
"day_change_pct": -0.0032,
"gap_pct": -0.0147,
"relative_volume": null,
"market_cap": 217252016,
"last_rating_firm": "Zuanic & Associates"
}
]
}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.