How to Download Your Tradebook from ICICI Direct
ICICI Direct splits the equity trade book and the F&O trade book across different screens, which is why people end up downloading a tax statement by mistake.
The file you want from ICICI Direct is a trade book: one row per executed trade, with a date and ideally a time. ICICI keeps the equity trade book and the derivatives trade book in different places, so the first thing to decide is which segment you traded.
Where it lives
For equity, the route reported by import guides is the back office: log in, open Stocks, then Trade Book. Some versions of the Stocks screen offer a Download dropdown with a choice between Summary and All Transaction. Take All Transaction. Summary is a rollup and loses the individual executions.
- Log in to ICICI Direct and open the back office or reports area.
- For equity, go to Stocks, then Trade Book. For derivatives, open the F&O trade book.
- Set a date range. ICICI tends to work in financial years, so expect to pull 1 April to 31 March and repeat per year.
- Download. CSV where it is offered, Excel otherwise.
The paths above come from third-party import guides rather than from ICICI's own documentation, and they already disagree with each other in places. If a menu is not where this says, do not hunt for the exact words. Look for anything called trade book, trade details or transaction report, then use the column check below to confirm you have the right file. That check works on any broker and does not go stale.
The files that are not it
- Tax P&L or capital gains statement. Built for filing a return. Aggregated per instrument with averaged prices and no trade times. This is the single most common wrong download.
- Holding statement. A snapshot of what you own right now. It says nothing about when you bought or sold.
- Portfolio or Equity Transaction Statement export. Closer, but often a point in time view rather than a list of executions.
- Contract notes. Correct data, wrong shape. One PDF per day is not something any tool can read in bulk, and you would need a year of them.
Four columns, then you know
- A symbol or contract column.
- A side column showing buy or sell. Watch for a column called Type that actually holds LIMIT or MARKET.
- A quantity column with plain numbers rather than lot descriptions.
- A timestamp. Date plus time of day unlocks everything. Date alone still works, but limits you to day level patterns.
One row per trade means you have the right file. One row per stock means you have a summary. The difference, and how to spot it in any broker export, is in tradebook or P&L statement.
A note on the F&O file
ICICI's F&O trade book is reported to download without a client name or ID in it. That matters for some import tools, which expect to match an account. It does not matter for reading your own behaviour, where the only thing that counts is the sequence of your own trades.
Expect to repeat the download per financial year. Pull enough history to include a bad stretch: a calm quarter can look completely clean and tell you very little.
What the file is good for
Read in order rather than as a total, a trade book shows how long you waited after a loss compared with after a win, whether your position size moved after a bad trade, how your trade count clustered on your heaviest days, and how much longer losers stayed open than winners.
The method and its honest limits are in tradebook analysis. Or put the file into Mirror, which reads it in your browser, shows each pattern with the trades behind it, and sends nothing anywhere.
Common questions
Where is the trade book in ICICI Direct?
Equity trades are reported to sit in the back office under Stocks and then Trade Book, while derivatives have their own F&O trade book screen. Menu names vary between versions, so look for trade book, trade details or transaction report, then confirm the file has one row per trade.
Summary or All Transaction?
All Transaction. Summary rolls your trades up and loses the individual executions, which is exactly the information behavioural analysis depends on.
Can I use the ICICI Direct tax P&L for this?
No. It aggregates per instrument with averaged prices and carries no trade times, so the order of your trades is gone. Order is the whole point.
Why does the F&O file have no client name?
The F&O trade book is reported to export without a client name or ID. Some import tools expect one. For reading your own behaviour it makes no difference, because the only sequence that matters is your own.
How much history should I download?
Enough to include a losing period. ICICI works in financial years, so one year is a natural unit, and a year that contains a drawdown tells you far more than a calm one.
Got your ICICI Direct trade book?
Drop it into Mirror and see what the sequence shows. Free, no account, and your file never leaves your browser.
Analyse my tradesRead entirely in your browser. Your file is never uploaded.
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.