CapOption | ||||||||
Data Type: Float (Optional) | ||||||||
Either a Float number (ie not an integer), or the variable can be omitted. If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). | ||||||||
Examples: 2.02: Capitalise the average of the last 2 cashflows omitting non-positives. 0: Capitalise last cashflow 1.04 Capitalise average of last 4 cashflows. | ||||||||
Example: 1 | ||||||||
Variable Values | ||||||||
Default(s) | ||||||||
0 | Capitalise the last value of the cashflow | |||||||
Switches | ||||||||
0 | Capitalise the last value of the cashflow | |||||||
1 | Capitalise average of the last nn cashflows | |||||||
2 | Capitalise average of the nn last cashflows (omitting non-positive cashflows) | |||||||
3 | Capitalise maximum of the last nn cashflows | |||||||
4 | Capitalise minimum of the last nn cashflows | |||||||
5 | Capitalise largest absolute cashflow of the last nn cashflows ie take the largest absolute number, whether its +ve or -ve. | |||||||
6 | Capitalise average of the last nn non-zero cashflows (omitting zero cashflows) |