# last_rating_action

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

A text 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: Upgrades & downgrades
- Type: text
- 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 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=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):

```json
{
 "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"
  }
 ]
}
```

## Related signals (Upgrades & downgrades)

- [last_rating_date](https://tickerbot.io/docs/signals/last_rating_date.md)
- [last_rating_firm](https://tickerbot.io/docs/signals/last_rating_firm.md)
- [recent_downgrade](https://tickerbot.io/docs/signals/recent_downgrade.md)
- [recent_initiation](https://tickerbot.io/docs/signals/recent_initiation.md)
- [recent_target_lower](https://tickerbot.io/docs/signals/recent_target_lower.md)
- [recent_target_raise](https://tickerbot.io/docs/signals/recent_target_raise.md)
- [recent_upgrade](https://tickerbot.io/docs/signals/recent_upgrade.md)

---

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