Talk:Documentation/Calc Functions/ACCRINTM

SF Comments

 * (1) Summary. Suggest replacing with – “Calculates the accrued interest for a security that pays interest on maturity.”. (Involving the word maturity here gives a clue where the “M” comes from in the function’s name!)
 * (2) Returns. Suggest replacing with the following – “Returns a positive real number which is the accrued interest, expressed in the same currency units that were used for the security’s par value.”.
 * (3) Arguments, Rate. Delete “interest” after “coupon”. State that this can be entered as a percentage (e.g. “2.5%”) as well as a real number (e.g. “0.025”).
 * (4) Arguments, Par. Suggest including the same note under this parameter as appears for ACCRINT. (I have also added this suggestion to the list of Help changes.)
 * (5) Arguments, Basis. I would include a link to Wikipedia’s “Day count convention” page.
 * (6) Arguments, 1st bullet. Suggest the following re-word for better grammar – “If either of Issue or Settlement are not valid dates then the function returns a value (#VALUE!) error.”. However the whole bullet needs thinking about because dates are essentially just numbers (search for "date and time functions" in the Help) – for example =ACCRINTM(3,5,0.1) does not give an error.
 * (7) Arguments, 3rd bullet. Insert “the” before “Issue”.
 * (8) Arguments, 4th 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.”.
 * (9) Arguments, 5th bullet. Change “ny” to “any”. I would remove the text in brackets as it does not really add anything.
 * (10) Additional details. Please delete the material in this section. Instead include a link to Wikipedia’s “Accrued interest” page and include a simple equation which is valid for our application. That equation should express that the accrued interest = (Rate * Par) * (days of interest earned / days per year). (Note: I am aware this is not vastly different from what’s there already!)
 * (11) Examples, 1st and 3rd examples. Last sentence of the Description not understood. Can we replace with clearer – “The basis used is option 3 (exact number of days in month, year has 365 days)”.
 * (12) Examples, 3rd example. Insert space before open round bracket within description.
 * (13) Examples, general. Maybe include some examples which use the DATE function, enter dates as numbers and use the % format for the Rate argument.
 * (14) ODF standard. Is there some reason why we have not included the appropriate link here? (If we do add a reference to the ACCRINTM chapter in the ODF, we might consider noting that the ODF specifies Par to be a required argument while it is optional in Calc).
 * (15) Equivalent Excel functions. Is there some reason why we have not mentioned Excel’s ACCRINTM function?

--Stevefanning (talk) 2020-11-11T19:58:34 (UTC)

Ronnie
All points addressed. --Ronnie rg8888 (talk) 2020-12-21T07:13:16 (UTC)