This is a free spreadsheet that downloads free historical stock data from the Yahoo database into the spreadsheet and calculates the historical or 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. Users are also able to change the date range used for the stock data, the number of days back to use for the volatility calculation and the number of volatility days to use.

Download (70 KB) Website Link to this page