Stock Volatility Calculator 1

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.

Major Features:

1. This download is an .xls file which requires Micro Excel or compatible programs.
2. This calculator models option implied volatility based on the market price of an option and reflects the market's view of future stock price volatility.
3. It enters up to 5 option/stock positions, current price, volatility target and target percentage profit.

WareSeeker Editor