Talk:Documentation/Calc Functions/ODDLPRICE

SF Comments

 * (1) Summary. To clarify the meaning of “odd” / “irregular” suggest replacing with – “Calculates the value of a security per 100 currency units of face (par) value. The security is assumed to have an irregular last interest date, so that the last interest payment does not cover the length of a normal period”.
 * (2) Arguments, Settlement. Suggest changing “date of purchase” to “settlement / purchase date”.
 * (3) Arguments, Maturity. Suggest replacing “date on which the security matures (expires)” with “maturity date”.
 * (4) Arguments, Rate. Change “annual rate of interest (coupon interest rate)” to the simpler “interest rate of the security”. We ought to state that this is expressed as a percentage value, expressed either in percentage format or as a decimal fraction.
 * (5) Arguments, Yield. We ought to state that this is expressed as a percentage value, expressed either in percentage format or as a decimal fraction.
 * (6) Arguments, Frequency. I do not think the table, and the values therein, add anything and I would delete it.
 * (7) Arguments, Basis. Please update to address comments on other instances of this argument.
 * (8) Arguments, 1st bullet. Insert “is” before “less”.
 * (9) Arguments, 2nd bullet. Replace with “If any of Last Interest, Maturity or Settlement is not a valid date then the function returns a value (#VALUE!) error”.
 * (10) Arguments, 3rd bullet. Insert “the” before “Settlement”.
 * (11) Arguments, 5th bullet. Please review – what is the Issue date? Do you mean Last Interest date?
 * (12) 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.”.
 * (13) Arguments, 7th bullet. Insert space before “2”.
 * (14) Arguments, 8th bullet. I would remove the text in brackets as it does not really add anything.
 * (15) Additional details. Formula needed in accordance with my emailed spreadsheet.
 * (16) Examples, 1st and 2nd examples. Was “per value” intended to be “par value”?
 * (17) Examples, 4th example. I am guessing that the formula is not as you intended – the first argument is an invalid date. Also insert “the” before “Settlement”.

--Stevefanning (talk) 2020-11-21T16:41:37 (UTC)