← tickerbot.io
Getting started

Queries

Anything you want to know about the market is a query over the table. Here are 30+ example queries to start with.

Which stocks beat earnings, are above their 200-day, and just had a price target raised?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "last_earnings_surprise_pct > 0 AND above_sma_200 AND recent_target_raise"
  }'

Run it in the sandbox →

Which large caps are 20% off their high but still growing revenue over 10%?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "market_cap > 1e10 AND from_52w_high_pct < -20 AND revenue_growth_yoy_pct > 10"
  }'

Run it in the sandbox →

Which stocks hit a 52-week high today on twice their usual volume, with news behind it?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "at_52w_high AND relative_volume > 2 AND recent_news_count > 0"
  }'

Run it in the sandbox →

Which heavily shorted stocks report earnings this week?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "short_float_pct > 20 AND earnings_this_week"
  }'

Run it in the sandbox →

Which large caps yield over 4% and still grew earnings last year?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "dividend_yield > 0.04 AND earnings_growth_yoy_pct > 0 AND market_cap > 1e10"
  }'

Run it in the sandbox →

Which stocks had a golden cross while an executive was buying?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "golden_cross AND insider_c_suite_buy"
  }'

Run it in the sandbox →

Which tech stocks trade under 15 times earnings with positive news sentiment?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "sector = 'Technology' AND pe_ratio < 15 AND news_volume_weighted_sentiment > 0"
  }'

Run it in the sandbox →

Which stocks were upgraded this week and still sit 10% under their target?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "recent_upgrade AND analyst_target_upside_pct > 10"
  }'

Run it in the sandbox →

Which ETFs charge under 0.1% and hold over $10B?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "etf_expense_ratio < 0.1 AND etf_net_assets > 1e10"
  }'

Run it in the sandbox →

Which large caps were oversold at the October 2023 low, on Oct 27, 2023?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "rsi_14 < 30 AND market_cap > 1e10",
    "asof": "2023-10-27"
  }'

Run it in the sandbox →

Which stocks gapped up more than 5% this morning on news?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "gap_pct > 5 AND recent_news_count > 0"
  }'

Run it in the sandbox →

Which stocks under $10 trade more than $50M a day?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "price < 10 AND day_dollar_volume > 5e7"
  }'

Run it in the sandbox →

Which large caps hold more cash than debt and bought back stock this month?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "cash_on_hand > total_debt AND buyback_30d AND market_cap > 1e10"
  }'

Run it in the sandbox →

Which stocks are oversold on RSI but still above their 200-day?

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

Run it in the sandbox →

Which stocks reporting this week have beaten four quarters running?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "earnings_this_week AND earnings_beat_streak >= 4"
  }'

Run it in the sandbox →

Which stocks with more than ten analysts covering them have a bullish consensus?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "analyst_count_total > 10 AND bullish_consensus"
  }'

Run it in the sandbox →

Which recent IPOs are up over the last month?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "recently_ipoed AND change_1m_pct > 0"
  }'

Run it in the sandbox →

Which low-float stocks are up more than 10% today?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "low_float AND change_1d_pct > 10"
  }'

Run it in the sandbox →

Which heavily shorted stocks with over five days to cover are up more than 3% today?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "short_float_pct > 15 AND days_to_cover > 5 AND change_1d_pct > 3"
  }'

Run it in the sandbox →

Which ETFs yield over 3%, charge under 0.2%, and hold over $1B?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "etf_dividend_yield > 0.03 AND etf_expense_ratio < 0.2 AND etf_net_assets > 1e9"
  }'

Run it in the sandbox →

Which stocks are in a Bollinger squeeze on thin volume?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "bollinger_squeeze AND relative_volume < 0.7"
  }'

Run it in the sandbox →

Which mega caps are down more than 3% today?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "mega_cap AND change_1d_pct < -3"
  }'

Run it in the sandbox →

Which companies grew revenue over 20% and trade under 5 times sales?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "revenue_growth_yoy_pct > 20 AND price_to_sales < 5 AND market_cap > 1e9"
  }'

Run it in the sandbox →

Which stocks had an estimate raised this month and are near a 52-week high?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "eps_estimate_revision_up_30d > 0 AND approaching_52w_high"
  }'

Run it in the sandbox →

Which stocks with a dividend coming up are above their 50-day?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "dividend_approaching AND above_sma_50"
  }'

Run it in the sandbox →

Which stocks have their 50-day below their 200-day and an executive selling?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "death_regime AND insider_c_suite_sell"
  }'

Run it in the sandbox →

Which large-cap healthcare stocks have negative news sentiment?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "sector = 'Healthcare' AND news_volume_weighted_sentiment < 0 AND market_cap > 1e10"
  }'

Run it in the sandbox →

Which stocks split recently and are up since?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "split_recent AND change_1m_pct > 0"
  }'

Run it in the sandbox →

Which profitable small caps trade under book value?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "small_cap AND profitable AND price_to_book < 1"
  }'

Run it in the sandbox →

Which stocks that institutions own more than half of were just upgraded?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "institutions_pct > 50 AND recent_upgrade"
  }'

Run it in the sandbox →

Which large caps were oversold at the March 2020 low, on Mar 20, 2020?

curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "rsi_14 < 30 AND market_cap > 1e10",
    "asof": "2020-03-20"
  }'

Run it in the sandbox →