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 series.
Download this application from here.
The data it uses is from NSE India’s website, so it will be very much reliable. This application will show a graph based on nifty options open interest data downloaded from NSE, below is a screen shot of graph.
Steps to Refresh Data:
- Start Nifty Options OI (excel based application).
- Press ALT + CTRL + F5 to refresh data from NSE server.
- MS Excel will give a Security notice, Just click OK.
- Data will be updated and new graph will be shown.
Share this small piece of application to your colleges and friends. If you want timely SMS updates from us then join our Free SMS List. Or Like my page on Facebook and Follow me on Twitter. 🙂
About
could you can give similar code or excel file like intradayafl dot com site etc along with it which should give targets in the calls.
Hi Pramod, I have gone through the link you shared above. I am having a very similar system which can generate buy or sell signals, but it wont show stop loss or target level. Let me check if I can add target and stop loss in it. I will update here via comment when I am successful. 🙂
Hi Bhaveek,
Thanks for this update.
Can we get such data for BankNifty Options..?
Anand, I have been working on bank nifty and few other front line stocks for options open interest data. Once testing is done I will make it available here and let u know. I am expecting this week I will complete Banknifty options OI data on excel sheet.
Till then be in touch, we can help this trading community by sharing each others doubts and queries. 🙂
sure,
thanks for prompt update
I am having odin which I run on internet can you tell me how can I use this excel file cause its showing corrupt character in my excel sheet and how it will download data.
Hi it seems the nse site got updated so the app is not working. can u fix it? it will be very kind of u
thanks
Hi Bhaveek,
the nse page to which the excel file connects to update the data, does not exist any more.
you need to fix the connection. would you kindly do this please…
thanks.
I had used MarketXLS for this. It works for me great.
NSE website sucks. Too much of time gets lost everyday just to load the webpage for future open interest quotes. Please develop some app to get the direct feed of all derivative stocks future OI and change in OI.