Talk:Documentation/Calc Functions/DURATION

SF Comments

 * (1) Returns. Insert “the” before “fixed”.
 * (2) Arguments, Coupon. The text “(nominal rate of interest)” does not seem to add much and could be deleted.
 * (3) Arguments, Coupon and Yield. State that these can be entered as a percentage (e.g. “2.5%”) as well as a real number (e.g. “0.025”).
 * (4) Arguments, Frequency. I do not think the table, and the values therein, add anything and I would delete it.
 * (5) Arguments, Basis. Please update to address comments on other instances of this argument.
 * (6) Arguments, 2nd bullet. Suggest replacing with “If either Settlement or Maturity is not a valid date then the function returns a value (#VALUE!) error”.
 * (7) Arguments, 3rd bullet. Insert “the” before “Settlement”. Also, inspecting the code indicates that there will also be an error if the Settlement and Maturity dates are the same.
 * (8) Arguments, 4th bullet. Suggest replacing with “If either Frequency or Basis is a non-integer value, then the function uses its floor value, i.e. it is truncated to an integer value.”.
 * (9) Arguments, 6th bullet. Change “ny” to “any”. I would remove the text in brackets as it does not really add anything.
 * (10) Additional details. Insert link to Wikipedia page entitled “Bond duration”. Also, I think you can include the right-hand part of expression (1) on that Wikipedia page as the formula for this function – it is a standard formula and is written using standard symbology.
 * (11) Examples, 1st example. “Coupon” does need an initial upper-case letter. Change “Using daily balance interest calculation (basis 3) the function finds how long is the duration” to “Using day count convention (Basis) 3, the function calculates the Macaulay duration”.
 * (12) Examples, 2nd example. “Coupon” does need an initial upper-case letter. Change “Using daily balance interest calculation (basis 0 by default) the function finds how long is the duration” to “Using day count convention (Basis) 0, the function calculates the Macaulay duration”.
 * (13) Examples, 4th example. Insert “the” before “Settlement”.

--Stevefanning (talk) 2020-11-18T10:12:32 (UTC)