power4XL Microsoft Excel Resource Center
Free Macros, Formulas, Functions, Tutorials, Downloads, Add-Ins & More!

Free Black-Scholes Stock Options Toolkit

The power4XL Options Toolkit is a complete set of field-tested macro functions for Black-Scholes options analysis in Microsoft Excel using Visual Basic macro code.

Most of the Visual Basic source code can be copied freely from this site and pasted into your own spreadsheet code modules.

Not a template or pre-constructed spreadsheet model, the Options Toolkit is a set of open-source VBA functions that can be copied & pasted directly into your Excel Visual Basic code module, making Black-Scholes and related functions available to all your spreadsheets.  

These functions behave just like native Microsoft Excel functions.  This lets you construct complex models and analyze hundreds of options in your own spreadsheets.

Get Started:

  • Functions: Browse available functions

  • Installation: Learn how to copy the functions into your own Excel program.

  • Case Study: See a real-life application of the Black-Scholes Option Toolkit.

Copyright notice:  This site and all content, including computer code and spreadsheet examples, are copyright 2006 by Fritz Dooley.  License is granted for individual users to download examples and to copy code directly into user's spreadsheets and Visual Basic for Applications files.  Users may not redistribute code in any way.  Providing hyperlinks to this web site is encouraged, but posting code and examples on other web sites is expressly forbidden.  "Microsoft" is a registered trademark of Microsoft Corporation.   Neither this web site nor Fritz Dooley is affiliated with Microsoft Corporation.