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
- Decides what to do next
- Calls the service's API
- Picks out the values
- Alerts you
- Sends a chat message
All 25 steps (as they appear in the app)
- If type matches ^crypto
- If coingecko_key not empty
- _cg_head = x-cg-demo-api-key: {{coingecko_key}}
- _cg_head =
- _id = {{symbol:lower}}
- GET {{coingecko_url}}/simple/price?ids={{_id:url}}&vs_currencies={{currency}}&include_24hr_change=true&include_market_cap=true
- Read values: price, change_pct, market_cap
- change_pct = round({{change_pct|0}}, 2)
- GET {{finnhub_url}}/quote?symbol={{symbol:upper}}&token={{finnhub_key}}
- Read values: price, change, change_pct, day_high, day_low, previous_close
- If price matches ^0(\.0+)?$
- Stop row: unknown symbol {{symbol}}
- If price empty
- Stop row: no price for {{symbol}}
- checked_at = {{now}}
- If alert_above not empty
- If price greater {{alert_above}}
- Notify: {{symbol}} is above {{alert_above}}
- If alert_slack equals yes
- Slack: {{symbol}} is above {{alert_above}} {{symbol}}: {{
- If alert_below not empty
- If price less {{alert_below}}
- Notify: {{symbol}} is below {{alert_below}}
- If alert_slack equals yes
- 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.
| symbol | type | alert_above | alert_below |
|---|---|---|---|
| bitcoin | crypto | ||
| ethereum | crypto | ||
| AAPL | stock |
Get this template
1. Download Develofly Autopilot: free, for Ubuntu and other Linux desktops.
Download Develofly Autopilot2. 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 AutopilotWhat 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.