Build a trading algorithm, with Tickerbot.

the recipe

One condition, three tenses.

1. Define the entry condition — a SQL WHERE clause over named, precomputed columns —421+ signals plus the fundamentals. This is the whole market evaluated in one call, right now:

curl -s -X POST https://api.tickerbot.io/v2/scan \
  -H "Authorization: Bearer $TICKERBOT_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{ "q": "rsi_14 < 30 AND above_sma_200 AND market_cap > 1e9" }'

2. Validate it historically — the same query with ?asof= reruns it against the market as it was at that moment — delisted tickers included, no survivorship bias, unlimited depth on every plan. Walk it across dates and you have a candidate history for your backtest:

curl -s -X POST "https://api.tickerbot.io/v2/scan?asof=2024-01-05" \
  -H "Authorization: Bearer $TICKERBOT_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{ "q": "rsi_14 < 30 AND above_sma_200 AND market_cap > 1e9" }'

3. Run it live — subscribe the same query as a webhook. It fires when the match set changes — a ticker entering your condition is your signal to decide; your handler runs the strategy and routes any order to your broker:

curl -s -X POST https://api.tickerbot.io/v2/scan/subscribe \
  -H "Authorization: Bearer $TICKERBOT_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{ "q": "rsi_14 < 30 AND above_sma_200 AND market_cap > 1e9",
        "target_url": "https://your-bot.example.com/hook" }'

4. Write the algorithm — the strategy itself is a webhook handler — and this is the part that stays yours. The payload’s matches are the tickers that just entered your condition; current_matches is everything matching right now — so entries and exits both fall out of one delivery. (Payload lists cap at 100 rows; at scale, confirm any single position with GET /v2/tickers/{ticker}.)

// POST from Tickerbot whenever the match set changes:
// { "event": "webhook.fired",
//   "q": "rsi_14 < 30 AND above_sma_200 AND market_cap > 1e9",
//   "as_of": "2026-08-14T15:05:00Z",
//   "matches":         [ { "ticker": "RIOT", "rsi_14": 27.4, ... } ],
//   "current_matches": [ /* every ticker matching right now */ ] }

app.post('/hook', async (req, res) => {
  const { matches, current_matches } = req.body
  const matching = new Set(current_matches.map((r) => r.ticker))

  // ENTRIES — tickers that just entered the condition.
  // Sizing, risk, portfolio state: your strategy, not Tickerbot's job.
  for (const row of matches) {
    if (!portfolio.has(row.ticker) && passesRisk(row)) {
      await broker.buy(row.ticker, positionSize(row))  // your broker's API
    }
  }

  // EXITS — held positions whose entry condition no longer holds
  // (or subscribe a second webhook on your exit condition).
  for (const pos of portfolio.positions()) {
    if (!matching.has(pos.ticker) && exitRules(pos)) {
      await broker.sell(pos.ticker, pos.qty)
    }
  }

  res.sendStatus(200)
})