Yes bank stock prediction using implied volatility excel sheet

Yes bank stock prediction using implied volatility excel sheet

Yes bank stock prediction using implied volatility excel sheet

Trading and investing in yes bank is very risky and volatile therefore we need some tool to identify the direction of the stock price. After reading this blog we can predict the yes bank share price.

Yes bank share price

Procedure to predict yes bank share price 






  • Download yes bank option chain excel sheet from this link
  • Visit nse.com
  • Check the closing price of yes bank
  • Fill the closing price in excel sheet in current stock price column e.g. yes bank closing price is 95
  • Check the implied volatility of  yes bank options 95 call side and put side
  • Fill implied volatility data in excel sheet 
  • Calculate days left for expiry for yes bank
  • Check the highest open interest build up call side and put 
  • Fill the strike price that has the highest open interest call side and put aside.
  • Check the probability of hitting the strike price 
  • Higher probability shows the probability of hitting that strike price for yes bank


  • Post a Comment

    1 Comments

    1. is it( excel sheets) reallly in working conditions.?
      if yes then I wants to learn how to creat these kind of Excel sheets.

      thnks.

      ReplyDelete

    Thank you for your valuable comment