Home Guides
How to export your MT5 trading report
MetaTrader 5 writes your whole history to one file straight from the terminal. Two minutes, no add-on, no broker request. Pick HTML if you want to analyse it — in TapeSheet or anywhere else — and XLSX only if you plan to pivot the numbers yourself in a spreadsheet first.
All History before you export anything. Skip this step and the file you save covers a week or a month, not your account — and every metric computed from it afterwards describes that slice, not your real history.The short version
Toolbox (Ctrl+T) → History → right-click → All History → right-click → Report → HTML.
Step by step
- Open the Toolbox
In MetaTrader 5, press Ctrl+T (or use View → Toolbox) to open the Toolbox panel at the bottom of the platform, then click the History tab.
- Switch the period to All History
Right-click anywhere inside the history list and choose All History. MT5 defaults to a short recent period, and a report saved from that view contains only that period.
- Choose Report → HTML
Right-click inside the list again, open the Report submenu, and pick HTML — or Open XML, which TapeSheet also reads. Both produce the same numbers.
- Pick a folder
Save it somewhere easy to find, such as your Desktop or Downloads folder. MetaTrader 5 writes a single .html file containing positions, orders and deals.
- Drop it on TapeSheet
Open the TapeSheet analyzer and drag the file onto the drop zone, or click to browse. Parsing happens on your own device and nothing is uploaded.
HTML vs XLSX vs CSV
The Report submenu offers up to three formats depending on your build and broker. Here is what each one actually is, not just what its extension suggests:
| Format | What it contains | Does TapeSheet read it? |
|---|---|---|
| HTML | Every deal, order and position, plus the account summary, in one self-contained file. The safest, most complete choice. | Yes, directly. |
| Open XML (.xlsx) | The same deals table, commissions, swaps and balance operations as the HTML report — it is plain XML inside despite the .xlsx extension, not a genuine Excel workbook. | Yes, directly — same numbers as the HTML report. |
| CSV | A flat, comma-separated table of whichever columns your build exports. No account summary, and column layout varies by broker build. | Not currently — use HTML or Open XML instead. |
A genuine Excel workbook does not read the same way: if you open an HTML or Open XML report in Excel and save it, that save converts it into a real .xlsx file with a different internal structure, and TapeSheet can no longer read it — export straight from MetaTrader again instead of re-saving through Excel.
Deals, orders and positions
MT5 records deals — individual fills — not round-turn trades, and some broker templates omit the Position column that would otherwise tie related deals back together. A position you closed in three pieces shows up as three separate deal rows in the raw export, not one. TapeSheet reconstructs whole positions from the deal list — by position id when it is present, and FIFO (first opened, first closed) when it is not — so partial closes collapse back into the trades you actually took rather than being counted as extra, smaller trades. Standalone commission deals are kept out of trade P&L and reported separately as balance operations, and cancelled or rejected orders are ignored with a note rather than counted as trades that never happened.
MT5 on Mac, the web terminal, and mobile
MetaQuotes does not ship a native Mac application; the desktop terminal runs on a Mac through a Windows-compatibility layer, and once it is running, export works identically to Windows — same Toolbox, same History tab, same Report submenu. The web terminal and the mobile apps both let you view, scroll and filter your history, but neither currently offers the same right-click → Report export with a format choice that the desktop terminal does. For a complete, exportable report, the desktop terminal — on Windows natively or a Mac through a compatibility layer — remains the reliable route.
XAUUSD.pro — suffixes are normalised so the same instrument does not appear three times in your per-symbol breakdown.What TapeSheet does with it
30+ metrics computed from your closed history: an equity and drawdown curve, profit factor, expectancy, payoff ratio, streaks, hold times and a full cost breakdown netting out commission and swap, results broken down by symbol, weekday, hour and session, plus a journal and a prop-firm rule replay on top. One thing worth knowing before you read an hour-of-day breakdown: MT5 timestamps every deal in your broker's server time, not yours, and TapeSheet lets you correct for that offset rather than silently assuming it away. All of it runs in your browser — drop the file in, or see it on a demo file first — with no account and nothing uploaded, which you can confirm yourself in DevTools → Network.
Trading on MT4 instead?
The menu names differ. See how to export an MT4 statement.
Questions
Why does my MT5 report only show recent trades?
The History tab defaults to a short recent period — right-click and choose All History before exporting, or the report you save only covers whatever slice was on screen, and every metric computed from it will describe that slice instead of your account.
What's the difference between deals, orders and positions?
MT5 records deals — individual fills — rather than round-turn trades. A position you closed in two pieces shows up as multiple deal rows, and some broker templates omit the Position column that would otherwise tie them back together. TapeSheet reconstructs whole positions from the deal list, by position id when it is present and FIFO when it is not.
Can I export MT5 history to Excel or CSV?
Yes. The Report submenu offers HTML, Open XML (which saves with an .xlsx extension) and, depending on your build and broker, a CSV export. TapeSheet reads the HTML and Open XML reports directly; a genuine Excel workbook created by opening one of those in Excel and re-saving it is not the same file and should be exported again from MetaTrader instead.
Can I export from the MT5 web terminal or phone app?
Both let you view your history, scroll it and filter by date. Neither offers the same right-click → Report export with format choices that the desktop terminal does. For a complete, exportable report, the desktop terminal remains the reliable route, on Windows natively or on a Mac through a Windows-compatibility layer.
Does the report include swap and commission?
Yes, both are recorded per deal in the export. TapeSheet nets them into your P&L rather than reporting them alongside gross results, so a trade that made money before costs but lost money after them is counted as the loss it actually was.
Ready when you are
Free, no signup, and the file never leaves your device.
Drop the report in — it's read in your browser, nothing is uploadedNo report handy? Load a demo account.
Once it is saved: what the MT5 report analyzer shows you.
This is educational information about measuring your own trading, not financial advice. Trading carries risk of loss. Full risk disclaimer.