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