2026-03-12 10:46:14 +00:00
|
|
|
# 📊 Crystal Data Extractor — MT5
|
|
|
|
|
|
|
|
|
|
**By Crystal AI Systems** | [MQL5 Profile](https://www.mql5.com/en/users/jawadtrader22)
|
|
|
|
|
|
|
|
|
|
Export **Tick** or **OHLC** market data to a clean comma-separated CSV file — directly from MetaTrader 5.
|
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
## ✅ Features
|
|
|
|
|
|
|
|
|
|
- Two modes: **Tick Data** (Bid/Ask/Last) or **OHLC Bars** (Open/High/Low/Close/Volume/Spread)
|
|
|
|
|
- Works on **live charts** AND **Strategy Tester**
|
|
|
|
|
- Proper CSV format — opens correctly in **Excel** (no column merging)
|
|
|
|
|
- Historical OHLC dump on startup (configurable lookback)
|
|
|
|
|
- Auto-named files with symbol + timeframe
|
|
|
|
|
- Optional file prefix for organizing multiple runs
|
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
## 📁 File Locations
|
|
|
|
|
|
|
|
|
|
### Live Chart:
|
|
|
|
|
```
|
|
|
|
|
File > Open Data Folder > MQL5 > Files > XAUUSD_M15_OHLC.csv
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
### Strategy Tester:
|
|
|
|
|
```
|
|
|
|
|
File > Open Data Folder > Tester > [AgentID] > Agent-127.0.0.1-3000 > MQL5 > Files
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
> ⚠️ Tester files are NOT in the main MQL5\Files folder!
|
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
## ⚙️ Input Parameters
|
|
|
|
|
|
|
|
|
|
| Parameter | Description |
|
|
|
|
|
|-----------|-------------|
|
|
|
|
|
| Data Mode | TICK = raw tick data / OHLC = closed candle bars |
|
|
|
|
|
| Timeframe | Used in OHLC mode only |
|
|
|
|
|
| Lookback Bars | Historical bars dumped on startup (0 = disabled) |
|
|
|
|
|
| File Prefix | Optional label added to filename |
|
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
## 📄 CSV Columns
|
|
|
|
|
|
|
|
|
|
**Tick mode:** `Time, Bid, Ask, Last, TickCount`
|
|
|
|
|
|
|
|
|
|
**OHLC mode:** `Time, Open, High, Low, Close, Volume, Spread`
|
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
## 🚀 How to Use
|
|
|
|
|
|
|
|
|
|
1. Copy `Crystal_DataExtractor.mq5` to your MT5 `MQL5\Experts\` folder
|
|
|
|
|
2. Compile in MetaEditor (F7)
|
|
|
|
|
3. Attach to any chart (e.g. XAUUSD M1)
|
|
|
|
|
4. Set your preferred **Data Mode** and **Timeframe** in Inputs
|
|
|
|
|
5. CSV file is created automatically in `MQL5\Files\`
|
|
|
|
|
|
|
|
|
|
### Strategy Tester Tip:
|
|
|
|
|
> Set the Tester chart TF **lower** than your OHLC input TF.
|
|
|
|
|
> Example: Want H1 OHLC? Run tester on M1 or M5.
|
|
|
|
|
> Use **"Every tick"** model for best accuracy.
|
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
## 📂 File Naming
|
|
|
|
|
|
|
|
|
|
| Mode | Filename |
|
|
|
|
|
|------|----------|
|
|
|
|
|
| OHLC | `XAUUSD_M15_OHLC.csv` |
|
|
|
|
|
| Tick | `XAUUSD_Ticks.csv` |
|
|
|
|
|
| With prefix | `Test1_XAUUSD_M15_OHLC.csv` |
|
|
|
|
|
|
|
|
|
|
---
|
|
|
|
|
|
|
|
|
|
## 📜 License
|
|
|
|
|
|
|
|
|
|
Free to use and modify. Credit appreciated.
|
2026-03-12 10:43:21 +00:00
|
|
|
© Crystal AI Systems — [jawadtrader22](https://www.mql5.com/en/users/jawadtrader22)
|
