8 Replies Latest reply on Nov 28, 2015 3:14 AM by hjgunn@mmedia.is

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

    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