This is a free spreadsheet that downloads free historical stock data from the Yahoo database and calculates the historical (realized) volatility of the selected stock. The standard deviation of prices are plotted along side the stock price chart.

The user can freely change the stock used by entering the ticker symbol into the appropriate field and perform a fresh download.

Note: This download is an .xls file which requires Microsoft Excel or compatible programs.