Options Pricing Models and Volatility Using Excel-VBA + CD-ROM Book

The book does a competent (although not outstanding) job covering option pricing models as well as volatility models like GARCH and the Heston Volatility Model. However, the code examples are incredibly sloppy. As just one example, look at the second function on page 16. It declares four variables that are never used in the function, while other variables are used without declaration. The use of arrays does not conform to accepted VBA practice. While none of these is an actual error, it illustrates the severe sloppiness of the code. In other places (some of which have been pointed out by other reviewers), it does result in errors. I found myself rewriting almost all the code. It is, however, to the book's credit that between the text and the code illustrations, it is possible to figure out what to do if you're a VB programmer.