Google Sheet NSE Delivery Analyzer
Budget: ₹600 – ₹1,500 INR
I need a Google Sheet that automatically pulls historical data for any Indian stock I type in, lets me set a custom date range, and then shows:
• Raw daily figures for any date range for traded volume, delivery volume, and the calculated delivery %
• An auto-updating chart that visualises that percentage across the same period
The flow I have in mind is simple: I enter a ticker (NSE symbol) and choose From / To dates; the sheet (perhaps through IMPORTHTML, IMPORTXML, an API, or Apps Script—whatever is most reliable) grabs the numbers, fills the table, and refreshes the line/column chart in one click. I should be able to repeat this on additional tabs for other symbols without rewriting code.
Please build the sheet, wire up the data-fetch logic, create the delivery % formula, and style a clean chart. If a public API key or script is required, document exactly where to paste it so I can maintain the sheet later.
• Raw daily figures for any date range for traded volume, delivery volume, and the calculated delivery %
• An auto-updating chart that visualises that percentage across the same period
The flow I have in mind is simple: I enter a ticker (NSE symbol) and choose From / To dates; the sheet (perhaps through IMPORTHTML, IMPORTXML, an API, or Apps Script—whatever is most reliable) grabs the numbers, fills the table, and refreshes the line/column chart in one click. I should be able to repeat this on additional tabs for other symbols without rewriting code.
Please build the sheet, wire up the data-fetch logic, create the delivery % formula, and style a clean chart. If a public API key or script is required, document exactly where to paste it so I can maintain the sheet later.