Bank nifty option chain data daily analysis
In this blog, we will share an excel sheet with data points at the end of the day. The main reason for the buying option is that it is a tool for making unlimited money with very small capital and risk is limited to the premium you pay. Options trading can double or triple your money within a day. But the question we need to ask ourselves how many traders make money in long terms by buying options? The answer may surprise you read this blog to find the answer
Stock market educators or institute vs retail traders
Standard Rules of Option chain analysis:
Stock market educators or institute vs retail traders
Standard Rules of Option chain analysis:
- Download the Bank nifty option chain data daily and analyze the positions
- How to analyze Short and Long positions build-up using the options chain?
- There are 4 possible cases for this analysis
Case 1 - Long CE - Short Buildup PE - UP Move
Our Automated excel sheet for nifty options
Advance nifty option trading automated excel sheet with back Testing
- Call side option price increase and open interest increase
- Put side option price decrease and open interest increase
- If both conditions fulfill then the market will move up.
- The fresh position is created call side and put side
- Maximum addition in open interest in call side act as a resistance
- Maximum addition in open interest in put side act as a support
Case 2 - Short Buildup CE - Long Buildup PE - Down Move
Case 3 - Short cover CE - Short Buildup PE - UP move- Call side option price decrease and open interest increase
- Put side option price increase and open interest increase
- If these both conditions fulfill then the market will move Down
- Call side option price increase and open interest decrease.
- Put side option price decrease and open interest Increase
- If these both conditions fulfill then the market will move UP due to short covering on the call side.
- But why shorts covering also leads the market to move up or down?
- Shorts covering generally happens when there is positive or negative news in the market
- Previous day positions on the call side which were acted as a resistance to the market are now sifted to the put side to act as a support due to some good news for the market.
- Big players book their losses in the call side and create the position in put side to minimize the losses or to gain greater profits from out side options
- This process happens in both put and call side - call side short covering leads the market to move up
- ut side short covering leads the market to move down
- Call side option price decreases and open interest increases.
- Put side option price increases and open interest decreases
- If these both conditions fulfill then the market will move down due to short covering in put side
- Case 5
- Call side option price decrease and open interest decrease.
- Put side option price decrease and open interest decrease
- If these both conditions fulfill then the market will remain sideways.
Standard terms of option chain analysis
- The put-call ratio(PCR) is the well-tested benchmark. To find out the put-call ratio we need to divide total put open interest by total call open interest. If PCR is above 1 it signifies bull trend and below 1 signifies a bearish trend. I personally have my own standard. Below 0.8 it is bearish and above 1.2 it is bullish. Between 0.8-1.2 it is no trading range
- The strikes where you see maximum call open interest(OI) works as resistance and the strike with maximum put OI works as support.
- If total call addition is more than total put addition on a particular day then you should look for short in underlying stock. If total put addition is more than total calls you should look for buy-in underlying stock.
- Option premium increases with volatility increase. And premium falls if volatility decreases. Browsers gauge for volatility is India vix.
15 Comments
thanx for such a information.Kindly tell weather u have prepared the above mentioned bank nifty option chain or this is readly availabe on some site.
ReplyDeleteThis excel sheet is developed by us. We will update this sheet daily after market close
Deletesir as per monthly OC of nifty 9000 ce , on put side increase in oi with reduction in price and on call side premium increase but oi reduce..that means 9000 will act as resistance
ReplyDeleteResistance is reduced and support is moved up to 9000. It suggest market will move up to 9000
DeletePlease check the Excel sheet it is not updating for New Expiry 28-May-2020
ReplyDeletesir, how to get updated sheet daily for this bank nifty option sheet
ReplyDeleteWe update the sheet after 7 AM
DeleteNice Article. Thank you for sharing the informative article with us.
ReplyDeleteCommodity Market
Share Market Tips
Stock Market Training
Hi Sir,
ReplyDeleteyour Banknifty option chain analysis sheet is pretty awesome & excellent to read it. This is a very fantastic sheet which I searched long time.
Thank you for your great work.
Requesting Pls updated sheet, the sheet is not yet updated after June 26th 2020.
Do to some personal reasons we are not able to update the sheet. We will update the sheet now onwards. Please help us by sharing this blog in social media
DeleteYeah Sure Sir, Myself I have shared your blog link to 4 of my friend, lets make to spread to somewhere in Twitter or FB.
DeleteThank you for your reply and your immense support to small retail traders like me.
many tks for the learnings u share with us. request u to pl update this sheet regularly. Hope u all are fine. can we prepare this sheet ????
ReplyDeletecan you share the sheet with formulas
ReplyDeleteThis sheet is derived from a set of rules and conditions. It is all explained in this blog.
Deletehttps://stockfuturesnse.blogspot.com/2019/06/option-chain-premium-decay-analysis.html
Dear
ReplyDeleteThe option chain data is last updated on August 2020. can we have the current month sheet Please.
Thank you for your valuable comment