PHP Classes

XIRR function return strange result

Recommend this page to a friend!

      Financial  >  All threads  >  XIRR function return strange result  >  (Un) Subscribe thread alerts  
Subject:XIRR function return strange result
Summary:XIRR function
Messages:2
Author:Alessandro Gonella
Date:2014-03-27 16:15:20
 

  1. XIRR function return strange result   Reply   Report abuse  
Picture of Alessandro Gonella Alessandro Gonella - 2014-03-27 16:15:20
Hello,
I'm having a problem in using the XIRR function.

print $f->XIRR(array(-400,18), array(
mktime(0,0,0,1,1,2014),
mktime(0,0,0,10,1,2014),
), 0.1);

The above code print -1.5714653207915E+40 while in Excel the result is 0.98.

Am I doing something wrong?
Thanks for any help!
Ale

  2. Re: XIRR function return strange result   Reply   Report abuse  
Picture of PSY CARN PSY CARN - 2015-08-12 01:36:39 - In reply to message 1 from Alessandro Gonella
Hi Alessandro, you could solve? Thx.