[Northwestern][Kellogg][Finance][McDonald]

Robert L. McDonald

Information on courses I teach.

Derivatives Markets I (Finance 465)

Derivatives Markets II (Finance 467)

Option Pricing Spreadsheets

A spreadsheet which performs Black-Scholes and binomial calculations is here. There is also an add-in version.

VBA Tutorial

I have written these to explain how you can create your own add-in functions and subroutines in Excel. VBA is a complex subject so I have focused on an area which I think is useful to Kellogg students and which in my experience is not well-covered in commercial VBA manuals. Please let me know if you have comments or find errors.


© Copyright 2010, Robert McDonald. You can send me mail at r-mcdonald@northwestern.edu.