BittyTax icon indicating copy to clipboard operation
BittyTax copied to clipboard

Add exchange: FTX

Open curtailment opened this issue 5 years ago • 3 comments

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"

curtailment avatar Mar 10 '21 15:03 curtailment

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.

nanonano avatar Mar 10 '21 15:03 nanonano

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).

curtailment avatar Mar 10 '21 15:03 curtailment

OK, will add it when I can, just got some other changes to prioritise first.

nanonano avatar Mar 10 '21 16:03 nanonano

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

dakkusingh avatar Dec 09 '22 15:12 dakkusingh

any chance we can get this merged?

dakkusingh avatar Apr 04 '23 14:04 dakkusingh

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.

nanonano avatar Oct 29 '23 12:10 nanonano