OKx CSV not importing correctly

[andwan0]

Describe the problem:
Last year “OKX Trading Account History” CSV imported perfectly fine for “Swap/Close long” lines, because it was taking the PNL from the “Balance Change” column.
Now this year I am testing on a separate Koinly account and re-building my whole portfolio. I am using exactly the SAME CSV file.
Now Koinly is treating the Swap transaction lines like normal spot trading. This is wrong.

Which exchange/wallet is this regarding?
OKx

How did you import data into this wallet?
CSV

What have you tried to fix this so far?
I can’t.
It would be good if Koinly reverted their OKx parser to how it was in 2023 so it can handle Swap transaction lines as well as spot trades in the same CSV file.

[Carl_Koinly]

Hey @andwan0

Thanks for your message!

There is a known issue that’s currently affecting OKX CSV files:

OKX CSV: Trading file format is not supported | API/CSV issues (public) | Koinly

Please could you try the following before importing:
1 - Change all column names to lowercase
2 - Change the name of one column: from ‘symbol’ to ‘instrument’

I’d also recommend using new files from OKX, if possible.

[Everton]

Amazing it worked a lot!!!