writer
2,661
edits
Changes
Manuals/calci/DURATION (view source)
Revision as of 03:17, 27 November 2013
, 03:17, 27 November 2013→Description
DURATION() calculates the rate of change of price with respect to yields. It is the weighted average time until cash flows are received.
DURATION() calculates the rate of change of price with respect to yields. It is the weighted average time until cash flows are received.
*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays an error message.
*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
*If settlement date ≥ maturity date, Calci displays an error message.
*If settlement date ≥ maturity date, Calci displays #N/A error message.
*'coupon' and 'yield' values must be greater than or equal to zero.
*'coupon' and 'yield' values must be greater than or equal to zero.
*The values for 'frequency' should be 1,2 or 4.
*The values for 'frequency' should be 1,2 or 4.
|}
|}
*If 'basis' value is other than 0 to 4, Calci displays an error message.
*If 'basis' value is other than 0 to 4, Calci displays #N/A error message.
== Examples ==
== Examples ==