ACCRINT description is inconsistent

XMLWordPrintable

    • Type: Bug
    • Resolution: Later
    • Priority: Major
    • ODF-Next
    • Affects Version/s: ODF 1.2 CD 05
    • Component/s: OpenFormula
    • None
    • Hide

      In definition of ACCRINT (Part 2, section 6.12.2) make the following changes:

      Replace Constraints with "issue < settlement ; coupon > 0; par > 0"

      Show
      In definition of ACCRINT (Part 2, section 6.12.2) make the following changes: Replace Constraints with "issue < settlement ; coupon > 0; par > 0"

      The description of ACCRINT has several issues:

      1) The constraint is given as: issue < first < settlement ; coupon > 0; par > 0. OOo and Excel clearly permit settlement<first and most examples on the web seem to be of that kind.

      2) The short description of calc_method reads "A logical value that specifies how to treat the case where settlement>first." which seems to imply that there is a permitted case where settlement > first does not hold.

      3) The formula given contains the undefined variables start-of-period and end-of-period. Especially in view of the statement "ACCRINT
      supports short, standard, and long coupon periods.", it is not clear what those values are.

      4) If the constraint is changed, a formula for the settlement < first case is needed.

            Assignee:
            Robert Weir (Inactive)
            Reporter:
            Andreas Guelzow (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: