Describe the problem:
The Swedish crypto Exchange Trijo (Trijo.co) has two different CSV files. One for transactions and one for orders. Koinly is able to parse the transactions one just fine but it cannot read the orders one at all.
An additional problem I noticed is that when you change the language of the website in Trijos settings the downloaded CSV files will also be localized to that language. There are two supported languages (English and Swedish).
It is the Swedish language transactions CSV file that works correctly with Koinly. None of the other ones can be parsed successfully. (Orders in Swedish, Orders in English, Transactions in English)
Which exchange/wallet is this regarding?
Trijo (Trijo.co)
How did you import data into this wallet?
CSV files
What have you tried to fix this so far?
Import the orders CSV file but Koinly does not understand it.
Here are the columns and one row of data for each CSV file type:
Transactions (Swedish):
"Belopp","Typ","Bekräftelser","Datum","Transaktions-ID","Beskrivning","TX-ID" "-0.12345678 LTC","Överföring",7,"2021-01-01 – 13:37:42","12345-987654","Outgoing transfer of 0.12345678 LTC to <censored LTC address>.","https://www.blockchain.com/ltc/tx/
Transactions (English):
> "Amount","Type","Confirmations","Date","Transaction-ID","Description","TX-ID" > "-0.12345678 LTC","Transfer",7,"2021-01-01 – 13:37:42","12345-987654","Outgoing transfer of 0.12345678 LTC to <censored LTC address>.","https://www.blockchain.com/ltc/tx/
Orders (Swedish):
"Order ID","Volym","Volym","Pris","Datum","Tid","Status" 12345678,"0.123456 LTC","€42.69","€69,42","2021-01-01","13:37","Klar"
Orders (English)
"Order ID","Volume","Volume","Price","Date","Time","Status" 12345678,"0.123456 LTC","€42.69","€69,42","2021-01-01","13:37","Completed"
In the orders CSV file, the first “Volume” is the currency converted to and the second the currency converted from. So in the examples above it is a trade from 42.69 EUR to 0.123456 LTC. The "Price is the price of 1 LTC. (I have changed all the numbers for privacy reasons)
I hope you find this info helpful and that you can resolve this issue for me!
Debug info
(Note I have actually not deposited any crypto so that is right, but all trades are missing)
Wallet: Trijo (Trijo)
Transactions: 31
Imported with: CSV
- No crypto deposits found
- No trades found
- 19 transactions are missing purchase history
---- Missing 0.06845083 BTC between 2020-12-29 17:12:38 UTC and 2021-01-12 20:40:10 UTC
---- Missing 1.2861528 ETH between 2020-12-22 11:29:47 UTC and 2020-12-29 23:40:41 UTC
---- Missing 3.32354931 LTC between 2021-01-04 23:57:26 UTC and 2021-02-25 16:03:19 UTC
---- Total gains due to missing cost basis: 267.68 SEK