Faccrintm()

Description:

The function equals the Excel ACCRINTM function.

Syntax:

Faccrintm(maturity,issue;rate,par)

Note:

The function returns the accrued interest for a security that pays interest at maturity, with the day count basis method US (NASD) 30/360.

Parameters:

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

Options

@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