Develofly Autopilot
Templates › Research & Reporting › Stock / crypto price logger

Stock / crypto price logger

Log a list of tickers and coins on a schedule.

Research & ReportingEvery hour on weekdays

Download the app, freeOpen in Autopilot

Stock / crypto price logger: what it does, step by step, with its sample data

What it does

Logs the price of each stock or crypto coin in your list (type: stock or crypto) with the day's change, and alerts you when one crosses your alert_above / alert_below levels. Crypto prices come from CoinGecko (no key needed; use the coin's CoinGecko id such as bitcoin); stock quotes from Finnhub (free API key). Schedule it and send results to a Google Sheet to build a price log.

How it works

  1. Decides what to do next
  2. Calls the service's API
  3. Picks out the values
  4. Alerts you
  5. Sends a chat message
All 25 steps (as they appear in the app)
  1. If type matches ^crypto
  2. If coingecko_key not empty
  3. _cg_head = x-cg-demo-api-key: {{coingecko_key}}
  4. _cg_head =
  5. _id = {{symbol:lower}}
  6. GET {{coingecko_url}}/simple/price?ids={{_id:url}}&vs_currencies={{currency}}&include_24hr_change=true&include_market_cap=true
  7. Read values: price, change_pct, market_cap
  8. change_pct = round({{change_pct|0}}, 2)
  9. GET {{finnhub_url}}/quote?symbol={{symbol:upper}}&token={{finnhub_key}}
  10. Read values: price, change, change_pct, day_high, day_low, previous_close
  11. If price matches ^0(\.0+)?$
  12. Stop row: unknown symbol {{symbol}}
  13. If price empty
  14. Stop row: no price for {{symbol}}
  15. checked_at = {{now}}
  16. If alert_above not empty
  17. If price greater {{alert_above}}
  18. Notify: {{symbol}} is above {{alert_above}}
  19. If alert_slack equals yes
  20. Slack: {{symbol}} is above {{alert_above}} {{symbol}}: {{
  21. If alert_below not empty
  22. If price less {{alert_below}}
  23. Notify: {{symbol}} is below {{alert_below}}
  24. If alert_slack equals yes
  25. Slack: {{symbol}} is below {{alert_below}} {{symbol}}: {{

Sample data included

The template comes with sample rows like these, so you can see it work before using your own list.

symboltypealert_abovealert_below
bitcoincrypto
ethereumcrypto
AAPLstock

Get this template

1. Download Develofly Autopilot: free, for Ubuntu and other Linux desktops.

Download Develofly Autopilot

2. The app comes with every template, so this one is already in your library. Click below to open it (or find it under Templates).

Open in Autopilot

What you need

  • A spreadsheet (CSV or Excel) — a sample is included

You fill in: Crypto: currency, Stocks: Finnhub API key, Crypto: CoinGecko demo key (optional), CoinGecko address (advanced), Finnhub address (advanced), Also send alerts to Slack.

Make it yours

Every step is editable in the app: change the site, the columns, the schedule, or chain it with other bots. Run it once, on a schedule, or sell it as your own bot.

More Research & Reporting templates

Grant / RFP finderScan grant and tender portals for new opportunities.News clipping monitorTrack a topic across news sites into a sheet.Daily KPI dashboard emailerPull numbers from APIs or sheets and email a daily digest.Daily numbers to SlackA number from any API, posted to Slack daily.