Option Trading Workbook

Option Trading Workbook icon

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. The calculations are made in Visual Basic and all of the code used is fully disclosed in the Visual Basic editor for user intervention.

Publisher description

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.

Related Programs

Option Pricing Calculator screenshot

Option Pricing Calculator 1.0.0

Free option pricing calculator.

2.06 MB
2006-06-16 00:00:01
Prime Option screenshot

Prime Option 2.2.1

Prime Option is a better decision enabler.

335.88 KB
2005-08-17 00:00:01
Real Option Valuation screenshot

Real Option Valuation 3.2

Valuation of Real Options for business.

158.89 KB
2016-09-05 20:28:28
Option Profit Calculator screenshot

Option Profit Calculator 2.1.0

calculates annualized stock and option profit

490.08 KB
2012-09-30 15:40:21
Aplus Enable PDF Print and Copy Option screenshot

Aplus Enable PDF Print and Copy Option

Software enables PDF print, copy, edit option

1.04 MB
2015-04-17 21:23:59