Talk:Documentation/Calc Functions/YIELD

SF Comments

 * (1) Summary. Suggest adding “that pays interest”.
 * (2) Returns. Replace “percentage or” with “decimal”. Add “for the given arguments”.
 * (3) Arguments, Settlement. For consistency, suggest changing “date of purchase” to “settlement / purchase date”.
 * (4) Arguments, Maturity. Suggest replacing “date on which the security matures (expires)” with “maturity / redemption date of the security”.
 * (5) Arguments, Rate. Change “annual rate of interest (coupon interest rate)” to the simpler “interest rate of the security”.
 * (6) Arguments, Price. Delete “(purchase price)”.
 * (7) Arguments, Redemption. For consistency with the line above, insert “of the security” before “per 100”.
 * (8) Arguments, Frequency. I do not think the table, and the values therein, add anything and I would delete it.
 * (9) Arguments, Basis. Please update to address comments on other instances of this argument.
 * (10) Arguments, 1st bullet. Insert “is” before “less”.
 * (11) Arguments, 2nd bullet. Suggest replacing with “If either Settlement or Maturity is not a valid date then the function returns a value (#VALUE!) error”.
 * (12) Arguments, 3rd bullet. Insert “the” before “Settlement”. Settlement = Maturity should also give an error.
 * (13) Arguments, 6th bullet. Suggest the following re-word for better grammar – “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.”.
 * (14) Arguments, 7th bullet. Insert space before “2”.
 * (15) Arguments, 8th bullet. I would remove the text in brackets as it does not really add anything.
 * (16) Additional details. This is a relatively complex function, and we need to populate this section. However, I am conscious that its population may be onerous, and I am happy to populate the section myself in due course if RG does not have time available for the necessary research.
 * (17) Examples, all examples. When I copied and pasted each of these formulas into Calc, an error 508 was the result. This was removed by deleting the apparently blank character after “0.0575” and before the subsequent semicolon.
 * (18) Examples, 1st and 2nd examples. Delete “how high” and “is” in the last sentence.
 * (19) Examples, 4th example. Insert “the” before “Settlement”.

--Stevefanning (talk) 2020-11-28T16:43:34 (UTC)