Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
Hi Peter,
I'm also interested in this as I'm finding discrepancies between results produced by Excel and Qlik...
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.