📈 Daily Crypto Market Summary Bot (Binance to Telegram)

This workflow fetches 24h price change data from Binance for selected crypto pairs (BTC/USDC, ETH/USDC, SOL/USDC) every hour using a cron schedule.
It performs in-depth analysis—including volatility, volume, bid-ask spread, momentum, and market comparison—then formats a detailed market summary.
The final report is sent to a Telegram chat using HTML formatting, highlighting top gainers, losers, and key metrics in a clean, readable layout.

🔑 Key Features

• ⏱ Runs every hour (cron: 5 * * * *)
• 🔍 Filters and analyzes major coins: BTC, ETH, SOL
• 📊 Calculates market metrics:
  • Volatility
  • Bid-ask spread
  • Momentum
  • Estimated market cap
  • Market average comparison
• 📈 Highlights gainers, losers, and top coins by volume
• ✂️ Splits messages to fit Telegram’s 4096 character limit
• 💬 Sends output in rich HTML format to a Telegram group or chat

🎯 Use Cases

• ✅ Crypto traders wanting hourly performance insights
• ✅ Telegram groups needing automated market updates
• ✅ Analysts monitoring key coin metrics in real-time
• ✅ Bot developers creating crypto dashboards or alerts

🛠 Technical Details

• Data Source: Binance 24hr ticker API (/api/v3/ticker/24hr)
• Coins Monitored: BTCUSDC, ETHUSDC, SOLUSDC (can be expanded)
• Metrics Calculated:
  • Price change percentage
  • Volatility (high vs low price)
  • Bid-ask spread %
  • Momentum (vs weighted average)
  • Estimated market cap
  • Number of trades
  • Market average movement
• Message Format:
  • HTML with emojis, bold styling, and section headings
  • Auto-split messages when exceeding Telegram's 4096-char limit
• Error Handling:
  • Retry on HTTP failure (up to 5 times with 5s delay)
  • Message length checked and split for Telegram compatibility

⚙️ Setup Requirements

1. Telegram Bot Token — Create a bot via @BotFather on Telegram
2. Chat ID — Use a personal ID or group chat ID (add the bot to the group)
3. n8n Instance — Either cloud or self-hosted
4. (Optional) Modify relevantSymbols in the Function node to track different coins

🧠 Notes

• This workflow is highly customizable—feel free to modify the analytics, tracked pairs, or formatting.
• Great base for alerting systems or crypto dashboards.

📷 Example Output (Telegram)

📊 Crypto Market Summary — 2025-04-20 14:05:05 UTC

🌐 Market Overview (BTC, ETH, SOL)
Average Change: -1.54%
24h Volume: $850,358,765.46
Most Volatile: SOLUSDC (4.53%)
Most Liquid: BTCUSDC (0.0000% spread)

💹 Top by Volume
ETHUSDC: $403,860,356.75 | -1.640%
SOLUSDC: $279,241,338.60 | -1.706%
BTCUSDC: $167,257,070.12 | -1.261%

📉 Losers

SOLUSDC
🔻 Change: -1.71% (24h)
💰 Current: $137.10
📊 Range: $135.82 - $141.97
📈 Volatility: 4.53%
🔄 Volume: 2.01M | $279,241,338.60
⚖️ Bid-Ask Spread: 0.0073%
⬇️ vs Market Avg: -0.17%
🔽 Momentum: -1.42%
🔢 Trades: 366,119

ETHUSDC
🔻 Change: -1.64% (24h)
💰 Current: $1,577.42
📊 Range: $1,565.60 - $1,631.98
📈 Volatility: 4.24%
🔄 Volume: 252.11K | $403,860,356.75
⚖️ Bid-Ask Spread: 0.0044%
⬇️ vs Market Avg: -0.10%
🔽 Momentum: -1.53%
🔢 Trades: 596,801

BTCUSDC
🔻 Change: -1.26% (24h)
💰 Current: $84,336.65
📊 Range: $83,963.35 - $85,634.50
📈 Volatility: 1.99%
🔄 Volume: 1.97K | $167,257,070.12
⚖️ Bid-Ask Spread: 0.0000%
⭐ vs Market Avg: 0.27%
🔽 Momentum: -0.68%
🔢 Trades: 124,202