Export cTrader History to Excel: Statement Formats, Stops and Hedging
cTrader's Statement opens as HTML, and what you can save depends on the app. Where the stop-loss lives and what netting does to the rows.
3 Nov 2026 · 6 min read
On this page
In cTrader the export is a Statement, opened from the History tab as an HTML page, and what you can save it as depends on the app. Spotware's Windows help says HTML or .xlsx; its Web and Mac help say save as a .csv file. Below: the steps, what a History row holds, where the stop-loss lives, and what hedging and netting do to the number of rows.
The steps
- Open the History tab of the Trade Watch panel. Closed positions end up there.
- Set the period with the date fields, standard or custom.
- Right-click a column heading to show or hide columns and drag to reorder. Table settings belong to the workspace.
- Click Statement. It opens an account statement in a new tab. On Mac the help puts the button in the Order history window.
- Save it as the app allows (next section), then open it in a spreadsheet.
Which file you get depends on the app
- cTrader for Windows: Statement opens "either an HTML or .xlsx account statement in a new tab". The saved file is described as an Excel spreadsheet in .csv format, so check what lands on your disk.
- cTrader Web: an HTML account statement, then Save stores a spreadsheet in .csv format. No .xlsx option is described.
- cTrader for Mac: the statement opens as HTML, and you can save it as a .csv file or print it. No .xlsx is mentioned.
What a History row holds
The Windows help lists the columns: ID, Order ID, Symbol, opening and closing direction, opening and closing time, entry price and closing price, closing quantity, closing volume in currency, requested quantity, swap, commissions, pips, gross and net profit and loss in account currency and in USD, label, comment, balance and channel. The help says each position is represented by a single deal in the list, and a deal can be opened to show the orders and positions linked to it.
Where is the stop-loss?
Not in the History columns. The Windows help says stop-loss and take-profit appear in the Order history, as orders, and nowhere else on that page; the Mac help says the same of the History tab and the deal information, and places SL and TP in the Positions and Orders tabs. So to get a trade's risk you read the stop order in the order history, or type the risk in yourself.
Hedging and netting decide what a row is
Spotware's trading accounts page says cTrader supports two account types, hedging and netting, and that not all brokers offer both. On a hedging account you can hold several positions in one symbol, long and short together, and manage each on its own. On a netting account you hold only one position in a symbol, and successive opposite orders offset each other by the amount traded. The help also says each order is filled through one or more deals, and closing a position executes an opposing deal.
For your sheet that means this. On a hedging account each position is its own row, so rows track your positions. On a netting account a symbol has one position at a time, so one row can cover a position that was added to and partly closed several times, and the number of rows is not the number of orders you sent. The guide to netting and hedging accounts covers the modes, and the MT5 guide shows the same split between deals and positions on the other platform.
Where to go next
With the table in a sheet, the trading journal template takes risk and result in money and works out R, expectancy and profit factor.
We're working on a free journal and a backtester, with no date yet. Today Trepeat is a trade copier for MT4, MT5 and cTrader, currently on demo accounts, and you can add notes, a grade and screenshots to any copied trade once it closes, with a calendar of your results.
That journal does not import a statement file today; the journal documentation says what it holds.
Written by the Trepeat team.