Stop Using Spreadsheets To Track Your Portfolio


Welcome to the first Navexa blog post.
We’re going to use our first expedition into theblogosphere to address a serious, widespread and frankly dangerous problem thatmight be stalking you as you read this.
This is the problem we are on a mission to solve as wedevelop and grow our investment portfolio analytics project.
Its name?
Spreadsheets.
Yeah, I know, they’re so useful and easy to customize…
Maybe you’ve used them for decades…
Maybe you can’t imagine using anything else to keeptrack of your investments, or your personal budgeting.
But, perhaps you don’t know this.
Spreadsheets are dangerous.
In fact, you could say that…
Spreadsheets Are Wealth’s Silent Killers.
If you're using a spreadsheet to keep track of the stocks in your portfolio, listen up.
Ever heard of Bargain Booze?
It’s a discount alcohol chain in the UK.
In 2018, the company that owned Bargain Booze,Conviviality Plc, imploded in a financial mismanagement fiasco.
Take a look…

After three years of rising share prices, Convivialitymade the shock announcement to its shareholders that it needed to raise £125 million to avoid going into administration.
The cause of this fiasco?
A single spreadsheet error.
Someone on Conviviality’s finance team screwed up.
It was a tiny screw up.
But the consequences of that error were, well, referto the chart above.
Now, this is just one (severe) example of what canhappen when we trust spreadsheets with important and complex tasks.
For a long and damning litany of spreadsheet crimes,head over to eusprig.org.
There, you’ll find horror story after horror story of people and businesses — even governments — committing spreadsheeticide and losing mountains of money.
€100 million here. $8 million there.
Aregulatory sanction against a pharmaceutical giant.
Overstatedoil reserves.
Alead witness in a fraud case found dead in Orlando (think I’m joking? Scrolldown to POB1501 on the website).
The point is, using spreadsheets for tracking crucial information is dangerous — and the results can be disastrous.
Why Would You Track Your Portfolio In A Format That Wreaks Such Havoc?
Most self-directed Australian investors have becomecomfortable using spreadsheets to track their portfolio.
They’ve either created their own, or used a templatesome else has set up.
It works for them.
At least they believe it does.
Firstly, because they, or a trusted friend, has set upthe equations in the spreadsheet.
Meaning the calculations the sheet performs to showreturns, income, long-term performance and so on must be correct, right?.
(Hint: Wrong.)
Second, they trust the spreadsheet because they personallyenter the information on each trade.
So again, they figure that must be right.
But if spreadsheet misuse has the power to sink abusiness because of one error…
Cost companies millions…
Trigger damaging legal proceedings…
And even lead to the death of a star witness in onesuch case…
It’s fair to say there’s a clear and present danger tothose who trust spreadsheets to track their investment portfolios.
Danger of what, exactly?
Well, say one of the formulae within your spreadsheetis wrong.
You could have been miscalculating your returns orincome since you started using it.
That might have led you to incorrectly report yourreturns at tax time.
Or, it could have caused you to make a major financialdecision like buying a house or borrowing money because your spreadsheet saidyou had plenty of spare cash in your investment account.
On the other hand, you might have sold out of aprofitable position because your spreadsheet showed poor performance.
Or maybe you mis-valued a company’s shares.
You get the idea.
When the formulae and the data entry are in your humanhands, they are both naturally vulnerable to human error.
And humans make errors all the time.
(Refer to the long list of spreadsheet disasters onthe eusprig website if you’re stillnot convinced.)
Bottom line: Your investment portfolio is tooimportant to trust to a spreadsheet.
That’s why we at Navexa have created…
A Smarter, Safer, More Sensible Way To Track Your Portfolio Without Costly Errors
The evidence shows spreadsheets have caused a litanyof financial and legal disasters.
And those are just the ones we know about.
So, if you’re a self-directed investor and you want totrack your portfolio in a way that not only greatly reduces the risk of humanerror causing havoc in your financial life…
But also gives you a sense of your invested wealththat goes far beyond numbers in a table…
Then it’s time to trade this:

For this:

It’s the second decade of the 21st century.
The spreadsheet was invented last millennium.
So it’s time to start tracking your portfolio in amanner befitting of a modern investor building wealth in the Information Age.
In other words, by using an online portfolio tracker.
Like the one we’ve made — Navexa.
In our opinion, it’s the best portfolio trackingsoftware in Australia.
But we would say that, wouldn’t we?
Of course we would.
So don’t take us at our word.
Make up your own mind.
Create your own Navexa account (all you need is a valid email address).
In place of a clunky spreadsheet that demands anunattainable level of manual data-entry perfection and, frankly, just isn’tthat interesting to look at (its limitations stop you seeing lots of valuableinformation)…
You’ll enjoy advancedportfolio management tools that hand you a commanding overview and a deep,detailed understanding of your invested wealth.
For example…
- Comprehensive Portfolio Performance Reporting: Responsive charts help you track capital gains and income.
- Focused Single Stock & Crypto Analysis: Easily monitor individual stocks and crypto assets.
- Real-Time Dividend Performance Monitoring: Map each dividend payment and chart cumulative income returns over time.
- Comprehensive Tax Reporting: Easily generate reports on capital gains and dividend income when preparing your tax return.
- Benchmark Your Portfolio Against The ASX & ETFs: Easily compare your portfolio performance with the wider Australian market and exchange traded funds.
- Monitor Your Cash Account When You Sell Shares: Navexa monitors your whole portfolio — even when you cash out of a position.
- Calculate A Stock’s Value With Ease: Use your account’s built-in discounted cash flow value calculator to evaluate if a stock is worth buying.
We Want To Help Australian Investors Build Their Wealth In The Age Of Big Data
We believe the era of tracking your stocks with a spreadsheet is over.
Today, it's high time you started using an online portfolio tracker to monitor and analyse your investments.
The reasons are obvious(see above).
The Information Agegives you more data than ever before about your investments, the markets andhow best to plot your course to a wealthier future.
It’s up to you to makethe most of that data.
And it’s up tocompanies like us to help you do that.
Thanks for tuning into this first Navexa blog.