Crypto price alerts, a morning digest and on-demand replies

The scenario watches your coin list and alerts Microsoft Teams on notable moves, sends a digest each morning, and replies with a price on command. Alerts are logged to Microsoft SQL.

  • Alerts only on moves that meet your rules
  • A morning digest for the whole list
  • A price reply on command
  • Alert history builds up in a table
Set it up for yourselfScriptera

How it works

To get Microsoft Teams notifications in Microsoft SQL, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Hourly Trigger
  2. Then: Configure Watchlist
  3. Check: Loop Over Assets
  4. Then: Fetch Crypto Prices
  5. Then: Merge Market Data
  6. Check: If Price Data Exists
  7. If yes: Load Asset State
  8. Check: If First Time Running
  9. If yes: Store Initial Price
  10. If no: Fetch RSI Values
  11. Then: Compute RSI
  12. Then: Check Alert Conditions
  13. Check: If Alert Needed
  14. If yes: If Alert Cooldown Over
  15. If yes: Create Alert Message
  16. Then: Send Alert on Telegram
  17. Then: Append Alert to Sheets
  18. Then: Save Alert Status
  19. If no: Log Price Without Alert
  20. Starts when: Daily 8am Trigger
  21. Then: Configure Daily Digest
  22. Then: Retrieve All Crypto Prices
  23. Then: Get Fear & Greed Index
  24. Then: Build Daily Digest Message
  25. Then: Send Digest on Telegram
  26. Starts when: When Telegram Command Received
  27. Then: Decode Telegram Message
  28. Check: If Command is /price
  29. If yes: Fetch Specific Price
  30. Then: Create Price Reply Message
  31. Then: Send Price Reply on Telegram
  32. If no: Send Unknown Command Alert

You can launch this Microsoft Teams + Microsoft SQL integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios