Live 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 Excel sheet is coded in VBA and can fetch the following live 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

☺ Change in Last Traded Price (%)


It fetches few selective Strike Price at Out of Money (OTM) near to ATM (At the Money) and not fetches deep far Out of Money Strike Prices

So, this Excel sheet gives a simplified view on OI and Price changes near to ATM.


How to use?

Select the Stock Symbol.

Then Select the Expiry Date and Click Fetch.

 

 

 

 

 

Important Disclaimer

1. This Excel is designed for Educational purposes only, to understand the Change in OI and Price for Stock Call or Put Options and not for Professional Trading.

2. Do not trade, based on these data.

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

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

5. This webpage data (www.enote.page) is not responsible for any money loses incurring with the options trading.

6. Enable the Macro to run the VBA code.



Download the Excel

 

---

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

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

---

Link to tutorial & source code (Excel sheet)

Link