Caution when importing from FTX.us

Koinly Support
1

Watch out when importing .csv files from FTX.us, which you have to do b/c of no API support.

  1. Their “Deposit” .csv file is in Eastern Time or your local time zone instead of UTC, while the rest of their .csv files are in UTC, leading to mismatched entries.

  2. Their .csv exporter only exports the last 200 trades, while giving you no indication that it is doing this. You have to manually filter for a wider date selection to download all your trades.

I wrote and complained but FTX support said they “can’t” change it. Super rubbish answer and wasted a lot of my time.

Just some friendly knowledge sharing.

2

Thanks.
Are you able to change the date format to UTC easily in Excel or does one have to create some sort of script?

3

Sorry, I don’t know. I had few enough transactions that I just changed them manually. I’m sure it’s possible to bend Excel to your will, but Excel is notorious for taking liberties with dates and .csv files and mangling them. I once contacted Microsoft support about it and they told me to try re-installing the Microsoft suite (facepalm)! Google sheets seems to be better behaved.