We're looking for an experienced n8n workflow developer to build a robust automation for a stock market screening tool using Simple Moving Averages (SMA) on Nifty 500 stocks

  1. Schedule Trigger Every 1 Hour
    • Use the Schedule Trigger node.
    • Set the interval to “Every 1 hour” or use the cron expression 0 * * * * for hourly runs.
  2. Get Nifty 500 Data and Symbols
    • Use an HTTP Request node to fetch the list of Nifty 500 symbols.
    • NSE’s website may not have a public API, so you might need to fetch a CSV or scrape the data. Yahoo Finance often has endpoints like:
      https://query1.finance.yahoo.com/v7/finance/quote?symbols=…
    • Parse the response to extract the list of symbols.
  3. Fetch Historical Data for Each Symbol
    • Use a SplitInBatches node to process each symbol individually.
    • For each symbol, use another HTTP Request node to fetch historical data (e.g., from Yahoo Finance’s historical data endpoint).
  4. Calculate SMA (Simple Moving Average)
    • Use a Function node after fetching historical data.
    • In the Function node, write JavaScript to calculate the 10-period and 20-period SMAs for each time frame (hourly, daily, weekly, monthly).
    • You can use array methods to calculate moving averages.
  5. Detect Bullish/Bearish Crossovers
    • In the same or a subsequent Function node, compare the 10 SMA and 20 SMA values.
    • Detect crossovers:
      • Bullish: 10 SMA crosses above 20 SMA.
      • Bearish: 10 SMA crosses below 20 SMA.
    • Store the result (bullish/bearish/none) for each symbol and time frame.
  6. Repeat for All Time Frames
    • For each symbol, repeat the SMA calculation and crossover detection for all four time frames.
    • You can do this in a loop within the Function node, or by structuring your data fetches accordingly.
  7. Generate and Merge Reports
    • Use a Merge node or a Function node to combine results for all symbols and time frames.
    • Structure the output as a summary grouped by symbol.
  8. Output the Final Report
    • Use a node like Google Sheets, Email, or Write Binary File to output the final report.
    • For Google Sheets, use the Google Sheets node to add rows.
    • For email, use the Email node to send the report.
      Tips:
  • Use expressions like $(‘HTTP Request’).item.json to reference data from previous nodes.
  • If you need to process large lists, consider using the SplitInBatches node to avoid memory issues.
  • For calculations, you can use JavaScript in the Function node to handle arrays and math.
1 Like

Hey, I can get it done. What’s the budget?

Book a call-

1 Like

Hi Sagar — I’d love to build this for you. I can implement the hourly schedule, fetch Nifty 500 symbols, calculate 10/20 SMAs across hourly/daily/weekly/monthly timeframes, detect crossovers, and output a clean report (Google Sheets / email / webhook) — scalable with SplitInBatches to avoid memory issues.

If that sounds good, book a 30-minute call so we can align on data source, output format, and timeline: https://calendly.com/muhammad-specials/30min

A bit about me:
I’m Muhammad Bin Zohaib — AI & Web Solutions Specialist, Full-Stack Developer, and Certified n8n Developer (Level 1 & 2). I build AI automations, voice agents, and intelligent web systems for clients across Canada, Greece, Singapore, India, Spain, Australia, Germany, the UK, and more. Recent work includes AI appointment setters, n8n automations, RAG chatbots, and voice AI for dental clinics. I’ll ensure the workflow is robust, error-tolerant, and easy to maintain.

Happy to start — book a slot and I’ll prepare a short demo plan for the call.

— Muhammad ([email protected] | +92 336 0327970)

Hi sagar

I’ve built multiple n8n systems for real-time data pipelines and trading analytics.
Your stock market screening project is right up my alley.

Here’s how I’d approach it:

  • Hourly trigger via cron

  • Yahoo Finance API for Nifty 500 data

  • SMA(10,20) computation using JS Function nodes

  • Crossover detection (bullish/bearish signals)

  • Output to Google Sheets + optional Telegram alert

  • Fully modular, optimized with SplitInBatches for large symbol sets

I can share a working demo within 2–3 days.
Would you like me to send the initial workflow JSON or a Loom walkthrough?

Best regards,
Victor Egbo
AI & Automation Engineer | n8n, Python, Playwright
:e_mail: [email protected]

Hey!

I work with AgentPowered, where we connect companies with vetted Automation and AI Engineers.
All of our builders are reviewed by our team and other engineers to ensure a high-quality standard before being listed in our catalog.

If you’re still looking, we can match you with the right builder this week. Book a meeting below:

Hey Sagar, I see you need a workflow to track 500 stocks hourly, calculate SMAs across timeframes, and detect crossovers automatically.

Here is how I can help:

  • Batch processing with delays to avoid Yahoo Finance rate limits

  • Efficient SMA logic for all timeframes

  • Automatic crossover detection with bullish/bearish signals

  • Error handling so failures don’t break the workflow

Here is my Portfolio.

Guarantee: If it is not stable and accurate, you get 100% money back. So you got noting to loose

Quick question: when a crossover is detected, do you want it logged or sent as an instant alert?

Here is my Calendly if you’d like to chat.

Regards,
Hammad