Get Live NSE Stock Option Chain Data for different stocks 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 the Excel sheet.

This Excel sheet is coded in VBA and can fetch the following live data for the selected stock 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 (%)

Designed by,
Dr. M Kanagasabapathy
Associate Professor of Chemistry
Coordinator, Incubation Centre
Rajapalayam Rajus’ College
Madurai Kamaraj University
Rajapalayam 626117 (TN)
Email: rrcmks@gmail.com

Download Link:
[ Ссылка ]

свернуть