I Could Not Believe What This Trading Data Was Showing Me
Data exposed what I was missing
--
I had been trading for almost two years when I finally sat down and did something I had been putting off for months. I exported every trade from my brokerage account into a spreadsheet and started categorizing them. Not just wins and losses. I tagged each trade by setup type, time of day, day of week, market condition, and whether I had followed my stated rules or deviated from them.
It took a Sunday afternoon and a lot of coffee. What the data showed me was so uncomfortable that I almost closed the spreadsheet and pretended I had not looked.
My gut feeling about my own trading was wrong in almost every important way. The setups I thought were my strongest were performing mediocrely. The times of day I preferred trading were among my worst. The trades where I had deviated from my rules thinking I was making smart adjustments were significantly underperforming the trades where I had followed the plan exactly. And the overall win rate I had estimated in my head was about twelve percentage points higher than what the actual numbers showed.
This is the article I wish I had read before spending eighteen months operating on false assumptions about my own performance. It is about what data actually reveals when you look at it honestly and what it means for how you approach the ongoing work of improving as a trader.
Why Traders Carry False Beliefs About Their Own Performance
The human memory is a storytelling machine. It does not record experience neutrally the way a camera would. It edits, emphasizes, and reconstructs based on emotional weight. In trading, this creates a specific and damaging bias.
Wins feel vivid. They get replayed, discussed, and remembered in detail. Losses, especially the ordinary ones that do not trigger a crisis, fade more quickly. They get categorized as part of trading, bad luck, or market noise and then filed away without much examination.
The result is that most traders carry a mental model of their own performance that is heavily weighted toward the memorable wins and underweighted toward the forgettable losses. Ask any retail trader to estimate their win rate off the top of their head and the number they give will almost always be higher than what their actual brokerage data shows. Not because they are being dishonest. Because memory genuinely distorts the record.
Beyond the win rate miscalculation, traders also develop narrative explanations for patterns that do not actually exist. After a run of successes with a particular setup type, that setup becomes a source of confidence that may not be warranted by a complete statistical picture. After a string of failures, traders may abandon approaches that were actually performing reasonably well in the full dataset.
Operating on feelings about performance rather than actual data is one of the most expensive mistakes available to a retail trader. And it is almost universal.
What the Numbers Actually Told Me
The first revelation was about setup type performance. I had been trading three distinct setups over the prior two years. I thought of one of them, a breakout continuation pattern, as my bread and butter. Most of my memorable wins had come from it. I sized it more aggressively than the other two and spent the most time looking for qualifying instances.
The data showed this setup had a win rate of 41 percent with an average winner that was only 1.3 times the size of the average loser. Marginally profitable at best. Not enough edge to justify the confidence I had placed in it and certainly not enough to justify the larger sizing.
My second setup, a pullback-to-structure entry in clear trending conditions, showed a win rate of 58 percent with an average winner nearly twice the size of the average loser. I thought of this as a secondary setup, something I used occasionally when conditions were right. I had sized it conservatively and taken it less frequently than the breakout pattern.
The gap between how I had been allocating attention and capital and what the data showed deserved that attention and capital was significant. I had been systematically undersizing my best edge and oversizing my weakest one. That misallocation had been costing me for almost two years without my awareness.
The third revelation, the one that stung most, was about rule deviations. I had categorized every trade as either rule-compliant or a deviation from my stated criteria. The compliant trades showed a collectively positive expectancy. The deviations, which represented about 23 percent of all trades, showed a negative expectancy substantial enough that removing them from the record would have made the previous two years considerably more profitable. Every time I thought I was making a smart discretionary adjustment, I was statistically making things worse.
Understanding Expectancy and Why It Matters More Than Win Rate
One of the most important things the data exercise taught me was to think about trading performance through the lens of expectancy rather than win rate.
Expectancy is a simple calculation but a powerful one. Multiply the win rate by the average winning trade. Subtract the product of the loss rate and the average losing trade. The result tells you the expected return per trade over a large sample.
A system with a 40 percent win rate can have positive expectancy if the average winner is meaningfully larger than the average loser. A system with a 70 percent win rate can have negative expectancy if the average winner is smaller than the average loser. Win rate alone tells you almost nothing useful about whether a trading approach is viable.
This matters because most retail traders optimize for win rate at the expense of expectancy. They take profits too early to lock in a win. They hold losers too long hoping for a recovery that would turn a loss into a smaller loss or a breakeven. Both behaviors improve win rate in the short term while quietly destroying expectancy over time.
When I looked at the data through the expectancy lens, the trades where I had exited early to secure a small winner were frequently followed by the asset continuing strongly in my direction. I had been cutting flowers and watering weeds, as the old expression goes, because the short-term emotional satisfaction of booking a win outweighed the long-term mathematical value of letting the trade reach its actual target.
Time of Day Patterns That Were Hiding in the Data
The time of day findings were among the most actionable things the spreadsheet produced.
I had always preferred trading in the first hour of the session. More movement, more volatility, more apparent opportunity. The data showed this preference was costing me. My trades in the first thirty minutes of the session had a win rate roughly fifteen percentage points below my trades taken between ninety minutes and two and a half hours after the open.
The reason makes sense in retrospect. The opening period is the most chaotic part of the trading day. Overnight orders are filling. Market makers are establishing their books. News from the prior evening and pre-market is being processed. Price action in this window is often erratic rather than directional and the setups that appear can be quickly reversed by forces that have nothing to do with the technical structure that made the setup look valid.
By mid-morning, that noise has largely settled. Price has established a direction or a range for the day. The setups that appear at that point have a more settled market environment supporting them. They also tend to look less exciting, which is probably why I was gravitating toward the opening hour instead.
Adjusting my trading hours based on this data, shifting focus away from the first thirty minutes and toward the mid-morning window, produced a measurable improvement in the following two quarters. Not dramatic. But consistent with what the historical data had predicted.
The Problem With Trusting Your Own Intuition on Performance
There is a reason experienced traders are so insistent on keeping detailed records. It is not because record-keeping is inherently enjoyable. It is because the alternative is operating on a self-image that the data would often contradict.
Every trader who has done a serious data review has a version of this story. The setup they were most confident in performing worse than expected. The approach they were using defensively turning out to be their actual edge. The time periods, market conditions, or asset types where their performance diverged sharply from their assumptions.
The uncomfortable implication is that without data, a trader cannot reliably know whether they are improving. Periods of profitability might reflect a favorable market environment rather than genuine skill development. Periods of loss might reflect market conditions rather than poor execution. Without breaking the numbers down across enough variables to distinguish between the two, it is very difficult to know what is actually happening.
This does not mean data always reveals clear answers. Sometimes the sample sizes within specific categories are too small to be statistically meaningful. Sometimes genuine market condition changes make historical performance data less predictive than it would otherwise be. These are real limitations.
But imperfect data is still far better than intuition as a basis for evaluating performance. The starting point is always having the data to look at.
What Changed After the Spreadsheet
The practical changes were straightforward once the data made them obvious.
The breakout continuation setup moved to smaller standard sizing pending a longer period of data to establish whether the historical underperformance was structural or a phase. The pullback-to-structure setup moved to the primary focus with the capital allocation to match. Rule deviation trades became the subject of a separate tracking discipline, with each deviation logged and reviewed monthly to understand what was driving the impulse to override the plan.
The time of day adjustment was immediate and easy to implement.
None of these changes required a new strategy or a different approach to the market. They required applying existing resources more honestly based on what the evidence showed rather than what the gut feeling suggested.
Two years of trading had produced a substantial dataset. The dataset had been sitting in the brokerage account the whole time, available, waiting to be examined. The Sunday afternoon I finally looked at it properly was among the most instructive sessions I have had as a trader. What it showed was not what I expected. That gap between expectation and reality is where most of the real learning lives.
📩 Join Investor’s Handbook Digest — get the best investing, markets, and wealth-building insights each week.
