volatility

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi all,
from historical prices of a stock for the last 3 months up to date, how to
calculate the implied volatility (IV) and the historical volatility (HV) of
this stock by using excel formulas, please (not micro), even if these
formulas are not exact 100%
with many thanks for any help
 
excelFan said:
hi all,
from historical prices of a stock for the last 3 months up to date, how to
calculate the implied volatility (IV) and the historical volatility (HV) of
this stock by using excel formulas, please (not micro), even if these
formulas are not exact 100%
with many thanks for any help
Click to expand...

I don't think you can do this without a macro. Everything that I have found
comes as an add-in. Can you show a site that tells how to calculate IV and
HV?

/Fredrik
 
Back
Top