• Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • ODF 1.2 Part 2 CD 3
    • Affects Version/s: ODF 1.2 Part 2 CD 1
    • Component/s: OpenFormula
    • None
    • Hide

      Add additional parameter to syntax: [ ; Logical calc_method = TRUE() ]

      In semantics add additional parameter: "calc_method A logical value that specifies how to treat the case where settlement>first"

      Then, under semantics add the following new paragraph:

      "If calc_method is TRUE (the default) then ACCRINT returns the sum of the accrued interest in each coupon period from issue date until settlement date.

      If calc_method is FALSE then ACCRINT returns the sum of the accrued interest in each coupon period from first date until settlement date.

      For each coupon period, the interest is par*coupon*YEARFRAC(start-of-period;end-of-period; basis)"

      Show
      Add additional parameter to syntax: [ ; Logical calc_method = TRUE() ] In semantics add additional parameter: "calc_method A logical value that specifies how to treat the case where settlement>first" Then, under semantics add the following new paragraph: "If calc_method is TRUE (the default) then ACCRINT returns the sum of the accrued interest in each coupon period from issue date until settlement date. If calc_method is FALSE then ACCRINT returns the sum of the accrued interest in each coupon period from first date until settlement date. For each coupon period, the interest is par*coupon*YEARFRAC(start-of-period;end-of-period; basis)"

      5.12.2 ACCRINT and ACCRINT are missing either a mathematical description of the returned value or a reference to a normative description for the calculation.

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

              Created:
              Updated:
              Resolved: