bank nifty option chain excel sheet download

bank nifty option chain excel sheet download

Stock futures July 02, 2019

bank nifty option chain excel sheet download





bank nifty option trading is risky and we need a tool to identify the rate of success. after reading this blog you will find the possibility of bank nifty options expiry every week and earn profits every week trading in bank nifty option.

 Procedure to trade in bank nifty option using excel sheet

  1. Download bank nifty option chain excel sheet from this link
  2. Visit nse.com
  3. Check the closing price of the bank nifty
  4. Fill the closing price in excel sheet in current stock price column e.g. bank nifty closing price is 31000
  5. Check the implied volatility of bank nifty options 31000 call side and put side
  6. Fill implied volatility data in excel sheet 
  7. Calculate days left for expiry for bank nifty
  8. Check the highest open interest build up call side and put 
  9. Fill the strike price that has highest open interest call side and put side.
  10. Check the probability of hitting the strike price 
  11. Higher probability shows the probability of hitting that strike price for bank nifty

Tags

Post a Comment

8 Comments

  1. Willing To DoNovember 4, 2019 at 1:00 PM

    Sir i have a doubt if closing price is 29730 or 29780, which strike price we should take please reply

    ReplyDelete
    Replies
    1. Stock futuresNovember 10, 2019 at 8:31 PM

      For 29730 take 29700 and for 29780 take 29800 strike price

      Delete
  2. Willing To DoNovember 11, 2019 at 12:08 PM

    sir one more doubt
    1.closing price means previous day closing right?
    2.Implied volatility data we should take previous day closing strike price or next day opening we have to fill it?. Please clarify
    3. Sat and sun also we have to taken into consideration for expiry or not?
    for example in days to expiry on friday we have to fill it with 7 or 5?

    Please clarify sir!!

    ReplyDelete
  3. Stock futuresNovember 11, 2019 at 12:28 PM

    After reading your doubt I will recommond you to don't take any trade in options to earn money. You can earn money in equity stocks.
    1. Dont take any option trade on friday. Decay is of 20 points for 2 days you will lose 20 points in options and even move if implied volatility is high. ie. IV is 20.
    2. buy options only if IV is near 10-11.
    2. Dont buy option on monday first hour - enter the data of monday after 1 hour

    ReplyDelete
    Replies
    1. Willing To DoNovember 11, 2019 at 7:14 PM

      Thank you sir for your words!! So we have to take 1 hr closing price and their IV data am i right??

      Delete
  4. AdyOctober 2, 2020 at 5:45 PM

    Nice work this blog gives clear knowledge about investment. stockinvestor.in is a stock related website which provides all stock market information.
    Sensex
    buy and sell
    shares
    stock exchanges

    ReplyDelete
  5. Universal NewsJanuary 18, 2021 at 2:44 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  6. 500PercroreJanuary 5, 2022 at 5:55 PM

    Excellent post for sharing important and excellent information. Top 10 Stock Brokers

    ReplyDelete

Thank you for your valuable comment