function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Foram Rana RForam Rana R 

Excel IRR Function Calculation in Apex class

Hi,

I have to perform Excel IRR Function Calculation in Apex class.
https://exceljet.net/excel-functions/excel-irr-function

Thanks,
Foram Rana
SwethaSwetha (Salesforce Developers) 
HI,
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.

Thanks,
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)