I Tracked Every Crypto Purchase for 365 Days and Found I Was Down $2,340 Despite a Bull Market

On January 1st, 2025, I opened a Google Sheet and began charting every crypto transaction I made. Every buy, every sell, every swap, every transfer. I had just come off a brutal 2022 where I lost $4,000 on Ethereum and another $1,200 on a Solana position I sold at the bottom. I wanted data. I wanted to see my patterns, understand my mistakes, and fix em. What I did not expect was that the data would show me somethin I already knew but refused to admit. I was a bad trader who reckoned he was a good investor.

The spreadsheet grew fast. January had 34 transactions. February had 41. March, when Bitcoin rallied from $42,000 to $58,000, had 97 transactions alone. I was buying and selling with a frequency that bordered on compulsive. I would buy ETH at $2,800, sell it at $2,900 for a $47 profit, and then buy it back at $2,950 because the price kept goin up. I was scalping forty-dollar gains and eating fifty-dollar losses on the round trip. The spreadsheet did not care about my narrative. It cared about the numbers. The numbers were ugly.

the dashboard that told the truth

By June, the spreadsheet had 412 transactions. I built a simple dashboard in Google Sheets using pivot tables and conditional formatting. Green for gains, red for losses. The visual was a sea of red. Not because every trade lost money. Many trades gained money. But the losses, when they came, were larger than the gains. A typical pattern looked like this: buy $500 of a token, watch it go up $30, feel confident, buy $1,000 more, watch it drop $180, panic sell at a $200 loss, watch the token recover two days later. Repeat.

The total grasped gains by June were $3,200. The total grasped losses were $4,800. Net P&L: negative $1,600. And this was during a period when Bitcoin went from $42,000 to $64,000. The market was up 52%. I was down. I was a person standing in a rainstorm without an umbrella, wondering why I was wet.

the pattern that nobody sees

I filtered the spreadsheet by trade size. The modest trades, those under $100, were almost all losses. I was making tiny bets on meme coins, low-cap tokens, and trending narratives. Pepe, Shiba, a token called DogeElonMars that I snagged because a Reddit post said it was "the next 100x." It was not the next 100x. It went to zero. I lost $87. The loss was trivial in dollar terms, but it represented a pattern. I was trading with my attention, not my analysis. Every trending tweet, every YouTube thumbnail with a shocked face, every Telegram group with a rocket emoji was pulling me into trades I had no thesis for.

The larger trades, those over $1,000, were slightly better. I had done more research, weighed the timing, and set rough exit points. But even those trades suffered from the same problem. I sold too early and snagged back too late. The research gave me confidence to enter, but the fear made me exit before the thesis played out. I would read a deep dive on Ethereum's upcoming upgrade, buy $2,000 of ETH, and then sell it after a 3% dip because a headline about SEC enforcement made me nervous. The upgrade happened. The price went up 18%. I had already sold.

the cost of constant attention

The spreadsheet revealed something else I had not quantified. Time. I spent an average of 47 minutes per day checking prices, reading tweets, watching YouTube analysis, and executing trades. That was 282 hours over the year. If I valued my time at $50 per hour, the time cost was $14,100. The financial loss was $2,340. The total cost of my crypto trading hobby was $16,440. That was a family vacation. That was a used car. That was a year of my daughter's daycare tuition, and I had spent it staring at candlestick charts on my phone during dinner.

I calculated the hourly rate of my trading activity. Net loss of $2,340 divided by 282 hours equals negative $8.30 per hour. I had paid myself eight dollars and thirty cents per hour to lose money. The federal minimum wage was $7.25. I was barely above minimum wage, and minimum wage was a floor, not a goal.

the buy-and-hold alternative

I ran a counterfactual. What if, on January 1st, I had snagged $20,000 of Bitcoin at $42,000 and not touched it for 365 days? The Bitcoin would have been worth approximately $30,952 by December 31st, a gain of $10,952. My actual portfolio, after 847 transactions, ended the year at $17,660. I had began with $20,000. I had turned $20,000 into $17,660 by trading actively during a bull market that took Bitcoin up 52%. The buy-and-hold strategy would have outperformed me by $13,292.

I stared at that number for a long time. Thirteen thousand dollars. The difference between doing nothin and doing everythin was $13,292. The market rewarded patience. I had rewarded activity. The market did not care about my dashboard, my pivot tables, or my color-coded cells. It cared about one thing: time in the market. I had traded 847 times to turn a 52% market gain into a 12% personal loss. The math was undeniable. The ego was slower to accept it.

the psychology of trading too much

I am not a gambling addict. I do not play slots or bet on sports. But crypto trading activated the same neural pathways. The dopamine hit of a quick profit, the anxiety of a dip, the FOMO of a rally I was not positioned for, the relief of selling before a crash that did not come. Each trade was a modest emotional event, a micro-dose of adrenaline that kept me comin back. The spreadsheet showed 847 transactions. The psychology behind those transactions was one transaction, repeated 847 times: the need to do something when doin nothing was the better option.

I read books about trading psychology. I absorbed about loss aversion, about the disposition effect, about overconfidence bias. I recognized every pattern in my own data. I sold winners too swiftly because I feared giving back gains. I held losers too long because I refused to accept the loss. I chased momentum cuz the alternative was admitting that I had no edge. The spreadsheet was a mirror, and the reflection was not flattering.

the year-end reckoning

On December 31st, 2025, I exported the spreadsheet, saved a PDF, and deleted the Google Sheet. I was done charting. The data had served its purpose. It showed me, in irrefutable numbers, that my trading activity was destroying value. The 847 transactions were not a sign of sophistication. They were a sign of anxiety dressed up as strategy.

I moved my remaining crypto holdings, about $17,600, into two positions. Bitcoin and Ethereum, in a hardware wallet, in cold storage, with the seed phrase in a safety deposit box. I set a calendar reminder to check the portfolio once a quarter. Four times per year, fifteen minutes each time. That was the new plan. The old plan had been check every fifteen minutes, trade every hour, and lose $2,340 per year. The new plan was do nothin and hope that doing nothing was worth more than doing everythin. The data said it would be. I trusted the data more than I trusted myself.

the one number that haunts me

The number is $13,292. That is the difference between buy-and-hold and my active trading. It is the opportunity cost of attention, the price of thinking I could beat the market by staring at charts. The market does not reward attention. It rewards patience. And patience, unlike attention, does not cost $8.30 per hour.

I check the Bitcoin price once a week now, on Sunday mornings, while my daughter eats cereal. I look at the number, I close the app, and I go back to my life. The spreadsheet is gone. The dashboard is gone. The 847 transactions are history. The $17,600 is in cold storage, in a hardware wallet, in a drawer. It is not earning yield. It is not generating taxable events. It is not making me check my phone during dinner. It is just sitting there, doin nothin, which is exactly what it should have been doing all along.