How to Analyze Your Zerodha or Angel One Statement Like a Pro
Your broker statement is a goldmine of behavioural data. Here is exactly what to extract from your Zerodha or Angel One report — and what it reveals.
Your broker hands you a complete record of every decision you have made — and most traders never open it beyond checking the P&L total. Your Zerodha or Angel One statement is the richest, most honest dataset you will ever have about your own trading. Here is how to read it like a professional.
Get the right report
Both major Indian brokers let you export your trade history. In Zerodha, the tradebook and P&L statement live in the Console; in Angel One, the trade and P&L reports are in the back-office reports section. Export to CSV or Excel for the period you want to study — a full quarter is a good starting sample.
For step-by-step connection details specific to each broker, see the Zerodha and Angel One pages, which cover exactly how to pull and sync your data.
The columns that matter
A raw statement has more columns than you need. The ones that carry behavioural signal:
- Trade date and time — the foundation for time-of-day and frequency analysis
- Symbol and segment — to separate equity, F&O, and intraday behaviour
- Buy/sell and quantity — direction and size
- Price — entry and exit fills
- Charges — brokerage, STT, GST, stamp duty, exchange fees
That last group is the one traders skip and shouldn't. Total your charges and express them as a percentage of your gross P&L. If costs are eating a large slice, overtrading is likely part of your story.
What to compute
Once the data is clean, build the metrics that actually describe your edge:
- Net P&L after all charges — the only number that pays your bills.
- Win rate, but in context — useful only alongside the next two.
- Average win vs average loss — the payoff ratio that decides whether your win rate is enough.
- Expectancy and profit factor — covered in depth in our win rate vs profit factor guide.
- P&L by time of day and day of week — where most behavioural leaks hide.
The leaks hiding in your statement
Patterns you can usually find with a few pivot tables:
- Time-of-day decay — strong mornings, sloppy afternoons, or a recurring bad hour.
- Symbol concentration — one instrument quietly responsible for most of your losses.
- Size inconsistency — position sizes that balloon after losses, the fingerprint of revenge trading.
- Cost drag — frequency-driven charges silently converting a gross-profitable strategy into a net loss.
Skip the pivot tables
You can do all of this manually in Excel, and for your first analysis it is a worthwhile exercise. But it is slow, error-prone, and most traders do it once and never again. The Leak Detector runs this analysis on your statement automatically and surfaces the time-of-day, symbol, and sizing leaks in seconds, while the Damage Calculator prices each leak so you know which one to fix first.
For an ongoing view, TradeMind imports your Zerodha or Angel One trades directly and keeps these metrics live, so every new trade updates your real picture without another export-and-pivot session.
Your statement already contains the answer to why you are or aren't profitable. The only question is whether you will read it.
Turn these ideas into your edge
TradeMind imports your trades and surfaces the leaks, metrics, and psychology patterns this article describes — no spreadsheets required.