Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 3
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Replace existing content with:

      "Constraints: The size of Values and Dates are equal. Values contains at least one positive and one negative cash flow."

      And under Semantics:

      "Values: a series of cash flows. Negative cash flows represent payments given; positive cash flows represent payments received."

      And:

      "Guess: If provided, Guess is an estimate of the interest rate to start the iterative computation. If omitted, the value 0.1 (10%) is assumed. The result of XIRR is the rate at which the XNPV() function will return zero with the given cash flows. There is no closed form for XIRR. Implementations may return an approximate solution using an iterative method, in which case the Guess parameter may be used to initialize the iteration. If the implementation is unable to converge on a solution given a particular Guess, it may return an error."

      Show
      Replace existing content with: "Constraints: The size of Values and Dates are equal. Values contains at least one positive and one negative cash flow." And under Semantics: "Values: a series of cash flows. Negative cash flows represent payments given; positive cash flows represent payments received." And: "Guess: If provided, Guess is an estimate of the interest rate to start the iterative computation. If omitted, the value 0.1 (10%) is assumed. The result of XIRR is the rate at which the XNPV() function will return zero with the given cash flows. There is no closed form for XIRR. Implementations may return an approximate solution using an iterative method, in which case the Guess parameter may be used to initialize the iteration. If the implementation is unable to converge on a solution given a particular Guess, it may return an error."

      Description

      Copied from office-comment list

      Original author: "David King" <openoffice@drking.plus.com>
      Original date: 7 Sep 2008 20:55:58 -0000
      Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00012.html

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: