Calcalutor, paper and tax calculations

How To Measure Your Portfolio Performance

Measuring the performance of your portfolio can be a little tricky in practice. Having experimented with a few methods, I’ve now settled on a mixture of Google Sheets to provide an up-to-date valuation and a simple unitisation calculation to measure my portfolio performance.

It’s not a fully automated process, but as measuring your portfolio performance is something you might only do each month, quarter or year, it shouldn’t be too onerous.

Using this method, you also need to do a valuation whether you add or remove cash from any of your investment accounts, so that might increase your workload a little depending on your investment strategy. I think of it as an added incentive to reinvest your dividends rather than spending them!

Why measure at all?

In my case, it is to answer the question “have I beaten the market?” and the follow up of “do I need to change my investing strategy?”

I have some passive funds, but most of my holdings are active (indeed pretty much all investment trusts are actively managed). All the evidence points towards the fact that the vast majority of active funds don’t beat their benchmarks over time.  So, by choosing the active route, you are explicitly making the statement that your own portfolio performance can beat that of the market. You think you can be the exception. Some people might say you’re full of it.

In my case, I have to admit I also enjoy the intellectual challenge of picking different funds and all the analysis that comes along with it. But, were I to find that over a decent period of time that my portfolio performance was lacking, I’m hoping that I wouldn’t be too proud to admit defeat and put all my cash in global trackers and lifestyle funds.

Enter Google Sheets

Portfolio tools on various websites seem to come and go. And while they can tell you what investments are worth, they don’t tend to track your portfolio performance very well.

For a while I’m been using Google Sheets, rather a website-based portfolio tool. It’s free and you can build other tables of financial information around it as you see fit.

Google Sheets is very similar to Excel in many ways. With the Google Finance function it’s pretty simple to build your own portfolio tool. You can then add extra information, such as dividends and position sizes as a percentage of your portfolio.

Here’s a screenshot showing some information for a couple of investment trusts that I hold.

Screenshot of Google Sheet to measure portfolio performance

And here are the formulas I’ve used to create that.

Screenshot of Google Sheet to measure portfolio performance, showing formulas

You should be able to click on these images to enlarge them. You just need to enter the number of shares and the expected or historical dividend per share (columns F and H in my example) and the spreadsheet should do the rest.

There are loads of different Google Finance attributes you can use rather than price, although I’ve found many of them only have data for US stocks. But for the simple purpose of tracking your portfolio’s value and income, it should suffice.

What to compare your portfolio performance to?

I think the main choice here is whether to measure your portfolio performance against the UK market (with an index like the FTSE All-Share) or the global (something like FTSE All-World or MSCI World). For simplicity, I use the UK market for now, but I suspect I might add a global index soon as well, as that better reflects my portfolio.

One thing to watch out for is that most indices are quoted without the returns from dividends. So, you need to look for the Total Return versions to make a proper comparison. One of the reasons I measure myself against the UK market is the relative ease of getting the Total Return values for the FTSE All-Share. It’s worth noting that most Total Return indices are only updated after the close of each day.

Setting up the unit calculations

These are actually pretty simple. Once you have decided on an index to compare yourself against you can set up a spreadsheet. In the tables that follow the figures in red are the ones being calculated from the other variables.

DatePortfolio valueUnit priceUnitsIndexIndex price
1 Jan 2018£125,000100.001,250.007,265.66100.00

For ease of comparison, I set both my starting portfolio unit price and that of the index to 100.0. So the only calculation required is for the starting number of units, which is 125,000/100 = 1,250.

Adding or taking out cash

At the start of the tax year, let’s say I added some cash to my ISA. The first thing to do is another valuation. I get the figure from my Google Sheet and look up the latest FTSE All-Share Index Total Return value from the FTSE website.

DatePortfolio valueUnit priceUnitsIndexIndex price
6 Apr 2018£120,71296.571,250.006,890.3594.83

The number of units stays the same, but the new unit price is 120,712/1,250 = 96.57. A fall of 3.5% then, not a great start to the year!

However, the UK market has done a little worse. 6,890.35/7,265.66 = 94.83, which is a drop of 5.2%.

Let’s assume I added £5,000 of cash to my ISA on 6th April. Although I had that cash in my bank account, it only gets included in these calculations when I add it to an investment account.

DatePortfolio valueUnit priceUnitsIndexIndex price
6 Apr 2018£125,71296.571,301.776,890.3594.83

The new number of units is 125,712 / 96.57 = 1,301.77. The unit and index prices remain unchanged.

And that’s all there is to it

Simply repeat this process every time you want to do a valuation or decide to add or take money out.

If you spend all your dividends or invest through numerous monthly schemes, then you could be making several calculations a month. I think it’s acceptable to bundle a few transactions together for the purpose of these calculations. So if you invested £500 but withdrew £750 a week later, you just count that as one withdrawal of £250. Obviously, the larger these amounts relative to the size of your portfolio, the more precise you should probably be.

I’ve only been using this method since 1 January 2018 and it’s been relatively painless so far. So far, I’m ahead of the market this year by 2.8%. My arrogant belief in my investing abilities remains intact! But who knows what the future holds.

Subscribe to IT Investor

Get an email alert every time I publish a new article. Your email address won't be used for anything else.

Spread the word...

2 Replies to “How To Measure Your Portfolio Performance”

  1. Hello IT Investor.

    I bumped into this page by chance. Yours is one of the rare pages that shows how one can monitor their portfolio on a real-time basis. Quick question for you: Do you also type in buy/sell/ divi reinvestments? (Not sure how the s/sheet above will cope up with that)


  2. Hi Iamwhatuthinkiam,

    I just use the overall valuation at any given point in time, so I don’t separately account for buys, sells, or dividends as they are effectively included within my overall valuation already. So I only adjust the number of units when I add new cash to my broker account or take any money out of it.

    Since I wrote this piece I’ve also added an IRR measure on a spreadsheet as an additional measuring point. There’s a good piece by UK Value Investor on the merits of the two:

    Hope that’s useful.

Leave a Reply

Your email address will not be published. Required fields are marked *

Copyright © 2018-2024

Disclaimer: This site is for informational purposes only. We make no assertions as to the accuracy, completeness, suitability or validity of anything on this site.
We will not be liable for any errors or omissions or any damages arising from its display or use.

Here's our privacy and cookie policy.