# pct_from_sma_200

Percent distance from the 200-day SMA. Negative when price is below the average.

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: Technicals
- Category: Moving averages & VWAP
- Type: numeric
- Unit: %
- Update cadence: post-close daily
- Intervals: 1m/1h/1d
- Universe: all tickers
- History: full · since 2004
- 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 pct_from_sma_200 above a cutoff

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

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

```json
{
 "as_of": "2026-08-18T00:25:06.369Z",
 "signal": "pct_from_sma_200",
 "condition": "> 0.8891",
 "universe": null,
 "count": 2,
 "results": [
  {
   "ticker": "WETO",
   "name": "Wetour Robotics Limited Ordinary Shares",
   "value": 27.6831
  },
  {
   "ticker": "BANL",
   "name": "CBL International Limited Class B Ordinary Shares",
   "value": 9.1694
  }
 ]
}
```

#### As-of — the same read at a past date

```bash
curl -G "https://api.tickerbot.io/v2/signals/pct_from_sma_200" \
  --data-urlencode "condition=> 0.8891" \
  -d "asof=2026-05-20" \
  -H "Authorization: Bearer YOUR_KEY"
```

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

```json
{
 "as_of": "2026-05-20",
 "signal": "pct_from_sma_200",
 "condition": "> 0.8891",
 "universe": null,
 "count": 2,
 "results": [
  {
   "ticker": "MGRT",
   "name": "Mega Fortune Company Limited Ordinary Shares",
   "value": 420.0516994819544
  },
  {
   "ticker": "INTW",
   "name": "GraniteShares 2x Long INTC Daily ETF",
   "value": 348.58328052838385
  }
 ]
}
```

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

```bash
curl -X POST "https://api.tickerbot.io/v2/signals/pct_from_sma_200/subscribe" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{"condition": "> 0.8891", "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=pct_from_sma_200 IS NOT NULL" \
  -d "order=pct_from_sma_200" -d "columns=pct_from_sma_200" \
  -H "Authorization: Bearer YOUR_KEY"
```

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

```json
{
 "as_of": "2026-08-18T00:25:08.773Z",
 "query": {
  "q": "pct_from_sma_200 IS NOT NULL",
  "limit": 2,
  "order": "pct_from_sma_200",
  "dir": "desc",
  "fields": [
   "pct_from_sma_200"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "WETO",
   "name": "Wetour Robotics Limited Ordinary Shares",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 35.36,
   "day_change_pct": 3.3017,
   "gap_pct": 0.236,
   "relative_volume": 3.2667,
   "market_cap": 6746976,
   "pct_from_sma_200": 27.6831
  },
  {
   "ticker": "BANL",
   "name": "CBL International Limited Class B Ordinary Shares",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 11.001,
   "day_change_pct": 0.0065,
   "gap_pct": -0.1446,
   "relative_volume": null,
   "market_cap": 23077558,
   "pct_from_sma_200": 9.1694
  }
 ]
}
```

#### As-of — the same scan at a past date

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

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

```json
{
 "as_of": "2026-05-20",
 "query": {
  "q": "pct_from_sma_200 IS NOT NULL",
  "asof": "2026-05-20",
  "interval": "auto",
  "limit": 2,
  "order": "pct_from_sma_200",
  "dir": "desc",
  "fields": [
   "pct_from_sma_200"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "MGRT",
   "name": "Mega Fortune Company Limited Ordinary Shares",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 122.49,
   "day_change_pct": -3.929411764705886,
   "gap_pct": -0.5725490196078462,
   "relative_volume": 0.6125488824976112,
   "market_cap": null,
   "pct_from_sma_200": 420.0516994819544
  },
  {
   "ticker": "INTW",
   "name": "GraniteShares 2x Long INTC Daily ETF",
   "asset_class": "stocks",
   "asset_type": "ETF",
   "price": 40.3588,
   "day_change_pct": 14.7290171274252,
   "gap_pct": 10.866320801648776,
   "relative_volume": 1.1736647935026017,
   "market_cap": null,
   "pct_from_sma_200": 348.58328052838385
  }
 ]
}
```

#### 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": "pct_from_sma_200 > 0.8891", "target_url": "https://example.com/hooks/tickerbot"}'
```

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

### Use series — `/v2/series`

Its history over time, on one aligned grid. (https://tickerbot.io/docs/endpoints/series.md)

#### History — the column on an aligned time grid

```bash
curl "https://api.tickerbot.io/v2/series?tickers=AAPL,MSFT&columns=close,pct_from_sma_200" \
  -H "Authorization: Bearer YOUR_KEY"
```

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

```json
{
 "as_of": "2026-08-18T00:25:12.337Z",
 "interval": "1d",
 "tickers": [
  "AAPL",
  "MSFT"
 ],
 "columns": [
  "close",
  "pct_from_sma_200"
 ],
 "count": 6,
 "series": {
  "AAPL": [
   {
    "t": "2026-08-12",
    "close": 302.25,
    "pct_from_sma_200": 7.893810668400356
   },
   {
    "t": "2026-08-13",
    "close": 305.26,
    "pct_from_sma_200": 8.902663989658887
   },
   {
    "t": "2026-08-14",
    "close": 305.93,
    "pct_from_sma_200": 9.066992603756004
   }
  ],
  "MSFT": [
   {
    "t": "2026-08-12",
    "close": 492.43,
    "pct_from_sma_200": 13.79151266574177
   },
   {
    "t": "2026-08-13",
    "close": 496.88,
    "pct_from_sma_200": 14.847367871211864
   },
   {
    "t": "2026-08-14",
    "close": 495.4,
    "pct_from_sma_200": 14.49678958678658
   }
  ]
 }
}
```

## Related signals (Moving averages & VWAP)

- [above_sma_10](https://tickerbot.io/docs/signals/above_sma_10.md)
- [above_sma_20](https://tickerbot.io/docs/signals/above_sma_20.md)
- [above_sma_200](https://tickerbot.io/docs/signals/above_sma_200.md)
- [above_sma_50](https://tickerbot.io/docs/signals/above_sma_50.md)
- [above_vwap](https://tickerbot.io/docs/signals/above_vwap.md)
- [above_vwap_minute](https://tickerbot.io/docs/signals/above_vwap_minute.md)
- [day_vwap](https://tickerbot.io/docs/signals/day_vwap.md)
- [death_cross](https://tickerbot.io/docs/signals/death_cross.md)
- [death_regime](https://tickerbot.io/docs/signals/death_regime.md)
- [ema_12](https://tickerbot.io/docs/signals/ema_12.md)
- [ema_21](https://tickerbot.io/docs/signals/ema_21.md)
- [ema_26](https://tickerbot.io/docs/signals/ema_26.md)
- [ema_9](https://tickerbot.io/docs/signals/ema_9.md)
- [golden_cross](https://tickerbot.io/docs/signals/golden_cross.md)
- [golden_regime](https://tickerbot.io/docs/signals/golden_regime.md)

---

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