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

Alright,
I want to thank you for your help,everything is fine now

either add the deposit of usd or leave it, if you leave it you'll see your actual profit/loss which is useful. its all explained in the faq:

https://cointracking.freshdesk.com/en/support/solutions/articles/29000018265-different-ways-of-managing-your-portfolio

Why can't I add attachments?

I wanted to post pictures of CoinTracking discrepancies.

According to my Binance trade history, I bough XLM at a lower XLM/BNB price then where I sold higher, but CoinTracking says I made an unrealized loss.

It seems like trade imports are inconsistent in general.

Yes you right powerful and strange , with so many exchanges it’s really hard to keep track of the entry price , really hope they make improvements to this

I'm finally sitting down to sort out the 3000 trades I've done in 2017 and there are some problems. I really like cointracking and I realise I should have signed up sooner, but here I am trying to sort through and make accurate the trades I've made for the tax man. Most of them I'm able to fix and am working through thanks to the FAQs. One problem I can't seem to figure out is the prices for NANO on Binance. I've been trading this coin a bunch recently and the price list says it is worth $.06. This is wrong - it's $9.81. I tried to manually change the price that worked, but what about the historical prices? Is there something I can do to fix the real problem - that the market price for this coin isn't registering? Thanks!

download the template from https://cointracking.info/import/import_xls/

enter the details in the correct fields, for csv's created by wallets dont forget to replace the T with a space

open excel file and csv, copy amounts and dates into relevant fields (date, buy amount, buy curr) highlight all dates and search replace 't' with ' ' (space)

under type put IN for transfers Mining for mining then save and upload.

if it gives the same error redownload the original excel file open your modified one select everything copy and paste the values into the newer file save and upload do not delete rows or anything like that just paste over the examples

the really important thing is removing that T

I haven't had a single wallet import work that requires a CSV, they all come back saying the timestamp is wrong.  No, I didn't open them first.  Does anyone know the CORRECT format these need to be in for Cointracker?  You'd think this program would have that somewhere in the FAQ but Noooo.

I'm starting to wish I would have just done this with a spreadsheet.  ALL of my numbers are screwed up.   

If the GDAX API auto importer is suppose to be importing all your data history it is not working.  I have done it correctly but something is broken or it doesn't handle that much trade history. 

Either way it is not working.

First you have to create the API key on CB. Make sure you keep both the key and the secret.
Then create an import on CT. You will need to put in the key and secret you created on CB here. There are a few options when you create this. One of them is a start date that will only import transactions after that date.

I do very little trading and am mining.

I can download a CSV from here that contains all my payouts with the transaction ID, date, time, and amount:
https://chainz.cryptoid.info/lux/

What I want to do is upload that CSV into cointracking and have it add the USD value of each payout then let me re-save the file.  This is for tax purposes.

Thanks.

Any way to delete the trades I've inputted? It's all wrong

Yes, but if you make TOO much mining, the government is not going to buy that this is just a hobby.  I don't know what that figure would be, but probably approaching $10k it would no longer be considered a hobby??

Will you have Huobi API import soon?

Read some previous posts) Yes. Cointracking ALWAYS works strange. Wrong or missed imported data, wrong balances, sometimes errors during importing data... But, despite all this annoying details i don't know more powerful instrument to analyze my deals. Often with manual checking (for example as with last Binance crash) Not every time there is the cointracking problem. Mostly exchanges API or some inside problems.

Hi guys I have been using the free version and sometimes the number are not correct does this happen for the paid version?

Thx for helping,I'm gonna backup everything before doing something.
But I just don't understand how to recreate a key with a special start date,the first time I created it I don't remember about such a setting( is it on CT or CB ),or is this something linked with the API version upgrade button I was talking about with  2018-01-11 date ?
Sorry if my question looks weird ,I'm a newbie with API stuff but I'm happy to learn more

Create a backup of your transactions before doing this. Delete the API key in CT and CB. Recreate it with a start date after your last successful import. Technically, setting the start date shouldn't be necessary as CT apparently ignores potential duplicates based on the Coinbase TXN ID but better safe than sorry. If it all goes wrong, just restore from backup.

Hi,
I never had problem importing with API and Coinbase until today.
Suddenly when I try to import via API , Cointracking is displaying "invalid key",but I didn't change anything and when I go to my Coinbase settings to check the key, it's the same one I use since the beginning.
Is there something dealing with the API version,in the Coinbase settings I see the API version 2018-01-11 and a upgrade button ?
I just imported trades from Gdax with no prob ,if someone experienced the same prob or knows what I can do to fix this I would be thankful;)

I really appreciate your response.  Right now I am completely frustrated with so many trades. So you are saying go back to the very first day of gdax, then do a manual import of every pair on gdax for example btc/usd eth/usd starting at the very first trade. Then also import the coinbase data ( which I think comes over correct and full history with the api).  Then after all the data is imported that gives all the crazy errors and completely off balance values, go to google sheets and upload the gdax csv files to compare to the cointracking.info trades list?

If that is what must be done I will start it.  Thinking it will be probably more like 80 hours for me.  Also from your experience I assume that when you did it line by line somehow the imported data and what you were showing in your excel sheet you downloaded differed?  Strange since they would be the same files from gdax imported to 2 different places, google sheets and then manually imported into cointracking.info.


Swimming in this quagmire with overloaded CSR and no help anywhere else to be found facing a daunting task your response was greatly appreciated!  Wish there was a step by step of how to fix the problem by people like yourself who have done so.  Obviously the FAQ on the site shows you how to import the data that gives errors and then even tells you where your problem could be, however, it doesn't give you a detailed solution path like you briefly described.

I use the Unlimited and trade at GDAX as well as 3 or 4 other exchanges. I set Cointracking up after about six months of trading - not nearly as much unrecorded history as you have, but still it was a lot. I would have quit if it wasn't for the fact that I paid for the unlimited version before moving my trades and mining into Cointracking. And I'm too cheap to throw away the money. It took me a good 40 hours of trade analysis between what was uploaded in CT and the crap that the exchange has for records. This is so hard without Exchange statements to balance against. But, if you export CT trades, by exchange, to Excel and go line by line with the export from GDAX - you can get it to balance. Once I did that, keeping on top of it is a weekly chore, but it's easy now.

CT is a type of accounting system. And it's not magical, you have review your uploads and entries. I review my balances all the time - each exchange and each Wallet. It took time and spreadsheets to set it up. But, once you get it balanced, it's easy to maintain, and really worth it.

You can do it, just get it all spread out in Excel and check it off, trade by trade.