Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 Part 2 CD 1
    • Fix Version/s: ODF 1.2 Part 2 CD 3
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      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)"

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              rcweir Robert Weir (Inactive)
              Reporter:
              aguelzow Andreas Guelzow (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: