Faccrintm()

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