Export History Data to CSV

Export History Data to CSV

Crystal AI Data Extractor — Get Clean MT5 Data Into Excel or Python in One Click

If you have ever tried to pull historical data out of MetaTrader 5 and ended up with a messy file where everything lands in one column — this tool is for you. Crystal AI Data Extractor does one job and does it properly: it takes your MT5 chart data and saves it as a clean, properly separated CSV file that opens correctly in Excel, Python, or any other tool you use.

No more copying and pasting from the terminal. No more broken exports. No more wasting time fixing data before you can even start your analysis.

Two Modes — Pick What You Need

Tick Mode — If you want to record every single price movement as it happens live, this is your mode. Every bid, ask and price update gets written to the file in real time. Useful if you are studying spread behavior, session volatility, or building a tick-by-tick dataset.

OHLC Mode — If you want classic candle data (open, high, low, close, volume, spread) on any timeframe from M1 to Monthly, use this mode. You can pull 500 bars of history the moment the EA starts, and it keeps adding new closed bars as the market moves.

What Gets Saved to the File

When running in Tick Mode, each row contains:

When running in OHLC Mode, each row contains:

Settings You Need to Know

Supported Timeframes

How Your File Gets Named

• OHLC on Gold, H1 timeframe: XAUUSD_H1_OHLC.csv
• OHLC on Gold, H1, prefix "Jan": Jan_XAUUSD_H1_OHLC.csv
• Tick data on Gold: XAUUSD_Ticks.csv
• Tick data on Gold, prefix "London": London_XAUUSD_Ticks.csv

Where to Find Your File After Export

This is the part that catches most people out. MT5 saves files in a different folder depending on whether you ran the EA on a live chart or inside the Strategy Tester.

If you ran it on a live chart:

1. In MT5, click File → Open Data Folder
2. Go into the MQL5 folder, then Files
3. Your CSV file is in there

If you ran it in the Strategy Tester:

1. In MT5, click File → Open Data Folder
2. Go into the Tester folder
3. Open the [AgentID] folder, then Agent-127.0.0.1-3000
4. Go into MQL5 → Files
5. Your CSV file is in there

The EA also prints the exact file path in the Journal tab every time it starts and every time it stops — so if you ever can't find the file, just check the journal and it will tell you exactly where to look.

Live Chart vs Strategy Tester — What's the Difference?

How to Use It — Step by Step

To pull historical OHLC data (Strategy Tester):

1. Attach the EA in the Strategy Tester. Pick your symbol and date range.
2. Set Data Mode = OHLC and choose your timeframe (e.g. H1).
3. Set Lookback Bars = 0 — the tester date range covers everything.
4. Set the tester chart timeframe to something lower than your OHLC timeframe. For example, if you want H1 data, run the tester on M5.
5. Hit Start. When finished, find the file inside: Tester → [AgentID] → Agent-127.0.0.1-3000 → MQL5 → Files

To record live tick data:

1. Drop the EA onto any live chart of the symbol you want.
2. Set Data Mode = TICK. Add a File Prefix if you want to label this session.
3. Leave it running. The file grows in real time as ticks come in.
4. When you are done, remove the EA from the chart. The file closes safely and the path is printed to the Journal.
5. Find the file inside: MQL5 → Files

This Tool Is For You If...

• You want to backtest a strategy in Python or Excel using real MT5 price data
• You are building an AI or machine learning model and need clean historical candles
• You want to study spread patterns, tick flow, or session volatility
• You are tired of MT5's built-in export producing files that need fixing before use
• You need years of OHLC data from your broker without any manual downloading
• You want a simple tool that just works without any complicated setup

Important: This EA does not trade. It does not open, modify or close any positions. It has no effect on your account. Data quality depends on the history your broker has available in MT5. Always check your data before using it in live trading decisions.

© Crystal AI Systems · jawadtrader22