Import trades from Oanda

Export your Oanda Transaction History as CSV, then upload it in Rize Trade under Add Trades > File upload with broker set to Oanda. Currency pairs import as forex trades. Other Oanda instruments, such as metals, indices and commodities, import as CFDs.

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

Export from Oanda

Download a Transaction History CSV from the Oanda web trading platform, then upload that file into Rize Trade.

1. Log in to the Oanda web trading platform.
2. Click Transaction History in the upper header.
3. Select the trading account you want to export trades for.
4. Choose your start and end dates, then click Show Transactions.
5. Click Export to CSV to download the file.

Tip: Keep the original column headers from Oanda. Do not rename columns in a spreadsheet before you upload.

Columns Rize Trade expects

Your file needs a header row. Column names are matched exactly (case does not matter). Required headers must be present under one of the accepted names below.

| Column | Required? | Accepted names | What it is used for | | --- | --- | --- | --- | | Date / time | Required | TRANSACTION DATE, Date / Time, Date/Time or Date | When the fill happened. Rows with a missing or invalid date, or a date with no time of day, are skipped. | | Instrument | Required | INSTRUMENT or Market | The forex pair or market symbol. | | Price | Required | PRICE or Price | Fill price. Must be a number above zero (not blank or - on rows you want imported). | | Units | Needed on each trade row | UNITS or Units | Trade size. Must be a non-zero number. Blank, zero, or - rows are skipped. | | Direction | Optional (one layout) | DIRECTION | Buy or sell side when this column is present. See the two layouts below. | | Transaction type | Optional (other layout) | TRANSACTION TYPE or Type | Which rows count as fills, and side when DIRECTION is missing. | | Commission | Optional | COMMISSION or Commission | Commission on the fill when present. | | Profit | Optional | Profit (USD) or Profit | Not read by the importer. It can stay in the file. |

Comma-separated and tab-separated files both work. Blank lines are ignored. Instruments made of two currencies (for example EUR/USD or EUR_USD) are stored as forex. Everything else (for example XAU_USD or SPX500_USD) is stored as a CFD.

Two column layouts Oanda exports use

Rize Trade supports two common Oanda layouts. Which rules apply depends on whether your file has a DIRECTION column.

Layout with DIRECTION

When DIRECTION is present, side comes from that column: buy values such as Buy become buys and sell values such as Sell become sells. Rows with a direction Rize Trade does not recognise are skipped.

• Each trade row needs price, units, and direction filled in.
• If TRANSACTION TYPE (or Type) is also in the file, only rows whose type is exactly ORDER_FILL are imported. Other transaction types are skipped.

Layout without DIRECTION

When there is no DIRECTION column, Rize Trade uses TRANSACTION TYPE (or Type) instead.

• The transaction type text must include filled.
• Price and units must be present and must not be -.
• Side comes from the first word of the transaction type, for example Buy Market Filled is a buy and Sell Limit Order Filled is a sell. If the first word is not a buy or sell, the row is skipped.

Upload in Rize Trade

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

• Set broker to Oanda.
• Set Time zone to match the timestamps in your export. Required. There is no Date Format selector for Oanda. Rize Trade works out whether your dates are day-first or month-first from the file itself.
• Accepted file types: CSV, TXT or HTML. Save tab-separated exports with a .csv or .txt extension. The HTML Account Statement Report from the Oanda portal is also read, from its Closed Transactions table. Max 50 MB.

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

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

Fix Oanda import errors

When something is off, Rize Trade shows a clear message. Oanda-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.

File is empty or invalid

Message: File is empty or invalid.

Cause: The upload has fewer than two lines (no header plus data), or the file has no usable content.

Fix: Re-export Transaction History for a date range that includes fills, download a fresh CSV, and upload that file.

Missing required columns

Message: Invalid Oanda file: Missing required columns.

Cause: The file is missing a required date column (TRANSACTION DATE, Date / Time, Date/Time or Date), instrument column (INSTRUMENT or Market), or price column (PRICE or Price).

Fix: Export again from Oanda Transaction History and keep the original headers. Do not rename or delete those columns before uploading.

No valid trades found in file

Message: No valid trades found in file.

Cause: Headers were found, but no rows passed the fill checks. Common reasons: transaction type is not ORDER_FILL (when DIRECTION is present), type does not include filled (when DIRECTION is missing), price or units are blank, - or zero, dates are invalid or have no time, or instrument is missing.

Fix: Export filled transactions only, confirm price and units have real numbers, and keep either a usable DIRECTION column or a transaction type that marks fills.

Mixed date formats

Message: The date column mixes day-first and month-first dates, so the trades cannot be dated safely. Re-export the file from Oanda and try again.

Cause: Some dates in the file can only be day-first and others can only be month-first, usually because the file was edited or joined from two exports.

Fix: Download a fresh export from Oanda and upload it without editing the dates.

Failed to read Oanda file

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

Cause: The file structure could not be read as an Oanda Transaction History export.

Fix: Export a clean CSV from Oanda again (not a heavily edited spreadsheet), keep comma or tab separators, and upload without changing the header row.