Generate Swing Trade Signals
Fetches daily market data for 40 NSE stocks, analyzes setups with AI, and delivers swing trade ideas to Telegram and Google Sheets.
This workflow generates high probability swing trade ideas for NSE Nifty 50 stocks every weekday after market close. It combines real time market data from Yahoo Finance, detailed technical analysis powered by an advanced AI model, and instant delivery to Telegram with automatic logging to Google Sheets.
It does 7 things:
- Triggers every weekday at 4:05 PM IST, right after NSE market close
- Defines a universe of 40 NSE large cap stocks across major sectors
- Fetches live End of Day (EOD) market data for all 40 stocks in parallel using Yahoo Finance via RapidAPI
- Cleans and normalizes raw API responses into structured stock objects with technical indicators
- Sends the normalized data to an AI agent which identifies exactly 3 swing trade setups with entry, target, stop loss, and reasoning
- Delivers formatted trade alerts to a Telegram channel or group in real time
- Logs every trade recommendation into a Google Sheet for historical tracking
What you need
- A RapidAPI account with access to the Yahoo Finance API (apidojo yahoo finance v1)
- A Telegram Bot token and a Chat ID where alerts will be sent
- A Google account with a Google Sheet prepared for trade logging
- A Needle Google connector authorized for Sheets write access
- A Needle Telegram connector authorized with your Bot token
- The workflow variables listed in the configuration table below
| Variable | Description |
|---|---|
RAPIDAPI_KEY | Your secret RapidAPI key for Yahoo Finance |
TELEGRAM_CHAT_ID | The Chat ID for your Telegram destination |
sheetId | The ID of your Google Sheet |
worksheetId | The ID of the specific worksheet tab |
How the flow works
Scheduled Trigger
Fires every Monday through Friday at 4:05 PM IST using a cron schedule. Once published, no manual action is needed.
Stock Ticker List
Defines the watchlist of 40 NSE symbols from the Nifty 50 index covering all major sectors. It returns an array of ticker objects enabling the next node to process them in parallel.
Yahoo Finance HTTP Request
Fetches live EOD quote data for every ticker simultaneously via RapidAPI. Run mode is set to item so all 40 requests happen in parallel. Requires the RapidAPI key variable.
Data Parser and Normalizer
Processes the raw API responses and extracts only the fields needed for analysis: price, open, high, low, previous close, change percent, volume, P/E ratio, 50 Day Moving Average, and 200 Day Moving Average. Invalid responses are filtered out gracefully.
AI Agent Analysis
Receives the full normalized dataset and performs deep technical analysis to identify exactly 3 high probability swing trade setups. It evaluates Moving Average crossovers, volume confirmation, support and resistance levels, risk to reward ratios, and valuation via P/E ratios. The output is structured JSON.
Trade Array Normalizer
Ensures the AI output is always a clean flat array before passing it to output nodes. This handles edge cases where the AI might return a single object instead of an array.
Telegram Alerts
Sends a formatted markdown message to your Telegram channel for each trade, showing stock symbol, direction, entry, target, stop loss, holding period, and the reasoning.
Google Sheets Logger
Appends one row per trade to your spreadsheet, capturing all fields for performance tracking and future backtesting.
Output
You receive 3 actionable swing trade ideas every weekday evening delivered to:
- Your Telegram channel as formatted real time alerts
- A Google Sheet that builds into a historical trade journal over time
Each trade includes the following structured data:
| Field | Description |
|---|---|
| Symbol | The stock ticker symbol |
| Direction | Buy or Sell recommendation |
| Entry | Suggested entry price |
| Target | Price target for the trade |
| Stop Loss | Recommended stop loss level |
| Timeframe | Expected holding period (3 to 15 trading days) |
| Reason | A concise technical reason grounded in the EOD data |
Notes
- The AI uses only the EOD data fetched during each run. It does not access real time intraday data or external news sources.
- Make sure your RapidAPI plan supports at least 40 requests per execution to avoid rate limiting.
- Your Google Sheet should have column headers matching the trade fields before the first run.
- This workflow is for educational and informational purposes only. It does not constitute financial advice. Always do your own research before making trading decisions.
- You can expand the stock universe by editing the ticker list in the Code Node. The workflow scales without any other changes.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
