Credit Risk Modeling Using Excel and VBA with DVD

Appendix A5

User-defined Functions

Throughout this book we use Excel functions and discuss user-defined functions to perform the described analyses. Here we provide a list of all these functions together with their syntax and short descriptions. The source for original functions is Microsoft Excel 2003's help file.

All the user-defined commands are available in the xls file accompanying each chapter and the lp.xla Add-in, both provided on the DVD. The Add-in is furthermore available for download on our website: www.loeffler-posch.com.

INSTALLATION OF THE ADD-IN

To install the Add-in for use in the spreadsheet, take the following steps in Excel:

1. Click on the item Add-Ins in the Menu Tools.
2. Click on Browse and choose the location of the lp.xla file.
   1. If you are using the DVD, the file is located in the root directory, e.g., D:\lp.xla.
   2. If you downloaded the Add-in from the Internet, the file is located in your download folder.

To install the Add-in for use within your own VBA macros, take the following steps in Excel:

1. Open the VBA editor by pressing [alt]+[F11].
2. Click on the item References in the Tools menu.
3. Click on Browse and choose the location of the lp.xla file.
   1. If you are using the DVD, the file is located in the root directory, e.g., D:\lp.xla.
   2. if you downloaded the Add-in from the Internet, the file is located in your download folder.

FUNCTION LIST

We developed and tested our functions with the international English versions of Excel 2003 and Excel 2007. If you run ...