Option Trading Workbook 1

Option Trading Workbook 1
Publisher: Option Trading Tips Date added: 04 April, 2008
License: Freeware Size: 54.0 KB

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 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.

Tags: Option Pricing, Option Trading, Option Pricing Spreadsheet, Black And Scholes
Platforms: Macintosh , Windows2000 , Windows2003 , Win 3.1x , Win95 , Win98 , WinME , Mac OS X , WinNT 3.x , WinNT 4.x , 2000 , 2003 , 3.1 , 95/98 , NT , XP , WinXP
Requirements: Microsoft Excel

Related Downloads

Excel VBA Models Open Source Code Excel VBA Models with Open Source Code - Option Greeks, Lotto Number, Probability, Normal Distribution, Monte Carlo simulation, Black-Scholes, Binomial Option Pricing, Portfolio Optimization, Multiple Regression, Bootstrap, Multivariate distribution

Excel VBA Open Source Code - 37 programs The Excel VBA Models Open Source Code Combo Set contains 37 programs in finance, statistics, option pricing models, and numerical methods in open source code. Programs include Distribution 12 Random Number Generator, 6 Option Pricing Models&more..