Glen99,
Agree with u, both demon7,gaweb are right too.
Historical volatility is annualised return for any given days, I have built a excel sheet use formula as follow:
STDEV($B70:$B83)/AVERAGE($B70:$B83)*252/COUNT($B70:$B83);
B70 to B83 is data of 14 days, 252/14 is to annalize it.
Does anyone know how to feed the data directly to sheet?
