Tradebook Analysis: What Your Trade History Actually Shows

Your P&L tells you the result. Your tradebook, read in order rather than as a total, tells you the decisions that produced it. Here is what is genuinely in that file, and what is not.

RiskoraUpdated 2026-08-21Behavioural trading research

Tradebook analysis means reading your executed trades as a sequence of decisions rather than as a column of profits and losses. The file your broker gives you already contains the timestamps, quantities and instruments needed to do it. Most traders never read it that way, because a spreadsheet sorted by date looks like bookkeeping rather than a description of their own behaviour.

The distinction matters because two traders can lose the same amount in a month for completely different reasons. One took eight planned trades and the market went against them. The other took forty, half of which were placed within minutes of a loss. The P&L line is identical. The behaviour is not, and only one of the two has something they can actually change.

What is actually in a tradebook

A tradebook is a record of executed trades. For each fill it typically carries the instrument, whether you bought or sold, the quantity, the price, and a timestamp. Some broker exports add order IDs, charges or segment codes.

That is a narrow set of columns, and the honest starting point for any analysis is that it bounds what can be concluded. Everything below is derived from those fields and nothing else.

Step one: pair the fills into round trips

Raw fills are not trades. A single position may be built from three buys and closed with two sells, and a tradebook lists all five as separate rows. Before anything can be measured, fills have to be paired into completed round trips, first in first out, per instrument.

This is where hand analysis in a spreadsheet usually stops being practical. Scaling in, partial exits and direction flips all have to be handled, and positions still open at the end of the file have to be excluded, because a trade that has not closed has no outcome to analyse yet.

Step two: the five things worth measuring

Once you have round trips in time order, a handful of measurements do most of the work. Each one compares you against your own history, not against an external benchmark, because there is no universal correct number of trades or holding time.

The gap between a loss and your next entry

Take the time from each trade closing to the next one opening. Split those gaps into two groups: the ones that followed a loss and the ones that followed a win. Compare the medians. If you waited a median of three minutes after losses and eighteen after wins, that difference is a fact about your behaviour that no amount of remembering could have given you. This is usually the single most recognisable number in the whole exercise. It is covered in detail in what happens in the minutes after a loss.

Position size after a loss

Compare the size of each entry against your own recent average. Riskora flags an entry placed straight after a loss at 1.3 times or more of that average. Size is the one component of a trade that is entirely under your control, so a change in it following a particular outcome is a behavioural change rather than a market one.

Trades per day against your own baseline

Count trades per calendar day, take your median, and add a margin for normal variation. Riskora uses your median plus 1.5 standard deviations, with an absolute floor of 6 trades so a quiet trader is never flagged for a slightly busier session. The number that tends to surprise people is not how many days cross the line, but what share of all their trades happened on those days. More on the method in the guide to measuring overtrading against your own baseline.

Holding time on winners against losers

Average how long losing positions stayed open and compare it to winning ones. Holding losers materially longer than winners is one of the most widely documented patterns in behavioural finance, and one of the hardest to notice in yourself without measuring it. Riskora flags the ratio at 1.5 times or above.

Where the losses actually sit

Rank your trading days by how much they lost and accumulate until you reach 80% of your total losses. The answer is often a startlingly small number of days. That reframes a bad quarter from a steady drip into a few specific sessions, which are far easier to think about and far easier to prevent.

What tradebook analysis cannot tell you

• Your intent. The file shows that your next entry came ninety seconds after a loss. It cannot tell you what you were thinking, and any tool that claims to read your emotional state from a CSV is overreaching.
• Stops and resting orders. These do not appear unless they filled. Stop-widening is therefore not measurable from a tradebook at all.
• The trades you did not take. Sometimes the most disciplined decision of the week leaves no record.
• Context. A hedge, a news event or a deliberate strategy change all look like ordinary rows.
• Anything about the future. These are descriptions of what already happened, not predictions.

One practical limitation is worth knowing before you export anything: some broker reports carry the date but not the intraday time. Angel One's "Trades and Charges" report is the common example. Without clock times, gaps, holding times and the order of trades within a day cannot be computed at all, though day-level measures like overtrading and loss concentration still work. The Angel One guide covers which report to pick.

Running it on your own file

1. Export your tradebook from your broker, not your P&L or capital gains statement. Those are aggregated per stock and contain no individual trades. Guides for Zerodha, Upstox, Groww, Dhan and Angel One.
2. Pick a period long enough to contain a drawdown. A calm month will show you very little, because most of these patterns only appear under pressure.
3. Pair the fills into round trips, then sort by entry time.
4. Measure the five things above, each against your own baseline rather than a rule of thumb.
5. Look at the individual trades behind any finding before you accept it. A pattern you cannot audit is a claim, not a measurement.

Steps three and four are tedious by hand and are exactly what Mirror automates. It reads the file in your browser, pairs the round trips, and reports each pattern with the trades behind it. Everything it uses is published in the full scoring methodology, so you can recompute any number yourself and disagree with it.

Common questions

What is the difference between a tradebook and a P&L statement?

A tradebook has one row per executed trade, with a timestamp. A P&L or capital gains statement has one row per stock with averaged buy and sell prices. Behavioural analysis needs the individual trades and their times, so a P&L statement cannot be used for it.

How many trades do I need before the analysis means anything?

Behavioural signals need a reasonable sample. Riskora flags a Discipline Score as low confidence below 5 closed round trips and withholds rupee figures entirely below 30 trades, because a money figure from a dozen trades reads as more certain than it is.

Can I do tradebook analysis in Excel?

The day-level measures yes, reasonably easily. Pairing fills into round trips with FIFO matching across scaling in and out is where spreadsheets get painful, and that step has to happen before any of the sequence measures are possible.

Does tradebook analysis tell me if my strategy is good?

No, and it is not trying to. It describes how you executed, not whether your setups had an edge. A trader with a sound strategy and poor execution and a trader with the reverse can produce similar results, and the tradebook only speaks to the second.

Riskora is a behavioural training and simulation platform. It is not a broker, investment adviser or research analyst, and nothing here is investment advice or a recommendation to trade. Figures describe patterns in your own past trades and do not predict future results.