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.

Keywords: historical volatility, calculate volatility, option pricing, option trading,

Recent Changes: Version 1 - No Changes

Install Support: No Install Support

Supported Languages: English

Additional Requirements: Microsoft Excel

PAD file URL: http://www.optiontradingtips.com/resources/historical-volatility.xml