How to Import FXTM Trades into PipJournal

FXTM (ForexTime) routes most traders through MetaTrader 4 or MetaTrader 5, which means your trade history lives in two places: the MyFXTM portal and the platform itself. This guide walks you through exporting that history and getting it into PipJournal so you can run proper analysis on your results. No programming knowledge required — the process takes under 10 minutes.

Step 1: Log Into Your FXTM MyFXTM Portal

Go to portal.fxtm.com and log in with your FXTM credentials. From the dashboard, select the trading account you want to export — FXTM accounts are labeled by number (e.g., 12345678 ECN, 87654321 Advantage).

Navigate to My Accounts → Account History or Reports. This section lets you generate a statement for any date range. For a first import, select the full available range — typically up to 36 months. If you have been trading with FXTM for longer, start with the most recent 12 months and work backward in separate batches.

Step 2: Export Your Trade History as a CSV or MT4/MT5 Report

Option A — MyFXTM portal export: In the Account History section, set your date range and click Download Statement. Select CSV format. The file will contain columns for ticket, open time, type, lots, symbol, open price, close time, close price, swap, commission, and profit.

Option B — MetaTrader platform export (more detailed): Open MT4 or MT5 and go to View → Terminal → Account History. Right-click anywhere in the history panel and choose Save as Detailed Report. This saves an HTML file that PipJournal can also parse. The MT4/MT5 export includes every tick-level detail including partial fills, which is useful for scalpers or traders who scale in.

For most traders, the CSV from MyFXTM is sufficient. Use the MT4/MT5 HTML export only if you need per-leg breakdowns on scaled positions.

Step 3: Format and Clean the Export File

Open the CSV in a spreadsheet application and check for these common issues before importing:

• Header row present: PipJournal expects a header row. If the file starts with account metadata (account number, balance, etc.), delete those rows so the column headers appear on row 1.
• Pending orders included: Filter out rows where the “Type” column shows “buy limit”, “sell limit”, “buy stop”, or “sell stop” — these are pending orders, not closed trades. Delete them.
• Swap and commission rows: Some FXTM exports list swaps as standalone rows with a ticket number ending in “-1”. Delete these rows — PipJournal reads swap from the trade row directly.
• Currency: Confirm the “Profit” column is in your account’s base currency (USD for most FXTM ECN accounts). Mixed-currency accounts require separate exports per currency denomination.

Save the cleaned file as CSV (UTF-8 encoding).

Step 4: Import the File Into PipJournal

In PipJournal, go to Import → Upload File. Select your cleaned CSV or MT4 HTML file. The import wizard will detect the file format and display a column mapping screen.

Map the following fields:

PipJournal Field	FXTM CSV Column
Ticket	Ticket
Open Time	Open Time
Close Time	Close Time
Symbol	Symbol
Direction	Type
Lots	Volume
Open Price	Open Price
Close Price	Close Price
Profit (pips)	— (calculated)
Profit (USD)	Profit
Swap	Swap
Commission	Commission

Click Confirm Mapping and then Import. PipJournal will process the file and display an import summary showing the number of trades loaded, total net P&L, and any rows skipped.

Step 5: Verify Imported Trades and Add Tags

Cross-check three numbers against your FXTM statement:

1. Trade count — total closed positions should match exactly
2. Gross profit — sum of all winning trades
3. Net P&L — gross profit minus swap and commission

A discrepancy of more than $1 usually means swap rows were not removed from the export, or a row was skipped due to a formatting issue. Re-export, clean, and re-import if needed.

Once verified, use PipJournal’s tag system to categorize your trades. Useful tags for FXTM traders: session (London, New York, Asian), setup type (breakout, pullback, reversal), and account type (ECN, Advantage Plus) if you trade across accounts. Tagging 20-30 trades takes about 5 minutes and unlocks the analytics dashboard filters that show you where your edge actually lives.

Pro Tips

• Schedule monthly exports: Set a calendar reminder on the last trading day of each month to export and import that month’s trades while the context is fresh.
• Use the MT5 export for prop firm accounts: If your FXTM prop-style account runs on MT5, the HTML detailed report captures commission structures more accurately than the CSV portal export.
• Import oldest trades first: PipJournal builds your equity curve chronologically — importing in reverse order creates a confusing chart. Always import from oldest to newest when batching.
• Tag by account before anything else: If you run an ECN account and an Advantage account simultaneously, tag them on import so your win rate and expectancy metrics stay separated.
• Cross-reference with the FXTM monthly report: FXTM emails a monthly statement PDF. Use it as a final audit against your PipJournal import totals.

Common Mistakes to Avoid

1. Importing without cleaning pending orders. Pending orders that never triggered inflate your trade count and distort your win rate. Always filter the Type column before importing.

2. Ignoring commission in P&L reconciliation. FXTM ECN accounts charge $4 per lot round-turn. On 50 trades averaging 0.5 lots, that is $100 in commissions — enough to flip a breakeven month to a losing one if excluded from analysis.

3. Importing duplicate date ranges. If you import January through June, then later import March through August, trades from March to June appear twice. Always check PipJournal’s date range before each import and exclude already-imported periods.

4. Skipping the verification step. Assuming the import is correct without checking trade count and net P&L means you may be making decisions based on incomplete data. The verification step takes 60 seconds and catches 90% of import errors.

5. Using gross profit for strategy comparison. FXTM’s commission structure varies by account type. Always compare net P&L (after swap and commission) when measuring your trading edge across different setups.

How PipJournal Helps

PipJournal’s import wizard handles FXTM’s CSV and MT4/MT5 HTML formats without requiring any manual field manipulation beyond the cleanup steps above. Once your trades are in, the analytics dashboard breaks down performance by pair, session, lot size, and tag — giving you the kind of breakdown that FXTM’s own reporting never provides. Features like equity curve visualization and drawdown tracking work immediately from imported data, so you can see your full account history as a coherent story rather than a disconnected list of trades. For traders running multiple FXTM accounts — common among those testing different strategies or account types — PipJournal’s multi-account view consolidates everything into one dashboard.