TugatheCat

The View From the Top of the Tree: How to Actually Measure Your Own Return

The View From the Top of the Tree: How to Actually Measure Your Own Return

The short version: your portfolio value is not your performance, and your average buy price is not your return. If you've been adding money at irregular times — which describes nearly everyone — working out how you've actually done requires one specific calculation, and the spreadsheet most people build gets it wrong in a flattering direction.

Tuga climbs the broken apple tree and sits on the high branch surveying the garden, and from up there she can see everything — the whole lawn, the hedge, both shelters, the field beyond the fence.

What that magnificent view tells her about whether she's eaten enough this week is precisely nothing. It's a position, not a record. She can see where she is and has no idea how she got there or whether it went well.

Most people's relationship with their portfolio is that branch. You can see the number. The number is not the answer to the question you're actually asking.

1. The question people think they're asking

"How am I doing?" sounds like one question. It's at least three:

What is it worth now? The easy one. Your app shows it.

What did I put in? Also easy, if you kept records — and this is where the bookkeeping piece stops being abstract.

What return did I earn on it? This is the hard one, and it is not the first number divided by the second.

The reason it's hard: you didn't put the money in all at once. Money added last month has had one month to work. Money added three years ago has had three years. Treating them as equivalent produces a number that is wrong, and — this is the part worth noticing — usually wrong in the direction that feels better.

2. Why "average buy price" misleads

Most people compute their average purchase price, compare it to today's price, and call the difference their return.

That tells you something real: whether you're above or below water. It does not tell you how well you've done, for two reasons.

It ignores time entirely. Turning €1,000 into €1,300 over six months and over six years are wildly different outcomes with identical average-price arithmetic.

It weights by money, not by decision quality. If you happened to make one large purchase at a good moment and many small ones at bad moments, your average looks excellent and your judgement wasn't.

Average buy price is a useful landmark. It's a terrible scorecard.

3. The two proper measures, in plain terms

Money-weighted return (an internal rate of return) answers: what constant annual rate, applied to each contribution from the day it arrived, would produce today's value? This is what your money actually earned, in your hands, with your timing. For someone buying monthly, this is the number you want. Any spreadsheet program will compute it — the function is usually called XIRR and it takes a list of dates and amounts, with today's value as a final positive entry.

Time-weighted return strips out the effect of when you added money, and measures the performance of the asset over the period regardless of your contributions. This is what funds report, because it's the right way to judge a manager who doesn't control the deposits.

The difference between the two is, in effect, a measure of your timing. If your money-weighted return is below the time-weighted one, your contributions landed at worse moments than average. That's not a moral failing — it's information, and it's information almost nobody has about themselves.

4. Setting it up once

Four columns: date, amount in your local currency (negative for money in), what it bought, a note. Add one final row with today's date and your current value as a positive number. Run XIRR over the dates and amounts.

Three details that decide whether the result means anything:

Use your own currency, consistently. For the reasons in the piece about measuring from where you're standing — a return in dollars is somebody else's return.

Include the costs. Fees, spreads and conversion margins are money that left your account and didn't become bitcoin. Leaving them out inflates your result by exactly the amount you'd most want to know about.

Count transfers between your own wallets as nothing. They're not contributions and not disposals. Misclassifying them is the most common error in home-made crypto spreadsheets, and it corrupts everything downstream.

Do it once a year. More often than that and you're measuring noise and inviting yourself to react to it.

5. The uncomfortable half

A precise number invites you to act on it, and that's the real risk. The most likely use of a carefully computed return is to compare yourself to something, feel behind, and change a plan that was working. Measuring is worth doing because an unmeasured position breeds vague fantasy in both directions — but the honest purpose is calibration, not a prompt to trade.

The number flatters volatility badly in both directions. Compute this at the top of a run and you'll conclude you're a genius; compute it mid-drawdown and you'll conclude you're a fool. Neither is a fact about you, and the only defence is computing it on a fixed schedule rather than when you feel like looking.

And the biggest term isn't in the spreadsheet at all. XIRR measures the money you put in. It cannot see the money you didn't put in — the months you skipped, the purchase you talked yourself out of, the position you cut in half after a bad week. For most people those decisions dominate the result, and they leave no trace in the data. That's the behaviour gap, and no formula will surface it for you.

One honest limit of my own advice: I've recommended annual measurement, which means for a long-term holder you'll have about a dozen data points over a decade. That's not enough to distinguish skill from luck in any statistical sense — the same complaint I made about seasonality applies to judging yourself. Measure to stay honest about where you are, not to find out whether you're good at this. You won't find that out.


The whole garden from one branch, and no idea whether the week went well. A position is not a record; if you want to know how you've done, you have to have written it down as you went. 🐾⚡

Did you enjoy this article?


TugaTheCat
TugaTheCat

My name is Tuga and I'm a cat that loves cripto market.


TugatheCat
TugatheCat

Welcome to Tuga the Cat! I am a professional Technical Writer sharing practical advice and daily experiences from raising three adult cats. This blog provides clear, easy-to-follow guides on feline care, behavior, and daily maintenance. Whether you need tips on managing large breeds, optimizing their environment, or choosing the best tech accessories for your pets, you will find well-researched and actionable advice right here. https://www.youtube.com/@TugatheCat

Publish0x Publish0x

Reward the author with $0.01 in crypto, and earn yourself as you read!

20% to author / 80% to me.
Rewards are FREE. Publish0x pays them, not you.

Page not displaying correctly?