Research work · 2018

User‐defined Functions

Michael Rees

Abstract

This chapter focuses on the application of user-defined functions (“udfs”). The chapter first summarises the potential benefits of using udfs. It then discusses some main points about their syntax and implementation. Functions are distinguished from subroutines in that they can provide a result only into an Excel cell (or into a range, for array functions), and that they create a live-link between the function's parameters and the results in Excel. The chapter further provides examples, especially of those which may have their application in general financial modelling contexts: these include “wrapper” functions (that include several Excel or VBA functionalities together within an overall function), and those that capture calculation processes that do not exist as Excel functions, including some statistical measures.

DOI: 10.1002/9781118903933.ch33