Freceived()

Description:

The function equals the Excel RECEIVED function.

Syntax:

Freceived(settlement,maturity;inverstment,discount)

Note:

The external library function (See External Library Guide) returns the amount received at maturity for a security.

Parameter:

settlement

The security's settlement date

maturity

The security's maturity date

investment

The initial amount invested into the security

discount

The security's discount rate

Option

@1

Specify the day count basis method Actual/Actual. It corresponds to the Excel basis parameter

@0

Specify the day count basis method Actual/360. It corresponds to the Excel basis parameter

@5

Specify the day count basis method Actual/365. It corresponds to the Excel basis parameter

@e

Specify the day count basis method European 30/360. It corresponds to the Excel basis parameter

Example:

Freceived@0(date("2001-2-15"),date("2001-5-15"),1000000,0.0575)

1014420.2658626447

Freceived@5(date("2001-2-15"),date("2001-5-15"),1000000,0.0575)

1014219.9190013407