Live Option Chain Sheet Sensex and Nifty

PHP, JavaScript, Software Architecture, Google Chrome, Financial Analysis, Scripting, Data Analysis, Google Sheets, API Integration, Data Management · I’m building a Google Sheet that must refresh automatically with live option chain data for both Nifty and Sensex. Inside the sheet I need four specific fields captured for every strike and expiry:

• Open Interest (OI) • Bid-Ask Price • Implied Volatility (IV) • The current spot price of the underlying index

I’d like the script—whether written in Apps Script, connected through an authorised API, or another reliable method you propose—to populate separate tabs for each index and update on a frequent-refresh schedule we can fine-tune together (ideally every minute or two during market hours). Data integrity and minimal latency are critical; stale or partial updates won’t be acceptable.

Deliverables 1. A working Google Sheet with the live feeds wired in. 2. Well-commented code placed in the sheet’s Script Editor (or linked as an add-on) so I can maintain it later. 3. A short read-me inside the sheet explaining how to adjust refresh intervals and add new expiries.

I’ll consider the job complete once I can open the sheet, watch the figures update automatically, and cross-check any row against the official exchange data without discrepancies.