How to Import Saxo Bank Trades into PipJournal

Saxo Bank is a premium broker popular with European retail traders and prop-funded accounts, but its proprietary platform means there is no native MetaTrader export. Importing your Saxo Bank trade history into PipJournal requires exporting a CSV from the Reports section and mapping it manually. This guide walks you through each step so your Saxo Bank forex trades are fully analyzed in PipJournal within 15 minutes.

This guide is written for beginner-level users who are new to trade importing. No technical knowledge is required.

Step 1: Log Into Saxo Bank SaxoTraderGO

Open SaxoTraderGO at saxotradergo.saxobank.com or launch the desktop application. Log in with your Saxo Bank credentials.

Once logged in, click the Account menu in the top-right corner. From the dropdown, select Reports. This takes you to the reporting hub where Saxo Bank stores all your historical transaction data.

If you use SaxoTraderPRO, the navigation is slightly different — look for Reports in the main left-side navigation panel rather than the top account menu.

Step 2: Export Your Trade History

Inside the Reports section, select Closed Positions or Trade History (the label depends on your account type and platform version).

Set your date range. Saxo Bank allows up to 12 months per export. If you need more than 12 months, export in 6-month batches and import each file separately into PipJournal.

Filter by Instrument Type: FX to isolate forex trades only. This prevents stocks, bonds, or other instruments from cluttering your export.

Click Export to CSV or Download. The file will typically be named something like ClosedPositions_2026-01-01_2026-06-30.csv.

Step 3: Clean the Export File

Open the downloaded CSV in Excel, Google Sheets, or any spreadsheet tool. Saxo Bank’s export includes all instrument types regardless of the filter in some account configurations, so scan the Instrument or Asset Class column and delete any rows that are not forex pairs (e.g., US500, Apple, Danish government bonds).

Key columns to verify before importing:

Saxo Column	What It Contains
Open Time	Trade open datetime (UTC)
Close Time	Trade close datetime (UTC)
Instrument	Currency pair (e.g., EURUSD)
Amount	Position size in units (not lots)
Open Price / Close Price	Entry and exit prices
P&L	Realized profit or loss in account currency

Saxo Bank reports position size in units, not standard lots. 100,000 units = 1.0 lot. Make note of this — you will need to convert during the import mapping step.

Step 4: Import the CSV into PipJournal

Log in to PipJournal and go to Import Trades in your dashboard. Select Manual CSV Import.

Upload your cleaned Saxo Bank CSV file. PipJournal will display a column mapping interface showing its required fields alongside the headers from your file.

Map the columns as follows:

PipJournal Field	Saxo Bank Column
Open Time	Open Time
Close Time	Close Time
Symbol	Instrument
Direction (Buy/Sell)	Direction or Side
Lot Size	Amount (divide by 100,000)
Entry Price	Open Price
Exit Price	Close Price
P&L	P&L or Profit/Loss

For the lot size conversion, use PipJournal’s built-in unit converter by selecting Units as the input format and entering 100,000 as the divisor. PipJournal will calculate lot sizes automatically.

Once mapped, click Preview Import. Review the first 5-10 rows to confirm the data looks correct before committing the full import.

Step 5: Verify and Tag Your Trades

After the import completes, navigate to your Trade Log in PipJournal. Sort by date and spot-check 3-5 trades against your Saxo Bank account statement to confirm:

• Open and close times match (Saxo Bank exports in UTC — confirm PipJournal is set to the same timezone)
• Lot sizes are correct (a 100,000-unit trade should show as 1.00 lot)
• P&L figures match within rounding tolerance (Saxo Bank may calculate swap/commission separately)

Once verified, apply setup tags to your imported trades. Tagging by strategy type, session, or currency pair unlocks PipJournal’s analytics dashboard filtering, which is where the real performance insights begin.

Pro Tips

• Export monthly batches if you have more than 6 months of history. Smaller files are faster to clean and easier to verify row by row.
• Check swap charges: Saxo Bank often lists swap costs as separate line items. After import, compare your PipJournal P&L totals against your Saxo Bank monthly statement — the difference is usually swap and commission. Tag these separately if needed.
• JPY pairs need attention: Saxo Bank reports JPY pair P&L in JPY, not USD. Verify that PipJournal’s currency conversion setting matches your account’s base currency before importing JPY-heavy trade sets.
• Save your mapping profile: After your first successful import, save the column mapping as a template in PipJournal. Future Saxo Bank imports will use the same mapping automatically.
• Use the 12-month limit strategically: Pull the most recent 12 months first. Analyze that data in PipJournal using win rate by setup before importing older history — most traders find their recent behavior is what needs correcting.

Common Mistakes to Avoid

1. Importing without filtering by instrument type. Saxo Bank is a multi-asset broker. Importing equity or bond trades alongside forex trades corrupts your forex-specific analytics. Always filter or clean the file first.

2. Ignoring the units vs. lots distinction. Saxo Bank reports position size in units. Importing without converting to lots makes every position appear 100,000 times larger than it is, breaking all risk and P&L calculations.

3. Mismatched timezones. Saxo Bank exports in UTC. If PipJournal is set to a different timezone, session analysis (London open, New York overlap) will be wrong by hours. Set PipJournal to UTC or convert the timestamps before importing.

4. Skipping the post-import verification step. Spot-checking 5 trades takes 3 minutes and catches 90% of import errors before they pollute your analytics. Never skip it.

5. Importing all history at once without reviewing. Dumping 3 years of trades into a new journal gives you data without context. Import recent history first, review it with entry timing analysis, then add older data once you understand the patterns.

How PipJournal Helps

PipJournal’s manual CSV import tool handles non-standard broker formats like Saxo Bank’s unit-based exports with a column mapping interface that preserves your custom settings for future imports. Once your trades are in, the analytics dashboard breaks down performance by currency pair, session, and setup tag — letting you see at a glance whether your Saxo Bank execution is consistent with your pre-trade checklist rules. The P&L tracking view accounts for commission and swap separately, giving you a cleaner picture of your true edge than Saxo Bank’s native reporting. For traders managing multiple accounts or brokers alongside Saxo, PipJournal consolidates everything into a single performance view without requiring identical broker formats.