*So apparently kucoin futures api is a beta only feature, trying to import any type of csv from kucoin however results in an error. Trade history, pnl, order history etc.
kucoin
csv file import
I have tried all file types kucoin will export. haven’t tried making custom headers on a csv yet
I am having same problem. I subscribed to Koinly for preparing the tax returns but looks like of no use
I wrote a small program to read the CSV file and calculate the basic PNL. Moving your money out of futures into one of the other KuCoin accounts will also get Koinly to at least recognize a profit or loss based solely on the cost basis. Once ALL the money is back in your regular accounts, Koinly will be able to give you at least a pretty close estimate to what actually is owed. I think you might save some money if you’re able to tabulate transaction fees with Koinly pulling that data straight from KuCoin Futures, but otherwise, just dumping it all back in your main KuCoin accounts usually makes the numbers line up.
Hi nmoschkin,
Did you end up making a CSV file to load? If so can you past the headings, I’ve looked all over the Koinly site but cannot find any useful templates.
I tried Date, Symbol, Profit, Currency
But didn’t load.
Okay. I wrote a small Windows Desktop App to read the PNL report and to basically calculate PNL with simple math after parsing the CSV.
I actually haven’t figured out, yet, how to get Koinly to see transfers between the two accounts, yet. And actually, I was wrong about it getting the numbers to sync up.
Apparently, if you just transfer all your money back and forth, it picks up transfers from Kucoin Futures to Kucoin as having zero cost basis.
I don’t really know if Koinly will have a solution to this, but I basically plan on just taking my losses from Futures and subtracting them from whatever Koinly says I really have.
I think it would be a tremendous amount of work to get these files in a format that Koinly could use.
And, like you said, they haven’t even documented the CSV format for trading on margins/futures.
However, They seem to be able to pick that sort of thing up from Kraken exported files, so maybe I will look at how Kraken is listing those sorts of things and write a translation program.
Right now all my work is in C#. I would probably have to translate this code into Python for other people to use it, conveniently. I understand not everyone has a Windows PC.
So … Let me do my investigations, and I will be happy to keep you posted as to my progress.
My email address is ironywrit@gmail.com. My github is github.com/nmoschkin …
So you can reach out to me. Just be clear in the subject line what this is for. I get a lot of junk mail. I have 2 dozen filters on my account, but still I get a lot of junk.
Any luck with this?
Do you have csv format that koinly supports? it would be huge help at this point if only I could see the table headers. Every time I try to upload the futures CSV the koinly app bitches about the format.