Skip to content
RizeTrade

Help Centre

153 guides on importing trades, connecting brokers and everything else in RizeTrade.

Import trades from Interactive Brokers

Export a Trade Confirmation Flex Query from Interactive Brokers as CSV, then upload it in Rize Trade under Add Trades > File upload with broker set to Interactive Brokers.

For the general import flow across all brokers, see How to import your trades.

Export from Interactive Brokers

Build a Flex Query once, then run it whenever you need a fresh CSV for Rize Trade.

  1. Log in to the Interactive Brokers Client Portal.
  2. Go to Performance and Statements > Flex Queries.
  3. Click the plus icon next to Trade Confirmation Flex Query.
  4. Set the query name to RoryTrade (or any name you will recognize later).
  5. Under Sections, open Trade Confirmation > Executions, choose Select All, then save.
  6. In General Configurations, set Date Format to yyyyMMdd, Time Format to HHmmss, and Date/Time Separator to semi-colon.
  7. Click Continue, then Create, then OK.
  8. Run the query: click the blue arrow next to it, pick your date range, choose CSV, and click RUN.
  9. Download the CSV and upload it into Rize Trade using the steps below.

Warning: If an import fails because of an invalid date or time, reopen the Flex Query and confirm Date Format is yyyyMMdd, Time Format is HHmmss, and Date/Time Separator is semi-colon, then export again.

Columns Rize Trade expects

Your file needs a header row with these columns. Required headers must match exactly as shown (the Date/Time header is recognized when the column name includes Date/Time).

| Column | Required? | Notes | | --- | --- | --- | | Date/Time | Required | Trade fill date and time. Supported date patterns: yyyyMMdd (default for IB), yyyy-MM-dd, MM/DD/YYYY, MM/DD/YY, DD/MM/YYYY, DD/MM/YY, dd-MMM-yy. Time as HH:MM:SS or HHMMSS. | | Symbol | Required | Ticker or instrument symbol (for example, MES). | | Buy/Sell | Required | Side of the fill. Use BUY or SELL only. | | Quantity | Required | Share, contract or size amount. | | Price | Required | Fill price. | | Commission | Optional | Commission on the fill when present in the export. | | AssetClass | Optional | Maps asset type: OPT is stored as option, FUT as futures, CASH as forex; anything else is treated as stock. |

Sample row (with the recommended Flex date/time settings). Columns are separated by commas; the semi-colon only separates the date from the time inside Date/Time:

20260310;133034,MES,BUY,1,6847.50

After you have the CSV, import it from Add Trades with Interactive Brokers selected. For the general upload flow, see How to import your trades. IB-specific settings:

  • Set broker to Interactive Brokers.
  • Set Time zone to match the timestamps in your export. Required.
  • Set Date Format to match the dates in your file. For the Flex Query settings above, use the yyyyMMdd style format.
  • Accepted types: .csv or .txt. Max 50 MB, up to 200,000 rows.

After upload, open Settings > Import History to confirm status, trade count and duplicates.

Tip: If dates look shifted after a successful import, fix time zone or date format and re-upload. See Why are my entries and exits on the wrong dates?.

When something is off, Rize Trade shows a clear message. IB-specific rejections are below. For generic errors (file too large, wrong file type, empty file, missing account or time zone), see Fix any import problem.

This doesn't look like an Interactive Brokers trade report

Message: This doesn't look like an Interactive Brokers trade report. Missing columns: ... Please export a "Trades" or "Trade Confirmations" report from Interactive Brokers.

Cause: The file is missing one or more required headers (Date/Time, Symbol, Buy/Sell, Quantity or Price), or it is not a Trade Confirmations / Trades export.

Fix: Export again from a Trade Confirmation Flex Query with Executions selected (all fields), and keep the default IB column names. Do not rename headers in a spreadsheet before uploading.

Wrong date format selected

Message: starts with Wrong date format selected.

Cause: The Date Format you picked in Rize Trade does not match the dates in the file. Rize Trade first tries to detect the right format from the file itself, so this message only appears when it can't.

Fix: Choose the date format that matches your export. For the recommended Flex settings, use yyyyMMdd. Or re-export the Flex Query with Date Format yyyyMMdd, Time Format HHmmss, and Date/Time Separator semi-colon.

No valid trades found

Message: No valid trades found. The file has the right columns but we couldn't extract any trades. Please check that you're exporting filled trades (not pending orders) and that the correct date format is selected.

Cause: Headers are present, but no rows could be turned into trades. Often this means pending orders instead of fills, empty data rows, or a date format mismatch.

Fix: Export filled executions only, confirm Date Format on the upload screen, and make sure Buy/Sell values are BUY or SELL.

Failed to read Interactive Brokers file

Message: starts with Failed to parse Interactive Brokers file: followed by more detail.

Cause: The file structure could not be read as an Interactive Brokers trade report.

Fix: Export a clean CSV from the Trade Confirmation Flex Query (not a modified spreadsheet workbook), then upload again without changing column names.

Was this helpful?