Why You Need to Export Trading Records
Maintaining complete trading records is a habit every trader should develop. Its value goes far beyond simply "seeing whether you made or lost money."
The most immediate need is tax reporting. An increasing number of countries and regions are taxing cryptocurrency trades, whether capital gains tax or income tax. Both require you to provide complete transaction details. If you wait until tax season to start digging through records, it will be extremely painful. Regularly exporting and archiving trading records means you can retrieve them whenever needed.
Second is trade review. By analyzing historical trading data, you can discover your trading habits and profit/loss patterns. Which coins do you trade well? What time periods have higher win rates? What's your average holding time? This information is all embedded in your trading records. Systematic analysis provides valuable reference for improving trading strategies.
Additionally, when you encounter account disputes or need to file a support appeal, having independently saved trading records serves as important evidence. While the platform also retains records, having your own copy always provides extra peace of mind.
Querying Historical Orders on the Web
The web version is the most common way to view and export trading records, with an intuitive navigation path.
After logging into the Binance website, click the user icon in the upper right corner and find "Orders" in the dropdown menu. This displays all your trading record categories, including spot orders, futures orders, margin orders, and more.
On the spot orders page, you'll see two tabs: "Open Orders" and "Order History." Switch to "Order History" to view all completed, canceled, and expired orders. You can narrow the view using filters such as specific trading pairs, time ranges, or order statuses.
In the order history list, each record shows the trading pair, order direction (buy/sell), order type (limit/market), set price, fill price, filled quantity, fees, and execution time.
For futures trading records, switch to the "Futures Orders" category on the orders page, where you can similarly view historical orders and trade details. Futures records additionally show leverage multiplier, margin mode, realized P&L, and other information.
Note that web-based online queries typically have time range limitations, and some records may only be retained for a recent period. For older records, use the export function to download complete data.
How to Export CSV Files
Binance provides batch export of trading records as CSV files, suitable for users who need complete data.
The specific path on the web is: after logging in, go to "Orders" > "Spot Orders" > "Trade History" and find the "Export" button in the upper right corner. After clicking, the system asks you to select a time range for export.
Time range limitations apply. A single export typically supports a maximum of three months of data. If you need longer records, you'll need multiple exports. For example, exporting a full year's data requires four separate exports, each covering one quarter.
After selecting the time range and trade type, click confirm and the system begins generating the CSV file. For large data volumes, this may take several minutes. Once generated, a download link appears on the page, and you can also find all generated files on the "Export Records" page.
Downloaded CSV files can be opened with Excel, Google Sheets, or any spreadsheet software. Files contain detailed information for each trade, including timestamp, trading pair, buy/sell direction, price, quantity, fees, and other fields.
In addition to spot trading records, you can separately export futures trading records, deposit records, withdrawal records, and funding rate records. Each type follows a similar export path but is found under different page entries.
Getting Trading Data via API
If you have some technical background, retrieving trading records via API is a more flexible and efficient approach.
Binance's REST API provides multiple trading record query endpoints. For example, /api/v3/myTrades retrieves spot trading records, and /fapi/v1/userTrades retrieves futures trading records. These endpoints require authentication using an API key with "Read" permissions.
The advantage of API data retrieval is automation. You can write a simple script that periodically (daily or weekly) pulls the latest trading data and saves it to a local database or spreadsheet. This eliminates the need to manually log into the website for exports each time.
A simple Python approach would be: use a third-party library like python-binance, call the appropriate API methods, convert the returned JSON data into a DataFrame, then save as a CSV file or write to a database.
When using the API, be mindful of rate limits. Binance imposes rate limits on API calls, and overly frequent requests in a short period may result in temporary access bans. Add appropriate delays between requests and set reasonable query time ranges.
For security, API keys used for retrieving trading records only need "Read" permissions enabled -- don't enable "Trade" or "Withdraw" permissions. The principle of least privilege is fundamental to API key management.
Where to Find Different Record Types
Binance has multiple types of financial activity records distributed across different pages:
Deposit and withdrawal records are found under "Wallet" > "Deposit/Withdrawal History." This shows all on-chain deposit and withdrawal details, including transaction hash, network, address, amount, and status.
Funding rate records are specific to futures trading and can be found on the "Funding Rate" page within the futures account. These records are essential for calculating the true cost of futures trading.
Dividend and airdrop records are under "Wallet" > "Transaction History" in the "Distribution" tab. If you held certain coins and received dividends or participated in airdrops, related records appear here.
Binance Earn income records are under "Earn" > "History." This includes subscription, redemption, and interest payment records for Flexible and Locked Savings.
Internal transfer records are under "Wallet" > "Transaction History" in the "Transfer" tab. Every fund transfer between your spot, futures, and funding accounts is recorded here.
Tips for Organizing and Storing Trading Records
Exporting data is just the first step. How you organize and store these records matters equally.
It's recommended to export and archive on a monthly or quarterly basis. Set a recurring reminder for a fixed date, such as the first of each month, to export all trading records from the previous month. Once you build this habit, you'll never face the predicament of "can't find trading records from months ago."
Use consistent file naming conventions, such as "binance_spot_202603" or "binance_futures_202603." Clear naming lets you quickly find needed records among many files.
For storage, keep copies in at least two different locations. One on your local computer, and a backup on cloud storage or an external drive. Trading records don't take up much space, but losing them can be very difficult to recover, especially for lengthy historical data.
If you trade frequently or need detailed performance analysis, consider using dedicated cryptocurrency tax and accounting tools. These tools can automatically import data from multiple exchanges, calculate profit/loss automatically, and generate reports meeting local tax requirements. This is far more efficient than manually organizing CSV files, especially when you have trading records across multiple platforms.