Useful Excel sheet for Stock Option Traders.
This Excel sheet can fetch the Live NSE Option Chain Data for Stocks.
Fetch the live Stock Option Chain data such as Open Interest and Price at differentStrike prices, specifically few Strike Price ranges near to ATM in Excel sheet.
It can be used to compare and analyze Open Interest and Price Changes at different Strike Prices.
This Excel sheet collects 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.
Homepage : https://www.enote.page/2022/08/stock-option-chain.html