How to Import MT4 Trades

Importing MT4 trades into a structured journal is the fastest way to build a complete trading record. Most forex traders accumulate months or years of trades in MetaTrader 4, but the platform itself doesn’t provide the behavioral analysis and pattern detection you need to improve.

This guide walks you through extracting your MT4 trade history and importing it into a trading journal where you can analyze and learn from every trade.

Why Import MT4 Trades?

MetaTrader 4 was built to execute trades, not to analyze them. The History tab shows you what happened, but it doesn’t tell you why or what to learn.

A trading journal does both.

When you import your MT4 trades into a dedicated journal, you gain:

• Session-by-session breakdown — Which sessions are profitable for you specifically?
• Pair performance analysis — Do you win on EUR/USD but lose on GBP/JPY?
• Emotional correlation — When you tag your trades with your emotional state, do your best trades come from calm vs. rushed entries?
• Progress tracking — Compare your win rate, average R, and expectancy across months

MT4 can’t do any of this. It’s a trading platform, not an analysis platform.

Step 1: Export Trades from MT4

Open MetaTrader 4 and navigate to the History tab (usually at the bottom of the terminal window).

You’ll see a list of all your closed trades. If this list is empty, it means MT4 is only showing trades from the current session. To see older trades:

1. Right-click in the History tab
2. Select “History Center” or click the icon that looks like a calendar
3. Choose the date range you want (e.g., last 6 months, all time)
4. Click “Download” or “Refresh” to load the full history

Once your complete trade history is displayed:

1. Select all trades — Press Ctrl+A or right-click and select “Select All”
2. Right-click and choose “Export” — Some versions have this directly in the context menu
3. Choose CSV format — Save as a .csv file to your computer
4. Name it clearly — Something like “MT4_2026_TradeHistory.csv”

Pro tip: If your MT4 doesn’t show an Export option, you can copy all trades (Ctrl+A, Ctrl+C) and paste them into a spreadsheet. Then save as CSV. It’s less elegant but works.

Step 2: Review Your MT4 Export File

Before importing, open the CSV file in Excel or Google Sheets to verify the data quality.

A proper MT4 export includes these columns:

Column	Example	Notes
Ticket	12345	Trade ID (unique)
Symbol	EURUSD	Currency pair
Open Price	1.0856	Entry price
Close Price	1.0891	Exit price
Lots	0.30	Position size
Open Time	2026-03-15 14:32:00	Entry timestamp
Close Time	2026-03-15 16:45:30	Exit timestamp
Profit (USD)	105.00	P&L in account currency

If you see blank columns or missing data, don’t panic. Some older MT4 versions export less detail. The critical fields are: Symbol, Open Price, Close Price, Lots, Open Time, Close Time.

Check for data issues:

• Are all trades present? Count the rows and compare to your MT4 History count.
• Do timestamps make sense? Is Open Time always before Close Time?
• Are there any corrupted entries (text where numbers should be)?

If you find problems, go back to MT4, re-export, and try again.

Step 3: Prepare the CSV for Import

This step depends on your journal app. If you’re using a journal with an import wizard (like PipJournal), the wizard will guide you through field mapping. If you’re using a spreadsheet, you’ll need to organize the columns yourself.

For dedicated journal apps (recommended path):

Most modern journal apps detect the CSV format automatically and ask you to map columns. You’ll see something like:

MT4 Column    →    Journal Field
Symbol        →    Pair
Open Price    →    Entry Price
Close Price   →    Exit Price
Lots          →    Position Size
Open Time     →    Entry Date/Time
Close Time    →    Exit Date/Time
Profit        →    P&L

The app does the matching; you just confirm it’s correct.

For spreadsheet-based tracking:

Rearrange your CSV columns to match your spreadsheet structure. If your template has columns: Date, Pair, Direction, Entry, Exit, Size, Pips, P&L — map the MT4 export columns to these.

You’ll also need to calculate:

• Direction — Long or Short? Check if Close Price is above Open Price (Long) or below Open Price (Short)
• Pips — (Close Price - Open Price) × 10,000 for 4-decimal pairs (EUR/USD, GBP/USD, etc.). For 3-decimal pairs (USD/JPY), multiply by 100.
• Risk % — (P&L / Account Size at entry) × 100

Step 4: Import into Your Trading Journal

If using a dedicated journal app (like PipJournal):

1. Open the Import section — Usually under Settings or Tools
2. Click “Import Trades” and select your CSV file
3. Review the column mapping — The app will show which CSV columns match which journal fields
4. Confirm and import — Click “Import” or “Process”

The app will:

• Read each row (trade)
• Check for duplicates (if you’ve imported before)
• Store all data in the journal

During import, watch for:

• Error messages — If a trade fails to import, the app will usually tell you why (missing price, invalid date format, etc.)
• Duplicate detection — If you’re re-importing and the app detects duplicates, it will either skip them or ask you to choose
• Timezone handling — MT4 exports timestamps in your MT4 timezone. Ensure your journal is set to the correct timezone (usually GMT or UTC for forex)

If using a spreadsheet:

Simply paste or import the MT4 CSV data into your spreadsheet columns. Then add extra columns for context that MT4 doesn’t capture:

• Session (London/NY/Asian)
• Setup Name (breakout, reversal, etc.)
• Emotional State (calm, frustrated, etc.)
• Notes

Step 5: Verify Accuracy

After import, manually spot-check 10-15 trades. Open your MT4 History tab and compare a trade from your journal to the original in MT4.

What to verify:

• Pair name matches exactly (EURUSD, not EUR-USD or EUR_USD)
• Entry and exit prices are correct to the pip
• Position size (lots) is correct
• Entry and exit times are in the right order (entry before exit)
• P&L calculation is accurate

If you find systematic errors (e.g., all pips are off by 10), stop and fix the mapping before importing more.

Common issues:

Issue	Cause	Fix
Dates are scrambled (2026-15-03 instead of 2026-03-15)	CSV date format mismatch	Adjust your spreadsheet date format or re-export
Pairs show as “EURUSD.m” or with extra characters	MT4 uses broker-specific naming	Manually clean the symbols or use a find-replace
P&L values are off by a factor of 10	Lot size calculation error	Verify lot size format (0.30 vs 30)
Trades are duplicated	Re-imported same CSV twice	Check journal’s duplicate detection settings

Step 6: Add Missing Context

MT4 exports only execution data. To make your journal truly valuable, add context that MT4 doesn’t capture.

For your most important trades (biggest winners and losers), add:

• Session — London, New York, or Asian? (Based on Open Time)
• Setup Name — What pattern did you trade? (breakout, support bounce, news trade, etc.)
• Emotional State — How did you feel before entry? (calm, excited, frustrated, bored)
• Pre-trade Plan — Did you have a plan before entering? (Yes/No)
• Rule Compliance — Did you follow your trading plan? (Yes/No)
• Post-trade Notes — What would you do differently? (2-3 sentences)

Example entry after adding context:

Pair: EUR/USD
Entry: 1.0856 | Exit: 1.0891
Pips: +35 | P&L: +105
Date: 2026-03-15 14:32

Session: London
Setup: Breakout above London open
Emotional State: Calm
Pre-trade Plan: Yes
Rule Compliance: Yes
Notes: Entered long after price cleared the London open high with confirmation on the 5-min chart. Exited at Asian session low. Clean execution.

You don’t need to do this for every trade—100 trades with no notes is better than 20 trades with perfect notes. But for your biggest trades, context is gold.

Making MT4 Import Part of Your Routine

The goal is to make this a repeatable process:

1. Monthly export — Export your MT4 History once per month
2. Import to journal — Upload the CSV and verify accuracy
3. Add context — Spend 30 minutes adding notes to your biggest trades
4. Review — Once per week, analyze patterns in your import

This rhythm ensures your journal stays current and your analysis stays sharp.

The Bottom Line

Importing MT4 trades into a journal transforms raw execution data into actionable insights. MT4 tells you what happened. A journal tells you why it happened and what to do about it.

Once your trades are imported, your real work begins: identifying patterns, understanding your edge, and building the discipline to repeat what works.

---

PipJournal is the only trading journal built exclusively for forex traders, with automated MT4 import, session-based analytics, and an AI co-pilot that surfaces behavioral patterns from your trading data.