Generate Swing Trade Signals

Claudetelegram_bot_apiGoogle Sheets

Fetches daily market data for 40 NSE stocks, analyzes setups with AI, and delivers swing trade ideas to Telegram and Google Sheets.

Swing TradingStock MarketTelegram AlertsTechnical Analysis

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:

  1. Triggers every weekday at 4:05 PM IST, right after NSE market close
  2. Defines a universe of 40 NSE large cap stocks across major sectors
  3. Fetches live End of Day (EOD) market data for all 40 stocks in parallel using Yahoo Finance via RapidAPI
  4. Cleans and normalizes raw API responses into structured stock objects with technical indicators
  5. Sends the normalized data to an AI agent which identifies exactly 3 swing trade setups with entry, target, stop loss, and reasoning
  6. Delivers formatted trade alerts to a Telegram channel or group in real time
  7. Logs every trade recommendation into a Google Sheet for historical tracking

What you need

  1. A RapidAPI account with access to the Yahoo Finance API (apidojo yahoo finance v1)
  2. A Telegram Bot token and a Chat ID where alerts will be sent
  3. A Google account with a Google Sheet prepared for trade logging
  4. A Needle Google connector authorized for Sheets write access
  5. A Needle Telegram connector authorized with your Bot token
  6. The workflow variables listed in the configuration table below
VariableDescription
RAPIDAPI_KEYYour secret RapidAPI key for Yahoo Finance
TELEGRAM_CHAT_IDThe Chat ID for your Telegram destination
sheetIdThe ID of your Google Sheet
worksheetIdThe 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:

  1. Your Telegram channel as formatted real time alerts
  2. A Google Sheet that builds into a historical trade journal over time

Each trade includes the following structured data:

FieldDescription
SymbolThe stock ticker symbol
DirectionBuy or Sell recommendation
EntrySuggested entry price
TargetPrice target for the trade
Stop LossRecommended stop loss level
TimeframeExpected holding period (3 to 15 trading days)
ReasonA concise technical reason grounded in the EOD data

Notes

  1. The AI uses only the EOD data fetched during each run. It does not access real time intraday data or external news sources.
  2. Make sure your RapidAPI plan supports at least 40 requests per execution to avoid rate limiting.
  3. Your Google Sheet should have column headers matching the trade fields before the first run.
  4. This workflow is for educational and informational purposes only. It does not constitute financial advice. Always do your own research before making trading decisions.
  5. 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.

Try Needle today

Streamline AI productivity at your company today

Join thousands of people who have transformed their workflows.

Agentic workflowsAutomations, meet AI agents
AI SearchAll your data, searchable
Chat widgetsDrop-in widget for your website
Developer APIMake your app talk to Needle
    Needle LogoNeedle
    Like many websites, we use cookies to enhance your experience, analyze site traffic and deliver personalized content while you are here. By clicking "Accept", you are giving us your consent to use cookies in this way. Read our more on our cookie policy .