Hello,
I am trying to calculate the XIRR for a set of stocks in my portfolio. I would like the XIRR to be calculated and shown in a summary table where I can also see the Net Asset Value (NAV) as of today. The trades are stored in a separate table where I update as I add a new position to my holdings. Both the stocks themselves and the trades will be constantly expanding and changing so I would like the formula to take this into account. This also makes it not feasible to have the "closing balance" stored at the end of the table to allow the XIRR to calculate properly. Attached is a spreadsheet which shows what I am trying to achieve. This is a followon from https://chandoo.org/forum/threads/calculatingxirroncertainentriesinalist.39636/
Ideally, I would like to append a value to an array of calculated values, something like: {values calculated by a formula; value I reference from another cell}
Thank you Haz and Somendra Misra for your help so far.
I am trying to calculate the XIRR for a set of stocks in my portfolio. I would like the XIRR to be calculated and shown in a summary table where I can also see the Net Asset Value (NAV) as of today. The trades are stored in a separate table where I update as I add a new position to my holdings. Both the stocks themselves and the trades will be constantly expanding and changing so I would like the formula to take this into account. This also makes it not feasible to have the "closing balance" stored at the end of the table to allow the XIRR to calculate properly. Attached is a spreadsheet which shows what I am trying to achieve. This is a followon from https://chandoo.org/forum/threads/calculatingxirroncertainentriesinalist.39636/
Ideally, I would like to append a value to an array of calculated values, something like: {values calculated by a formula; value I reference from another cell}
Thank you Haz and Somendra Misra for your help so far.
Attachments

18.4 KB Views: 17