Description:
The function equals the Excel ACCRINTM function.
Syntax:
Faccrintm(maturity,issue,rate,par)
Note:
The external library function (See External Library Guide) returns the accrued interest for a security that pays interest at maturity, with the day count basis method US (NASD) 30/360.
Parameter:
|
maturity |
The security's maturity date |
|
issue |
The security'’s issue date |
|
rate |
The security's annual coupon rate |
|
par |
The security's par value. If omitted, it takes the default value of zero for 100 yuan |
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:
|
Faccrintm@1 (date("2001-6-15"),date("2001-4-1"),0.1,1000) |
20.54794520547945 |