Singapore Stock Picker said... I did try it. But your example did not show what happens when you sell shares. All three only show, when you add capital. I tried to google for the answer to no avail too...
If anyone else has problem you may "google" Uncle8888 for help. LOL
XIRR is a tool to track ROC and it is not a tool to track portfolio. For portfolio tracking, you may need to use a separate worksheet to track it. Suggested sample is as follows:
and then you link "Portfolio Value at Closing Price" back to "Portfolio Value" in XIRR.
Read? Measure, Measure, Measure (3)
I realize that some of you may have problem using CAGR to measure your performance as you may periodically add more capitals into your portfolio.
In this case, you may want to use Microsoft Excel function: XIRR to calculate and return the internal rate of return of ......