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

Welcome to power4XL - your Microsoft Excel resource center

Case Study:
"How I made a 350% IRR on an option trade using the Black Scholes Options Toolkit"

On This Site

Black Scholes Macros Complete set of free Black-Scholes functions for stock option analysis.  Call premium, put premium, historical volatility, implied volatility, Greeks, delta, rho, theta, gamma, vega, d1, d2.  Open-source VBA code, complete documentation.  Not a spreadsheet template, these functions behave just like native Excel formulas, available to all your spreadsheets for your own custom analysis.
Monte Carlo Tutorial Step-by-step tutorial for building your own Monte Carlo method simulation models in Excel.  No add-ins or special software required.  Includes examples & Visual Basic for Applications (VBA) source code.  Build simulations with or without VB.
MBA Toolkit Financial and other functions designed to streamline the tasks of the MBA student or professional.  Includes functions for calculating Compound Annual Growth Rate (CAGR), weighted average, and more.  Formulas range from complex calculations to simple shortcuts.
Analysis ToolPak Guide Complete reference guide to Microsoft Excel's Analysis ToolPak for data analysis and complex statistical functions.  How to download and install the Analysis ToolPak, what functions are included, troubleshooting help.

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.