How to download your tradebook from Upstox
Upstox keeps the trade history under Reports. It takes about a minute, and the only real decision is the date range.
Downloading it, step by step
- Open Upstox on the web, or the app, and go to Account or Reports.
- Open Trade Book — not P&L, and not Holdings.
- Set the date range you want. Prefer several months over a single week.
- Choose the segment if prompted — F&O for derivatives, Equity for stocks.
- Download as CSV or Excel. Both work for analysis; CSV is simplest.
Before you use the file, open it once and confirm there is a time against each trade, not just a date. Timestamps are what allow patterns like re-entering minutes after a loss to be measured at all.
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 Trade Book in Upstox?
Under Account or Reports in the Upstox web platform and app. Menu names shift a little between versions, but the report is called Trade Book.
Can I download the Upstox tradebook as Excel?
Yes. Upstox offers CSV and Excel. Either is fine for analysis, though CSV avoids spreadsheet formatting quirks.
Why does my Upstox download have no trade times?
You have likely downloaded a P&L or summary report rather than the Trade Book. The Trade Book has one row per executed trade with a timestamp.
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.