Could you please help me with the formula for calculating XIRR from a set of cash flows based on a particular identifier?
To compute XIRR that fits the conditions, the formula should use the precise trend length.
In the attached file, I computed XIRR by manually picking the trend length, and every time the number of data points in the array increases, I have to manually update the XIRR calculation, which I like to avoid.
To compute XIRR that fits the conditions, the formula should use the precise trend length.
In the attached file, I computed XIRR by manually picking the trend length, and every time the number of data points in the array increases, I have to manually update the XIRR calculation, which I like to avoid.
Attachments

9.4 KB Views: 27