Login

How to Download Your Tradebook from HDFC Securities

HDFC Securities offers several exports that look right and are not. The one with your individual executions in it is Trade Details, under Equity Reports.

The file you want from HDFC Securities is one with one row per executed trade. The reports area offers several exports that look close, and the portfolio export in particular is a live snapshot of what you hold rather than a record of what you did.

Where it lives

  1. Log in to HDFC Securities and open Reports.
  2. Under Equity Reports, choose Trade Details.
  3. Set a date range. The report is typically pulled year by year.
  4. Use Export to Excel on that screen.

For derivatives, trade reports are reported to come from the online trading portal rather than the same reports screen, downloaded one financial year at a time. Expect to repeat the export for each year you want.

Menu names move, the file does not

These paths come from third-party import guides, some written in 2022 and 2023, rather than from HDFC's own documentation. If a menu is not where this says, do not hunt for exact words. Look for trade details, trade book or transaction report, then use the column check below. That check works on any broker and does not go stale.

The exports that are not it

Four columns, then you know

  1. A symbol or contract column.
  2. A side column showing buy or sell. Beware a Type column holding LIMIT or MARKET instead.
  3. A quantity column with plain numbers rather than lot descriptions.
  4. A timestamp. Date and time unlocks everything. Date alone still works at day level.

One row per trade means you have it. One row per stock means you have a summary. Tradebook or P&L statement shows the difference on real files.

If it arrives as Excel

Bank broker exports often carry a title block above the actual table: account name, period, a logo row. That is normal and it is not a problem for a reader. If a tool refuses the file, the usual cause is those rows sitting above the header, not the data itself.

What the file is good for

Read in order rather than as a total, a trade record shows how long you waited after a loss compared with after a win, whether your 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 limits are in tradebook analysis. Or put the file into Mirror, which reads it in your browser and shows each pattern with the trades behind it. Nothing is uploaded.

Common questions

Which HDFC Securities report has my individual trades?

Trade Details, under Equity Reports, exported to Excel. Derivatives trade reports are reported to come from the online trading portal instead, downloaded one financial year at a time.

Why is the portfolio export not enough?

It is a snapshot of what you currently hold. It carries no record of when you entered or exited, so there is no sequence to read.

Can I use the capital gains report?

No. It aggregates per instrument with averaged prices and no trade times. Correct for filing a return, useless for measuring behaviour, which depends entirely on order.

The Excel file has rows above the table. Is that a problem?

Not for reading it yourself. Bank brokers commonly put an account and period block above the header row. If a tool rejects the file, that block is the usual reason rather than the data.

How much history should I pull?

Enough to include a losing stretch. A calm quarter often shows nothing, which is useful to know but weak evidence. A year containing a drawdown tells you far more.

Got your HDFC Securities trade details?

Drop it into Mirror and see what the sequence shows. Free, no account, and your file never leaves your browser.

Analyse my trades

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. Figures describe patterns in your own past trades and do not predict future results.