Talk:Documentation/Calc Functions/YIELDMAT

SF Comments

 * (1) Summary. Suggest the following alternative wording – “Calculates the yield of a security that pays interest only once, on the maturity date”.
 * (2) Returns. This seems to bear little relation to what the function actually does!
 * (3) Arguments, general. Please update the descriptions of Settlement, Maturity, Price and Basis to match their descriptions on the YIELD page.
 * (4) Arguments, Rate. Change “coupon interest rate” to “interest only paid at maturity”.
 * (5) Arguments, 1st bullet. Insert “is” before “less”.
 * (6) Arguments, 2nd bullet. Suggest replacing with “If Settlement, Maturity, or Issue is not a valid date then the function returns a value (#VALUE!) error”.
 * (7) Arguments, 3rd bullet. Insert “the” before “Settlement”. Settlement = Maturity should also give an error.
 * (8) Arguments, 6th bullet. I would remove the text in brackets as it does not really add anything.
 * (9) Arguments, bullets. Also, I think an error will be raised if Settlement is before Issue.
 * (10) Additional details. We need to populate this section. I am happy to populate the section myself in due course if RG does not have time available for the necessary research.
 * (11) Examples, 1st and 2nd examples. Delete “how high is”.
 * (12) Examples, 2nd example. Change “The basis is 2” to “The basis is 0 by default”.
 * (13) Examples, 4th example. Insert “the” before “Settlement”.

--Stevefanning (talk) 2020-11-28T17:47:13 (UTC)