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

Bermuda666

member

Activity: 85

Merit: 10

Quote from: DehiDehi on June 21, 2017, 01:08:30 PM

Hey there,
When I export my trade history from exchange platforms (such as GDAX and Bittrex) and import them into Cointracking, I noticed the trade timestamps change by -2 hours. As a result, my portfolio value is quite inaccurate.
My timezone is correctly configurated in those exchange platforms (UTC+1), but when it comes to Cointracking it changes all the times to UTC -1. My Cointracking account timezone is UTG+1 aswell.

Here are two screenshots featuring a trade I did on Bittrex that illustrates my issue: http://imgur.com/a/o6jku

Can you help?
Cheers

Hi @DehiDehi,

thank you for getting in touch with us.
You are right, we still have some problems with the timestamps.

We are currently working on a solution for this problem and we hope to get it integrated over the next weeks.
Sorry for inconvenience, we do our best to solve this problem as soon as possible.

Thanks for your patience.

Best regards,
Keven

hessenbob

newbie

Activity: 4

Merit: 0

Dashboard reported amount does not match amount shown on ethplorer.io.

I've imported my purchases and trades from Bittrex without any issue. I transferred all of my ETH to my Trezor, which has a MEW address. The amount shown in Trezor/MEW matches ethplorer.io, however, the Cointracking database underreports my ETH by about 25%. I have deleted and reimported my trades and MEW address multiple times, but cannot get Cointracking database to match the amount in MEW.

Additionally, when I manually input a trade to reflect the difference, the Cointracking database then overrepresents the ETH amount.

Any suggestions?

DehiDehi

newbie

Activity: 7

Merit: 0

Hey there,
When I export my trade history from exchange platforms (such as GDAX and Bittrex) and import them into Cointracking, I noticed the trade timestamps change by -2 hours. As a result, my portfolio value is quite inaccurate.
My timezone is correctly configurated in those exchange platforms (UTC+1), but when it comes to Cointracking it changes all the times to UTC -1. My Cointracking account timezone is UTG+1 aswell.

Here are two screenshots featuring a trade I did on Bittrex that illustrates my issue: http://imgur.com/a/o6jku

Can you help?
Cheers

Dario3000

hero member

Activity: 760

Merit: 516

CoinTracking - Crypto Portfolio & Tax Management

@Prodigy4
I have checked your BTC address.
There are 6 transactions and all of them have already been imported into your account.

Dario

Dario3000

hero member

Activity: 760

Merit: 516

CoinTracking - Crypto Portfolio & Tax Management

Hey, all transactions are checked every few hours.
What time was the last BTC transaction for your address?

Please let me know via support ticket, so I can have a look if it does not import it within the next 2-3 hours.

Dario

Prodigy4

newbie

Activity: 5

Merit: 0

The import of my BTC wallet transactions worked perfectly but now it doesn't add the future transactions. How can I fix this?

Dario3000

hero member

Activity: 760

Merit: 516

CoinTracking - Crypto Portfolio & Tax Management

Thanks,

Yeah, there was already a coins called HERO.
As soon the new coins will be listed here coinmarketcap.com or here cryptocoincharts.info (currently having issues), it will be listed automatically on CoinTracking.
This happens usually 0-3 days after a coins was listed on an exchange.

Dario

sgjenks01

member

Activity: 91

Merit: 10

Hi Guys,

On a different subject, I see that HERO is now listed as a "Dead Coin". It's anything but. Perhaps there was a coin called HERO that "died", but HERO is alive and well and trading on the Bitshaes Exchange.

Here's the latest quote:

HERO : bitUSD
price: 159.83101
volume: 14.97k
change: 3.12%

Can you bring it back from the dead?

Thanks,

Steve

sgjenks01

member

Activity: 91

Merit: 10

Quote from: Dario3000 on June 17, 2017, 05:27:13 PM

Adding minings into that calculation could result in a cost basis of 1200 USD.
The value would still be correct, but I does not tell you the break even of your trades any more, but for a mix of trades and minings.

@Dario,
If only my mining would result in a cost basis of 1200 USD!

But I do see your point. An analogy in stocks might look at mining activity like dividends. If you have a stock that pays dividends, you can evaluate your trading based on the price you paid or you can look at your total investment by reducing the basis by subtracting the dividends. Both points of view are valid and are for two different purposes. I think the explanation you added to the Info popup clearly explains what the button does. I'm just not sure people using the platform will understand the reasons for displaying the results two different ways. But maybe I'm just a little slow sometimes. Huh

Thanks,

Steve

Dario3000

hero member

Activity: 760

Merit: 516

CoinTracking - Crypto Portfolio & Tax Management

Sorry for the IOTA issues.
Multiple price APIs have changed the ticker and the decimals already 5 times in the last 3 days.
I really hope this was the last time

All IOTA prices are back again.

@sgjenks01:
It's just a recommendation and not a must-use option.
I'm using the gains page myself to see the profit I already did with my trade-sales and the profit I could achieve right now by selling my assets.
Adding your minings into that calculation will always distorts the values as they don't have a cost basis.

Let's say your overall cost basis is 2600 USD per BTC and the current price is 2500 USD.
It tells you to wait for the price to go up by 100 USD to break even.

Adding minings into that calculation could result in a cost basis of 1200 USD.
The value would still be correct, but I does not tell you the break even of your trades any more, but for a mix of trades and minings.

But that's why I have created a checkbox for this option. You can enable and disable it, to check both possible values.

@BitcoinPC:
You can register completely anonymous. You do not even have to enter an email address.
Our tool was designed for your convenience, so you do not have to track thousands of trades by hand in a list.
If you don't like it, use Excel Wink

Have a great weekend,
Dario

Bermuda666

member

Activity: 85

Merit: 10

We are sorry guys,

at the moment there seem to be big problems with IOTA and our price is not correct.

We are currently working on that and we just wanted to let you know.

Please have patience. We hope we are able to fix it as soon as possible.

Thank you.

Beat regards,
Keven

BitcoinPC

hero member

Activity: 812

Merit: 500

It looks interesting but seems that you have the clients collecting all the info themselves. We stopped at the first entry. If I have to get the buy in price, sell price and all of that, then why don't I simply do the last few little steps myself and graph the info. No one is going to give you account access to other accounts, which would be the only real way to get this done, because there is no reason to trust you.

sgjenks01

member

Activity: 91

Merit: 10

Quote from: Dario3000 on June 16, 2017, 12:16:02 PM

I have added a new function into the gains page called "Add Deposits & Withdrawals to remaining amount"
Activating this function will show the same values as in the dashboard.

Disable: Calculates all gains and the costs basis from trades only. (recommended)
The remaining amount of a coin can deviate from the values in the dashboard, because deposits and withdrawals will not be included.

Dario,
Thanks for implementing a solution so quickly.

However, I am curious why you recommend not using this option.

In the case of deposits from mining, shouldn't the basis of those coins be zero and thereby "average down" the cost basis of all those coins which are owned?
Conversely, if a person sells a coin in exchange for goods and services (a withdrawal), wouldn't that result in a gain or loss on the number of coins sold using the current market price of the coin versus the basis for all coins owned at that point in time based?

Please help me understand your recommendation.

Thanks,

Steve

Dario3000

hero member

Activity: 760

Merit: 516

CoinTracking - Crypto Portfolio & Tax Management

Quote from: ebliever on June 16, 2017, 03:40:54 PM

Bitcoin price in cointracking.info has been stuck at $2,503.83 for several hours now.

Thanks. It's updating again.
BitcoinAverage has disabled their old free API without letting users know

ebliever

legendary

Activity: 1708

Merit: 1035

Bitcoin price in cointracking.info has been stuck at $2,503.83 for several hours now.

Dario3000

hero member

Activity: 760

Merit: 516

CoinTracking - Crypto Portfolio & Tax Management

Quote from: coolcash on June 16, 2017, 12:33:52 PM

Do I need to pay for each account if I link them? I am using a trading bot which generates thousands of trades. It would be nice to separate each account out, but might become very costly to do that.

Thanks.

Hey coolcash,

No, you don't have to pay multiple times

See the info on the upgrade page:
For users with multiple accounts, all current and future accounts will be upgraded when purchasing CoinTracking Pro or Unlimited.

Best, Dario

coolcash

newbie

Activity: 30

Merit: 0

Do I need to pay for each account if I link them? I am using a trading bot which generates thousands of trades. It would be nice to separate each account out, but might become very costly to do that.

Thanks.

Dario3000

hero member

Activity: 760

Merit: 516

CoinTracking - Crypto Portfolio & Tax Management

Hey guys,

I have added a new function into the gains page called "Add Deposits & Withdrawals to remaining amount"
Activating this function will show the same values as in the dashboard.

Disable: Calculates all gains and the costs basis from trades only. (recommended)
The remaining amount of a coin can deviate from the values in the dashboard, because deposits and withdrawals will not be included.

Enable: Includes all deposits and withdrawals into the calculation.
Gains and the cost basis will change as deposits and withdrawals do not have a cost basis.

Bermuda666

member

Activity: 85

Merit: 10

Quote from: sgjenks01 on June 15, 2017, 11:54:13 PM

Quote from: sgjenks01 on June 15, 2017, 09:33:49 PM

Dario & Kevin,
I ran into issues when I sold all BTC and ETH because I had errors related to the ShapeShift transactions I didn't keep good records on. These errors caused the balances to be negative, which, as you know, CT can't deal with, so it showed realized gains at zero and losses at zero. To try to figure out the errors, I decided to use the "Double Entry List" report. Doing this actually helped me find the gross errors, but the totals still didn't match what I expected.

While doing this, I noticed that the Double Entry List pulls Fees out of the Fee column and puts it as an "Out" transaction. This means that if I add up all the Ins and Outs for a particular currency, I get a different answer than the Remaining Amount that shows on the Realized/Unrealized page. So, I thought if I just strip out all the Out transactions for fees that I would get a total quantity by currency from the Double Entry List that would match the quantities in the Remaining Amount column of the Realized and Unrealized Gains page.

Unfortunately, it didn't turn out that way. The totals from the Double Entry List (without Fees) is almost always an amount lower than the amount reported on the Realized Gains and Losses page. It's usually a small amount - just a fraction of a coin. But with BTC, the totals disagree by 0.25 BTC, which at today's prices is a pretty hefty difference how much is being reported.

You might be wondering how I got the numbers. I started with the raw output from the Double Entry List and then filtered out all the fee transactions and deleted them. Next, I downloaded the Realized Gains and Losses spreadsheet. I transposed it so that the totals and currency symbols go across the page instead of down. Then I wrote Excel formulas to only extract data into a column if the symbol matched the cell containing the symbol from the Realized Gains and Losses sheet. The formulas looked for In or Out in the transaction type and changed all the Out transactions to a negative number. Next, I calculated a running total and it's that total that I compared with the amouts from the Remaining Amount column. So, in essence, I wound up with a spreadsheet with the transactions running down the page on the left with all the symbols running across the page. Each column in that array only contains transactions that relate to that column's symbol and all the Out transactions are negative quantities.

It seems to me that the quantity from the Gains and Losses page should match the sum of all non-Fee transactions for that currency, and they don't. What am I missing?

Steve

Sorry for the "book".

The book continues... I did some more digging on this and what I have found is that the Double Entry List (minus the Fee entries) either matches exactly with a tally of the wallet totals for that currency or very, very close. On BCN, I had a transaction where I moved BCN from a miner to the "Main" wallet and then decided to create a "Miner" wallet and move those funds over. I end up with a discrepancy of ZERO between the IN?OUT totals and the wallet totals. But the total from the Realized and Unrealized page doesn't account for the coin moved to the "Miner" wallet AT ALL. Similarly, with BTC where I had a discrepancy of over .25 BTC when comparing the IN/OUT total to the Realized and Unrealized page where the difference between the IN/Out total and the actaul wallet values is .0003147 BTC or about 75 cents. With BTS, the error is the opposite of that found in BCN. Here the Realized and Unrealized total is overstating the available balance, where the difference between what the wallets say I have and the In/Out totals is off by .01213 BTS or 0.4 cents.

Anyway, I hope you see that the In/Out totals (excluding Fees) agrees very closely with what is in the wallets and the totals from the Realized and Unrealized Gains page does not.
Steve

Hey Steve,

ok, thank you for going into this.

We have to check your statements in detail and this could take a while,
since there is a lot of stuff to do at the moment.

Please have patience. Thank you.

Best regards,
Keven

sgjenks01

member

Activity: 91

Merit: 10

Quote from: sgjenks01 on June 15, 2017, 09:33:49 PM

Dario & Kevin,
I ran into issues when I sold all BTC and ETH because I had errors related to the ShapeShift transactions I didn't keep good records on. These errors caused the balances to be negative, which, as you know, CT can't deal with, so it showed realized gains at zero and losses at zero. To try to figure out the errors, I decided to use the "Double Entry List" report. Doing this actually helped me find the gross errors, but the totals still didn't match what I expected.

While doing this, I noticed that the Double Entry List pulls Fees out of the Fee column and puts it as an "Out" transaction. This means that if I add up all the Ins and Outs for a particular currency, I get a different answer than the Remaining Amount that shows on the Realized/Unrealized page. So, I thought if I just strip out all the Out transactions for fees that I would get a total quantity by currency from the Double Entry List that would match the quantities in the Remaining Amount column of the Realized and Unrealized Gains page.

Unfortunately, it didn't turn out that way. The totals from the Double Entry List (without Fees) is almost always an amount lower than the amount reported on the Realized Gains and Losses page. It's usually a small amount - just a fraction of a coin. But with BTC, the totals disagree by 0.25 BTC, which at today's prices is a pretty hefty difference how much is being reported.

You might be wondering how I got the numbers. I started with the raw output from the Double Entry List and then filtered out all the fee transactions and deleted them. Next, I downloaded the Realized Gains and Losses spreadsheet. I transposed it so that the totals and currency symbols go across the page instead of down. Then I wrote Excel formulas to only extract data into a column if the symbol matched the cell containing the symbol from the Realized Gains and Losses sheet. The formulas looked for In or Out in the transaction type and changed all the Out transactions to a negative number. Next, I calculated a running total and it's that total that I compared with the amouts from the Remaining Amount column. So, in essence, I wound up with a spreadsheet with the transactions running down the page on the left with all the symbols running across the page. Each column in that array only contains transactions that relate to that column's symbol and all the Out transactions are negative quantities.

It seems to me that the quantity from the Gains and Losses page should match the sum of all non-Fee transactions for that currency, and they don't. What am I missing?

Steve

Sorry for the "book".

The book continues... I did some more digging on this and what I have found is that the Double Entry List (minus the Fee entries) either matches exactly with a tally of the wallet totals for that currency or very, very close. On BCN, I had a transaction where I moved BCN from a miner to the "Main" wallet and then decided to create a "Miner" wallet and move those funds over. I end up with a discrepancy of ZERO between the IN?OUT totals and the wallet totals. But the total from the Realized and Unrealized page doesn't account for the coin moved to the "Miner" wallet AT ALL. Similarly, with BTC where I had a discrepancy of over .25 BTC when comparing the IN/OUT total to the Realized and Unrealized page where the difference between the IN/Out total and the actaul wallet values is .0003147 BTC or about 75 cents. With BTS, the error is the opposite of that found in BCN. Here the Realized and Unrealized total is overstating the available balance, where the difference between what the wallets say I have and the In/Out totals is off by .01213 BTS or 0.4 cents.

Anyway, I hope you see that the In/Out totals (excluding Fees) agrees very closely with what is in the wallets and the totals from the Realized and Unrealized Gains page does not.
Steve

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