+ Start a Discussion
Foram Rana RForam Rana R 

Excel IRR Function Calculation in Apex class


I have to perform Excel IRR Function Calculation in Apex class.

Foram Rana
SwethaSwetha (Salesforce Developers) 
You can try this code https://github.com/stonarelli/stonarelli/blob/master/XIRR/Salesforce/src/classes/XIRR.cls

Related: https://developer.salesforce.com/forums/?id=906F000000091z7IAA
Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you
Foram Rana RForam Rana R
Hi Swetha,

Thanks, quick response.
I have already referred this but not getting.

Foram Rana
Christan G 4Christan G 4
Recently, I received a similar requirement and developed a method for this. I uploaded it to GitHub. Feel free to reference it here: Excel IRR Function in Apex (https://github.com/Saiunai/calculateExcelIRR/blob/main/calculateExcelIRR.cls)