I Tracked My Crypto Portfolio for a Year — Here's What the Numbers Taught Me

I opened a spreadsheet on January 3rd last year with a simple goal: stop guessing how much my crypto was actually worth. Not the number on the exchange dashboard — that dopamine hit of a portfolio total that looks different depending on which currency you're viewing it in — but the real number, in the currency I actually spend at the grocery store.

Twelve months, 365 rows, and somewhere north of 600 manual currency conversions later, I have opinions.

Why I Started Doing This Manually

I'll be honest: it started from embarrassment. A friend asked me over dinner how much I'd made on Ethereum that year. I said "a lot." He pushed — how much exactly? I genuinely didn't know. I'd been watching the ETH price in USD but I live in the UK. My rent is in pounds. My salary is in pounds. The number on Coinbase was a fiction until I converted it, and I'd been avoiding that conversion because some part of me knew the exchange rate hadn't been kind.

That dinner was the nudge I needed. The next morning I set up a Google Sheet with five columns: date, asset, amount held, price in USD, and price in GBP. Every weekday morning, I'd pull the conversion rate — usually from a money converter tool I bookmarked — and log it before I looked at anything else.

Within two weeks, I noticed my first uncomfortable truth.

The Illusion of Dollar Gains

Between January and March, Bitcoin climbed roughly 40% in USD terms. My portfolio looked fantastic in the app. But GBP/USD moved during the same period — the pound strengthened slightly against the dollar — which meant my actual sterling gains were closer to 31%. Still good, obviously. But not the same story.

This gap between "how it looks" and "how it actually is" became the central theme of my year. Every crypto investor I know talks about prices in dollars by reflex, even those of us who've never lived in America. It's the lingua franca of the space. But it's a translation that costs you money if you ignore it.

I started using a proper currency converter every single morning instead of relying on the exchange's built-in conversion (which, I discovered, often uses slightly delayed or slightly unfavorable rates compared to live mid-market rates). The difference on any single day is negligible — sometimes less than 1%. Compounded over a year of tracking actual entries and exits, it started to matter.

The Habit That Changed Everything: "Real GBP Day"

Around week six, I added a new column: "Real GBP Day." Once a week, usually Sunday, I'd calculate what my portfolio would actually net me if I sold everything that morning, accounting for the live GBP/USD rate, estimated exchange fees (typically 0.5–1.5% depending on platform), and a rough tax estimate based on my capital gains position that year.

That number — the after-everything, spend-it-today number — was almost always smaller than what the apps showed. Sometimes 8% smaller. Once, during a volatile week in August, it was 14% smaller because crypto had dipped, the pound had weakened, and Coinbase's spread was wider than usual.

Seeing that number weekly made me a calmer investor. Not because I became pessimistic, but because I stopped treating paper gains as real money. I had a visceral, weekly reminder that gains only exist once they're converted, transferred, and settled in your bank account.

What the Numbers Actually Showed

By April I had enough data to spot patterns. A few that genuinely surprised me:

Monday mornings were historically my worst time to convert. I have no rigorous explanation for this — crypto doesn't follow traditional market hours — but in my dataset, the GBP/USD rate Monday morning was marginally less favorable more often than other times. Could be noise in 12 months of data. Could be genuine weekend liquidity effects. Either way, I started doing any meaningful conversions on Wednesday or Thursday.

Altcoins looked better in USD almost every time. The coins further down the market cap list tend to be priced and discussed in USD even more exclusively than Bitcoin. When I converted my Solana and Chainlink holdings to GBP, the psychological effect was deflating in a useful way — it made me more conservative about position sizing in smaller assets because the "real" number in my own currency always felt humbler.

My cost basis in GBP was wildly different from my cost basis in USD. I'd bought some ETH in late 2022 when the pound was under significant pressure (post-mini-budget chaos, if you remember that period). The rate at purchase was around 1.10. By the time I was logging seriously, it had recovered toward 1.27. This meant my GBP cost basis was actually lower than it appeared in USD terms, making my real returns better than my dollar-denominated tracking would have suggested. A rare pleasant surprise.

The Tool Question

I cycled through a few different money converter tools over the year. My main criteria were simple: live mid-market rates, historical rate lookup (crucial for cost basis calculations), and the ability to quickly do multi-currency conversions when I was thinking about moving between assets priced in different base currencies.

I ended up settling into a rhythm of using two tools. One for quick spot checks — the kind you can do in 15 seconds from a browser tab — and one with historical data that let me look up what the rate was on a specific date in 2022 when I made a purchase. That historical function is underrated. Your tax calculation is only as good as the exchange rate you use on the date of acquisition, and "I think it was around 1.15" isn't going to fly with HMRC.

The Psychological Lessons Were Bigger Than the Financial Ones

Here's the thing I didn't expect: doing this made me care less about daily price movements, not more.

I thought tracking obsessively would turn me into someone who refreshed prices every hour. The opposite happened. Once I had a system and a weekly "real number," the noise between Sunday and Sunday stopped feeling important. I knew what my position was. I knew roughly what it would be worth if I sold. I didn't need to know what it was worth at 2pm on a Tuesday.

It also clarified my actual investment thesis. When you strip away the dollar-denominated euphoria and see your holdings in your spending currency, you ask different questions. Not "is this coin going up?" but "at what GBP price would selling this make a meaningful difference to my financial situation?" Those questions have real answers. They lead to real decisions, not just vibes.

I sold a chunk of my Bitcoin in September — not because of any particular market signal, but because my Sunday number crossed a threshold I'd set at the start of the year. That threshold was in GBP. It represented a specific thing: clearing the remaining balance on a loan. I hit it, I converted, I transferred, I paid off the loan. The system worked exactly as designed.

What I'd Do Differently

Log staking rewards and airdrops more carefully from day one. These have a taxable value in GBP at the moment of receipt, and I was sloppy about this for the first four months. Reconstructing those conversion rates retroactively was tedious.

Also: track fees separately from the start. Every conversion, every withdrawal, every network fee — these should be their own column. They're deductible in many cases, and they add up to more than you think. My total fee spend last year, once I finally tallied it, was enough to make me genuinely reconsider how often I was moving things between wallets.

The One-Line Summary

Crypto is priced in dollars. Most of life is not. Every number you see in an exchange app is one conversion away from reality, and that conversion matters more than most investors bother to track.

The habit of converting daily — methodically, with actual live rates, into the currency you spend — won't make you richer by itself. But it will make you more honest about whether you're actually building wealth or just watching numbers that feel good.

For me, that honesty was worth every one of those 600 manual lookups. I'd do it again.