Option Trading Workbook

Option Trading Workbook is an option pricing spreadsheet that allows you to price European call and put options. It calculates theoretical price and option Greek derivatives of call and put options by using Black and Scholes. The Black and Scholes is the foundation model for pricing options today. Five key components including Exercise Price, Time to Expiry, Underlying Price, Interest Rates and Volatility are needed to correctly calculate a theoretical price for an option contract.

The program incorporates strategy simulation worksheet to allow a user to enter up to 10 different option/stock leg combinations. This combination is then graphed to display expected profit and loss on the expiration date. The option strategy graphs included in the spreadsheet are only two-dimensional. Graph also shows expected payoffs and combined option Greeks for the strategy at expiration. The Black and Scholes code used in the spreadsheet is now fully disclosed and you can edit using the Visual Basic Editor.

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 show the expected profit and loss at the expiration date as well as the combined option greeks for the strategy. The Black and Scholes code that is used for this spreadsheet is fully disclosed and available for editing using the Visual Basic editor.