Talk:Documentation/Calc Functions/PRICEMAT

SF Comments

 * (1) Summary. Suggest replacing with the following – “Calculates the price per 100 currency units of face (par) value of a security that pays interest once, at maturity”.
 * (2) Returns. Maybe mention that the result is in currency units.
 * (3) Arguments, general. Update descriptions for Settlement, Maturity and Basis to match the corresponding arguments for PRICE. Note that the descriptions for Rate and Yield should NOT be changed to match PRICE.
 * (4) Arguments, Issue. Change to “Issue is a date or a reference to a cell containing that date which is the original issue date of the security”.
 * (5) Arguments, Rate. Suggest change “coupon interest rate” to “interest only paid at maturity”. Presumably expressed as either a percentage or a decimal fraction.
 * (6) Arguments, 2nd bullet. Change to “If any of Issue, Maturity or Settlement 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, 4th bullet. Delete “or equal to”.
 * (9) Arguments, 5th bullet. Suggest the following re-word for better grammar – “If Basis is a non-integer value, then the function uses its floor value, i.e. it is truncated to an integer value.”.
 * (10) Arguments, 6th bullet. I would remove the text in brackets as it does not really add anything.
 * (11) Additional details. Include the following high-level formula “PRICEMAT = Present value of Redemption Value and Interest – Accrued Interest”. Include a note that here present value is calculated on a non-compounding basis.
 * (12) Related LibreOffice functions. Has a link to PRICE been omitted intentionally?

--Stevefanning (talk) 2020-11-24T20:52:25 (UTC)