Stock Option Chain Data in Excel Sheet

Simplified Excel sheet for Stock Option traders to fetch and analyze NSE Stock Option Chain Data for both Calls and Puts.

This Excel sheet fetches the live NSE Stock Option Chain data such as OI and Price at different strike prices specifically few Strike Price ranges near to ATM in Excel sheet.








This is coded in VBA and can fetch the following data at a given Strike Price, for both Calls (CE) and Puts (PE) and at different Expiry Dates.

> Open Interest (OI)

> Change in Open Interest (in %),

> Last Traded Price for NSE Stock option (in INR)

> Change in Last Traded Price (%)


It narrows down and fetches few selective Strike Price ranges only at Out of Money (OTM) near to ATM (At the Money) and not fetches from deep far Out of Money Strike Price data. So, it gives a simplified view on OI and Price changes.  

How to use?

1. Select the Stock Symbol.

2. Then Select the Expiry Date and Click Fetch.






Important Disclaimer

1. Please note that, this Excel Stock Option Chain data is designed for Educational purposes only in order to understand the Change in OI and Price for Stock Call or Put Options and not for Professional Trading. Do not trade, based on these data.

2. Fetching and processing the data may take considerable time.

3. Data will be fetched as expected in Live Market Hours.

4. This webpage data ( is not responsible for any money loses incurring with the options trading.

5. Enable the Macro in Excel to fetch the data,

6. If data is not fetched, check your internet connection or try after some time. Data will be fetched slowly due to the lag in response from NSE server.


Download the Excel Macro


This is the basic version and for advanced choices, please email to mail{at}

For bugs and codes, please contact here.

Also check these pages for fetching NIFTY and Bank Nifty Option Chain Data in Excel.

NIFTY Option Chain in Excel

Bank Nifty Option Chain in Excel