CSV / broker statement

Upload an export file from your broker or platform. It is a one-off import, not a live sync.

Steps

  1. 1Export your trades from your broker or platform as a .csv or .json file. Fills or closed trades both work.
  2. 2Open Connections in the sidebar, click Add connection and pick CSV / broker statement. The Import Trades button at the top of the page opens the same window.
  3. 3Leave Broker Format on Auto-detect (recommended). The app reads the column names and works out the layout itself.
  4. 4Under Account, pick the journal account the trades belong to, or choose + New account… and give it a name, a type and an optional starting balance.
  5. 5Drag the file in or click to browse (5MB max), then click Import Trades.
  6. 6You get a message like "Imported 12 trades (24 executions)". Notes about skipped rows or left-out trades show under it.

Supported files

  • File types: .csv and .json. A JSON file must be an array of objects. Maximum size 5MB.
  • One row per fill: needs a symbol, a side (Buy/Sell, BOT/SLD, Long/Short, or a signed quantity), a price, a quantity and a time. Columns such as Instrument, Action, Qty, Price, Time and Timestamp are recognised, in any case.
  • Account, commission and P&L columns are optional. If the file has a P&L column, that figure is used.
  • One row per closed trade: needs a symbol, a quantity, entry and exit prices, and entry and exit times (for example Entry Price, Exit Price, Entry Time, Exit Time). Each row becomes an entry and an exit. If there is no direction column, the app uses a signed quantity or the sign of the P&L; a row it cannot tell is skipped.
  • Tradovate Performance reports (bought and sold timestamps, buy and sell prices) and DeepCharts trade exports (Entry DT and Exit DT) are read as closed trades. DeepCharts writes no real exit time, so the entry time is used and the holding time is unknown.
  • ATAS, MotiveWave and Interactive Brokers exports are recognised by their column names. Anything else with the usual column names is read as Generic.
  • Fills are grouped into trades by your running position. A fill that goes past flat opens a reverse trade, and the notes mention it.

Times and time zones

  • Times in the file without a zone are read in your browser’s time zone, which the Import window sends along. Upload from the computer whose clock wrote the file.
  • A time that names its own zone, such as 2026-09-04T18:05:00Z or 2026-09-04 18:05:00 +03:00, is used as it is.

If something goes wrong

  • "Choose a CSV or JSON execution log to import." The file is missing or empty. Pick it again.
  • "File exceeds the 5MB import limit." Export a shorter date range and upload it in parts.
  • "File must have a .csv or .json extension." Save or export the file as CSV.
  • "This file has no data rows to import." The file has only a header or nothing at all. Re-export with a date range that has trades.
  • "Could not find a column for …" The headers are not recognised. The card lists what was looked for and the columns found in your file. Rename the headers to the usual names (symbol, side, price, quantity, time) or export a trade or execution history instead of a summary. A MotiveWave Journal export has no fill prices; use the trade or execution history.
  • "Could not parse CSV", "File is not valid JSON." or "JSON import must be an array of execution records." The file is damaged or is not an export of trades. Export it again.
  • "No valid executions found in this file." Every row was rejected. The notes list each row and why, for example Invalid price, Unrecognized side value or Unrecognized timestamp.
  • Some rows are skipped but the rest import. The count shows as "N row(s) skipped" and the notes list up to 50 of them. Fix those rows and upload the file again; only the missing trades are added.
  • "This file has fills from N broker accounts…" The file mixes accounts. If you pick an existing account linked to one of them, only that account’s fills are imported and the rest are left out. If the pick is not linked to any of them, or you chose + New account…, the upload is refused: export one account at a time. A new account is linked to the broker account named in the file.
  • "Broker account … is already on the site as …" Pick that account instead of creating a new one.
  • "Every trade in this file is already on this account from the automatic sync." The account’s automatic sync already has these trades. Nothing was added.
  • "Every trade in this file was previously deleted from this account." Trades you deleted do not come back through an upload.
  • "Import failed: …" The save did not finish. If some earlier trades were saved, upload the same file again and only the missing ones are added. A new account made for the failed upload is removed again.

Good to know

  • Re-uploading the same file is safe. Trades already on the account are skipped and counted, not doubled. Identical fills in the same second, such as three 1-lots at one price, are kept as separate fills.
  • If the account also has an automatic sync, trades that start at or before its latest synced fill are left out, so a file never doubles what the sync already has. Use one source per account where you can.
  • Commission: if the file states any commission, its figures are used. If it states none, the account’s fee profile prices each fill. An account on the Free (sim) fee profile always gets zero fees.
  • If you search for your broker or prop firm under Add connection and it shows "No direct sync yet", this import is the way in.
  • This is a one-off import. The live connections send trades automatically; a file import does not update by itself, so upload a fresh file when you want newer trades.

Back to the help center