Calculate Historical Volatility in Excel

This spreadsheet calculates the historical volatility of a stock. It uses returns data automatically downloaded from Yahoo. Historical volatility is the standard deviation of an asset’s historical returns. The standard deviation is calculated over a moving time window.