Analyze Crypto Market with CoinGecko: Volatility Metrics & Investment Signals

Description

This n8n template lets you automatically pull market data for the cryptocurrencies from CoinGecko every hour, calculate custom volatility and market-health metrics, classify each coin’s price action into buy/sell/hold/neutral signals with risk ratings, and expose both individual analyses and a portfolio summary via a webhook. It’s perfect for crypto analysts, DeFi builders, or portfolio managers who want on-demand insights without writing a single line of backend code.

🔧 How it works
Schedule Trigger fires every hour (or interval you choose).
HTTP Request (CoinGecko) fetches the top 10 coins by market cap, including 24 h, 7 d, and 30 d price change percentages.
Split In Batches ensures each coin is processed sequentially.
Function (Calculate Market Metrics) computes:
A weighted volatility score
Market-cap-to-volume ratio
Price-to-ATH ratio
Composite market score

IF & Switch nodes categorize each coin’s 24 h price action (up >5%, down >5%, high volatility, or stable) and append:
signal (BUY/SELL/HOLD/NEUTRAL)
riskRating (High/Medium/Low/Unknown)
recommendation & investmentStrategy guidance

NoOp & Merge nodes consolidate each branch back into a single data stream.

Function (Generate Portfolio Summary) aggregates all analyses into:
A Markdown portfolioSummary
Counts of buy/sell/hold/neutral signals
Risk distribution

Webhook Response returns the full JSON payload with individual analyses and the summary for downstream consumers.

👤 Who is it for?
This workflow is ideal for:

Crypto researchers and analysts who need scheduled market insights

DeFi and trading bot developers looking to automate signal generation

Portfolio managers seeking a no-code overview of top assets

Automation engineers exploring API integration and data enrichment

📑 Data Structure
When you trigger the webhook, you’ll receive a JSON object containing:

individualAnalyses: Array of { coin, symbol, currentPrice, priceChanges, marketMetrics, signal, riskRating, recommendation }

portfolioSummary: Markdown report summarizing signals, risk distribution, and top opportunity

marketSignals: Counts of each signal type

riskDistribution: Counts of each risk rating

timestamp: ISO string of analysis time

⚙️ Setup Instructions
Import: In n8n Editor → click “Import from JSON” → paste this workflow JSON.

Configure Schedule: Double-click the Schedule Trigger → set your desired interval (default: every hour).

Webhook Path: Open the Webhook node → choose a unique path (e.g., /crypto‐analysis) and “POST”.

Activate: Save and activate the workflow.

Test:
Open the webhook url to other tab or use cURL
curl -X POST https://<your-n8n-host>/webhook/<path>

You’ll get back a JSON payload with both portfolioSummary and individualAnalyses.

📝 Tips
Rate-Limit Handling: If CoinGecko returns 429, insert a Delay node (e.g., 500 ms) after the HTTP Request.
Batch Size: Default is 1 coin at a time; you can bump it to parallelize.
Customization: Tweak volatility weightings or add new metrics directly in the “Calculate Market Metrics” Function node.
Extension: Swap CoinGecko for another API by updating the HTTP Request URL and field mappings.