How to download your tradebook from Zerodha
Zerodha keeps your trade history in Console, not in Kite. Here is exactly where it is, which report to pick, and the one report people download by mistake.
Downloading it, step by step
- Open Console at console.zerodha.com and log in with your Kite credentials.
- Go to Reports in the top menu, then choose Tradebook.
- Pick the segment you want — choose F&O for futures and options, or Equity for delivery and intraday stock trades.
- Set the date range. Three to six months gives a far more reliable read on behaviour than a single week.
- Click Download and choose CSV. The file lands in your downloads folder.
Zerodha's tradebook CSV includes a column called order_execution_time. That
timestamp is what makes behavioural analysis possible — it is how you can tell that a trade
was placed four minutes after a loss rather than four hours after.
Console exports one segment at a time. If you trade both options and equity and want the full picture, download each segment separately.
A tradebook is not a P&L statement
This is the single most common mistake, and it is worth getting right before you download anything. Brokers offer several reports that look similar:
| Report | What it contains | Useful for behaviour? |
|---|---|---|
| Tradebook | One row per executed trade, with the time, quantity, price and buy/sell side | Yes — this is the one you want |
| P&L / Tax P&L statement | One row per stock or contract, with averaged buy and sell prices | No — individual trades and their timing are gone |
| Holdings / positions | What you currently own | No — it is a snapshot, not a history |
| Ledger / funds statement | Money in and out of your account | No — no trade detail at all |
Behaviour lives in the timing and sequence of trades — how many minutes after a loss you re-entered, whether the next position was larger, how long you held losers versus winners. A P&L statement averages all of that away. If your download has one row per instrument rather than one row per trade, you have the wrong report.
What the file needs to contain
Whatever the column headings are called, the export needs these five things for the analysis to work:
- Instrument or symbol — which contract or stock
- Buy / sell side — sometimes a separate column, sometimes a signed quantity
- Quantity
- Price — the executed price, not the order price
- Date and time — the timestamp matters most; a date alone limits what can be measured
Column names differ wildly between brokers, which is why a good analyser maps columns by meaning rather than expecting one fixed format.
What to do with the file once you have it
A tradebook on its own is a spreadsheet of numbers. What makes it useful is reading the sequence: which trades followed a loss, which were larger than your own average, which days you traded far more than usual, and how long you held losers compared with winners.
Riskora's free Mirror does exactly that, and it does it inside your browser — the file is never uploaded to a server. You get a Discipline Score out of 100, the single pattern costing you the most, and the rupee figure attached to it.
Common questions
Where is the tradebook in Zerodha — Kite or Console?
It is in Console (console.zerodha.com), not in the Kite app. Kite shows your current orders and positions; Console holds the historical reports including the tradebook.
How far back can I download my Zerodha tradebook?
Console generally lets you pull several years of history, though very long ranges may be split by financial year. For behavioural analysis, three to six months is usually enough to see a stable pattern.
Should I download CSV or Excel?
CSV is the most reliable. Excel works too, but CSV avoids formatting quirks and opens in any tool.
Is the Zerodha P&L report the same as the tradebook?
No. The P&L report aggregates by instrument with averaged prices and no individual trade times. Behavioural analysis needs the tradebook, which has one row per executed trade.
See which habit is costing you money
Upload the tradebook you just downloaded. In about ten seconds you get a Discipline Score out of 100, the pattern costing you the most, and what it cost in rupees.
Get my Discipline Score — free🔒 Read 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. Broker menu names change between app versions — check your broker's own help pages if a step looks different.