R rsd007 Member Oct 31, 2022 #1 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 Help Please. Thanks Attachments XIR Help .xlsx XIR Help .xlsx 9.6 KB · Views: 2
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 Help Please. Thanks
R rsd007 Member Nov 6, 2022 #3 rsd007 said: Hello Any help Click to expand... Further reading Found that XIRR can only work if the dates are oldest to new. So have dropped this idea. Thanks everyone.
rsd007 said: Hello Any help Click to expand... Further reading Found that XIRR can only work if the dates are oldest to new. So have dropped this idea. Thanks everyone.
J joeu2004 Member Nov 11, 2022 #5 rsd007 said: Further reading Found that XIRR can only work if the dates are oldest to new. Click to expand... 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.
rsd007 said: Further reading Found that XIRR can only work if the dates are oldest to new. Click to expand... 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.
