Support for Cointracking.info import

[jameskitt616]

Enabling support for https://cointracking.info/ would be a great option for people who wrote down their trades for years there.

[dickwolff]

Thanks for the request! Do you have a sample export that I can use to build this?

[jameskitt616]

CoinTracking_Trade_Table_export_example.csv
I created some Test account there and added a few random Trades/Deposits/Withdrawals, since there are so many different types, i only did some few basic ones. If needed i could go through everyone and create an entry for every of these if wished

[dickwolff]

I created an initial version of the converter based on the example you provided. This now supports buy and sell records. I think staking rewards can also be added (like dividends). Can you create staking reward transaction and send it to me, so I can add it? Thanks!

Also, here is a version of the converter. Can you test it for me?

Finally, can you provide me with instructions on how to make a CSV export, so I can add this to the README?

[jameskitt616]

CoinTracking Trade Table Test.csv

Here is a new export, i added an Income -> Staking example.

Further will follow shortly.
I can setup some Test environment for Ghost and the importer later and see if everything works as i would expect it.
Also send instructions on how to Make an export.

[jameskitt616]

How to make an export

1. Go to the Transactions section.

2. Click the Export -> CSV (Full Export) Button to Download the Export.

[dickwolff]

Thanks, I will add the staking tonight, as well as updating the README. I'm looking forward to your test results!

[jameskitt616]

So for the first file i posted, the import seemed to work fine, but the second file i posted today throws an exception when converting.

export-to-ghostfolio  | [i] Found Test_new.csv!
export-to-ghostfolio  | [i] Determined the file type to be of kind 'cointracking'.
export-to-ghostfolio  | [i] Starting Export to Ghostfolio v0.23.0
export-to-ghostfolio  | [i] Restored 0 ISIN-symbol pairs and 1 symbols from cache..
export-to-ghostfolio  | [i] Processing file using CoinTracking converter
export-to-ghostfolio  | [e] An error ocurred while processing.
export-to-ghostfolio  | [e] Error: An error ocurred while parsing! Details: Invalid Record Length: columns length is 12, got 11 on line 2
export-to-ghostfolio  | [e] Moving file to output..

[dickwolff]

This means your second file has more columns then currently expected. Can you send me a part of this new file so I can check?

[jameskitt616]

CoinTracking Trade Table Test.csv

Here is a new export, i added an Income -> Staking example.

Further will follow shortly. I can setup some Test environment for Ghost and the importer later and see if everything works as i would expect it. Also send instructions on how to Make an export.

i used the file posted here

[dickwolff]

I see, that one doesn't seem to have a "Tx-ID" colum, which the initial one had.

[dickwolff]

@jameskitt616 For some reason the date format also changed from "2025-01-01 10:12:27" to "18.01.2025 15:18:55". Did you change anything while exporting that could cause these differences?

[jameskitt616]

Hm, there is CSV and CSV (full export), seems like those two are different. Here is the Full export version.
I will also update my "How to export" message from earlier to use the correct export.

CoinTracking_Trade_Table Test.csv

[dickwolff]

Thanks. I will continue today and let you know when it's ready to test!

[dickwolff]

I just added the Tx-ID back, and updated the instructions in the README.

Can you verify if you can use it now using this Docker image? Thanks!

[jameskitt616]

Seems to work, i only noticed that the Staking doesnt have any Unit Price, thus no Value after importing.
But the rest seems to work 👍🏻

[dickwolff]

This is due to there being no value to compare with. I can set it to 1, maybe that will work? You can check with this Docker image.

[dickwolff]

@jameskitt616 Did you by chance take a look?

[jameskitt616]

I tried it and i am actually a bit more confused with ghostfolio right now, i dont understand why dividend counts towards the Overview or total amount for an Account.

[dickwolff]

Any update on this? Is this a ghostfolio thing, or should there be done more on this tool? Otherwise I’d like to merge the change. Thanks!

[jameskitt616]

The behavior seems to be the exact same if i add a dividend manually. So from my understanding i think this MR should be fine and does what it's supposed to do.