Dear David,
I am confused after studying your spreadsheet (http://www.bionicturtle.com/premium/spreadsheet/4.b.8_implied_volatility/). I would appreciate it if you could kindly elaborate on how to determine whether a volatility or implied volatility is trading cheap or expensive?
What confused me specially is that I think given a market price, there could be only one implied volatility and this is obtained from the reverse engineering of BS pricing model. Whereas when we do pricing with BS pricing model, the volatility is one key variable that can take many possible input. I'm not sure how this single one implied volatility can be compared to the almost infinite collection of possible volatility inputs in order for us to figure out if it is higher or lower (trading cheaper or expensive respectively). What I mean is that the 'error' could well be eliminated by adjusting the volatility input to the implied volatility, I think this actually indicates that I don't understand the logic of comparing these two volatility and therefore concluding that implied volatility is trading cheap in your spreadsheet.
Thank you very much for your enlightenment!
Cheers!
Liming
27/09/2009
I am confused after studying your spreadsheet (http://www.bionicturtle.com/premium/spreadsheet/4.b.8_implied_volatility/). I would appreciate it if you could kindly elaborate on how to determine whether a volatility or implied volatility is trading cheap or expensive?
What confused me specially is that I think given a market price, there could be only one implied volatility and this is obtained from the reverse engineering of BS pricing model. Whereas when we do pricing with BS pricing model, the volatility is one key variable that can take many possible input. I'm not sure how this single one implied volatility can be compared to the almost infinite collection of possible volatility inputs in order for us to figure out if it is higher or lower (trading cheaper or expensive respectively). What I mean is that the 'error' could well be eliminated by adjusting the volatility input to the implied volatility, I think this actually indicates that I don't understand the logic of comparing these two volatility and therefore concluding that implied volatility is trading cheap in your spreadsheet.
Thank you very much for your enlightenment!
Cheers!
Liming
27/09/2009