BONDDURATION
Description
Returns the duration of a fixed interest security in years. Maturity is based on the Macaulay duration. For the modified duration, use MDURATION() or BONDMDURATION().
Syntax
BONDDURATION(
settlement
,
maturity
,
coupon
,
yield
,
frequency
, [
basis
])
- settlement: The security's settlement date.
- maturity: The security's maturity date.
- coupon: The security's annual coupon rate.
- yield: The security's annual yield.
- frequency: The number of coupon payments per year. 1 = annual; 2 = semiannual; 4 = quarterly.
- basis: The financial day count to use, shown here using x/y where x = days per month and y = days per year. 0 or Empty = US NASD 30/360; 1 = actual/actual; 2 = actual/360; 3 = actual/365; 4 = European 30/360.