How to Calculate Volatility in Excel

Description
There are multiple ways to compute a stocks volatility. The most popular volatility measures are "implied" and "historical" (which is also named realised or statistical).

It is straightforward to compute historical volatility in excel and this will be explained here.

Note: Computing implied is slightly more tricky. You can technically do this in excel, but you have to impute it from an option price. Moreover, there is a volatility surface or various values of implodes for different strike prices and maturities.

-> Adam H Grimes, 2011
www.adamhgrimes.com