Live Option Chain Sheet Sensex and Nifty

@anas389

Good day! Based on your requirements, I understand that you're looking to build a Google Sheet that automatically pulls and refreshes live Nifty and Sensex option chain data, including OI, Bid-Ask Price, IV, and the current spot price for each strike and expiry. I can build this using Google Apps Script with a reliable authorised API/data source, keeping separate tabs for Nifty and Sensex. The script can refresh automatically during market hours, handle multiple expiries, validate the received data, and avoid overwriting the sheet with stale or partial updates. I’ll also add clear comments and a simple README explaining how to adjust the refresh interval and add new expiries. Q1: Do you already have an authorised API/data provider for the Nifty and Sensex option chain, or should I recommend a suitable source? Q2: Should the sheet refresh every 1–2 minutes only during Indian market hours, with automatic stopping outside those hours? I would love to have a quick conversation about the data source and refresh requirements so I can set this up reliably and make sure the values can be cross-checked against official exchange data. The budget and payment terms can be discussed and mutually finalized after reviewing the complete requirements and scope of work. Thank You!

@divaakar2810

Hi, I can build the Google Sheets-based live option chain system for Nifty and Sensex as described. I’ll set up separate tabs for Nifty and Sensex with the required strike/expiry data, including Open Interest, Bid-Ask Price, Implied Volatility, and the current spot price. I’ll implement the data integration and automated refresh using Google Apps Script and a suitable authorised data source/API. I’ll also provide: * Clean, well-commented Apps Script code * Automatic refresh during market hours * Configurable refresh intervals * Support for adding new expiries * A short README explaining how to maintain and adjust the system * Final testing against the available official exchange data to ensure the populated values are accurate and consistent I’ll focus on reliable updates and handling partial/API failures properly rather than simply importing data into the sheet. I can complete this within 3–4 days. Thank you.

@ferpez

Stale or partial updates won't be acceptable is the real spec here, not the four fields. Option chain endpoints throttle and drop rows under a one-minute refresh, so the design has to survive that, not just fetch once. Phase 1, 3 days, at the bid price: - Apps Script pulling the full chain for both indices, one tab each, every strike and expiry, with Open Interest, bid and ask, Implied Volatility, and spot. - A time trigger you can retune, plus a retry-and-hold rule: if a pull comes back partial, the sheet keeps the last good row and stamps it, so you never read a half-updated table as if it were live. - A status cell per tab: last successful refresh, row count, and any skipped strike. - Commented code in the Script Editor and a read-me tab covering refresh intervals and adding expiries. What I need from you, so the clock does not depend on you: which data source you are authorised to use, and edit access to one sheet. Both in your first message and I work without interrupting you after that. Not included: paid market-data subscriptions, brokerage order placement, hosting outside Google. If the figures do not cross-check against the exchange on delivery day, I keep fixing it at no cost or you pay nothing. Which source should I wire to? And tell me straight if the price or the 3-day window is wrong for you.