Posts

Showing posts with the label Live Stock Option Chain Data in Excel

Live Stock Option Chain Data in Excel Sheet

Image
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.