Logical-and Structural-Based Calculations

  • Jack Avon


In this chapter, I want to take a look at functions that fit into a specific part of modeling. I will be discussing functions that work with dates, lookup functions, mathematical functions, and also some functions that are specific to particular situations. I will also outline the functions that fit into various modeling structures and point out functions that modelers should be learning to use. In financial modeling, there are no defined methods of using functions; in fact, there are no prescribed functions for any given modeling situation. The functions that are used in models are instead a reflection of the modeler's skills, experience, and understanding of best practice modeling.


Modeling Situation Text Function Prescribe Function Precise Situation Array Function 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Jack Avon 2015

Authors and Affiliations

  • Jack Avon
    • 1
  1. 1.SurreyUnited Kingdom

Personalised recommendations