AnsweredAssumed Answered

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

Question asked by on Nov 25, 2015
Latest reply on Nov 28, 2015 by

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