CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies - page 62.

llanaio

newbie

Activity: 58

Merit: 0

I have 30K+ txs that I'm importing into Unlimited. It's vexing because some APIs are unreliable (KuCoin) and many wallets are unsupported. When all -Qt wallets have the same essential format, why the hell does CoinTracking not have a dedicated importer for them? It's absolutely ridiculous!

I have created a process for transferring QT wallets into CoinTracking accepted Excel files (or CSV files). Sharing in case it's helpful to others. This is easy to implement as an Excel macro or just to do if you only have a few wallets to sync.

QT Wallet Export CSV -> CoinTracking Excel Import Macro

1
Import CSV file.

2
Request CoinName text from user.

3
Check CSV Col-A (Confirmed) and delete any rows <> TRUE.

4
Modify Date to text as “YYYY-MM-DD HH:MM:SS” (use 24 hr time. If SS is blank add as 00) (If altering by hand, just find/replace "T" with " ".)

5
If CSV file Col-C (Type) = “Received with” then Output file Col-A (Type) == “Deposit”; Output Col-B (Buy Amount) == CSV Col-F (Amount); Output Col-C (Buy Cur.) == CoinName.

6
If CSV file Col-C (Type) = “Mined” then Output file Col-A (Type) == “Mining”; Output Col-B (Buy Amount) == CSV Col-F (Amount); Output Col-C (Buy Cur.) == CoinName.

7
If CSV file Col-C (Type) = “Sent to” then Output file Col-A (Type) == “Withdrawal”; Output Col-D (Sell Amount) == CSV Col-F (Amount); Output Col-E (Sell Cur.) == CoinName.

8
If CSV file Col-C (Type) = “Payment to yourself” then Output file Col-A (Type) == “Transfer”; Output Col-B (Buy Amount) == 0; Output Col-C (Buy Cur.) == CoinName; Output Col-D (Sell Amount) == 0; Output Col-E (Sell Cur.) == CoinName; Output Col-F (Fee Amount) == CSV Col-F (Amount); Output Col-G (Fee Cur.) == CoinName.

9
Output file Col-H == CoinName+“ wallet”; Output Col-J (Comment) == CSV Col-D (Label).

hammerhart

member

Activity: 381

Merit: 11

Quote from: hammerhart on March 17, 2018, 01:56:52 AM

Quote from: AltScope on March 16, 2018, 04:06:37 PM

Quote from: hammerhart on March 16, 2018, 03:42:18 PM

So after supervising the tool for 1,2 month i deciced to buy it as well;)
The API is nice- but i am wondering if there is already a sample list (with example setups for each exchange) available somewhere to import manually from exchanges which are not supported so far:
I thereby have in mind:
Coinexchange.io
Coinsmarkets.com
https://stocks.exchange/

For exchanges like coinsmarkets one has obviously first copy the trades into a xls file before being somehow able to import them;) Anyone has a link/hint for me?

Same i was wondering if there was a list, whith import-examples, somewhere to add other altcoins-wallets, which are not supported by the AltcoinsImport at the moment. Thinking about Rain/condensate/Boat/aerium etc.

My last question is if there is a nice guide/recommendation how to best consider staking coins with the tool- e.g. Pool-staking, POS, or special tokens like DAY.

Thank you for your support.

on cointracking
import from excel file
download the template (CoinTracking_Excel_Import.xls)
input the trades
upload

Thanks - well i somehow hoped for a "excel" file where there is already some kind of data-transformations-formulas implemented to be compliant with the required cointracking-style (e.g. date/buy/sell-order) Wink

Anyhow I am doing it myself now - i am planning to share it here so other dont have to do the same again;) but be warned i am not a guy of nice optics XD

***Update***
So my taxes are done- much more than i thought i would be:/
I will publish the next days an excel-file with example code i used for some exchanges to only/mainly copy-past the transactions and then import with cointracking- if anyone has already something similar- ffeel free to drop a line and i can maybe add my examples;)

So all together,

i uploaded my file to convert exchange data to a cointrack-format:
https://docs.google.com/spreadsheets/d/1kXmgfhlBVPDbpZ4dpg1ZcuyMC05S6kKeE3MMo9Vf85Q/edit#gid=242444363

Feel free to use on your own responsability. It was useful to me, maybe it is also useful for someone else- Even if it is just as a starting point for his own exchanges;)

MrBender

newbie

Activity: 8

Merit: 0

Gee that forgotten password system totally blows. What if i forgot my username.. then i can't reset my password.. yikes.

WickedPigeon

member

Activity: 345

Merit: 16

Quote from: AltScope on March 22, 2018, 05:08:18 AM

c'mon guys add XSN already

How about getting Coin Market Cap to list it.

AltScope

sr. member

Activity: 714

Merit: 252

c'mon guys add XSN already

FrankWatsonJr

newbie

Activity: 269

Merit: 0

I am interested in reviewing more of these tools for better UX

I will provide feedback when the time comes after I have done the full analysis with my Organizational audits

Pink Panther

newbie

Activity: 33

Merit: 0

hi, can you please disable deps/withdrawals for binance
regards

Onda_su_onda

newbie

Activity: 19

Merit: 0

Kindly, I would like to use this call to the CoinTracking API in Excel:

$result = cointracking('getBalance');

better if you could make a quick video to put in your youtube channel, but any form of manual for the user would be welcome

Thank you for your kind attention

jda009

newbie

Activity: 1

Merit: 0

Hi,

I am using pro version and trying to import transaction from Kucoin via API. I am always getting "Error: Signature verification failed" error for the last three days. Can anyone please shed some light on how to overcome this error?

~J

krypt0n1

full member

Activity: 238

Merit: 100

🔵 Brickblock.io - Future of Stock Trading

Quote from: shinep on March 19, 2018, 03:04:11 PM

Quote from: krypt0n1 on March 19, 2018, 11:50:28 AM

Is anyone else having trouble using the Liqui.io API? I've already manually entered the deposits and withdrawals since these cannot be accessed with the software's API, but the trades should be importing. I've deleted the API access and created a new API key but it still is listing zero imports.

Any help/insight would be appreciated.

I have the same issue. Looks like the liqui api is not supported for now.

I ended up manually entering since I didn't have too many liqui trades.
However, depending on your trade size and technical skill, I found this post about an hour after I posted. He includes a link to the script he wrote to import the liqui trades.

https://www.reddit.com/r/ethtrader/comments/7oldza/just_spent_about_12_hours_figuring_out_my_tax/

shinep

hero member

Activity: 630

Merit: 500

Quote from: krypt0n1 on March 19, 2018, 11:50:28 AM

Is anyone else having trouble using the Liqui.io API? I've already manually entered the deposits and withdrawals since these cannot be accessed with the software's API, but the trades should be importing. I've deleted the API access and created a new API key but it still is listing zero imports.

Any help/insight would be appreciated.

I have the same issue. Looks like the liqui api is not supported for now.

krypt0n1

full member

Activity: 238

Merit: 100

🔵 Brickblock.io - Future of Stock Trading

Is anyone else having trouble using the Liqui.io API? I've already manually entered the deposits and withdrawals since these cannot be accessed with the software's API, but the trades should be importing. I've deleted the API access and created a new API key but it still is listing zero imports.

Any help/insight would be appreciated.

eclips

newbie

Activity: 25

Merit: 0

hi, can you correct this :
https://reho.st/thumb/self/1ab11120a37e63d57a1d3afe12167d530dc60c0c.jpg

thanks

petermh

newbie

Activity: 1

Merit: 0

is anyone having trouble importing via API from Bitfinex? Just got cointracking the other day and have tried importing via API from Bitfinex several times with several different API keys wtih no success - all read permissions enabled. Other exchanges mostly work - no idea what the issue is with Bitfinex.

Further, I read that Bitfinex API as well as CSV download only allows for up to the last 90 days of trade history. Is there literally any way at all for me or anyone else to access my trade history from before? Not sure what to do about reporting if I have no way to access my trades.

hammerhart

member

Activity: 381

Merit: 11

Quote from: AltScope on March 16, 2018, 04:06:37 PM

Quote from: hammerhart on March 16, 2018, 03:42:18 PM

So after supervising the tool for 1,2 month i deciced to buy it as well;)
The API is nice- but i am wondering if there is already a sample list (with example setups for each exchange) available somewhere to import manually from exchanges which are not supported so far:
I thereby have in mind:
Coinexchange.io
Coinsmarkets.com
https://stocks.exchange/

For exchanges like coinsmarkets one has obviously first copy the trades into a xls file before being somehow able to import them;) Anyone has a link/hint for me?

Same i was wondering if there was a list, whith import-examples, somewhere to add other altcoins-wallets, which are not supported by the AltcoinsImport at the moment. Thinking about Rain/condensate/Boat/aerium etc.

My last question is if there is a nice guide/recommendation how to best consider staking coins with the tool- e.g. Pool-staking, POS, or special tokens like DAY.

Thank you for your support.

on cointracking
import from excel file
download the template (CoinTracking_Excel_Import.xls)
input the trades
upload

Thanks - well i somehow hoped for a "excel" file where there is already some kind of data-transformations-formulas implemented to be compliant with the required cointracking-style (e.g. date/buy/sell-order) Wink

Anyhow I am doing it myself now - i am planning to share it here so other dont have to do the same again;) but be warned i am not a guy of nice optics XD

***Update***
So my taxes are done- much more than i thought i would be:/
I will publish the next days an excel-file with example code i used for some exchanges to only/mainly copy-past the transactions and then import with cointracking- if anyone has already something similar- ffeel free to drop a line and i can maybe add my examples;)

AltScope

sr. member

Activity: 714

Merit: 252

Quote from: hammerhart on March 16, 2018, 03:42:18 PM

So after supervising the tool for 1,2 month i deciced to buy it as well;)
The API is nice- but i am wondering if there is already a sample list (with example setups for each exchange) available somewhere to import manually from exchanges which are not supported so far:
I thereby have in mind:
Coinexchange.io
Coinsmarkets.com
https://stocks.exchange/

For exchanges like coinsmarkets one has obviously first copy the trades into a xls file before being somehow able to import them;) Anyone has a link/hint for me?

Same i was wondering if there was a list, whith import-examples, somewhere to add other altcoins-wallets, which are not supported by the AltcoinsImport at the moment. Thinking about Rain/condensate/Boat/aerium etc.

My last question is if there is a nice guide/recommendation how to best consider staking coins with the tool- e.g. Pool-staking, POS, or special tokens like DAY.

Thank you for your support.

on cointracking
import from excel file
download the template (CoinTracking_Excel_Import.xls)
input the trades
upload

hammerhart

member

Activity: 381

Merit: 11

So after supervising the tool for 1,2 month i deciced to buy it as well;)
The API is nice- but i am wondering if there is already a sample list (with example setups for each exchange) available somewhere to import manually from exchanges which are not supported so far:
I thereby have in mind:
Coinexchange.io
Coinsmarkets.com
https://stocks.exchange/

For exchanges like coinsmarkets one has obviously first copy the trades into a xls file before being somehow able to import them;) Anyone has a link/hint for me?

Same i was wondering if there was a list, whith import-examples, somewhere to add other altcoins-wallets, which are not supported by the AltcoinsImport at the moment. Thinking about Rain/condensate/Boat/aerium etc.

My last question is if there is a nice guide/recommendation how to best consider staking coins with the tool- e.g. Pool-staking, POS, or special tokens like DAY.

Thank you for your support.

chunkyjunkie

hero member

Activity: 494

Merit: 500

I was having regular contact with support and was assured a refund if I was not satisfied. After no progress was being made and taxes coming due I requested the promised refund and now communication has stopped. I will update this post with every bit of information I have including timelines and correspondence if I don't get a reply soon. I am hoping it is just an oversight but at this time I think people should be cautious.

Again, I will make sure to update the tread with any positive development or a completely detailed recap of my situation if I continue to get no response after what was daily communication.

I hope to be able to report a great customer service experience soon.

Update- I got a quick reply with the information I need. I will further update this post later with more info.

AltScope

sr. member

Activity: 714

Merit: 252

Quote from: Blitzky on March 15, 2018, 09:31:02 PM

Quote from: soothaa on March 12, 2018, 10:30:43 AM

Oh look. Delta just released their new Exchange connector and it supports Binance. Without specifying each trading pair. And it's automatic!

Yet my paid cointracking still doesn't...

What is Delta? Another tax tool?

its a free portfolio tracker needs alot of work its good but atm you have to sit on your phone manually typing in transactions for mining, the desktop version is even more limited.

I believe there's api imports for trades but as yet no csv import and I've not seen any tax info on it.

only used it for 5 minutes its promising but atm I think cointracking is far superior

Blitzky

newbie

Activity: 11

Merit: 0

Quote from: soothaa on March 12, 2018, 10:30:43 AM

Oh look. Delta just released their new Exchange connector and it supports Binance. Without specifying each trading pair. And it's automatic!

Yet my paid cointracking still doesn't...

What is Delta? Another tax tool?

Topic: CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies - page 62. (Read 122657 times)