• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

XIRR with Date in Column from New to Old

rsd007

Member
Hello,
I am not sure if it is possible calculating XIRR with New to old date / Data as shown. Also, can have more than 1 entry per month. List keeps growing

81507

Help Please.
Thanks
 

Attachments

  • XIR Help .xlsx
    9.6 KB · Views: 2
Further reading Found that XIRR can only work if the dates are oldest to new.

No. For Excel XIRR, the only requirement is that the value and date of the earliest cash flow must be first.

The order of the other cash flows does not matter.

However for your purposes, IMHO, all cash flows must be in date order because you want to calculate cumulative XIRRs.
 
Back
Top