It also contains links of options open interest analysis sheet for nifty bank nifty and 60 f o stocks.
Bank nifty option chain analysis excel.
Fill the closing price in excel sheet in current stock price column e g.
Fill implied volatility data in excel sheet.
They mainly trade in these instruments.
It has been redirected to the current article as the updated version of excel sheet can now fetch open interest data for nifty banknifty and any other index or stock of your choice.
Banknifty 30709 40 as on dec 09 2020 15 30 26 ist.
Chart oi chng in oi volume iv ltp net chng bid qty bid price ask price ask qty strike price bid qty bid price ask price ask qty net chng ltp iv volume chng.
Check the closing price of the bank nifty.
5 thoughts on excel sheet for nifty options traders microsoft excel data into microsoft says.
There was another article titled banknifty options open interest analysis excel sheet in this website.
View options contracts for.
Option chain equity derivatives underlying index.
This excel based open interest tracker is a live trend finding tool that gets you only nifty options open interest on the realtime live basis.
It will show security warning don t worry just press ok.
It syncs with nse every 10 minutes currently shows data for 28th feb 2019 expiry.
The document also contains lot size of all f o stocks along with sectors they belong.
Knowledge of lot size and sectors will help you identify the stocks you want to trade.
Expiry date futures contracts.
Now press alt ctrl f5 to update the data.
Bank nifty closing price is 31000.
May 17 2013 at 8 13 am thanks for sharing your thoughts.
I really appreciate your efforts and i am waiting for your next post thank you once again.
Options open interest analysis sheet for nifty and other f o stocks.
Check the implied volatility of bank nifty options 31000 call side and put side.
Data will be updated from nse servers instantly.
Repeate above steps every time you wish to update data.
But before trading in options i would advice you to read the article i prescribed above.
For most traders nifty and bank nifty excel sheets fulfill the requirement.
Download bank nifty option chain excel sheet from this link.
After that u need to change the link to next weekly or monthly expiry.
Open excel sheet from bank nifty options live oi zip.