# analyst_consensus_rating_value

Consensus rating as a numeric score on the standard 1–5 scale (1 = strong buy, 5 = strong sell). Lower is more bullish.

A numeric signal column on the Tickerbot computed state table (20,798+ ticker rows) — computed by the platform, queryable by bare name across the API. Values are NULL on rows the signal doesn't apply to.

- Group: Analyst ratings
- Category: Consensus ratings
- Type: numeric
- Update cadence: hourly
- Universe: all tickers
- History: none — live row only, not historized (no as-of reads for this column)
- Nullable: yes

## Query it

Every applicable form factor, grouped by endpoint family. 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. (https://tickerbot.io/docs/endpoints/signals.md)

#### Live — every ticker with analyst_consensus_rating_value above a cutoff

```bash
curl -G "https://api.tickerbot.io/v2/signals/analyst_consensus_rating_value" \
  --data-urlencode "condition=> 4" \
  -H "Authorization: Bearer YOUR_KEY"
```

Response (sampled 2026-08-18, trimmed):

```json
{
 "as_of": "2026-08-18T00:22:36.352Z",
 "signal": "analyst_consensus_rating_value",
 "condition": "> 4",
 "universe": null,
 "count": 2,
 "results": [
  {
   "ticker": "ESQ",
   "name": "Esquire Financial Holdings, Inc. Common Stock",
   "value": 5
  },
  {
   "ticker": "FRST",
   "name": "Primis Financial Corp. Common Stock",
   "value": 5
  }
 ]
}
```

#### Subscribe — webhook when a ticker starts matching

```bash
curl -X POST "https://api.tickerbot.io/v2/signals/analyst_consensus_rating_value/subscribe" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{"condition": "> 4", "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. (https://tickerbot.io/docs/endpoints/scan.md)

#### Live — the whole market, ranked by this column

```bash
curl -G "https://api.tickerbot.io/v2/scan" \
  --data-urlencode "q=analyst_consensus_rating_value IS NOT NULL" \
  -d "order=analyst_consensus_rating_value" -d "columns=analyst_consensus_rating_value" \
  -H "Authorization: Bearer YOUR_KEY"
```

Response (sampled 2026-08-18, trimmed):

```json
{
 "as_of": "2026-08-18T00:22:36.536Z",
 "query": {
  "q": "analyst_consensus_rating_value IS NOT NULL",
  "limit": 2,
  "order": "analyst_consensus_rating_value",
  "dir": "desc",
  "fields": [
   "analyst_consensus_rating_value"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "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_value": 5
  },
  {
   "ticker": "FRST",
   "name": "Primis Financial Corp. Common Stock",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 16.64,
   "day_change_pct": -0.0012,
   "gap_pct": -0.0072,
   "relative_volume": null,
   "market_cap": 413152539,
   "analyst_consensus_rating_value": 5
  }
 ]
}
```

#### Subscribe — webhook on a market-wide condition

```bash
curl -X POST "https://api.tickerbot.io/v2/scan/subscribe" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{"q": "analyst_consensus_rating_value > 4", "target_url": "https://example.com/hooks/tickerbot"}'
```

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

## Related signals (Consensus ratings)

- [analyst_consensus_rating](https://tickerbot.io/docs/signals/analyst_consensus_rating.md)
- [analyst_count_buy](https://tickerbot.io/docs/signals/analyst_count_buy.md)
- [analyst_count_hold](https://tickerbot.io/docs/signals/analyst_count_hold.md)
- [analyst_count_sell](https://tickerbot.io/docs/signals/analyst_count_sell.md)
- [analyst_count_strong_buy](https://tickerbot.io/docs/signals/analyst_count_strong_buy.md)
- [analyst_count_strong_sell](https://tickerbot.io/docs/signals/analyst_count_strong_sell.md)
- [analyst_count_total](https://tickerbot.io/docs/signals/analyst_count_total.md)
- [analyst_count_with_target](https://tickerbot.io/docs/signals/analyst_count_with_target.md)
- [bearish_consensus](https://tickerbot.io/docs/signals/bearish_consensus.md)
- [bullish_consensus](https://tickerbot.io/docs/signals/bullish_consensus.md)
- [well_covered](https://tickerbot.io/docs/signals/well_covered.md)

---

Full catalog: https://tickerbot.io/docs/signals.md · Schema: https://tickerbot.io/docs/schema.md · Interactive: https://tickerbot.io/explore?signal=analyst_consensus_rating_value · HTML: https://tickerbot.io/docs/signals/analyst_consensus_rating_value/