Binance trading journal: export your history and journal it in R

Last checked: 8 October 2026. Exchange menus, fees and rules change, so confirm on the exchange’s own site before you rely on them.

Binance is the exchange most of our crypto users start on, and its exports are detailed enough to journal well. The two things that trip people up are fees paid in BNB, which hide the real cost of a trade in a different coin, and the difference between USDⓈ-M and COIN-M futures, which settle profit in different currencies.

Export your spot trade history

1. On the website, open your profile menu and go to Orders › Spot Order › Trade History.
2. Click Export Trade History, set the start and end dates, and click Generate.
3. Binance notifies you when the file is ready. Download the CSV. The link stays valid for 7 days.

Each statement covers up to one year, from any start date after 13 July 2017, and you can generate 5 statements a month. Times are in UTC, so a trade you placed at 9pm in New York shows the next day’s date. On the app the path is Trade › Orders › Trade History › Download: the last six months export straight away, up to 10,000 rows, and older ranges are generated in the background.

Export your futures history

For futures, go to Orders › USDⓈ-M Futures Order (or COIN-M) › Order History › Export. Choose Beyond 3 months, Custom for older history. This export is order-level. Realised P&L, commission and funding fees are shown in the futures Transaction History view, so check there for the funding you paid. Funding on most contracts settles every 8 hours, at 00:00, 08:00 and 16:00 UTC, and some USDⓈ-M contracts settle every 4 hours.

Binance’s help pages describe the order-history export for futures but do not list the CSV columns. Open the file before importing and confirm it has a symbol, side, quantity and price on every row.

Fees paid in BNB: put them back in dollars

If you pay fees with BNB, the fee column shows a small amount of BNB and the Fee Asset column says BNB. Your USDT P&L then looks better than it is, because the cost left a different wallet.

USDⓈ-M versus COIN-M

COIN-M results are in coin, and the coin’s own price moves while you hold. A trade that made 0.01 BTC is worth more in dollars if BTC rose during the trade. Keep COIN-M on its own account in your journal so its R figures are not mixed with dollar results. The Deribit page works through an inverse contract example in both units.

How the import works

1. In the journal, open Import and choose the CSV option, or pick Binance / Bybit (Crypto) in the paste box.
2. The journal reads headers such as Realized Profit, Fee Asset and Order Side and treats the file as a crypto export.
3. A fill export has one row per execution. The journal pairs buys and sells per symbol first in, first out into round trips, and anything unmatched becomes a currently open position.
4. Add your stop to each trade, if it was not in the export, so the journal can show R. Then tag the setup.

Set the account’s cost preset

For trades you log by hand, set the account’s crypto cost preset. Binance’s base futures fee for a regular user is 0.02% maker and 0.05% taker. The journal’s perp preset uses 0.055% per side with 0.01% funding per 8 hours, which is slightly conservative for Binance. Choose Custom and enter 0.05% if you mostly take liquidity, or your own VIP rate.