ACCRINT

ACCRINT(arg1, arg2, arg3, arg4, arg5, arg6, arg7, arg8) → { number | string | boolean }

Returns the accrued interest for a security that pays periodic interest..

Parameters:

Name Type Description
arg1 any

Is the security's issue date, expressed as a serial date number.

arg2 any

Is the security's first interest date, expressed as a serial date number.

arg3 any

Is the security's settlement date, expressed as a serial date number.

arg4 any

Is the security's annual coupon rate.

arg5 any

Is the security's par value.

arg6 any

Is the number of coupon payments per year.

arg7 any

Is the type of day count basis to use.

arg8 any

Is a logical value: to accrued interest from issue date = TRUE or omitted; to calculate from last coupon payment date = FALSE.

Returns:

Type
number | string | boolean