How to download your Zerodha tradebook and make sense of it
The tradebook lists every buy and sell you have made, with date, quantity and price. On its own it is a long list; matched into entries and exits, it shows what each closed trade made or lost.
What the tradebook has
Each row is one executed trade: the symbol, trade date, whether it was a buy or a sell, the quantity and the price. Console lets you choose the segment and date range before you download.
From rows to closed trades
Matching buys with later sells (and sells with later buys, for shorts) gives each closed trade its profit or loss: exit minus entry, times quantity. The Stock Journal does this when you upload the file, and keeps delivery, intraday and F&O apart.
What is not included
Brokerage and other charges are not part of the profit figures, so they show the trade itself. The journal reports facts about your own trades and never suggests one.
Export and upload your tradebook
- 01Open ConsoleSign in to Zerodha Console and go to Reports › Tradebook.
- 02Choose and downloadPick the segment and date range, then download the CSV.
- 03Upload itOpen the Stock Journal here and choose Upload Zerodha CSV. It is read in your browser.
Common questions
How far back can I export?
Console limits the date range per export, so download the tradebook in parts and upload each file.
Is the tradebook the same as the P&L statement?
No. The tradebook is the list of trades; a P&L statement is a calculated report. The journal works from the trades.
Can I upload it more than once?
Yes. Upload a newer file whenever you want more history, or add single trades by hand.
Ready when you are. It takes about two minutes.
Upload my tradebookArthtome is not a SEBI-registered Investment Adviser or Research Analyst. Data shown is based on the user's CAS and entries, AMFI's public NAV data and NSE's end-of-day prices. For informational and educational purposes only. No buy/sell recommendation. Past performance is not indicative of future returns.