QArchive.ORG Main Page
Home | Blog | Terms of service | Sign in
All Vista Win Linux Mac
Related Products

Option Trading Workbook 2.1
Download Now
File Size: 54 Kb

Option Trading Workbook 2.1

Publisher:Option Trading Tips
Platform:Windows, MAC
Requirements:Microsoft Excel
Install:No Install Support
Recommend Option Trading Workbook Suggest to Friend

Publisher's Description:

Option Trading Workbook - 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.

List of Changes:

Version 2.1 from 2005-07-25


Option pricing spreadsheet

Download Now
File Size: 54 Kb

Share |

Text link code :
Hyper link code:
UBB/BLOG code:

Latest User Reviews:

Soumyajit Iit 2011-01-31 00:30:57 #
Version: 2.1

Extremely helpful and accurate.

Fkoroth 2010-11-23 09:53:04 #
Version: 2.1

the software is really helpful, which help me to find exist strategy.

Propell Icandothat 2010-10-20 17:27:34 #
Version: 2.1

Excellent little program - Thank you!

Marku1 2010-06-30 19:09:16 #
Version: 2.1

I just downloaded this nifty little program.Some Options programs go for hundreds of dollars,yet they have similar features.What I like about this one is that It calculates the theoretical price.Great feature that many programs don't Have.Thanks

Robothesailor 2010-06-09 14:31:47 #
Version: 2.1

I found this spreadsheet to be extremely useful, and saved me many hours of trying to code it all myself. I liked being able to access all the code, and make my own modifications and experiments. Thanks!!

J Bussiere 2010-02-10 08:46:42 #
Version: 2.1

Cant download the application.

Vikram Murthy 2010-02-04 13:31:40 #
Version: 2.1

Awesome software. It should suffice for any sophisticated individual trader

Business2 2009-08-02 13:27:42 #
Version: 2.1


Dear OTW,
I finally got to try the spreadsheet. I entered the info for 4 calendar spreads, but could not tell the Strategies Page to pay attention to the different expiration months. Even though the Option Page recognized the different expirations, the calculated prices in the Strategy page were the same for the Long and Short positions, thereby making the graph a straight line.

Can you give me some guidance as to how to handle Calendar and Diagonal spreads?

If you reply by e-mail, I can send you a reply that has the Worksheet as an attachment, so you can see if I did anything wrong.

Rhudson 2009-06-12 14:44:52 #
Version: 2.1

From My preliminary review -- Cool.
But, I will need more time to really get into it.

Tom Kemmsies 2009-05-01 15:03:27 #
Version: 2.1

An elegant overview and simple yet effective macro to depict what kind of strategy one should favor in different markets. Gives a very good plastic view of the greeks and their sensitivities across ranges of inputs. Well done!

Alpo 2009-04-25 14:36:34 #
Version: 2.1

Good work. I added more functionality.
Note to earlier comment of somebody: Black-Scholes and variants are widely used by institutions but big money has to spread their bids and asks. Insider information penetrates to prices, too. Therefore market does not follow mechanically the model.
I use it to find overprice/underprice anomalies, run approximate simulations etc.


Alpo 2009-04-22 16:11:45 #
Version: 2.1

Nice work. I added a sheet to run a macro of two years price history of any stock and I get a very informative dynamic graph. A semiautomatic strike calculation was added, too. For my taste I changed DTE to 365 days model.
Actually I need an American options binomial model.
I recommend the program as informative and easy to add your own code.


Bsenseindia 2009-04-18 01:38:48 #
Version: 2.1

sir i just want to know more about the sheet what is loaded here . i mean the use and utility of the tool to enhance performance of my trade.


Grailseeker 2008-07-28 06:43:29 #
Version: 2.1

Option Trading Workbook is terrific

I am writing a visual-basic program for trading stock options. I needed to calculate the theoretical price using the Black and Scholes model. I was unable on my own to program this model, so I googled "Visual Basic Calculator with Black and Scholes". Somewhere in the list I found the Stock Option Workbook.

After downloading the SOW, it was only a matter of minutes before I had it working in my Excel spreadsheet. It works beautifully. I intend to copy and paste the Excel macros into my VB program where I can then calculate option prices and other desirable quantities.

I highly recommend the Stock Option Workbook.

options dummy 2008-03-11 12:45:22 #
Version: 2.1

quick evaluation

The spreadsheet and access to formulas used are great for learning options. It does not appear to calculate numbers that match those form real option data (from sites such as Yahoo). Might need some tweaking.

Author's Response:
Hi there, thanks for commenting! About the may be that Yahoo uses the Binomial model to calculate the theoretical prices of the options, where my workbook uses Black and Scholes model. Another common area that causes calculation differences is in the handling of dividends...I use a dividend yield for simplicity, where Yahoo may use a series of discrete dividends.

But the code is disclosed so that you may adjust and tweak it to your liking.



leonard613 2007-11-24 17:39:58 #
Version: 2.1

At a price of FREE what could be so wrong?

Workbook is an excellent base from which I can develop further. Must be careful, though as there are numerous bugs and inconsistencies in formulas.

bk117_0 2007-01-15 18:24:33 #
Version: 2.1

Newbie from Florida

I was looking for something that might make analysis a little easier to understand. This did not really help to make it easier to understand but has alot of information that it charts. I guess I was looking for more educational software.

Download Now
File Size: 54 Kb