Investment Studio > Expressions

Expressions (formulas written in a spreadsheet-like syntax) are used to tell Investment Studio how to:

compute cell values in Grid objects,
compute data points and create dynamic text in Chart objects,
compute data points and create dynamic text in Graph objects; and
specify System rules and objective functions for system parameter optimization.

If you are familiar with a spreadsheet like Excel or Lotus 1-2-3, you should feel right at home writing Investment Studio expressions.

Warning: do not assume that Investment Studio expressions will always work as they would in your favorite spreadsheet! While this may often be the case, you should also expect significant differences. Always refer to the documentation when using Investment Studio functions with which you are not thoroughly familiar.
Tip: A bit of experimentation goes a long way. The simple spreadsheet in the Macros view is ideal for testing unfamiliar functions and new expressions.

Investment Studio expression topics:

Data types
Syntax
Operators
Constants
References
Arrays
Functions