Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

XIRR - what method is used?

Hi Folks,

Does anyone know what methodology Qlikview uses to solve XIRR or IRR?  Newton's method?  If it is a combined or custom method, can you give a brief description?

Any help is appreciated.  Thanks.

4 Replies
JonnyPoole
Employee
Employee

Hi there - the online help has these definitions for the function as well as some short samples.  If you have already read this and it doesn't provide what you need , please let me know.

Not applicable
Author

Hi Jonathan,

Thanks for the prompt response.  I have read through those before but they do not discuss the methology used for root finding.

To find the one interest rate that can discount all of the cashflows to a npv sum of zero requires an iterative root-finding technique, most commonly the Newton, or Newton-Raphson method, and some seeding methodology.

So I am curious about the internals of the Qlikview implementation, which are not discussed anywhere, as far as I can tell.  It seems quite stable and very fast, but I would like to know the details.  This is probably a question that only someone from inside Qlikview can answer, there may be an existing internal whitepaper that they could post......

Thanks,

Peter

juleshartley
Specialist
Specialist

Hi Peter,

I'm also interested in this as I'm finding discrepancies between results produced by Excel and Qlik...


Not applicable
Author

Hi Julian

I got this in reply (below).

Cheers,

Peter

::

XIRR uses  our own code - it is not fetched from the Cephes library which we use for many other functions. When it was implemented, we used Excel as norm for how it should work.

The only reason XIRR  can't be done using the common functions is that the order of amounts and dates is important (load order only) and there is a Newton raphson iteration at the end.