| Summary: | Class to implement internal excel function RATE | ||
|---|---|---|---|
| Product: | POI | Reporter: | carlo.traversa |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | enhancement | ||
| Priority: | P2 | ||
| Version: | 3.8-dev | ||
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | All | ||
| Attachments: | Class to implement internal excel function RATE | ||
Created attachment 27805 [details] Class to implement internal excel function RATE Hi all. It would be great to implement the internal financial excel function RATE. The class in attachement is my own implementation but the most important thing is the method calculateRate(double nper, double pmt, double pv, double fv, double type, double guess) that find root by using the Newton secant method. In this way it'd be possible to easily adapt the code. I hope this will help the project with my few rows of code. Feel free to contact me for any detail. Regards, Carlo Traversa.