R
RSunday
I am trying to use the function XIRR. To speed up the process I start it up
with a qualified "guess".
My code is
calculate_IRR = objExcel.Run("xirr", post_amount, post_date, Guess)
where post_amount and post_date are arrays with matching investments and
dates.
This works well when my guess is a positive value. But it fails if I use a
negative guess. In Excel it works - but not here.
Why is that & what do I do?
with a qualified "guess".
My code is
calculate_IRR = objExcel.Run("xirr", post_amount, post_date, Guess)
where post_amount and post_date are arrays with matching investments and
dates.
This works well when my guess is a positive value. But it fails if I use a
negative guess. In Excel it works - but not here.
Why is that & what do I do?