search

provinzio / CoinTaxman

Calculate your taxes from cryptocurrency gains
GNU Affero General Public License v3.0
142 stars 31 forks source link

how Binance transactions export works ? #93

Closed jancovic closed 2 years ago

jancovic commented 2 years ago

Hi I have question, when I generate Transactions csv file from Binance, I don't see there price, for what was the coin Bought/sold, Any idea how it works the calculation in Tax Software, when there is no info about Spot price ?

example of my csv

2021-04-22 20:27:28,Spot,Buy,BTC,0.00203500,"" 2021-04-22 20:27:28,Spot,Fee,BTC,-0.00000204,"" 2021-04-22 20:27:28,Spot,Transaction Related,USDT,-105.82000000,"" 2021-04-23 06:58:24,Spot,Fee,BNB,-0.00007500,"" 2021-04-23 06:58:24,Spot,Transaction Related,USDT,-48.06804000,"" 2021-04-23 06:58:24,Spot,Buy,BNB,0.10000000,"" 2021-04-23 08:36:09,Spot,Transaction Related,USDT,-10.13148818,"" 2021-04-23 08:36:09,Spot,Buy,BTC,0.00020900,"" 2021-04-23 08:36:09,Spot,Fee,BNB,-0.00001602,"" 2021-04-23 09:03:39,Spot,Buy,BTC,0.00205500,"" 2021-04-23 09:03:39,Spot,Fee,BNB,-0.00015363,"" 2021-04-23 09:03:39,Spot,Transaction Related,USDT,-99.97778445,"" 2021-04-23 09:36:39,Spot,Fee,BNB,-0.00015543,"" 2021-04-23 09:36:39,Spot,Buy,BTC,0.00207400,"" 2021-04-23 09:36:39,Spot,Transaction Related,USDT,-100.03379020,"" 2021-04-23 10:27:09,Spot,Transaction Related,USDT,-100.00717616,"" 2021-04-23 10:27:09,Spot,Fee,BNB,-0.00015081,"" 2021-04-23 10:27:09,Spot,Buy,BTC,0.00203200,""

provinzio commented 2 years ago

CoinTaxman queries the price from the Binance History API

jancovic commented 2 years ago

aah, so you can query any coin for spot price during timeline, right ?

jancovic commented 2 years ago

if the limit order hit some 1 minute price drop ? can you query this 1 minute interval e.g. 15:03 3rd March 2021 ? Binance has this detail info in their database in last year archive ?

jancovic commented 2 years ago

I am asking also, because for some TaxTools is OK to just provide only this transactions CSV file, so even after that, you have to additional query Exchange for coin prices, right ?

provinzio commented 2 years ago

I can not say, how other TaxTools work.

CoinTaxman tries to get the nearest price to your transaction.

jancovic commented 2 years ago

OK, I just checked on Binance, other option is to use separate option : to export just Spot Trade History, but then I am missing also conversion history, deposits... But looks more usefull, report has also prices,

Date(UTC),Market,Type,Price,Amount,Total,Fee,Fee Coin 2021-07-31 21:56:09,SOLUSDT,BUY,36.241,0.279,10.111239,0.00002237,BNB 2021-07-31 21:56:08,SOLUSDT,SELL,36.202,0.285,10.31757,0.00002289,BNB 2021-07-31 21:33:34,BNBUSDT,BUY,336.23,0.0301,10.120523,0.00002257,BNB 2021-07-31 21:33:33,BNBUSDT,SELL,336.27,0.0761,25.590147,0.00005709,BNB

jancovic commented 2 years ago

Another question: so your tool is supporting and working OK with API Binance ? I have to fill my API credentials, right ? I tested this tool 6 months ago, but just tested with exported transactions file, no API...

scientes commented 2 years ago

Currently we use the public available API for the prices. No credentials necessary or possible.