RangeIRR - script and chart function
RangeIRR() returns the internal rate of return for a series of cash flows represented by the input values.
The internal rate of return is the interest rate received for an investment consisting of payments (negative values) and income (positive values) that occur at regular periods.
This function uses a simplified version of the Newton method for calculating the internal rate of return (IRR).
Syntax:
RangeIRR(value[, value][, Expression])
Return data type: numeric
Argument | Description |
---|---|
value | A single value or a range of values as returned by an inter record function with a third optional parameter. The function needs at least one positive and one negative value to be calculated. |
Expression | Optional expressions or fields containing the range of data to be measured. |
Limitations:
Text values, NULL values and missing values are disregarded.
Examples | Results | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RangeIRR(-70000,12000,15000,18000,21000,26000) |
Returns 0.0866 |
||||||||||||||||
Add the example script to your app and run it. To see the result, add the fields listed in the results column to a sheet in your app. RangeTab3: LOAD *, recno() as RangeID, RangeIRR(Field1,Field2,Field3) as RangeIRR; LOAD * INLINE [ Field1|Field2|Field3 -10000|5000|6000 -2000|NULL|7000 -8000|'abc'|8000 -1800|11000|9000 -5000|5000|9000 -9000|4000|2000 ] (delimiter is '|'); |
|