OANDA Trading Journal - Auto Import

OANDA traders can import their complete forex transaction history into JournalPlus via CSV export from fxTrade or through automated sync using OANDA’s v20 REST API. The integration handles OANDA’s unit-based sizing model, multi-currency P&L conversion, and overnight swap accounting — features that generic trading journals typically ignore. The result is a OANDA trading journal that reflects true total-return performance, not just pip gain.

Key Features

Unit-Based Position Sizing Normalization

OANDA allows trading from as little as 1 unit, with standard lots at 100,000 units, mini lots at 10,000, and micro lots at 1,000. A EUR/USD position of 50,000 units at a rate of 1.1000 has a pip value of $5.00 — halfway between a mini and standard lot. JournalPlus calculates this precisely rather than rounding, so risk percentage per trade is accurate even for irregular position sizes like 37,420 units or 82,000 units.

Multi-Currency P&L Conversion

When you trade EUR/TRY or GBP/AUD, the quote currency is not your account currency. JournalPlus converts realized P&L to your base currency (USD, EUR, GBP, etc.) using the exchange rate at the time of close — the same method OANDA uses in its own statements. This is a meaningful difference from equity journaling, where every gain and loss is already denominated in the account currency with no conversion required.

Carry Trade Ledger Separation

Traders holding positions like AUD/JPY or NZD/JPY overnight collect or pay swap interest daily. At a rate differential of approximately 4.25% annualized (RBA at 4.35% vs. BOJ at 0.1%), a standard lot of 100,000 AUD/JPY generates roughly $11–$12 per day in swap income. JournalPlus logs these as separate ledger entries, so pip P&L and carry income are tracked independently. A position that lost 22 pips ($66 on 30,000 units) but collected $87 in swap over 25 days is a net +$21 winner — a fact invisible without ledger separation.

Pip Performance by Currency Pair

JournalPlus builds a pair-level breakdown from your imported OANDA history: average pips per trade, win rate, and expectancy for each instrument. If you average +8 pips on GBP/USD but -2 pips on EUR/GBP across the same sessions, that divergence reveals where your edge actually exists versus where you’re giving it back. According to research from Brad Barber at UC Davis, retail forex traders lose money roughly 70% of the time — pair-level expectancy analysis is one of the primary tools for identifying which instruments are driving losses.

v20 API Sync or CSV Import

OANDA’s publicly documented v20 REST API supports pulling up to 90 days of transaction history per request. Once your API key is connected, JournalPlus syncs new transactions automatically each day. For traders who prefer not to share API credentials, the fxTrade CSV export covers the same data fields and can be imported manually on any schedule.

How to Connect OANDA

Step 1: Log in to OANDA fxTrade

Open your OANDA fxTrade platform (web or desktop) and navigate to My Account. From the top navigation, select History, then choose Account Statement to access the transaction export interface.

Step 2: Set Your Date Range and Export

Select the date range you want to import — starting with 90 days is recommended for an initial import. Set the file format to CSV and click Download. The exported file includes transaction type, instrument, units, open price, close price, interest charges, and realized P&L per trade.

Step 3: Open JournalPlus and Go to Import

In JournalPlus, go to Settings > Import Trades and select OANDA from the broker list. This activates the OANDA-specific column mapping, which correctly parses the units field and separates interest line items from trade P&L rows.

Step 4: Upload the CSV and Confirm Base Currency

Drag your downloaded CSV into the import window. Confirm your account base currency — JournalPlus uses this setting to convert all cross-currency realized P&L using close-rate conversion, matching OANDA’s methodology.

Step 5: Review the Import Summary

JournalPlus shows a pre-import summary: total trade rows detected, swap/interest entries identified, and any rows flagged for review. Check that the trade count matches your expectations, then click Import to finalize.

Step 6: (Optional) Connect via v20 API for Automated Sync

For daily automated sync, go to Settings > Connections and enter your OANDA v20 API key. You can generate this key under Manage API Access in your OANDA account settings. Once connected, new transactions pull automatically without manual CSV exports. This works alongside CSV upload if you ever need to backfill a gap.

What Gets Imported

Data Field	Description
Trade Date & Time	Exact open and close timestamps
Instrument	Currency pair (e.g., EUR/USD, AUD/JPY)
Side	Buy (long) or Sell (short)
Units	Position size in OANDA units
Open Price	Entry execution price
Close Price	Exit execution price
Realized P&L	Gross gain/loss in account currency
Interest/Swap	Daily swap credits or debits as separate entries
Commissions	Spread cost or explicit broker fee (where applicable)

Fields that require manual entry after import include trade rationale, setup tags, emotional state, and screenshots. JournalPlus prompts for these during trade review, but they are not available in OANDA’s export.

Analytics & Insights

Once your OANDA history is imported, JournalPlus calculates pip-based P&L for every trade using the correct pip value for each pair and unit size. For a position like 50,000 units GBP/USD with a 60-pip stop (entry 1.2650, stop 1.2590), the risk is exactly $300 — and JournalPlus logs this against your account balance to show risk percentage per trade without manual calculation.

Carry trades gain a dedicated view: each position shows pip P&L and swap income as separate line items, plus a total-return figure that combines both. The example below illustrates why this matters. A US-based trader holds 30,000 units AUD/JPY as a carry position. After 25 days, the position closes with a -22 pip loss ($66). But swap income over that period totals +$87 — making the position a net +$21 winner. The pip-only view flags this as a losing trade; the total-return view correctly identifies it as profitable. Without ledger separation, a trader following only pip P&L would have closed this position early.

Pair-level analytics reveal expectancy across your entire OANDA trading history. JournalPlus plots average pips per trade and win rate by instrument, session (London, New York, Asian overlap), and day of week. If EUR/GBP consistently underperforms while GBP/USD shows positive expectancy, that data is visible immediately rather than buried across individual trade records. Traders using MetaTrader alongside OANDA can also consolidate both data sources into a single journal for portfolio-level analysis.

Frequently Asked Questions

Does JournalPlus support OANDA’s unit-based trade sizes?

Yes. JournalPlus normalizes OANDA’s unit-based positions to calculate accurate pip values and risk percentages per trade. A position of 50,000 units GBP/USD is treated as a half-lot, with pip value calculated accordingly — not rounded to the nearest standard lot.

How do I import my OANDA trade history into JournalPlus?

Log in to OANDA fxTrade, navigate to My Account > History > Account Statement, select a date range, and download as CSV. Then upload the file in JournalPlus under Settings > Import Trades, selecting OANDA as the broker. The full walkthrough is covered in the setup steps above.

Does JournalPlus track OANDA swap interest and carry income?

Yes. OANDA’s CSV export includes interest as separate line items. JournalPlus imports these as distinct ledger entries, separating pip P&L from carry income so you can calculate true total-return profitability for each position — critical for carry strategies like long AUD/JPY or NZD/JPY.

Can JournalPlus handle multi-currency OANDA accounts?

Yes. Trades in pairs like EUR/TRY or USD/MXN are converted to your account base currency using the exchange rate at close. This mirrors OANDA’s own P&L methodology and ensures your journal reflects accurate realized gains across exotic pairs.

Does JournalPlus integrate with OANDA’s v20 REST API?

Yes. JournalPlus supports automated sync via OANDA’s v20 REST API, which allows pulling up to 90 days of transaction history per request. Once your API key is connected under Settings > Connections, new trades sync daily without manual CSV exports.