Excel Nifty-50 Live Feed

I need an Excel workbook that pulls the Nifty 50 option-chain directly from the NSE India website and shows the live strike-price field, refreshing automatically every minute. The sheet should start updating as soon as it is opened and continue without manual clicks, so a VBA routine, Power Query script, or any other reliable method you favour is fine with me as long as it respects the site’s response rules and keeps Excel responsive. Core requirement • Live strike price for every listed contract, populated and refreshed at 60-second intervals. Nice-to-have (not essential today, but useful if easily added) could be bid or ask prices, yet the strike price stream is the only compulsory field for this first build. Deliverables • An unlocked Excel file with the working code/queries. • A brief note inside the workbook (or a separate text file) explaining where the script lives and how to adjust the refresh cycle if I ever need a slower cadence. Acceptance I will test by opening the sheet during market hours and watching the strike price column roll over on the next minute mark without errors or manual prompts. ┌───────────────────────────────────────────────────────────────────────────────────────────────┐ │ NIFTY 50 PROFESSIONAL TRADING TERMINAL │ ├───────────────────────────────────────────────────────────────────────────────────────────────┤ │ Spot Future VIX Expiry ATM PCR Max Pain Refresh Time │ ├───────────────────────────────────────────────────────────────────────────────────────────────┤ │ Market Trend │ CE Build-up │ PE Build-up │ Buy Signal │ Sell Signal │ Risk Level │ ├───────────────────────────────┬───────────────────────────────────────────────────────────────┤ │ LIVE OPTION CHAIN │ OI HEATMAP │ │ Strike CE OI ChgOI IV │ ██████████████████████ │ │ PE OI ChgOI IV │ ██████████████████████ │ ├───────────────────────────────┼───────────────────────────────────────────────────────────────┤ │ SUPPORT LEVELS │ RESISTANCE LEVELS │ │ S1 │ R1 │ │ S2 │ R2 │ │ S3 │ R3 │ ├───────────────────────────────┼───────────────────────────────────────────────────────────────┤ │ PCR Trend Chart │ OI Chart │ ├───────────────────────────────┼───────────────────────────────────────────────────────────────┤ │ Greeks │ Strategy │ │ Delta │ Iron Condor │ │ Gamma │ Iron Fly │ │ Theta │ Short Straddle │ │ Vega │ Short Strangle │ ├───────────────────────────────┴───────────────────────────────────────────────────────────────┤ │ Status Bar: Connected | Auto Refresh ON | Last Update | Data Source │ └───────────────────────────────────────────────────────────────────────────────────────────────┘

Project ID: 40613181