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 and graphs the result.
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.
Historical Volatility is a statistical calculation that tells option traders how rapid price movements have been over a given time frame. The most common method of calculating historical volatility is called the Standard Deviation.
Standard Deviation measures the dispersion of a set of data points from its average. The more disperse (spread out) the data is, the higher the deviation. This deviation is referred by traders as volatility.
Don't get too caught up in trying to understand the how's and whys of the standard deviation, just accept that all traders use this method for determining historical volatility.
Platform: Windows 3.x, Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP, Windows 2003, Mac OSX, Windows Vista
System Requirements: Microsoft Excel
Stock Volatility Calculator Related Freeware Terms
Option Pricing Calculator - This free option pricing calculator can be used to calculate: Call Price, Put Price, Gamma, Delta, Theta, Vega, Implied VolatilityThis free option pricing calculator can be used to calculate: Call Price, Put Price, Gamma, Delta, Theta, Vega,...
Option Trading Workbook - Option pricing spreadsheet that calculates the theoretical price and all of the Option Greeks for European Call and Put options. The spreadsheet also allows the user to enter up to 10 option legs for option strategy combination pricing.Free option...
WebCab Options and Futures for .NET - Add our Equity derivatives pricing framework to COM, .NET and Web service Apps3-in-1: .NET, COM and XML Web service Components for pricing option and futures contracts using Monte Carlo and Finite Difference techniques. General Monte Carlo pricing...
WebCab Options and Futures for Delphi - Add our Equity derivatives pricing framework to COM, .NET and Web service Apps.3-in-1: .NET, COM and XML Web service Components for pricing option and futures contracts using Monte Carlo and Finite Difference techniques. General Monte Carlo...
WebCab Bonds for Delphi - Interest Derivative Pricing for .NET/Win32/Web Service Applications.3-in-1: COM, .NET and XML Web service Interest derivatives pricing framework: set contract, set vol/price/interest models and run MC. We also cover: Treasury bonds, Price/Yield,...
WebCab Bonds for .NET - Price Interest derivatives in .NET, COM and XML Web service Applications3-in-1: COM, .NET and XML Web service Interest derivatives pricing framework: set contract, set vol/price/interest models and run MC. We also cover: Treasury bonds,...
WebCab Options (J2EE Edition) - EJB Suite for pricing equity option and futures contracts using Monte Carlo and Finite Difference techniques.EJB Suite for pricing equity option and futures contracts using Monte Carlo and Finite Difference techniques. General MC pricing...
Stock Volatility Calculator Match at Super Shareware
Visual Stock Options - Visual Stock Options Analyzer. Build options strategies, hedging.Visual Stock Options Analyzer (VOptions) is a powerful analysis tool for development, testing, and application of stock and options strategies. Its easy-to-use interface allows you...
Stock Profit Calculator - Stock Profit Calculator is the first equity calculator that lets your store buy and sell calculations for quick reference. The main calculator portion is freeware. There are many great extra features that can be unlocked for a nominal fee.Stock...
Option Pricing Calculator - This free option pricing calculator can be used to calculate: Call Price, Put Price, Gamma, Delta, Theta, Vega, Implied VolatilityThis free option pricing calculator can be used to calculate: Call Price, Put Price, Gamma, Delta, Theta, Vega,...
Ashkon Stock Watch - Ashkon Stock Watch is an advanced charting software for financial market information. It allows to display several technical indicators for a single security on the same chart, open multiple chart documents and test investment strategies.Ashkon...
Trade Journal Software - Plan your trade and trade your plan, with Trade Journal Software. Achieve the discipline needed to be a successful trader. Calculate and graph risks, profit & loss ratio, & breakeven points. Keep a watch list and your notes for stocks and...
WebCab Options and Futures for .NET - Add our Equity derivatives pricing framework to COM, .NET and Web service Apps3-in-1: .NET, COM and XML Web service Components for pricing option and futures contracts using Monte Carlo and Finite Difference techniques. General Monte Carlo pricing...
WebCab Options and Futures for Delphi - Add our Equity derivatives pricing framework to COM, .NET and Web service Apps.3-in-1: .NET, COM and XML Web service Components for pricing option and futures contracts using Monte Carlo and Finite Difference techniques. General Monte Carlo...
Business & Productivity Tools / Investment Tools Popular Software
Personal Stock Streamer - With Personal Stock Streamer, the active investor can track stocks in real-time; get live technical intraday and historical charts; execute trades; calculate gains; collaborate with groups; all free w/ supported brokerage accounts.Personal Stock...
Stock Volatility Calculator - 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 and graphs the result.This is a free spreadsheet that...
Stock Predictor - Chart stocks and backtest your stock market trading strategies using historical quotes data. This software features include over a dozen built-in technical indicators, more than 600 investment strategies, free stock market data feed and more.Stock...
Stock NeuroMaster - Stock NeuroMaster is a stock prediction tool based on Neural Networks with advanced technical analysis module. Supported data sources: CSV, Metastock database and free online stock quotes. Maximize your profit by predicting the best BUY/SELL...
Personal Stock Monitor GOLD - Personal Stock Monitor Gold enables the active investor to quickly research, track, chart, and trade stock market securities within the privacy of a personal desktop Windows application. It features technical analysis, alerts, gain/loss, and...
Option Trading Workbook - Option pricing spreadsheet that calculates the theoretical price and all of the Option Greeks for European Call and Put options. The spreadsheet also allows the user to enter up to 10 option legs for option strategy combination pricing.Free option...