I’ve created a spreadsheet that analyzes the total return of my portfolio in various ways. Among the metrics: A graph that tracks the annualized rate of return. For example a year ago the portfolio had an annualized return of about 6.7%. Now it’s around 8%. The figure changes slightly each day and produces an interesting line graph. I haven’t seen this type of graph (showing daily updates to annualized return) elsewhere and wonder if that is because it really is nonsense. Here’s why. One year after inception, if the portfolio gained 1% on a particular day, the annualized return also rose 1%. But now after three years, if the portfolio gains 1% in a day the change to the chart is maybe 1/3 of that. The sensitivity of the chart to the data is not constant. Doesn’t that invalidate the whole chart?


If you think about it, that makes sense because the older your portfolio is, the less that new data points are going to affect the lifetime average. If a portfolio is relatively flat for a year then jumps 1% on the last day of the year, then the portfolio would have a 1% gain for the entire year. If the portfolio is flat for 3 years then jumps 1% ,then the annualized return would be 1.01^(1/3) = ~0.33% per year. So the math checks out.

If you instead look at a rolling 1-year performance chart then the sensitivity to new data would be constant.

But whether that's valuable or not depends on what you do with that information. How is that going to change what you invest in, or whether you lock in some gains, sell off (or double up on) some losers, etc.

  • Yes, it makes sense mathematically. But I wonder if this chart I’ve created is not the sort of metric a pro would use to analyse a portfolio’s performance, due to its changing sensitivity to the data. And if that is the case, is there a better way to track annualized return on a daily basis? – Jim V Nov 27 '19 at 17:58

You analyze data in a variety of ways in order to give you insight into performance and hopefully, to help you make better decisions. In this case, it doesn't matter whether it's a 3 week or a 3 year graph as long as it provides information that you find useful.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.