Skip to content

Other functions

SumOverIndex

SumOverIndex(
    StartIndex,
    EndIndex,
    Var1,
    Var2,
    …
)

Arguments

StartIndex
start t index for sum
EndIndex
end t index for sum
Var1, Var2, Var3
variables to sum

Examples

SumOverIndex(t-12+1,t,foo,bar)

ConcatenatePipe

ConcatenatePipe(
    Arg1,
    Arg2,
    …
)

Concatenates all arguments with "|"

Discount

Discounts cashflows

Discount(
    MonthlyDiscountRate=0,
    CashflowStartOfMonth=0,
    CashflowEndOfMonth=0
)

Arguments

MonthlyDiscountRate
Nominal monthly effective discount rate compounded monthly.
CashflowStartOfMonth
Start of period cashflows
CashflowEndOfMonth
End of period cashflows

SolveToZero

Solves a referenced variable to 0.

SolveToZero(
    FunctionToSolve,
    StartingValue=0
)

Arguments

FunctionToSolve
The function that should be solved to zero. Currently, this can only be another variable that can contain a function that should be solved.
StartingValue
The starting value for the variable that calls this function. By default, the starting value is zero.

Examples

x = SolveToZero(y,0.01)
y = x^2 - 4

This would change x, until y is solved to 0. Because the starting value was >0, x will solve to 2 (as opposed to -2 if the starting value was <0)