Thursday, December 28, 2006

JXIRR - Excel Compatible XIRR Implementation In Java

I have released JXIRR 1.0.0 on my web site under the LGPL license. JXIRR is Microsoft Excel compatible, pure Java implementation of XIRR.

I wrote it for my personal use for tracking my investments. Do let me know if you download and use it.

2 comments:

Anonymous said...

Gautam there seems to be an issue with the java code. For annualised XIRR values greater than 998.99, the code seems to return a #NUM! error i.e. you could expect a XIRR value of 1500(example) but all you get is a NaN error from the code. Also, for annualised XIRR values lesser than -0.88, your code doesnt seem to behave like the excel function. Please see if you can look into this. Regards.

Anonymous said...

And do mail me at scorpion_nib@rediffmail.com if you have noticed and fixed this already. Would really appreciate this. Thanks!