Data-driven investing

You have an investment strategy of some sort. But is it succeeding — and how do you know? Even if you’ve already been investing for some years, the information you need will still be available.

The content of this article was relevant at the time of publishing. Circumstances change continuously and caution should therefore be exercised when relying upon any content contained within this article.

artificial intelligence investing algorithms

Image source: Getty Images.

When investing, your capital is at risk. The value of your investments can go down as well as up and you may get back less than you put in.

Read More

The content of this article is provided for information purposes only and is not intended to be, nor does it constitute, any form of personal advice. Investments in a currency other than sterling are exposed to currency exchange risk. Currency exchange rates are constantly changing, which may affect the value of the investment in sterling terms. You could lose money in sterling even if the stock price rises in the currency of origin. Stocks listed on overseas exchanges may be subject to additional dealing and exchange rate charges, and may have other tax implications, and may not provide the same, or any, regulatory protection as in the UK.

You’re reading a free article with opinions that may differ from The Motley Fool’s Premium Investing Services. Become a Motley Fool member today to get instant access to our top analyst recommendations, in-depth research, investing resources, and more. Learn More.

Next year, I turn 70.

Not entirely coincidentally, this year has seen something of a focus on fitness.

I bought a Fitbit, and started tracking and targeting my daily step counts. Fairly regularly, I do a particular coastal walk a few minutes’ drive away, timing myself over a specific route. And recently, I’ve joined an informal running group, timing myself over a 5K distance.

Central to all these activities — well, apart from doing them in the first place — has been a process of data collection and analytics.

Fitbit makes it easy: you can download your personal statistics in spreadsheet format, which makes charting your progress very straightforward. My regular walks have become faster, and easier. They may yet turn into runs. And looking at the 5K data, progress is discernible.

It’s what I do. It’s how I think. And it’s how I approach targeted improvements in other areas — such as our household’s electricity consumption, for instance.

Data driven

You won’t be surprised to learn that I take the same data-driven approach to investing. Indeed, readers with long memories will perhaps remember me mentioning spreadsheets and charts in previous columns.

And it’s an approach I’ve seen taken by other investors, too — some with multi-decade investing experience behind them.

What do they track? What do I track? Whatever we want, in short. Whatever suits our own investment circumstances and strategies, in other words. That’s the beauty of a spreadsheet-driven approach, as opposed to a tool such as Microsoft Money, or one of the proprietary portfolio-tracking tools that are out there.

Nor is the use of the word ‘strategies’ in the paragraph above without significance. I firmly believe that investing should be strategy-directed, and have some of goal in mind. In which case, it is only rational to measure progress towards achieving that goal.

Data that I capture

It’s no secret that these days I’m an income investor. And so, since 2005, my primary spreadsheet has been income-focused, measuring my progress in building up an investment income from a portfolio of individual shares.

The first ‘tab’ in the spreadsheet records progress within a given year: total new cash added, total dividends received, net share purchases, cash at year-end, and some columns of totals designed to inform a number of yield calculations: equity valuation, total new cash, and total bought cost.

Fairly obviously, then, I’m capturing yield as a percentage of equity valuation, yield as a percentage of new cash invested, and yield as a percentage of bought cost. Another column — and probably the least important one — captures profit against the year-end valuation. Finally, a column captures noteworthy comments of the year in question, and I also capture total annual dividend payments by company.

And, as I say, I have all that data and analysis going back to 2005.

Passive income stocks: our picks

Do you like the idea of dividend income?

The prospect of investing in a company just once, then sitting back and watching as it potentially pays a dividend out over and over?

If you’re excited by the thought of regular passive income payments, as well as the potential for significant growth on your initial investment…

Then we think you’ll want to see this report inside Motley Fool Share Advisor — ‘5 Essential Stocks For Passive Income Seekers’.

What’s more, today we’re giving away one of these stock picks, absolutely free!

Get your free passive income stock pick

A further tab displays and charts the timetabled payments of dividends throughout the year, to aid in planning. Another tab tracks a detailed sectoral breakdown, to aid in maintaining diversification and balance. A further tab records the total portfolio. And a final tab records every transaction, so that I could — if I wished — run a pivot table against it. So far, I’ve never wished to, it has to be said.

Steady as you go

So how am I doing, in terms of investment performance?

Thanks to the spreadsheet, I know. Objectively, not subjectively. Factually, and with real clarity.

Dividend income has increased, year on year. Yield on bought cost is satisfactory. Yield as a percentage of equity valuation fluctuates as capital values fluctuate, but is also satisfactory. And capital values have fluctuated — but then, global financial crises, pandemics, and unexpected national referendum outcomes tend to have that effect.

In other words, steady as you go. I have an investment strategy, and my spreadsheet tells me that it’s working reasonably well.

Other spreadsheets track other aspects of my retirement income planning. Overall, I’m holding the planned course.

Equities still win out

But should you even bother? Granted, retail investors are waking up to these opportunities. But from what I’ve read, it’s wealthier, more sophisticated investors, often with prior bond market experience.

Better by far, I think, is to stick with equities. Plenty of UK blue-chips yield more than bonds and gilts, and also offer capital upside.

Last time I looked, the FTSE 100 was trading on a price-to-earnings (P/E) ratio of 13, and the FTSE All-Share a P/E of 14. America’s S&P 500? 20. The broader Russell 2000? 25.

I know where I see the greater prospect of an upwards re-rating.

Why not?

Perhaps you already have such a spreadsheet, designed to suit your own particular needs. I know lots of investors do.

But perhaps you don’t already have a such a spreadsheet — and I know lots of investors don’t.

“It’s too late,” I hear you say. “I started investing several years ago. I’m not sure that I’ve kept all the paperwork.”

No matter: every investing platform that I know of keeps records of investors’ trades — even if they’ve since moved their investments elsewhere. The information is out there, and you can access it, and build your spreadsheet, just as if you’d maintained it right from the start of your investing journey.

Don’t have Microsoft Office? There are alternatives, such as Libre Office. And even a free, online version of Microsoft Excel, maintained by Microsoft.

If the will is there, the means are there. What have you got to lose?

This AI stock is becoming a digital juggernaut in a £ 12.5 billion market!

🤖 Curious about the next big player in AI? 🤖

Our leading industry analysts have uncovered a trailblazing content platform that's revolutionising the industry with its unparalleled generative AI technology, setting new standards in creativity and efficiency.

Care for a sneak peek?

Trusted by global giants like Amazon, Disney, and Netflix, this innovative company is not just transforming digital media with AI-generated 3D content but is also capturing a significant share of a £12.7 billion market!

With a remarkable 62% gross margin, indicating exceptional profitability and operational efficiency, this company's growth trajectory positions it as a must-watch for savvy investors.

Best of all, we're offering exclusive access to the name of this game-changing stock, absolutely free!

Discover your free AI stock pick

Should you invest, the value of your investment may rise or fall and your capital is at risk. Before investing, your individual circumstances should be assessed. Consider taking independent financial advice.

More on Investing Articles

Investing Articles

Up 10% in a month! Is the abrdn share price set for the biggest comeback since Lazarus?

The Abrdn share price has been through hell but now there are signs that it may be coming back again.…

Read more »

Three signposts pointing in different directions, with 'Buy' 'Sell' and 'Hold' on
Dividend Shares

Can the Rolls-Royce share price be a top performer again in 2025?

The Rolls-Royce share price has been flying high, but can it keep soaring? Ken Hall has his say on the…

Read more »

A Black father and daughter having breakfast at hotel restaurant
Investing Articles

Should I eat some humble pie and buy Tesla stock?

After being wrongly bearish on Tesla stock last year, this investor is left wondering if he should just bite the…

Read more »

Concept of two young professional men looking at a screen in a technological data centre
Investing Articles

After falling 6% in a week, should Microsoft be on my list of stocks to buy?

With OpenAI being surpassed by DeepSeek’s cheaper and more powerful LLM, is now the time for investors to consider buying…

Read more »

Investing Articles

Up 7%! Here’s 1 AI growth stock that had a surprisingly good week!

As the world of AI has been rocked by a small startup in China, one former growth stock might have…

Read more »

Dividend Shares

Which FTSE 100 bank stock is the best value right now?

Ken Hall looks at which FTSE 100 bank stock is his top value pick after a stellar past 12 months…

Read more »

Investing Articles

Is it game over for the GSK share price?

Harvey Jones isn't having much fun playing the GSK share price game. The FTSE 100 pharmaceutical stock must work hard…

Read more »

Investing Articles

Down 45% in a year, is the Ocado share price about to soar?

Christopher Ruane explains why the Ocado share price is down -- and sets it in a wider context as a…

Read more »