AnsweredAssumed Answered

[XPOST]How to program Newton / Raphes in Filemaker?

Question asked by hjgunn@mmedia.is on Nov 25, 2015
Latest reply on Nov 28, 2015 by hjgunn@mmedia.is

At this time I have created a solution that uses the bisection method to calculate the EARP of a loan.

This method takes about 35 iterations to come up with an answer.

 

So I would like to do these calculations using either the Newton / Raphes method or one of the Quasi Newton methods.

I believe those methods use around 5 iterations to come up with a fairly accurate solution.

 

Is there anyone here that has done this in Filemaker or that could show me how it's done?

 

Also, how can I prevent the calculation from not converging?

 

Kind regards

Hans

Outcomes