Screen shot

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

What is new:
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.

Add your comment

Title of your comment:

Your comment (max. 1000 characters):

Your name/alias: Guidelines for writing a comment: Try to be as clear as possible. Write using plain text, although you can use the following html tags: <b> <i> <u> <ol> <ul> <li> <br> <p> <blockquote>. Do not use urls in the text. Do not use offensive language. If your comment is inappropriate it will not be used.

How would you rate this product? 5 - Excellent   4 - Very Good   3 - Good   2 - Fair   1 - Poor   0 - Rubbish