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 an investment. IRR (Internal Rate of Return) is quite close to CAGR as an alternate mean of measuring performance.
I have provided three examples on how to use XIRR when you add more capitals as follows:
Portfolio Value = Current Value of all Stocks at last market closing price + Remaining Cash left for investing