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 ...
Free option pricing spreadsheet. Uses Black and Scholes to calculate the theoretical price and option greek derivatives of call and put options. Includes a strategy simulation worksheet, which enables a user to enter up to 10 option legs that will be used as a single option combination. This combination will then be graphed to ...