Option Trading Workbook 2.1

Free Option Trading Workbook screenshot file
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.
Type : Freeware
OS Support : Windows All
Date stamp / Size : Dec, 6. 2006 / 54 kBytes
Asked : Microsoft Excel
Users' value : - Write a Review
Download Option Trading Workbook fileNo active image buttonImage of Option Trading Workbook
Update history of Option Trading Workbook
v2.1 (October, 2. 2007)
11/06/07. Fixed a bug that failed to calculate the greeks correctly for stock positions on the OptionStrategies tab.

1/10/06. Added support for Dividend Yield.
v2 (May, 22. 2007)
1/10/06. Added support for Dividend Yield.

28/08/06. Fixed a small calculation bug for the Option Theta, which now has a near perfect accuracy.

27/04/06. Fixed a bug that failed to calculate the theoretical change in P&L for stocks in the strategies tab.
Distribution permissions for Option Trading Workbook
This product can be freely distributed through the Internet. To put it onto a CD, contact admin@optiontradingtips.com
Featured Option Trading Workbook 2.1 Vista Files

...- Numerical Methods and Option Pricing Set...solve mathematical equations and implied volatility from...option pricing models. It also...includes vanilla option pricing models on future,...exchange), stock index, and stock that pays...It contains practical and well explained examples...Scholes Call - Newton...

...This free option pricing calculator can be...Implied Volatility. This option pricing calculator has...three option pricing models to caculate...prices: Black-Scholes Option price, Binomial American...option price and Binomial European option...

...(Set 1, 2, and 3) The Excel...in finance, statistics, option pricing models, and...source code. Finance and Statistics Models Set...1. Standard Deviation and Mean 2. Lotto...Integration 6. Black-Scholes Option Pricing Model -...European Call and Put 7. Binomial...Option Pricing Model 8. Portfolio...

...Tool - Finance and Statistics Models Set...to do finance and statistics within Excel?...examples? The Financial and Statistics Model set...It contains practical and well explained examples...1. Standard Deviation and Mean 2. Lotto...Integration 6. Black-Scholes Option Pricing Model -...European Call and Put 7. Binomial...

...The Real Option Valuation model encompasses...a suite of option pricing tools to...of financial analysis and investment scenarios. Traditional...in your proposal and the tools to...model include: Ease and flexibility of input,...the situation, Modified Black Scholes models to...a competitive environment and Ability to predefine...