AI Stock Trading Sheet Integration
Budget: ₹12,500 – ₹37,500 INR
I’m building an automated workflow in Google Sheets that turns live and historical Indian stock-market data into actionable buy/sell alerts. Here’s what I need:
• Data feeds
– Import and refresh historical prices and intraday trading volumes for NSE/BSE symbols.
– Pull or receive recent news sentiment in JSON format so the model can gauge market mood.
• Signal engine
– In one Apps Script (Java / JavaScript), calculate Moving Averages, RSI, and MACD on the fly.
– Combine those indicators with a lightweight machine-learning layer so the sheet anticipates trend changes instead of reacting after the fact.
• Output
– When the model’s rules or probability thresholds are met, the sheet should surface colour-coded alerts in dedicated cells/columns (no emails needed).
– A compact dashboard tab with sparkline charts is enough for visual context.
• Workflow & hand-off
– Code must run fully inside the Google Sheets environment (Apps Script) and accept JSON payloads for news.
– Comment the script clearly, include a short README, and demonstrate the signals on at least two live NSE tickers.
– Accuracy targets and thresholds can stay configurable so I can fine-tune later.
Deliver a functional prototype that I can paste into my own sheet, test, and extend.
I have stratergy in place
Daily outcome (by ~10:00 AM IST)
• G/L cells in both Top/Bottom tables show green/red based on Research360Data.
• Shortlist uses:
• BUY: Top 3 sector AND stock % > 0 AND index = green
• SELL: Bottom 3 sector AND stock % < 0 AND index = red
• Data feeds
– Import and refresh historical prices and intraday trading volumes for NSE/BSE symbols.
– Pull or receive recent news sentiment in JSON format so the model can gauge market mood.
• Signal engine
– In one Apps Script (Java / JavaScript), calculate Moving Averages, RSI, and MACD on the fly.
– Combine those indicators with a lightweight machine-learning layer so the sheet anticipates trend changes instead of reacting after the fact.
• Output
– When the model’s rules or probability thresholds are met, the sheet should surface colour-coded alerts in dedicated cells/columns (no emails needed).
– A compact dashboard tab with sparkline charts is enough for visual context.
• Workflow & hand-off
– Code must run fully inside the Google Sheets environment (Apps Script) and accept JSON payloads for news.
– Comment the script clearly, include a short README, and demonstrate the signals on at least two live NSE tickers.
– Accuracy targets and thresholds can stay configurable so I can fine-tune later.
Deliver a functional prototype that I can paste into my own sheet, test, and extend.
I have stratergy in place
Daily outcome (by ~10:00 AM IST)
• G/L cells in both Top/Bottom tables show green/red based on Research360Data.
• Shortlist uses:
• BUY: Top 3 sector AND stock % > 0 AND index = green
• SELL: Bottom 3 sector AND stock % < 0 AND index = red