MDURATION

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

Returns the Macauley modified duration for a security with an assumed par value of $100.

Parameters:

Name Type Description
arg1 any

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

arg2 any

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

arg3 any

Is the security's annual coupon rate.

arg4 any

Is the security's annual yield.

arg5 any

Is the number of coupon payments per year.

arg6 any

Is the type of day count basis to use.

Returns:

Type
number | string | boolean