How to get trade history from Binance

Cryptact Now Supports Australian Dollar (AUD) as Accounting Currency

As of December 21, 2023, we now support the Australian Dollar (AUD). You can check from the ledger settings page. For more information please find the details in our news article. 

Trade types that can be obtained by Binance API and exchange file.

Please see this article for more details about our support for Binance.

Binance limits the the history in one file to be 10,000 lines.

When changing the period, please add 1 day of a safe margin between periods. For example, if you download from 2019/02/01 to 2019/04/1, the next download should start from 2019/03/30.

Please download excel files.

When downloading the files, please make sure to download in excel files since we don't support PDF files.

Please see below link for how to download Binance Japan trade history file.

How to download trade history from Binance Japan


Contents

  1. Spot trade history
  2. Margin (Cross) history
    1. Trade history
    2. Borrow history
    3. Return history
  3. Margin(Isolated) history
    1. Trade history
    2. Borrow/Return (as custom)
  4. Leveraged token: Subscription and Redemption
  5. Futures history
    1. USDⓈ-M Future transaction history
    2. COIN-M Future transaction history
  6. Buy Crypto history
  7. Withdrawal history
  8. Convert history
  9. Conversion history of Small Amount to BNB (Custom trades)
  10. Referral
    1. Commission history
    2. Commission Fees Shared with You
  11. Mining reward (Binance pool)
  12. Auto-Invest history
  13. Saving History
  14. ETH 2.0 Staking history
    1. Stake
    2. Distribution
  15. Upload trade history files from Binance

1.  Spot trade history

1. Choose "Spot Order" from the menu bar.

スクリーンショット 2023-12-05 141913.png

 

2. Choose "Trade history" from "Spot Order", then click "Export Trade History"

スクリーンショット 2023-12-05 141540.png

 

Choose the period, "Excel" file and "Export".

スクリーンショット 2023-12-05 141645.png

 

3. If you have traded more than 6 months

Repeat to download by changing the period in the dialog above, and get all trade histories.

After that, upload them in "append" mode from the oldest file to the newest.

append.png

 

2.  Margin (cross margin) trade history

1. Choose "Margin Order" from "Orders"

EN-40-margin-menu.png

 

2. Choose "Trade history" from "Margin Orders". Confirm "Cross" is selected, then click "Export complete trade history".

EN-3-margin-trade.png

 

3. Likewise, choose "Borrowing"

Confirm "Cross" is selected, then click "Export complete trade history".

EN-4-margin-borrow.png

 

4. Likewise, choose "Repayment"

Confirm "Cross" is selected, then click "Export complete trade history".

EN-5-margin-repay.png

 

3.  Margin (Isolated margin) trade history

1. Choose "Margin Order" from "Orders"

EN-40-margin-menu.png

 

2. Choose "Trade history" from "Margin Orders". Confirm "Isolated" is selected, then click "Generate All Trade Statements".

mceclip2.png

 

3. As there is no download function for the borrowing/repayment history of the isolated margin, you will need to upload them as custom trades. Please check this article to download the custom file format.

Please see below for the description method.

 

Example: Borrowing 3BNB at compound, then returned.

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
datetime of the borrowing BORROW Any BNB 3
(Empty)
JPY 0 JPY
datetime of the returning RETURN Same one with borrowing BNB 3
(Empty)
JPY 0 JPY

 

 

4.  Leveraged token: Subscription and redemption

1. Choose "Leveraged Tokens" from "Derivatives"

 

EN-10-lev.png

2. Choose "Subscription History" and click "Export Subscription History".

EN-10-lev-sub.png

3. Choose "Redemption History" and click "Export Redemption History".

EN-10-lev-red.png

 

5.  Futures transaction history

USDⓈ-M Futures transaction history

1. Choose "Futures Order" from the menu

EN-1-Menu.png

2. From "Futures Orders", choose "Transaction History"

EN-2-sub-menu.png

 

3. Click "USDⓈ-M Futures", and click "Export Complete transaction history". Specify the trade period and download the file. If you have traded for more than 3 months, repeat downloading while changing the period so that you can get all transaction histories.

mceclip3.png

 

 

COIN-M Futures transaction history

Like USDⓈ-M Futures, in the transaction history menu, click "COIN-M Futures", and click "Export complete transaction history". Repeat downloading if you have more than 3months of trade history.

mceclip4.png

 

6.  Buy Crypto(Credit card) history

Choose "Buy Crypto History" and click "Buy", and then click "Export Buy History".

bi-card-1-en.png

In the download dialog, specify status=Completed, Method=Credit Card. Choose your trade period and download. If you have traded for more than 3 months, repeat downloading by changing the period of 3 months so that you can get all transaction histories.

bi-card-2-en.png

 

7.  Withdrawal history

We support blockchain network fees in this file.

EN-6-wallet.png

EN-6-wallet-hist.png

1. Click "Wallet" and choose "Overview"

2. Choose "Transaction History"

3. Switch to "Withdrawal"

4. Click "Export Withdrawal History"

 

8.  Convert history

1. Click "Orders", and select "Convert History".

mceclip0.png

 

2. In the Convert History section, click "Export".

mceclip1.png

 

3. Select the date range and then click "Export".

* The maximum number of trades that can be downloaded at one time is 10,000. If you have a large number of trades to download, please download them multiple times and upload them in order of the oldest to the newest.

mceclip3.png

 

9.  Conversion history of Small Amount to BNB (Custom trades)

Cryptact does not handle the conversion history of small amounts in your wallet to BNB. Please upload them separately as custom trades.

Please check your BNB Convert history on the Binance screen and identify trades that need to be uploaded as custom trades. Please refer to section 2.1 of this article and upload them.

 

An example of converting two A-COIN to three BNB for a fee of 0.1 BNB

Timestamp Action Source Base Volume Price Counter Fee FeeCcy
Datetime SELL Binance etc. A-COIN 2
1.5*
BNB 0.1 BNB

*Price is the price for a single A-COIN in BNB. In this case, it is 1.5 (=3/2).

 

10.  Referral history

1. Commission history

Login and click "Referral".

mceclip8.png

 

Click "Export complete history" on Commission History column.

mceclip9.png

 

Choose "Latest 1 year (or Latest 3 months)" for Time range, "Commission History" for Type, "All Accounts" for Account Type, then click "Export".

An email notification will be sent to your registered address, and you will be able to click on the "Download" link.

mceclip10.png

 

2. Commission Fees Shared with You

Login and click "Referral".

mceclip8.png

 

Click "Export complete history" on Commission Fees Shared with You column.

mceclip11.png

Choose "Latest 1 year (or Latest 3 months)" for Time range, "Commission Fees Shared with You" for Type, "All Accounts" for Account Type, then click "Export".

An email notification will be sent to your registered address, and you will be able to click on the "Download" link.

mceclip12.png

 

11.  Mining (Binance Pool)

Click "Binance Pool" in Finance.

mceclip2.png

 

Click "Earnings", choose the period and click "Download". 

mceclip3.png

 

12.  Auto-Invest history

* Auto-Invest history cannot be fetched via API.

 

After logging in, click "Orders", and then select "Earn History".

mceclip4.png

In the Earn History section, click "Auto-Invest", and then click "Export".

mceclip5.png

 

Select Coin to "すべて(All)", select the date range and then click "OK".

mceclip6.png

 

13. Saving history

After logging in, click "Orders", and then select "Earn History".

mceclip7.png

 

In the Earn History section, click "Simple Earn", and then click "Export".

スクリーンショット 2023-11-21 172005.png

 

Please select the corresponding transaction by checking the box next to it based on your own transactions.

スクリーンショット 2023-11-21 172325.png

 

スクリーンショット 2023-11-21 172401.png

*Note that the title of the downloaded file will be the same for all files. If you wish to distinguish them, please edit the file titles on your own.

 

14.  ETH2.0 Staking history

After logging in, click "Orders", and then select "Earn History".

mceclip4.png

 

In the Earn History section, click "Staking", and then click "Export".

mceclip0.png

 

For Stake history;

Select "Stake" on the Type, date and click "OK"

__________2023-02-24_153947.png

 

For Distribution;

Select "Distribution" on the Type, date and click "OK"

__________2023-02-24_154035.png

15.  Upload trade history files from Binance

After downloading the trade history files, please upload them via upload screen.