Trade import and export
Which CSV formats the Journal reads, how duplicates are detected, entering single trades and exporting your data again.
Which formats the Journal reads
| Source | What you export |
|---|---|
| Tradovate | The fills from Tradovate's reports |
| TradingView | The list of trades |
| NinjaTrader | The list of trades |
| Generic CSV | A list with symbol, direction and result per trade |
The Journal detects the format itself. It reads numbers with a decimal comma or decimal point, dates in US or international notation, and times with a time zone.
Tradovate
A short guide in the Journal walks you through the export: open Tradovate, sign in, open the reports and download the CSV. Tradovate uses Chicago time. The Journal assigns every fill to the correct day and to the chosen account.
How to import
- Choose the account the trades should go into at the top right.
- Open the Journal page and choose Import.
- Drop the CSV. Before anything is saved, the Journal shows a preview of the new trades, how many of them already exist and which rows could not be read.
- Assign the trades to a strategy. Strategies whose symbols appear in the export are preselected.
- Confirm the import.
Duplicates
The Journal recognises trades that are already in the account and imports only the new ones. So you can upload the same export several times, for example the whole month every week.
Rows that do not fit
A row that cannot be read carries its reason, such as a missing symbol or a date that cannot be interpreted. The other rows still go through. No row is silently guessed or set to today.
Entering single trades
For trades without an export, you add a trade by hand on the Journal page through Trade hinzufügen (add trade). The dialog only closes once the trade is saved. If the server recognises it as a duplicate, it says so.
Export
The Journal page exports your trades as CSV. The file is made for a German Excel:
- semicolon as separator and decimal comma,
- account, account number and currency on every row,
- text in quotes so that a note cannot shift the columns.
The column names stay in English so the Journal can read the file back in.