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

Hi there. Im using Cointracking to keep a track of my trades, its taken me a good week or so to iron out most problems but im slowly getting there.

Im hoping someone could help me. I am looking to export a list of all my trades (as they show in the 'Trade List (full view)' tab) but I want to be able to group my trades together (Similar to how you can group trades by day in the tax reporting). I currently have in excess of 2000 trades but they are predominantly made up of lots of smaller trades within a trade.

For example, I would place a limit order to buy 1 BTC and this would be filled... however it shows as 12 individual trades in the list totalling the 1BTC initial order.

Is there anyway to get the trades to group up an consolidate so there isnt so much overwhelming data on the list? It also makes me appear as though im a trader doing thousands of trades when infact its only a few hundred.

Any answers to this would be super appreciated.

Many Thanks

Type eth into the buy cur. box and ^(?!btc) in the sell cur. box + activate the RegEx checkbox in the sell cur. box.
This will show all ETH purchases where the sell is not BTC.

PS: Dominik is on vacation this week, but will be back on Monday to answer all the other questions
Best, Dario

Hi,

I have been using CT extensively for the past two years.  I have a powerful feature request for the tool:

Please add switches to filter OUT variables...

e.g. I want to make an for all purchases in "ETH" but NOT sales in "BTC".

So I enter "ETH" in the buy currencies field.  

But presently, if I then enter "BTC" in the sell currencies field -  CT only returns results of purchases in "ETH" AND sales in "BTC".

There needs to be a switch below "Smart' and RegEx" called "Exclude". Imagine that the user turns a switch ON and now enters "BTC" to exclude "BTC" from the sell currencies results.

Please add "Exclude" switches below all of the search fields.  By default they are all OFF.

You can do it! :-)

Please add this powerful feature.

Thanks for all you do!!

How to add new coin in coin tracking service for coin stats?

Hi jonasnoble,
the following transactions are not transferred by the Binance API and must be entered manually:

• Trades of delisted Coins (also old coins from swaps). Must be imported via CSV or manually.
• Referral Commissions: https://www.binance.com/invite.html
• Airdrops: https://www.binance.com/userCenter/dividend.html

Please check if the problem results from this.



Hi jgalt,
please contact us via our HelpDesk: https://cointracking.freshdesk.com

I'm experimenting with a variety of crypto tax software solutions and I've spent several hours trying to get my coinbase imports to reconcile to the current balance that I have in coinbase. Your auto-import of deposits/withdrawals is a premium feature, but without understanding how well it works I'm hesitant to purchase. Is it possible for you to temporarily provide this feature so I can trial it? (feel free to disable the ability for me to create any reports, etc)

Hi everybody,

I've been using Cointracking for almost a year, and have really enjoyed it so far.

Something I'm having trouble with, my BNB balance is slightly off between Binance and Cointracking. I've tried backing up, deleting, re-importing. I've done with and without Dust Conversion included. I've manually entered the Dust conversion. No matter what I do, I end up just a little bit off; always the same amount. It's not really a big deal (other than annoying my obsessive compulsive nature), but I want to make sure I didn't do anything wrong so I can prevent it in the future.

Everything I have read says go through your trades 1 at a time... I have almost 2000 trades logged this year. Can anyone think of a quicker way to do it? Or a possible reason my imported amounts from the Binance API is different from what lands in my Cointracking portfolio?



Thanks for any suggestions.

Please send us a ticket via our HelpDesk (https://cointracking.freshdesk.com) so that we can take a closer look at the problem.


How Forks are handled is explained in the following FAQ article: https://cointracking.freshdesk.com/en/support/solutions/articles/29000018052-entering-coins-with-a-fork-e-g-btc-and-bch-

Hello, I'm trying to use your software to calculate the cost-basis for my capital gains back to 2013. I've started with Coinbase because I figure if I can input all deposits, withdrawals, buys and sells, and it ultimately matches up to my current balance in coinbase, then I prove to myself I at least have a basic understanding of how this works and then I'll slowly start adding the other exchanges one by one. (if you have a better idea of how to go about tackling this gigantic problem, i'm all ears)

So i started by following the instructions and downloading the "buys, sells and merchant payouts" report for each individual account - all history. I've uploaded each of them into your system. It seems to work fine.

Then I tried to determine how to manually enter all sends/receives (aka withdrawals/deposits). After playing with a few of the coinbase reports, it seems as if "Transaction history for taxes" was the one most relevant. It shows a long list of all sends/receives across all accounts and currencies. So, starting in chronological order, I begin manually entering these as "General deposit" for the receives and "General withdrawals" for sends.

About 1/4 of the way through manually entering these, I noticed that in early 2014 I made a "Send" of nearly 30 BTC. It seemed like a rather high number so I manually went back to try and determine if I would have even had this much in the account at that time - and I wouldn't have. Therefore it leads me to believe that i'm missing something somewhere. Can you please help?

On an additional note, in the event that i get too frustrated trying to do this myself, is there a service somewhere where I can safely provide the csv files and have somebody else do this work for me?

Hi Colicco,
I'm afraid that's not possible.

How to disable crypto/crypto gains? I need calculate only crypto to fiat gains for taxes.

Does CoinTracking have this feature. Calculate realized gains only from crypto to fiat trades and ignore crypto to crypto realized gains.
If both are enabled it calculate my gains wrongly with FIFO.
I'm using free version and I haven't figured out yet, but it's somehow possible or not?

Hi Poeta,

we use the chainz.cryptoid.info API to import Altcoin Wallet transactions. So we can only import the Altcoins that are available there.
For now, you can enter the transactions either manually on the "Enter Coins" page, with the "Excel Import", or with the "Custom Exchange Import". Both are very flexible and customizable and data can be uploaded in a bulk action.

is it possible to add wallet from stellar, wanchain and tezos?

thanks

Dear CoinTracking User. We would like to inform you about the following changes / improvements:

Update for exports
When exporting the tax report and the report for (un)realized gains, the totals in the footer are now also exported (for Excel, PDF and print table).

New Imports
- itBit API Import
- Poloniex CSV Import for Borrowing
- Bitfinex CSV Import for Deposits and Withdrawals (updated to the new Bitfinex format)

I have had luck with the following semi-manual "pull." I create a new API - this sometimes updates right away but not always, but either way, I just wait a day.  Then I go to the API and press up date now. While this doesn't work at that moment, I still get the error, within 24 hours it seems to update on its own. If it doesn't work, I start over with a new API, wait, press, wait, repeat.

Good luck,

Not exactly a fix, but I've been getting the data via API that way.

Having the same problem. My last import was on August 15th, 2018. Binance API errors with the same error described above, mentioning the ban will last till 1538878129544 which maps to October 7th, 2018 but today is already November and I still can not import.

I think this is not only a problem on the Binance side. When I go to my jobs overview it tells me "0 trade pairs," but this is obviously wrong, it should be a couple of dozens. Also, finally, when I go to the job details, it tells me this job never succeeded importing anything.

Can you double and tripple check this? Thanks

Thanks for the reply. I see that the API eventually makes its connection and uploads the trades. It just takes time. All is well that ends well.
 

Binance ban usually lasts only for a couple of hours, so if you run into the ban again in the future, it should work again after one or two hours. You can also start the API job manually once.
We have contacted them regarding this issue and asked them to raise our call limit. In addition, we are constantly working to minimize the hits. As this ban is put in place by Binance, there is nothing we can do about it.
Apologies for the inconvenience caused.

Same here - seems it's been weeks since any import from Binance.  Last successful add from Binance API was 2018-10-25, then it was a week before that. 

I know Binance can be extremely restrictive on their API pulls, and they do not publish all of their "rules", because they do not want anyone to be able to game the system.  I believe Cointracking is doing a lot and expending effort to try to fix this, as I'm sure they're aware and intent on making customers happy.

As a suggestion to Cointracking, in case the following items weren't thought of:

• Binance's API responses warns you when you're about to break their rules, so when they respond with the "Back off" messages, be sure to back off to prevent the full ban.  For example, if you get 429 responses, that's a warning to slow down.  418 is when you've been auto banned due to ignoring their 429 responses too many times.  When you get the red error shown, that means you've been more "hard banned" by IP, which in my experience means the 429, and 418 errors were ignored, OR a malformed request was sent and the WAF (web application firewall) stepped in and is now blocking requests.
• Throttle yourself in a queue so all your requests are evenly dispersed by entitlement and age, and spread out more IP addresses.
• Favor the customers who pay more.  Unlimited subscribers should be queued first, then Pro.  If needed, go one Ultimate, then one Pro. Increase intervals to always prevent the ban per IP.
• Set age limits where a certain age by entitlement triggers an increase in queue.  For example, a Pro waiting 5 days is bumped up the queue ahead of an Unlimited waiting 2 days, but not ahead of an Unlimited waiting 3 days.
• "Spread out more IP addresses" - I realize IP addresses are not "free" but VPS hosts and proxies to host your API pulls are cheap enough, especially if you have paid subscribers.  As low as $5/month in most places, and that's retail.  I don't know how many you can logistically support from one device, or how long you have to wait between queries, but it'd be worth the calculation, I'd bet.
• I'm pretty sure Binance lowers the "risk profile" of API queries for a given API key if it knows the IP address it's coming from.  If you provisioned said VPS host dynamically out in the cloud, assigned it to a swath of users, and showed the dynamically-assigned IP address on the user's Binance API page, such that we could put that on our API Key page at Binance, it would likely reduce the risk of an IP ban for that specific API key, and that would help you out a lot.  For security reasons, you would want to make sure this was an IP address from a VPS host and not from your data center.  For throttling reasons, you would also probably want to assign, ratio-wise, a set number of Unlimited subscribers together with Pro subscribers so that the Unlimited queuing mentioned above would work out better. Note that each IP address would need to be sticky to the user and stay that way.
• If you haven't already, maybe reaching out to Binance and discussing this issue with them would be a worthy endeavor.  I would think they (the largest fee-based exchange by volume) would appreciate you (the largest fee-based tracker, I think) who helps people make sense of their trades.
• Is there still no way to combine CSV and API - is that due to the way BNB and fees are handled?  I wouldn't mind filling in the gaps every few days myself by importing CSV file... I'm hurting quite a bit recently without my Binance trades.

I still love Cointracking!

(and if anyone needs a 10% link from me, and finds my tips helpful, feel free to use my personal code at https://cointracking.info?ref=C937652 or GBU's at https://gunbotuniversity.com/cointracking)