Home Guides

How to export your MT5 trading report

MetaTrader 5 writes your whole history to one HTML file straight from the terminal. Two minutes, no add-on, no broker request. Here is the path, and the two choices that decide whether the file is actually useful.

MetaTrader 5 · desktop terminal · about 2 minutes

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.

Always choose “All History” first. MT5 exports exactly the period the History tab is showing. Miss this and your report covers a week. TapeSheet prints the date range it found at the top of the dashboard, so check that it matches the account you think you are looking at.

HTML or Open XML — both work. A genuine .xlsx does not. The Report submenu offers several formats and two of them are fine. HTML is the safest choice. Open XML saves with an .xlsx extension but is actually plain XML inside, and TapeSheet reads it directly — same deals table, same commissions, swaps and balance operations, same numbers. What we cannot read is a real Excel workbook: if you open either report in Excel and save it, the save converts it into one, so export it again from MetaTrader instead.

Deals, positions, and why TapeSheet does extra work here. MT5 records deals, not round-turn trades, and some broker templates omit the Position column entirely. TapeSheet reconstructs whole positions from the deal list — by position id when it is present, and FIFO when it is not — so partial closes collapse into the trades you actually took. Standalone commission deals are kept out of trade P&L and reported as balance operations, and cancelled or rejected orders are ignored with a note rather than counted.

Your platform does not need to be in English. Character set, decimal comma and non-breaking-space thousands separators are all detected automatically, including non-UTF-8 encodings such as windows-1251. A localised MT5 report parses the same as an English one.

Hedging and netting accounts both work. So do cent accounts and brokers that append symbol suffixes such as XAUUSD.pro — suffixes are normalised so the same instrument does not appear three times in your per-symbol breakdown.

What TapeSheet does with it

It builds an equity and drawdown curve from your closed history, computes profit factor, expectancy, payoff ratio, streaks, hold times and cost drag, breaks results down by symbol, weekday, hour and session, and gives you a journal and a prop-firm rule replay on top. All of it in your browser, with no account and no upload.