After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 614147 - XIRR calculates incorrect result
XIRR calculates incorrect result
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
1.10.x
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2010-03-28 02:29 UTC by Chris Uhlik
Modified: 2010-03-28 12:28 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
the offending list of dates and values (2.37 KB, application/octet-stream)
2010-03-28 02:32 UTC, Chris Uhlik 		Details

Description Chris Uhlik 2010-03-28 02:29:36 UTC 
I have a range of dates and cash flows where XIRR() evaluates to exactly -100.00% which is not near the correct answer.  The search algorithm is not converging for this case.  This is not a pathological case, the values are completely reasonable from real-life.
Comment 1 Chris Uhlik 2010-03-28 02:32:36 UTC 
Created attachment 157300 [details]
the offending list of dates and values

These are the dates and cash-flows for which XIRR evaluates incorrectly.  The file is a gnumeric spreadsheet file.
Comment 2 Morten Welinder 2010-03-28 12:11:07 UTC 
I see this.
Comment 3 Morten Welinder 2010-03-28 12:28:39 UTC 
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.

This was a slightly more general problem with goal seek and NaN values.

You can work around it by supplying a third argument to xirr.  It is a guess
as to what the result should be.  10% is the default.  Try 0 or -5%.