Live Nifty Options Excel Logger

Замовник: AI | Опубліковано: 08.12.2025

I want a single, self-contained solution that collects the full Nifty option-chain directly from the NSE in real time and drops it into one Excel workbook. The file must refresh every minute during market hours so I can later run systematic back-tests on the historical ticks. Key needs • Storage: native Excel—no external database or cloud repository. • Format: clean XLSX file, appended or overwritten per your design, but always ready for analysis. • Frequency: automatic one-minute pulls without manual clicks. You are free to build the collector in Python, VBA, .NET, or any stack that can reliably grab the data and push it to Excel. Just make sure the routine: 1. Timestamps each snapshot. 2. Captures all strikes, calls, puts, and any extra Greeks you can fetch. 3. Handles network hiccups gracefully and reconnects. 4. Ships with a brief README or inline comments so I can run it on a standard Windows laptop. Deliverables • Source code / macro file. • A working XLSX sample populated with at least one hour of minute-wise data. • Quick start instructions. Once I can launch the script and see Excel populate on its own every sixty seconds, we’re done.