Concepts › Signals › Analyst ratings › Consensus ratings
analyst_consensus_rating
Consensus analyst rating across contributing firms. One of `strong buy`, `buy`, `hold`, `sell`, `strong sell`. NULL for tickers without analyst coverage.
Watch this signal live on real tickers: Open in Explore →
At a glance
| Type | text |
| Group | Analyst ratings |
| Category | Consensus ratings |
| Update cadence | hourly |
| Universe | all tickers |
| History | none — live row only, not historized (no as-of reads) |
| Nullable | yes — NULL where not applicable |
The aggregate analyst opinion: consensus rating, the buy/hold/sell distribution, coverage depth.
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=analyst_consensus_rating IS NOT NULL" \
-d "order=analyst_consensus_rating" -d "columns=analyst_consensus_rating" \
-H "Authorization: Bearer YOUR_KEY"Response (sampled 2026-08-18, trimmed)
{
"as_of": "2026-08-18T00:22:35.815Z",
"query": {
"q": "analyst_consensus_rating IS NOT NULL",
"limit": 2,
"order": "analyst_consensus_rating",
"dir": "desc",
"fields": [
"analyst_consensus_rating"
],
"full": false,
"universe": null,
"asset_class": null
},
"count": 2,
"results": [
{
"ticker": "CVEO",
"name": "Civeo Corporation",
"asset_class": "stocks",
"asset_type": "CS",
"price": 33.74,
"day_change_pct": 0.0135,
"gap_pct": -0.012,
"relative_volume": null,
"market_cap": 344114036,
"analyst_consensus_rating": "strong buy"
},
{
"ticker": "ESQ",
"name": "Esquire Financial Holdings, Inc. Common Stock",
"asset_class": "stocks",
"asset_type": "CS",
"price": 124.09,
"day_change_pct": -0.031,
"gap_pct": 0.0004,
"relative_volume": null,
"market_cap": 1550112898,
"analyst_consensus_rating": "strong buy"
}
]
}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.