Excel - NSE Stock Option Chain Files

For complete details, please visit to the Project Homepage:

https://www.enote.page/2022/08/stock-option-chain.html


This Excel sheet fetches the live 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.  


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 (www.enote.page) 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.