koala icon indicating copy to clipboard operation
koala copied to clipboard

Excellib.irr() might not output correct values

Open bleucitron opened this issue 8 years ago • 6 comments

We use the numpy version of Excel IRR function.

But for file 230, Calculations!CU273 does not output expected value. It seems final evaluation value is correct though ...

bleucitron avatar May 30 '16 13:05 bleucitron

Same for file 100032845, Calculations!AF206

bleucitron avatar Jun 13 '16 18:06 bleucitron

100069704, Calculations!AZ285

bleucitron avatar Jun 14 '16 14:06 bleucitron

100071551, Calculations!O231

bleucitron avatar Jun 14 '16 14:06 bleucitron

100038612, Calculations!AD206

bleucitron avatar Jun 14 '16 14:06 bleucitron

100035575, Calculations!W231

bleucitron avatar Jun 14 '16 14:06 bleucitron

IRR() from Excel accepts a second argument to help the calculation to converge. If nothing is passed as 2nd arg, IRR() outputs #VALUE when it can't converge.

Numpy.irr() doesn't, and seems more efficient.

bleucitron avatar Jul 12 '16 08:07 bleucitron