Binance Futures CSV Upload

Dr. Christiane Williams

Modified on: Wed, 24 Jul, 2024 at 5:09 PM

Binance has two versions of the Future Trades files. The file can be downloaded from the Trade History or the Transaction History.

1) For the Trade History you can upload via the Custom Exchange Import page and use the following setting to import the Realized Profit.

In CoinTracking, you need to import the realized profit as Futures Gain and Futures Lost. While the settings above only allow you to import them as Deposit and Withdrawal. Therefore, you need to change the transaction type (Deposit --> Income; Withdrawal --> Lost) once you have successfully imported them. You can do that on the Transactionspage using Bulk Edit

Changing transaction-type from Deposit to Futures Gain

2) For the Transaction History, please import your file 3 times with the following settings:

1) Importing COMMISSION, INSURANCE_CLEAR, REALIZED_PNL

(You can also use the attached file (Binance-Futures_Com_Ins_PNL_importSettings (1).dat) to import your settings automatically without having to set the columns and parameters manually. You can find a guide on how to do this here: How to Import / Export Custom Settings)

Whether you set your settings manually or import them with our import file, it is recommended to save your settings for later use.

2) Importing TRANSFER as Deposit and Withdrawal

(You can also use the attached file (Binance-Futures_Transfer_importSettings (1).dat) to import your settings automatically without having to set the columns and parameters manually. You can find a guide on how to do this here: How to Import / Export Custom Settings)

3) Importing FUNDING_FEE as Reward/Bonus and Other Fee

(You can also use the attached file (Binance-Futures_FundingFee_importSettings (1).dat) to import your settings automatically without having to set the columns and parameters manually. You can find a guide on how to do this here: How to Import / Export Custom Settings)

Binance-Futures_FundingFee_importSettings (1).dat
(1.56 KB)
Binance-Futures_Transfer_importSettings (1).dat
(1.55 KB)
Binance-Futures_Com_Ins_PNL_importSettings (1).dat
(1.56 KB)

English

Related Articles