Docs
Functions Cheatsheet
Functions Cheatsheet
A concise functions table, hover on the function's name to see details.
| Function | Syntax | Category |
|---|---|---|
| - | a - b | arithmetic |
| - | -a | arithmetic |
| ! | !a | logical |
| != | a != b | comparison |
| @blank | @blank | keyword |
| @self | @self | keyword |
| * | a * b | arithmetic |
| / | a / b | arithmetic |
| && | condition a && condition b | logical |
| ^ | a ^ b | arithmetic |
| + | a + b | arithmetic |
| + | +a | arithmetic |
| < | a < b | comparison |
| <= | a <= b | comparison |
| == | a == b | comparison |
| > | a > b | comparison |
| >= | a >= b | comparison |
| || | condition a || condition b | logical |
| abs | abs(Series) | arithmetic |
| avg | avg(Serie 1, Serie 2 ...) | statistical |
| avg_series | avg_series(Series, Filter, Placement) | statistical |
| cagr | cagr(Series, Filter, Placement) | financial |
| children | children() | macro |
| convolve | convolve(Inflow, Curve, Filter) | lifecycle |
| days | days() | date |
| depreciate | depreciate(CapEx, Useful Life, Method, Salvage, Filter) | lifecycle |
| if | if(Condition, Value if True, Value if False) | logical |
| iferror | iferror(Value, Value if Error) | logical |
| ifs | ifs(Condition 1, Value if True 1, Condition 2, Value if True 2 ...) | logical |
| is | is(Marker) | lookup |
| is_first | is_first(Marker) | lookup |
| is_last | is_last(Marker) | lookup |
| lookup | lookup(Series, Condition, Search Direction) | lookup |
| max | max(Serie 1, Serie 2 ...) | statistical |
| max_series | max_series(Series, Filter, Placement) | statistical |
| min | min(Serie 1, Serie 2 ...) | statistical |
| min_series | min_series(Series, Filter, Placement) | statistical |
| month | month(date) | date |
| next | next(Series, Periods, Final Value) | timeshift |
| prev | prev(Series, Periods, Initial Value) | timeshift |
| prod | prod(Serie 1, Serie 2 ...) | arithmetic |
| prod_series | prod_series(Series, Filter, Placement) | arithmetic |
| quarter | quarter(date) | date |
| roll | roll(Series, Window, Method) | statistical |
| round | round(Series, Places) | arithmetic |
| runoff | runoff(Balances, Retention, Anchor) | lifecycle |
| sqrt | sqrt(Series) | arithmetic |
| sum | sum(Serie 1, Serie 2 ...) | arithmetic |
| sum_series | sum_series(Series, Filter, Placement) | arithmetic |
| survival | survival(Harzard Curve) | lifecycle |
| wtavg | wtavg(Value and Weight Pair 1, Value and Weight Pair 2 ...) | statistical |
| wtavg_series | wtavg_series(Values, Weights, Filter, Placement) | statistical |
| xirr | xirr(Values, Filter, Valuation Period) | financial |
| xnpv | xnpv(Rate, Values, Filter, Timing, Valuation Period) | financial |
| year | year(date) | date |
| year_frac | year_frac() | date |