Skip to main content

Exporting Trade History to CSV/XLSX (All Bots & SmartTrade)

Export DCA, Signal, SmartTrade, and Grid bot history, plus backtest results, as CSV/XLSX with simple import steps and column descriptions.

Updated yesterday

How to export DCA Bot trades (CSV)

  1. (Optional) Set filters (e.g. date, accounts, bots, pairs, direction).

  2. Click Export.

  3. Choose date format and CSV separator then confirm export.

  4. Check your email for the download link and unzip then import to Excel.

DCA Bot CSV Columns

Column

Description

deal_id

Unique trade ID assigned to each DCA trade.

status

Final trade status (e.g. completed, cancelled, failed, etc.).

bot

Bot name or title.

account

Exchange account used for the trade.

bot_id

Unique ID number of the bot.

bot_pairs

Number of trading pairs the bot trades.

strategy

Strategy type (long or short).

signals

Indicator or signal used to start the trade.

pair

Trading pair (e.g. BTC/USDT).

take_profit_condition

Take-profit percentage.

safety_order_volume / base_order_volume

Ratio of averaging order to base order sizes.

safety_order_step_percentage

Price deviation between averaging orders in %.

take_profit_type

Type of profit target (from base or average price).

created_at

Trade start date and time.

closed_at

Trade close date and time.

duration

Time between opening and closing the trade (in seconds).

profit_percentage_from_total_volume

Profit % based on total trade volume.

profit_percentage_from_base_volume

Profit % based on base order only.

max_safety_orders_count

Maximum number of averaging orders set in the bot.

active_safety_orders_count

Maximum number of active averaging orders placed in exchange in the bot.

used_safety_orders

Number of averaging orders actually used.

martingale_volume_coefficient

Multiplier for increasing order sizes.

martingale_step_coefficient

Multiplier for expanding order spacing.

safety_order_volume

Averaging order size

safety_order_volume_type

Volume unit (quote or base currency).

base_order_volume

Base order size.

base_order_volume_type

Volume unit (quote or base currency).

bought_volume

Total bought volume in quote currency.

sold_volume

Total sold volume in quote currency.

bought_amount

Quantity of asset bought.

sold_amount

Quantity of asset sold.

base_order_price

Price of the initial base order.

final_profit

Total realized profit in quote currency.

close_date

Date the trade was closed.

note

Any user notes attached to the trade.

Import to Excel (CSV)

Opening the downloaded file as-is may put all the data in a single column. Follow the steps below to import it so your data appears neatly in columns.

  1. Open Excel and start a blank worksheet.

  2. Go to Data → From Text/CSV and choose your downloaded file.

  3. You'll then see a smaller pop-up window with a preview of the data. Click "Load," and your data will be imported nicely into columns.


How to export DCA Backtesting results

  1. Open the Backtest history page and choose a completed backtest.

  2. You can export two types of files from your backtest report:

    1. Overview file: contains a summary of key performance metrics for your strategy.

    2. Logs file: Provides detailed trade-by-trade data for every deal executed during the backtest.

Overview CSV Columns

Column

Description

PnL

Total realized profit or loss for the strategy.

PnL Currency

Currency in which PnL is displayed.

PnL Percent

Profit or loss expressed as a percentage of invested capital.

uPnL

Unrealized profit or loss for open positions.

uPnL Currency

Currency of unrealized PnL.

uPnL Percent

Unrealized profit or loss in percentage terms.

Period

Duration of the backtest or data sample.

Period Units

Unit of time used for the period (e.g. days, hours).

Deals Closed

Number of completed deals during the test period.

Win Rate Percent

Percentage of profitable deals.

Max Safety Orders Used

Highest number of safety orders used in any deal.

Avg Trade Duration

Average time a deal stayed open.

Avg Trade Duration Units

Unit of time for average trade duration.

Max Trade Duration

Longest trade duration recorded.

Max Trade Duration Units

Unit of time for maximum trade duration.

Max Drawdown

Largest equity decline measured in currency units.

Max Drawdown Units

Currency used for drawdown measurement.

Max Drawdown Percent

Largest equity decline as a percentage.

Max Floating Drawdown

Maximum unrealized loss during open trades.

Max Floating Drawdown Units

Currency used for floating drawdown.

Max Floating Drawdown Percent

Maximum unrealized loss as a percentage.

Avg Win Trade

Average profit per winning trade in currency terms.

Avg Win Trade Units

Currency unit for average winning trade.

Avg Win Trade Percent

Average profit per winning trade as a percentage.

Avg Loss Trade

Average loss per losing trade in currency terms.

Avg Loss Trade Units

Currency unit for average losing trade.

Avg Loss Trade Percent

Average loss per losing trade as a percentage.

Total Fees

Total trading fees paid during the test.

Total Fees Units

Currency in which total fees are displayed.

Sortino

Sortino ratio – risk-adjusted return metric.

Sharpe

Sharpe ratio – overall return-to-volatility measure.

Standard Deviation

Volatility of returns across all trades.

Logs CSV Columns

Column

Description

Deal Id

Unique identifier of each individual trade.

Start Date

Timestamp when the deal opened.

Start Date Units

Time-unit formatting used for the start date.

Close Date

Timestamp when the deal closed.

Close Date Units

Time-unit formatting used for the close date.

Pair

Trading pair for the deal (e.g. BTC/USDT).

Type

Trade direction or order type (e.g. long, short).

Price

Execution price of the trade.

Price Units

Currency of the price field.

Volume

Total trade volume.

Volume Units

Unit of measure for trade volume (base or quote).

PnL

Profit or loss for the completed deal.

PnL Units

Currency of the profit or loss.

Maximum Floating Drawdown

Largest unrealized loss during the deal.

Maximum Floating Drawdown Units

Currency of floating drawdown.

Order Id

Unique identifier for each order within the deal.

Order Type

Base order, TP order or safety order.

Order Amount

Amount allocated to each order.

Order Amount Units

Currency or unit for each order amount.

Order Price

Execution price for each order.

Order Price Units

Currency used for order prices.

Order Filled

Timestamp when the order filled.

Order Filled Units

Time-unit formatting used for the filled date.

Order Volume

Total value of each executed order.

Order Volume Units

Currency of each order’s total value.


How to export Signal Bot trades

  1. Choose History and filter your Signal bot trades which you want to export then Export.

  2. Choose the date format and click OK.

Signal Bot CSV Columns

Column

Description

Coin

The cryptocurrency traded by the Signal bot (e.g., BTC, ETH).

Account

The connected exchange account where the trade was executed.

Date opened

The date and time when the Signal bot opened the trade.

Date closed

The date and time when the trade was closed.

Market

The trading pair used in the trade (e.g., BTC/USDT).

Status

The final state of the trade (e.g., finished, cancelled, failed).

Units

The quantity of the asset bought or sold during the trade.

Total

The total trade value, calculated as Units × Price.

Buy Price

The average price at which the asset was purchased.

Sell Price

The average price at which the asset was sold.

Profit

The realized profit or loss in the selected currency.

Profit %

Profit or loss expressed as a percentage of the total trade value.

Profit Currency

The currency used to calculate profit (e.g., USDT).

Note

Any user-defined notes or comments attached to the trade.


How to export SmartTrade history

  1. (Optional) Set filters (date, source, pair, account). You can also export Signal bot trades on this page.

  2. Click Export.

  3. Choose the date format and click OK.

SmartTrade CSV columns is the same with Signal bot CSV columns.


How to export Grid Bot closed orders (XLSX)

  1. Go to your Grid Bot and click on the three dots and choose View history.

  2. Filter the table and click Export. An XLSX file of the table will download.

Grid Bot XLSX columns

Column

Description

id

Unique identifier assigned to each Grid Bot order.

price

The execution price at which the grid order was placed or filled.

order_side

Indicates whether the order is a buy or sell grid level.

pair

The trading pair used in the bot (e.g., BTC/USDT).

profit_currency

Currency in which profits and fees are calculated (e.g., USDT).

status

Current state of the grid order (e.g., executed, cancelled).

error_message

Displays any exchange or system error returned during order execution.

amount

Quantity of the base asset in the order.

total

Total value of the order (amount × price) in quote currency.

realized_profit

Profit (or loss) realized when the grid order was closed.

commission

Exchange trading fee or commission applied to the order.

closed_on

Date and time when the grid order was completed or cancelled.

enter_trade_id

Links the closed grid order to the main trade or parent order ID for tracking related transactions.

avg_position_entry_price

Average entry price of the bot’s open position after this order executed.

after_change_funds

Marker showing that the order was created after a Add Funds action. If blank or FALSE, the order was not caused by an Add Funds action and it’s a normal grid order.

Did this answer your question?