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 |