Option Trading Tips

Home | Contact | Newsletter

Option Pricing

Option Greeks

Free Option Pricing Spreadsheet

Download the zipped version Option Trading Workbook (53 KB)
Download the Excel file Option Trading Workbook.xls (259 KB)

The above option pricing spreadsheet will allow you to price European call and put options. You can also enter up to ten different option/stock leg combinations to view the expected payoff at expiration.

If you have trouble with the formulas, check out the support page.

Alternatively, you can visit the online version of these calculations at Option-Price.com

Just to note that much of what I have learnt that made this spreadsheet possible was taken from the highly acclaimed book on financial modeling by Simon Benninga - Financial Modeling - 2nd Edition

If you're an Excel junkie, you'll love this book - Simon's a freak. There are loads of real world problems that Simon solves using Excel. The book also comes with a disk that contains all the exercises Simon illustrates. You can find a copy of Financial Modeling at Amazon of course.

 

Comments page 2 of 2
Click here to add a comment
rknox
Posted 70 days ago
Very Cool! Very nicely done. You sir, are an artist. One old hacker (76 years old - started on the PDP 8) to another.