← tickerbot.io
View as markdown
Concepts › Signals › Fundamentals › Balance sheet

cash_on_hand

Cash plus cash equivalents — the most-liquid balance-sheet line.

metadata
typebigint
unitUSD
cadencepost-close daily
intervals1d
universeall tickers
historyrecent only (forward-only from first computation)
nullableyes — NULL where not applicable

Swap YOUR_KEY for a key from /dashboard/keys. Responses are real captures from 2026-09-18, trimmed.

Every ticker matching this signal /v2/signals/{signal}

Live — every ticker with cash_on_hand above a cutoff
curl -G "https://api.tickerbot.io/v2/signals/cash_on_hand" \
  --data-urlencode "condition=> 17" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-09-18, trimmed)
{
 "as_of": "2026-09-18T14:37:50.727Z",
 "signal": "cash_on_hand",
 "condition": "> 17",
 "universe": null,
 "count": 2,
 "results": [
  {
   "ticker": "BNO",
   "name": "United States Brent Oil Fund, LP",
   "value": 1936
  },
  {
   "ticker": "BMRC",
   "name": "Bank of Marin Bancorp",
   "value": 447
  }
 ]
}
As-of — the same read at a past date
curl -G "https://api.tickerbot.io/v2/signals/cash_on_hand" \
  --data-urlencode "condition=> 17" \
  -d "asof=2026-07-04" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-09-18, trimmed)
{
 "as_of": "2026-06-20",
 "signal": "cash_on_hand",
 "condition": "> 17",
 "universe": null,
 "count": 2,
 "results": [
  {
   "ticker": "BNO",
   "name": "United States Brent Oil Fund, LP",
   "value": 6707
  },
  {
   "ticker": "FDBC",
   "name": "Fidelity D & D Bancorp, Inc. Common Stock",
   "value": 3051
  }
 ]
}
Subscribe — webhook when a ticker starts matching
curl -X POST "https://api.tickerbot.io/v2/signals/cash_on_hand/subscribe" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{"condition": "> 17", "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.

The whole market, filtered on it /v2/scan

Live — the whole market, ranked by this column
curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{ "q": "cash_on_hand IS NOT NULL", "order": "cash_on_hand", "columns": "cash_on_hand" }'
Response (sampled 2026-09-18, trimmed)
{
 "as_of": "2026-09-18T14:37:53.749Z",
 "query": {
  "q": "cash_on_hand IS NOT NULL",
  "limit": 2,
  "order": "cash_on_hand",
  "dir": "desc",
  "fields": [
   "cash_on_hand"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "BNO",
   "name": "United States Brent Oil Fund, LP",
   "asset_class": "stocks",
   "asset_type": "ETV",
   "price": 61.382,
   "change_1d_pct": 0.7749138072566103,
   "gap_pct": 0.3284,
   "relative_volume": 0.1084,
   "market_cap": null,
   "cash_on_hand": 1936
  },
  {
   "ticker": "BMRC",
   "name": "Bank of Marin Bancorp",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 28.073,
   "change_1d_pct": -1.151408450704219,
   "gap_pct": -0.8451,
   "relative_volume": 0.2062,
   "market_cap": 449714266,
   "cash_on_hand": 447
  }
 ]
}
As-of — the same scan at a past date
curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{ "q": "cash_on_hand IS NOT NULL", "order": "cash_on_hand", "columns": "cash_on_hand", "asof": "2026-07-04" }'
Response (sampled 2026-09-18, trimmed)
{
 "as_of": "2026-06-20",
 "query": {
  "q": "cash_on_hand IS NOT NULL",
  "asof": "2026-06-20",
  "interval": "auto",
  "limit": 2,
  "order": "cash_on_hand",
  "dir": "desc",
  "fields": [
   "cash_on_hand"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "BNO",
   "name": "United States Brent Oil Fund, LP",
   "asset_class": "stocks",
   "asset_type": "ETV",
   "price": 43.88,
   "change_1d_pct": 0.8967578753736504,
   "gap_pct": -0.9887330420786381,
   "relative_volume": 0.9202207164880715,
   "market_cap": null,
   "cash_on_hand": 6707
  },
  {
   "ticker": "FDBC",
   "name": "Fidelity D & D Bancorp, Inc. Common Stock",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 49.67,
   "change_1d_pct": 4.15181379744182,
   "gap_pct": 2.138813168379122,
   "relative_volume": 1.8508523998925708,
   "market_cap": 175498,
   "cash_on_hand": 3051
  }
 ]
}
Subscribe — webhook on a market-wide condition
curl -X POST "https://api.tickerbot.io/v2/scan/subscribe" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{"q": "cash_on_hand > 17", "target_url": "https://example.com/hooks/tickerbot"}'

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

Its history /v2/series

History — the column on an aligned time grid
curl "https://api.tickerbot.io/v2/series?tickers=AAPL,MSFT&columns=close,cash_on_hand" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-09-18, trimmed)
{
 "as_of": "2026-09-18T14:37:56.167Z",
 "interval": "1d",
 "tickers": [
  "AAPL",
  "MSFT"
 ],
 "columns": [
  "close",
  "cash_on_hand"
 ],
 "count": 6,
 "series": {
  "AAPL": [
   {
    "t": "2026-09-15",
    "close": 331.34,
    "cash_on_hand": 0
   },
   {
    "t": "2026-09-16",
    "close": 332.41,
    "cash_on_hand": 0
   },
   {
    "t": "2026-09-17",
    "close": 337.002,
    "cash_on_hand": 0
   }
  ],
  "MSFT": [
   {
    "t": "2026-09-15",
    "close": 497.12,
    "cash_on_hand": 0
   },
   {
    "t": "2026-09-16",
    "close": 490.3,
    "cash_on_hand": 0
   },
   {
    "t": "2026-09-17",
    "close": 497.75,
    "cash_on_hand": 0
   }
  ]
 }
}

Same grammar on scan, series, and webhooks; state reads take ?asof= for point-in-time answers.

Related signals — Balance sheet