Finance.js IRR function problem.

[eastmoon]

Hi, Essam.
I am Jacky from Taiwan.

Few day ago, my friend has a project use Finance.js, IRR function.
But, function was not enough precision than Excel IRR function.
So, my friend ask for my help

I look your program, and find 2 issues.

1. dynamic guess variable isn't exist, and decimal is not enough.
2. recursive call will happen stack error.

First, i tell to my friend to modify your program at some const variable.
That will fix issues 1, but at same time it will happen issues 2.
Because i use more decimal and more precision guess, it mean time complexity will grow, in recursive call it also mean more stack.

So, i write a do-while version to calculate, but performance still limit by browser.
Then, i write a burst-guess to speed-up, when VPN too huge.
e.g : Math.log(VPN).

My code is over here.
https://github.com/eastmoon/Tutorial-JavaScript/blob/master/Issues-FinanceIRR/Index.html

Hope it would be helpful for you

[jasonfungsing]

@eastmoon Tested your linked code. looks like it is still not correct.

[eastmoon]

@jasonfungsing What's wrong has happened ?
Could you give me data and result ?
It will help me know how to fix it.