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

[Dario3000]

Great job... Really very useful

Thanks a lot

@cryptaolee:
Well, it's hard to say without knowing any details.
Have you added any other exchanges or trades?
Which exchanges do you use?
As we are using average prices, there might be a difference of $30 compared to the values the exchange is converting for you.
The best would be to create a ticket so I can have a detailed look.

And I would not include deposits and withdrawals into the gains calculation, as those values do not have a cost basis and will distort your gains.

Best,
Dario

[EveryDayArms]

Is it possible to add support for margin trading for CEX.io? All my coin values are skewed since I did quite a bit of margin trading but CoinTracking doesn't recognize it.

[Dario3000]

Is it possible to add support for margin trading for CEX.io? All my coin values are skewed since I did quite a bit of margin trading but CoinTracking doesn't recognize it.

Sure. I will try to add an API import for CEX.io in a few days.

Dario

[EveryDayArms]

Is it possible to add support for margin trading for CEX.io? All my coin values are skewed since I did quite a bit of margin trading but CoinTracking doesn't recognize it.

Sure. I will try to add an API import for CEX.io in a few days.

Dario

Perfect - thank you very much.

[KelvinatorNL]

This is definitely an awesome product and I'm very happy with it since I'm HODL'ing more than 25 coins at the moment.
It will give you a nice overview of all the coins you're keeping.

But I do have a question; Why are there only 2 exchanges selectable when I've selected EUR? (Bitcoinaverage + Bitcoin.de)

[Extreme]

I'm having an issue on the Realized/Unrealized Gains page. If I uncheck "Add Deposits & Withdrawals to remaining amount" it is showing my ETH balance in the negative. If I turn it on it shows the right ETH balance, but my cost per unit is in the negatives, so it throws off all of my profit values. What is the proper way to deal with this? All of the coins in my balance were ones I recently bought, and did not come in from a deposit, so it should still know the cost per unit.

[Dario3000]

This is definitely an awesome product and I'm very happy with it since I'm HODL'ing more than 25 coins at the moment.
It will give you a nice overview of all the coins you're keeping.

But I do have a question; Why are there only 2 exchanges selectable when I've selected EUR? (Bitcoinaverage + Bitcoin.de)

Hey,
I will add more exchange prices soon for EUR and USD.
But I'm still recommending BitcoinAverage. The price usually fits very good to all exchanges.


@Extreme:
If the ETH balance is negative with the unchecked box, your ETH trades are not listed completely on CoinTracking.
Please double check if all your ETH trades have been imported and also enter all ETH you have bought on other exchanges.

Best,
Dario

[seeARMS @ Bit-Bank]

Any updates on the CEX.io API import? Thanks!

[Dario3000]

Any updates on the CEX.io API import? Thanks!

Should be done until Sunday

[Galletera]

Hello! Couple of questions.

1. If I buy 100 units of one coin at various prices and my 'cost of unit' appears as 0.25 (Example), why does the "cost of unit" change after I sell some of the 100?

Rough example, I buy (50) units at 0.18, (35) at 0.25 and (15) at 0.40. My "cost per unit" is 0.245. Why is the 'cost of unit' changing after I sell 10 coins (at any price)?

I'm using "unsold Assets as Cost Basis" and was under the impression the "cost of unit" is sort of all the prices you have payed when buying, averaged out.

2. The "counterpart prices" the most realistic, precise ones? They include how much I payed + fees for the transaction while "Transactions prices" do no include fees?



Lastly a suggestion: A setting where we could select from which exchange we want the "Current Price" to be shown for each coin.

I only trade coins that are on Bittrex, so I'd like to be able to click "Select all" coins and then check a box saying "Get Current Price for Un/Realized gains/losses" --> Bittrex.

[Dario3000]

@Galletera:
The 'cost per unit' will be calculated from the weighted average of all unsold assets according to your selected method (e.g. first-in first-out).

Let's use your example:
-> buy (50) units at 0.18, (35) at 0.25 and (15) at 0.40.
selling 10 units will result in a remaining amount of:
-> buy (40) units at 0.18, (35) at 0.25 and (15) at 0.40.
And this will lead to a different cost per unit price as 10 units @ 0.18 have already been sold.

Correct, counterpart prices will include the spread and the fees.

The average prices we are using will match Bittrex prices in most situations.
But yes, adding more exchange prices is already on our to do list

Best,
Dario

[seeARMS @ Bit-Bank]

Any updates on the CEX.io API imports? 

[Dario3000]

Any updates on the CEX.io API imports? 

Sorry, still in progress.
CEX is more complicated than I thought.
But it will come very soon. I promise

[zulu89]

HI, I just started using cointracking and it blew my mind. The functionality is amazing and awesome features. I'm a new user so I'm sorry if this is a really stupid query. I just want to ask how do i Input something like this. I bought 100 EOS @2 and sold it @1.34 so basically I got 134USD. Now with this same USD i bought 11.5 Monaco @12. Creating two new entries distorts the investment figure. So how do i got about this?

[Dario3000]

HI, I just started using cointracking and it blew my mind. The functionality is amazing and awesome features. I'm a new user so I'm sorry if this is a really stupid query. I just want to ask how do i Input something like this. I bought 100 EOS @2 and sold it @1.34 so basically I got 134USD. Now with this same USD i bought 11.5 Monaco @12. Creating two new entries distorts the investment figure. So how do i got about this?

Hey and thanks a lot. I really appreciate it.

The correct entries are:
Buy 100 EOS | Sell 200 USD
Buy 134 USD | Sell 100 EOS
Buy 11.5 MCO | Sell 138 USD

It will show a realized EOS loss of 66 USD (because all coins were sold) and a current unrealized MCO loss of 18 USD (as all MCO are still available).
The sum is your total gain/loss for those 3 trades.
(The unrealized gain/loss will change depending on the current MCO market price. The realized gain/loss will not change any more).

Best
Dario

[zulu89]

Hey thanks for the reply. Yeah i got the point of how to input it from an accounting point of view but my noob question is in the earlier example I have put in 200 USD in total and when i input it like you said it reflects as 350 usd approx. So when i see my total trades and the amount I have invested vs their current market price, won't that give me a distorted figure. Should i make the monaco entry as something other than trade?

[coolcash]

I am not sure if there is a report for this or I am not sure what its called. I am looking to figure out my profit from my completed buy/sell pairs. Such as 1 ETH buy then 1 ETH sell at a higher price. Is this an option?

[zulu89]

I am not sure if there is a report for this or I am not sure what its called. I am looking to figure out my profit from my completed buy/sell pairs. Such as 1 ETH buy then 1 ETH sell at a higher price. Is this an option?

I'm hoping they have such an option especially for people like me who rebalance their portfolio a lot. One way out is adding the input for the new trade from the proft/loss of the last trade as an income instead of a trade(exchange) but then your new trade doesn't get displayed in the avg price and profit/loss thing. Maybe cause i'm new to this platform I've completely misunderstood things but hopefully there's a way out which i've just overlooked.

[Dario3000]

@zulu89:
Are you sure, you have not switched "Buy" and "Sell" on your trade entries?
Because 350 should not be the result of your example.

@coolcash:
Not sure if I get it right.
You can check the "Reporting -> Trade Analysis" where you can analyse all trades by trade-pair, exchange, group and date.
Also it could be interesting to check the 2nd table on the gains page (minimized by default) where you can find all sales according to your selected method (FIFO, LIFO...) which is also searchable, and filterable by exchange, group and date.

Dario

[zulu89]

No, I did it exactly as you said. The EOS pair is fine. It shows a loss of 66USD. But when i make an input for the monaco trade even according to your example i enter 138 USD as the investment. My point being in real terms I have just put in 200 USD innit. I get the accounting bit but is there a way to see what I'm asking. Also see my second post, it's related to the same thing i said earlier. Thanks a lot for all your help so far and replying so promptly. I'm loving cointracking and it's features. Just want to clear this confusion.