Tradebook or P&L Statement? Which Report You Actually Need

The most common reason a trade analysis fails is not the tool. It is that the file is a P&L summary rather than a tradebook, and the two look almost identical until you open them.

RiskoraUpdated 2026-08-21Behavioural trading research

Every Indian broker offers a handful of downloadable reports with confusingly similar names: Tradebook, Trade Book, Tax P&L, P&L Statement, Capital Gains, Trades and Charges, Order Book. They are not interchangeable, and for behavioural analysis only one category is usable.

The distinction is simple once you have seen it. A tradebook has one row per executed trade. A P&L statement has one row per instrument. Everything else follows from that.

What each report contains

A P&L statement is the right document for your accountant and the wrong one for understanding how you traded. If you bought Nifty three times and sold twice across a week, the tradebook shows five rows with five timestamps. The P&L statement shows one row with two averages, and the entire sequence of decisions has been averaged away.

How to tell which one you downloaded

Open the file and look at the header row. You do not need to understand every column.

• Columns named like "Avg Buy Price" and "Avg Sell Price" mean it is a P&L statement. Averages only exist because multiple trades were collapsed together.
• A "Realised P&L" or "Net P&L" column usually points the same way. Tradebooks record what happened, not what it netted to.
• A column with a clock time, such as order execution time or trade time, is the strongest sign you have the right file.
• The same symbol appearing many times across different rows is a tradebook. Each symbol appearing exactly once is a summary.
• Row count is a quick sanity check. If you took roughly two hundred trades last quarter and the file has eleven rows, it is a summary.

What to pick, broker by broker

Angel One deserves a specific warning. Its correct export is called "Trades and Charges" rather than anything containing the word tradebook, it arrives with roughly thirty rows of preamble above the actual table, and it carries the date but not the intraday time. That last point is a genuine structural limit: day-level patterns such as overtrading and loss concentration remain measurable, but anything counted in minutes cannot be computed from it by any tool.

Before you analyse anything, check four columns

1. A symbol or contract column, so trades can be grouped by instrument.
2. A side column showing buy or sell. Watch out for a column called "Type" that actually holds LIMIT or MARKET, which is order type and not side.
3. A quantity column with real numbers rather than lot descriptions.
4. A timestamp. Date alone limits what can be measured; date plus clock time unlocks everything.

If all four are present, the file will support a full analysis. If the timestamp is date-only, expect an honest tool to suppress its time-based findings and say so rather than producing a plausible-looking number from an ordering that is really just the file's row order.

A note on formats: CSV is the most reliable export across every broker. Excel usually works but sometimes carries multiple sheets or title rows above the real table. PDF is the worst choice, because the table structure is often lost entirely in the conversion.

Once you have the right file

Reading it is covered in tradebook analysis: what your trade history actually shows, which walks through pairing fills into round trips and the five measurements worth taking. If you would rather not do it by hand, Mirror reads the file in your browser and reports each pattern with the trades behind it. It also detects a P&L statement and tells you specifically that you downloaded the wrong report, rather than failing with a generic error.

Common questions

Can I use a Tax P&L statement for trading behaviour analysis?

No. A Tax P&L aggregates to one row per instrument with averaged prices and no timestamps, so the sequence of trades is gone. Behavioural measurement depends entirely on that sequence and cannot be recovered from an aggregated report.

What is the difference between an order book and a tradebook?

An order book lists orders placed, including ones that were cancelled or never filled. A tradebook lists executions only. For analysing what you actually did, the tradebook is correct; an order book can contain orders that never became positions.

My tradebook has no time column. Is it useless?

Not useless, but limited. Day-level patterns such as trades per day and where losses concentrated still work. Anything measured in minutes, including re-entry speed and holding time, cannot be computed. Check whether your broker offers an alternative export that includes execution times.

Should I download CSV or Excel?

CSV is the most reliable across brokers. Excel generally works but may include several sheets or title rows above the real table. Avoid PDF where possible, since the table structure is frequently lost.

How far back should my tradebook go?

Long enough to include a losing period. Most behavioural patterns only express themselves under pressure, so a calm month can look clean and tell you very little. A quarter that contains a drawdown is far more informative than a good one.

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.