Trading Journal › Guides

How to export and analyse your crypto trades

Your exchange stores every trade. Here is how to export your position history as a file or connect the API, and turn it into a full analysis in minutes.

Daniel Schollerer · Updated October 22, 2026

Position history or order history?

Most exchanges offer several exports: orders, executions (fills), account movements and the position history. For a trading journal the position history (closed P&L) is best. Each closed position is one row with entry, exit, size and realised result.

The order or fill export lists every partial execution separately. Rebuilding a trade from it is tedious.

Where to find the export

Exchange menus change regularly. Usually you find the export on the website (not in the app) in one of these places:

  • OKX: Assets or Trade → Order history or Position history → Download. OKX keeps the position history of the last months.
  • Bitunix: Futures → History → Position history → Export.
  • WEEX: Futures → Orders → History → Export.
  • Bybit: Orders → Derivatives → Closed P&L → Export.
  • Binance: Orders → Futures → Position history or Trade history → Export.

Choose the longest possible period and CSV or Excel format. Some exchanges send the file by email.

Import the file into the trading journal

  1. Open Import in the journal and drop the file into the box.
  2. Columns are detected automatically: symbol, direction, times, prices, size, result, fees, funding and leverage.
  3. Check the preview. If needed, switch the date format or the file's time zone.
  4. Optionally assign all imported trades to a strategy right away.
  5. Click import. Duplicates are detected and skipped, so you can upload a newer file any time.
Tip: after importing, check whether the result includes fees. Many exports show the result before fees. For that case there is the "result column is before fees" option in the import.

Even easier: automatic import via API

With a read-only API key the journal pulls your closed positions automatically every hour. This is available in Pro for OKX, WEEX and Bitunix. Pro is free for members of Daniel's Academy.

  • Create a new API key at your exchange and give it read-only permission, no trading and no withdrawals.
  • If possible, bind the key to the journal's IP address. You will find it in the journal when connecting.
  • Enter key, secret and passphrase (if required) in the journal. Done.

On OKX the journal automatically rejects keys with trading or withdrawal rights. Bitunix and WEEX do not report a key's permissions, so make sure you only grant read-only rights there. Keys are stored encrypted and you can disconnect any time.

What to review after importing

  • Overall metrics: expectancy, profit factor, drawdown.
  • Long versus short and your best and worst coins.
  • Time of day and weekday: when do you lose the most?
  • Holding time: do you hold losers too long?
  • Then add strategy and mistakes to your key trades and let the AI coach take a look.

Try it right away: the trading journal calculates everything for you. Free, with an AI coach.

Start for free

FAQ

Is my data shared with third parties?

No. Your trades are stored only for your journal. For the AI review a summarised analysis is sent to Claude AI (Anthropic), without your email address.

My exchange is not listed. Will the import still work?

Yes. The CSV import detects the columns of almost any exchange automatically. If not, you map them once using the dropdowns.

Can I import spot trades?

Yes, as long as the file contains a result per row. For plain buy and sell lists without a result, the futures position history works better.

More guides