hey all,
anyone here ever tried (or is already using) a local volatility model?
I am trying to implement it with dupire's formula, following the method in this webisite:
https://financetrainingcourse.com/e...cal-volatility-surfaces-in-excel-final-steps/
however after I run the calculation I get "impossible" vols, for one strike for instance I get a value of 22%, one strike after that it jumps to 259%, then goes back to 23%. Any advice? Is there something inherently wrong in the method the website is proposing? Are there known limitations in this model? Does it work only for specific options classes?
And the second question would be.. let's admit that the model works, one thing that I can't wrap my head around is this: local vol is supposed to be the vol that you get when spot goes to a certain strike..correct? but how does the model account for the timing of the move? I expect that the vol would be different if the strike was reached tomorrow vs one month from now. Can someone explain to me the concept in layman terms?
anyone here ever tried (or is already using) a local volatility model?
I am trying to implement it with dupire's formula, following the method in this webisite:
https://financetrainingcourse.com/e...cal-volatility-surfaces-in-excel-final-steps/
however after I run the calculation I get "impossible" vols, for one strike for instance I get a value of 22%, one strike after that it jumps to 259%, then goes back to 23%. Any advice? Is there something inherently wrong in the method the website is proposing? Are there known limitations in this model? Does it work only for specific options classes?
And the second question would be.. let's admit that the model works, one thing that I can't wrap my head around is this: local vol is supposed to be the vol that you get when spot goes to a certain strike..correct? but how does the model account for the timing of the move? I expect that the vol would be different if the strike was reached tomorrow vs one month from now. Can someone explain to me the concept in layman terms?