Here is the link to download excel sheet to keep a track on the nifty options open interest and do analysis on it. This is how you can do the analysis using open interest data of nifty options. Download from here. Sheet will auto refresh itself every 5 minutes. You will have to disable security warning, else it will not refresh the data. Next week's analysis: I am seeing some correction ... [Continue Reading]
Nifty options excel IO sheet for October series, Free Download
Nifty options excel sheet for live options open interest for the month of October is here. Using this sheet you can easily find the potential area of support and resistance in the market, for more information read the article here. This article was updated on 1 January 2024. Link to download the file. How to update the data: Let me know if you are having any issues while using this ... [Continue Reading]
Free Excel Sheet: Nifty options OI for August F&O series
Friends I know I am very late in publishing the Nifty options OI excel sheet August F&O series. I was on 20 days holiday to Gujarat and Rajasthan, so I was unable to carry out research. Also I found that NSE has recently updated their old servers, from where we used to extract the data. After going through lots of test I have found a working source. Anyways, you can download the files from ... [Continue Reading]
Live Nifty options open interest data on excel sheet for July F&O series
Nifty options live open interest data excel sheet has been updated for July F&O series. Also traders use it to know the trend of Nifty future. Use the link below to download the file. Download File here. How to use this file: Open the file in MS Excel, and press Alt + Ctrl + F5. Click on OK. Data will be updated on file. Traders use Nifty options open interest data to find the range ... [Continue Reading]
Track Nifty Options Open Interest Level in Real Time, Excel based Application
After sharing free real time data of NSE and NSE F&O data last week, today I am sharing an application which I have been talking about in my previous articles on Nifty options open interest. After series of testing today I am sharing my small excel based application which will get you nifty call options and nifty put options which are active. These options contracts will be of current month ... [Continue Reading]