Highlighted options are in-the-money. 1. Loading Option Chains from Yahoo Finance into Microsoft Excel using MARKET.RTD. If you have NOW of Odin Diet, you can get live prices in excel. 1. Means Green colour for 3 highest OI for put and call and Blue colour for 3 highest change in OI for both side. NSE Option Chain Automated Data Extractor in Excel, Tag: NSE Option Chain Automated Data Extractor in Excel. You will first have to login to yahoo otherwise the data might be delayed I had done this long ago so know this is one approach. Procedure to record the nifty option chain data from nse.com. To Get all option chain of a stock symbol that are in the Money I have read and agree to the privacy policy. Using the free Excel Add-in, data in your workbook will automatically update every time you open Excel. After almost 1.5 years, I am again sharing the live open interest excel sheet. After this, just check the expiry of this data in next column and click go button. Note. It will show Security Warning (Don’t worry), Just press OK. Data will be updated from NSE servers instantly. You can set it to update every minute. And that’s it, you will get the data for option chain and future contracts in next tab. So, we select cells A2-A4 in our Excel spreadsheet, then go the Data tab in the ribbon and click the Geography icon: 3) Add a new column to get real-time online data Select the option chain data as shown in picture. The excel sheet is downloadable from the end of this article. Reference rate of Cross currency pairs is computed by using Reference rate - FBIL for USD-INR and the corresponding exchange rate published by RBI for EUR-INR,GBP-INR, and JPY-INR, as applicable. Excel formula for using option codes: =RTD("gartle.rtd",,"YahooFinanceOptions","