OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Updated: (OFFICE-1107) Public Comment: ODFF:XIRR

     [ http://tools.oasis-open.org/issues/browse/OFFICE-1107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Robert Weir  updated OFFICE-1107:

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."


"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."

> Public Comment: ODFF: XIRR
> --------------------------
>                 Key: OFFICE-1107
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1107
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>            Reporter: Robert Weir 
>            Assignee: Robert Weir 
>            Priority: Blocker
>             Fix For: ODF 1.2 Part 2 CD 3
> 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

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]