Stock market technical analysis alerts with Alpha Vantage & Discord

by Raz Hadas ✓ · 2,394 views · created 2025-07-30 · Crypto Trading

What this workflow does

This workflow has 14 nodes and runs on a schedule (every week at 17:00). Along the way it connects Postgres. It also calls alphavantage.co and discord.com over HTTP.

How it runs

Trigger: On a schedule (every week at 17:00).

1. Set - Ticker List (Edit Fields (Set)): sets 1 field: symbol
2. Split - Tickers (Split Out): splits a list into separate items
3. Fetch Daily History (HTTP Request): calls alphavantage.co
4. Getting today's data (Code): runs custom JavaScript code
5. Insert rows in a table (Postgres): uses Postgres
6. Execute a SQL query (Postgres): run a query
7. Compute 60/120 SMAs (Code): runs custom JavaScript code
8. If: checks a condition and branches into true / false
9. Set - Golden Cross Msg (Edit Fields (Set)): sets or maps fields
10. If: checks a condition and branches into true / false

…plus 3 more steps. See the full node list below.

Services it uses

Postgres

HTTP calls to: alphavantage.co, discord.com

Before you upgrade to n8n 3.0

Nodes used (7)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• Split Outn8n-nodes-base.splitOut
• HTTP Requestn8n-nodes-base.httpRequest
• Edit Fields (Set)n8n-nodes-base.set
• Postgresn8n-nodes-base.postgres
• Ifn8n-nodes-base.if

From the author

This n8n template demonstrates how to automate stock market technical analysis to detect key trading signals and send real-time alerts to Discord. It's built to monitor for the Golden Cross (a bullish signal) and the Death Cross (a bearish signal) using…

View the original on n8n.io → Check your own copy