RangeXNPV - script and chart function

Overview

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• Financial data contained in a table called RangeTab3.

• The use of the RangeXNPV() function to compute net present value.

Load script

RangeTab3:
LOAD *,
recno() as RangeID,
RangeXNPV(DiscountRate,Value1,Date1,Value2,Date2) as RangeXNPV;
LOAD * INLINE [
DiscountRate|Value1|Date1|Value2|Date2
0.1|-100|2021-01-01|100|2022-01-01|
0.1|-100|2021-01-01|110|2022-01-01|
0.1|-100|2021-01-01|125|2022-01-01|
] (delimiter is '|');

Results

Load the data and open a sheet. Create a new table and add these fields as dimensions:

• RangeID

• RangeXNPV

Overview

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• Financial data contained in a table called RangeTab3.

• The use of the RangeXNPV() function to compute net present value.

Load script

RangeTab3:
LOAD *,
recno() as RangeID,
RangeXNPV(DiscountRate,Value1,Date1,Value2,Date2) as RangeXNPV;
LOAD * INLINE [
DiscountRate|Value1|Date1|Value2|Date2
0.1|-100|2021-01-01|100|2022-01-01|
0.1|-100|2021-01-01|110|2022-01-01|
0.1|-100|2021-01-01|125|2022-01-01|
] (delimiter is '|');

Results

Do the following:

Load the data and open a sheet. Create a new table and add the following calculation as a measure:

=RangeXNPV(0.1, -2500,'2008-01-01',2750,'2008-09-01')