Import Zerodha trades into your QbarTrade journal.
Follow one clear two-part process: export Tradebook from Zerodha Console, then upload, validate and confirm the executions inside QbarTrade.
This guide covers
Zerodha allows a maximum 365-day range per Tradebook download. Export separate files when importing a longer history.
Click to watch the import, validation and review workflow in QbarTrade.
What happens after import?
How to download your Zerodha Tradebook.
Sign in to Zerodha Console
Open Zerodha Console and sign in using your Zerodha account credentials.
Open Reports
From Console, open Reports and select Tradebook.
Choose the segment and date range
Select the segment whose trades you want to import and choose the required date range. Load the report before downloading it.
Download CSV or XLSX
Use the Download option beside the Tradebook report and save the file as CSV or XLSX. Keep the original column structure unchanged before uploading it to QbarTrade.
Use the Tradebook file. Export CSV or XLSX directly from Zerodha Console under Reports → Tradebook, and keep the original columns unchanged.
Need more than one year? Download multiple Tradebook files using separate date ranges, then import them into QbarTrade in sequence.
Upload and validate your Zerodha trades.
Follow these 12 steps inside QbarTrade to transform raw Console executions into a clean, reviewable trade journal.
Open Trades
From the QbarTrade sidebar, open Trades.
Open the import menu
Use the three-dot menu beside the Add button and select Import trades.
Add the Tradebook file
Select Add file and upload the CSV or XLSX file downloaded from Zerodha Console.
Assign the broker account
Select the Zerodha broker account that produced the imported trades. This keeps broker-specific trades and analytics organised correctly.
Review the imported rows
QbarTrade displays the mapped trades before final import. Review the instrument, side, quantity, segment, entry, exit, duration, stop-loss, P&L and strategy fields.
Resolve validation warnings
Rows may be marked valid, invalid, needs broker or needs instrument. Correct the missing information or remove rows that do not represent actual trade executions.
Remove unwanted rows
Select invalid or irrelevant rows and use the delete action to exclude them from the final import. Examples include disclaimer text interpreted as a row, empty lines, summary rows, unmapped instruments, or non-trade information.
Merge related executions
Select related trades and use Merge when multiple executions belong to one completed trading idea or round-trip. A merged round-trip can preserve the individual entry, scale-up, scale-down and exit legs while showing the combined position as one reviewable trade.
Edit trade details
Use the edit action to correct the instrument or add broker account, strategy, notes, stop-loss price and charges or taxes.
Save the changes
Save the edited row after confirming the corrected trade information.
Confirm the import
When the valid rows are ready, select Confirm & Import to add them to the QbarTrade trading journal.
View all imported trades
Return to the Trades page and use the All filter to review imported open and closed trades.
Turn execution rows into reviewable trades.
Validate trade rows
Review which rows contain usable execution data and identify rows that require broker or instrument information.
Connect executions into round-trips
Combine related entries, additions, reductions and exits so a complete position can be reviewed as one trading outcome.
Preserve individual trade legs
The complete round-trip can retain its underlying fills, helping you understand how the position was built and closed.
Add strategy context
Assign a strategy so later analysis can compare outcomes across your repeated trading setups.
Add risk and cost details
Add stop-loss and charges or taxes where required so the journal reflects more than gross price movement.
Analyse performance
Evaluate key journal metrics including Net P&L, Win rate, Profit factor, Expectancy per trade, Average R multiple, Maximum drawdown, Equity curve, Daily net P&L, Average win, Average loss, Win and loss streaks, Performance by weekday, and Top traded symbols.
One trading idea can contain several Zerodha executions.
Scaling into a stock, adding quantity at a second price, partially exiting and closing the remaining position can create several execution rows in a Tradebook. Reviewing each row separately can hide the outcome of the complete decision. QbarTrade lets related executions be combined into one round-trip while preserving the underlying legs for audit and review.
Round-Trip Example
Common Zerodha Tradebook import issues.
The broker is not assigned
Select your Zerodha broker account before confirming the import. This ensures the imported executions are connected to the correct account.
An instrument is not linked
Search for and select the correct NSE, BSE, futures, options or commodity instrument. Unlinked instruments may have limited chart or analytics functionality.
Disclaimer or summary text appears as a trade
Select rows that are clearly not trade executions and remove them before confirming the import.
Some historical trades are missing
Check the date range selected in Console Tradebook. Zerodha limits individual exports to 365 days, so download additional files for earlier periods when required.
The P&L does not match
Check whether you are comparing the same date range, open or closed trades, gross or net P&L, missing brokerage or taxes, incorrect entry or exit mapping, or unmerged execution legs.
Scale-in trades appear separately
Select only the executions that belong to the same completed position and use Merge to create one round-trip.
A row has the wrong strategy
Open the row editor and assign the strategy that accurately represents the original trading setup.
A Tradebook records executions. A journal explains performance.
| Aspect | Zerodha Tradebook | QbarTrade Journal |
|---|---|---|
| Primary function | Authoritative broker execution log | Complete round-trip review |
| Trade details | Date, segment, price and quantity | Strategy and setup context |
| Risk tracking | Executed quantities and prices | Risk and stop-loss context |
| Position grouping | Individual transaction rows | Merged trading ideas |
| Analytics focus | Historical Console report | Performance analytics |
| Workflow depth | Broker reporting | Notes, behaviour and review workflow |
Zerodha Console provides authoritative broker records. QbarTrade builds on those records to deliver deep performance journaling and decision analytics.
Zerodha Trade Import FAQ
Which Zerodha file should I import into QbarTrade?+
Use the Tradebook report available under Reports in Zerodha Console. Download the report as a CSV or XLSX file so QbarTrade can read the structured transaction rows.
How do I download the Zerodha Tradebook?+
Sign in to Zerodha Console, open Reports, select Tradebook, choose the required segment and date range, click the search button and use Download to save CSV or XLSX.
Can I import older Zerodha trades?+
Yes. Zerodha limits each export to 365 days. When your history spans multiple years, download separate Tradebook files and import them into QbarTrade in sequence.
Can I import Zerodha stock, F&O and commodity trades?+
This workflow is intended for supported equity, futures, options, currency and commodity trade rows contained in the Zerodha Tradebook. Review instrument and segment mapping before confirming the import.
Why are some Zerodha rows marked invalid?+
A row may be missing an instrument, contain non-trade disclaimer text, have incomplete execution data or require broker assignment. Review the warning and correct the row or remove it if it is not an actual trade.
Can I merge multiple Zerodha executions?+
Yes. When several executions belong to the same completed trading idea, select them and merge them into one round-trip while retaining the underlying execution legs.
Can I edit a Zerodha trade before importing it?+
Yes. The review screen allows fields such as instrument, broker account, strategy, notes, stop-loss and charges or taxes to be reviewed or corrected before final import.
Why does my imported P&L differ from Zerodha Console?+
Check whether you are comparing the same date range, open or closed trades, gross or net P&L, and whether charges, taxes and all execution legs are included correctly.
Does importing trades allow QbarTrade to place Zerodha orders?+
No. Importing a Tradebook report is strictly used for journaling and analysis. It does not give QbarTrade permission to place, modify or execute orders in your Zerodha account.
Should I upload a Zerodha contract note or Tradebook report?+
Use the Console Tradebook for this import workflow. Contract notes are day-wise confirmations, while the Tradebook provides the multi-day structured history needed for journaling.
FROM TRADEBOOK TO TRADING INSIGHT
Import the executions. Review the decisions.
Bring your Zerodha trading history into QbarTrade, organise related executions, add the context missing from a broker report and review the patterns behind your results.