Generate daily stock buy/sell signals using technical indicators and Google Sheets
Go to Workflow
Rahul Joshi
Description
📊 Description
This automation calculates commonly used technical indicators for selected stocks and presents the results in a simple, structured dashboard. It removes the need for manual chart analysis by automatically fetching price data, calculating indicators, and generating clear Buy, Sell, or Neutral signals.
The workflow is designed to run daily and provides a consistent technical snapshot for each tracked stock. It is suitable for traders and analysts who want a repeatable and transparent way to monitor technical conditions without relying on manual tools.
⚙️ What This Template Does
Runs automatically on a daily schedule
Processes a predefined list of stock symbols
Fetches recent daily price data from a market data API
Calculates RSI, Moving Averages, and MACD
Applies rule-based logic to generate Buy, Sell, or Neutral signals
Stores indicator values and signals in Google Sheets
✅ Key Benefits
Eliminates manual technical analysis
Uses standard, widely accepted indicators
Produces clear and easy-to-interpret signals
Keeps all results in a single dashboard
Easy to customize and extend
🧩 Features
Daily scheduled execution
Historical price data integration
RSI (14-period) calculation
Moving Averages (SMA 20 and SMA 50)
MACD (12, 26, 9) calculation
Rule-based Buy / Sell / Neutral classification
Google Sheets dashboard output
Built-in data validation checks
🔐 Requirements
To use this workflow, you will need:
A market data API key (Alpha Vantage or similar)
A Google Sheets account for storing results
Google Sheets credentials configured in n8n
An active n8n instance (cloud or self-hosted)
🎯 Target Audience
Stock traders and investors
Technical analysts
Finance and research teams
Automation builders working with market data
🛠 Customization Options
Update the stock list to track different symbols
Adjust indicator periods or thresholds
Modify Buy / Sell signal rules
Change the schedule frequency
Extend the dashboard with additional indicators