Add exchange: FTX
Hello, I think it is worth adding a parser for FTX. They are a major exchange with a good reputation and they provide full historical exports. I'm happy to provide a sample of my exports to show the format and also to test out the parser with my full data.
Trades export file looks like this:
"id","time","market","side","type","size","price","fee","feeCurrency" "1161825778","2021-03-10T15:08:14.014047+00:00","BNB/USD","buy","Limit","0.3","285.5","0.0000582","BNB" "1154335856","2021-03-09T20:17:21.375475+00:00","BAO/USD","sell","Market","3000","0.00114225","0.00232676325","USD" "560686890","2021-01-03T18:53:11.266682+00:00","BTC-PERP","buy","Market","0.011","32701","0.2517977","USD"
Deposits:
"id","time","coin","size","status","txid" "3151875","2021-03-10T04:47:20.563371+00:00","USD","0.0685","complete","Payment for lending USD at 2021-03-09 02:00:00 UTC" "1228435","2021-02-15T15:38:00.094518+00:00","LTC","0.188","confirmed","tx id goes here..."
Withdrawals:
"time","coin","size","address","status","txid","fee","id" "2021-03-10T15:11:11.686401+00:00","BNB","4.36915222","withdrawal address goes here...","complete","tx id goes here...","0","1485325"
Conversions:
"time","from","to","size","fee","price","proceeds","status" "2020-12-28T16:19:22.815001+00:00","GBP","USD","25","0","1.33632652","33.408163","" "2020-12-28T16:14:27.573086+00:00","GBP","USD","25","0","1.33772456","33.443114",""
Perpetual funding payments (I'm not sure what the tax treatment of these is, I guess Income/Spend)
"time","future","payment","rate" "2021-01-04T10:00:00+00:00","BTC-PERP","0.05381078","0.000144" "2021-01-04T09:00:00+00:00","BTC-PERP","0.03610502","0.000094"
Lending history (on FTX you can lend assets to others and receive hourly interest payments, so here 'proceeds' should be Income denominated in 'coin')
"time","coin","size","rate","proceeds" "2021-03-10T15:00:00+00:00","AAVE","0.999742","0.00002283","0.00002282410986" "2021-03-10T14:00:00+00:00","AAVE","0.999742","0.00001712","0.00001711558304"
Hi @curtailment, a couple of people have asked for this. I thought they were margin trades/futures only, or do they do spot trades too? If it's futures it's linked to this issue https://github.com/BittyTax/BittyTax/issues/22 which is in progress. Hope to create a branch for it soon, so others can test it.
Hi, they do spot trading as well, no requirement to use margin or futures. Although it is a fair point that the majority of their volume is on perpetuals. One advantage of FTX is that all non-Ethereum withdrawals are free (they cover the network fee) and Ethereum withdrawals are free if you stake FTT (or otherwise you only pay the gas fee).
OK, will add it when I can, just got some other changes to prioritise first.
id time market side type size price total fee feeCurrency
0 2022-11-08 BTC/USD buy Limit 0.0013 19500 25.35 0.00000026 BTC
0 2022-11-08 BTC/USD buy Limit 0.0012 19550 23.46 0.00000024 BTC
0 2022-11-08 BTC/USD buy Limit 0.0011 19600 21.56 0.00000022 BTC
0 2022-11-08 BTC/USD buy Limit 0.0011 19650 21.615 0.00000022 BTC
0 2022-11-08 BTC/USD buy Limit 0.001 19700 19.7 0.0000002 BTC
0 2022-11-08 BTC/USD buy Limit 0.001 19750 19.75 0.0000002 BTC
0 2022-10-29 BTC/USD sell Market 0.0046 20664 95.0544 0.06653808 USD
@nanonano you can give this dummy data a try. column 1 is the transaction ID - which i have omitted to just a 0
any chance we can get this merged?
I've added an FTX parser, see https://github.com/BittyTax/BittyTax/commit/038f978e21f818f0a52791094da6b11a31bfcf96.
I had very little test data, so please test throughly. If anyone has an example of a Trade which is an Airdrop please share.