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

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".

Hey, the "Total Value" without currencies is exactly the "Sum Coins" value.
So you can just use this one if you're not interested in your currencies.

As an alternative you could add a withdrawal of 500 EUR to equal both values.
But the first solution is much easier.



Yes, the API import will always re-import all trades once they have been deleted.
I have this "time-period" feature already on my todo list.

But there is a workaround for now:
Go to the Enter Coins page, and select all your older trades you don't want (use the SHIFT key to select multiple entries at a time).
Click now on the "edit" button and set the "buy amount", "sell amount" and "fee amount" to 0.
This will overwrite all selected trades with 0 and because they are not deleted, they will not be re-imported or overwritten by the Polo API.

Best, Dario

Hello, who can help me solve my problem.
i bought Unlimited license for cointracing but cant set up it as i need.

i have 3 Poloniex acc and 1 Bittrex
so i want all info be imported using API from all this acc.

and here the problem i have. I need all data from 3 poloniex acc be imported only from certain date 10/06/17 and Bittrex from the opening acc is ok.

so now i delete all data till my date but avery day after avto import it load all data including before 10/06/17 .

so how i can setut my acc for this?

regards

Is their a way to show the ''total value'' without sum currencies ?
Because when i decide to sell for euro i would like to not show it in the total value anymore.

Sum Coins:       1.458,84 €
Sum Currencies:    500,00 €
Total Value:       1.958,84 €
        

Well, there's no need for more colours really. Only the choice of colour for each coin is more than enough. 

Hey moftkhor,

Currently not, but I will add that to our to do list.
Right now we have 30 different colors. Once you have reached 30 coins, the colors will repeat.
I could add more than 30, but I guess it will be hard to see a difference

Best, Dario

Is there any way to change colours on the coin diagram 'Value each Currency in EUR.'
There are too many kinds of blue on 1 circle diagram right now and that makes it a little messy when there are numerous coins on 1 diagram.
Can we customize the colors?

Hey Steve

Thanks again for your suggestion. I just put it on the todo list and we will talk about it.

Wish you good investings.

Best regards,
Keven

@ Dario,

You are welcome.

I have another feature request, which I had been meaning to put in, but you beat me to it, sort of. You changed the interface so that if the balances need to be recalculated, you put up a dialog asking the user to push the button. My idea was to have CT do something more automatic. Here's why:  As long as the user is changing the table by manual entry or import, CT should do no recalculating. But as soon as the user asks for a display of the data in any form, except the Data Input Table, CT should check to see whether anything has changed since the last recalculation (which you have always been doing) and if it's needed, just go ahead and recalculate and display the same progress bar that you do now.

Here's why I say that. If I have been adjusting transactions, or putting them in. When I want to see what happened to the results, i will most commonly ask to see the Balance by Exchange report because it gives the sort of sub-totals I want to be sure line up with what is at the exchanges and/or wallets. But here's the thing: I already know a) that I made changes, and b) that to check them, recalculations have to be done. So why ask me? By adjusting and entering transactions and then asking for a report, I know that such action will require a recalculation, so just do it!

Thanks,

Steve

You're welcome.
Yeah, it's much faster to find the issue in an account than just guessing what it could be.

Thank you too for answering user questions here at bitcointalk
I really appreciate it.
Dario

Dario,
Thank you so much! The BTC quantity had some digits transposed. it was supposed to be 0.207... NOT 0.027, which put me 0.18 BTC short! Big difference! This is an issue I sometimes have with numbers.
It's can be hard for me to spot transposed numbers but much easier to transpose them.

I sure didn't expect you to debug my data entry, but it goes with the territory. I know this because I used to write code that used Excel spreadsheets as input. The users would come to me saying the script was messing up, when, more often than not is was a simple data entry error that they just did not see.

Thanks again!

Steve

Hey Steve,

Actually we calculate the value directly in USD.
We do not calculate in BTC and convert the value into USD.

I think I have found the issue.
You have created a manually ShapeShift transaction of:
Buy: 4 DASH
Sell: 0.02731424 BTC

I don't think this is correct and the reason why the PnL is broken.
0.02731424 BTC had a value of 75.67 USD at transaction
and 4 DASH had a value of 570 USD at transaction.

You can see the wrong values on the gains page (https://cointracking.info/gains.php) by opening the 2nd box and typing "dash" into the search box.
You will also find more buy and sell prices for your DASH sales there, which look good to me by the way.
So it's just this one trade you need to fix.

Best,
Dario

@ Dario or Kevin,
Hi guys, I've just been "taking profit" on Dash. I say taking profit in quotes because CT tells me I have taken an $18 loss for every DASH sold! I was shocked to see that, so I did some digging. If I chart DASH/USD, the graph is pointing straight up, but if I plot DASH/BTC, the trend is sideways to down. I did some rough calculations and found that my weighted average purchase price is roughly $104/DASH. I also calculated my weighted average sale price and it is about $147/DASH, which represents a $43/DASH gain per DASH sold.  I think the reason for this discrepancy is because DASH has been flat to down vs BTC. I'm just guessing that you are calculating gains and losses vs BTC and then converting those gains/losses to USD rather than calculating the gains/losses vs the USD all the way through. When BTC was trading sideways against the USD, this didn't really make a big difference, but now... Long story short, since you are reporting gains and losses vs the USD, I think gains and losses should be calculated against the USD throughout the process.

I hope you see what I mean. Let me know your thoughts!

Thanks,

Steve

Hi, I'm a user here, but can answer your question. I see Dario answered your question, but he is a busy guy and gave you a quick answer. I'm retired, so am not as pressed for time as Dario, so I can give you a little more detailed answer, because there is a lot more to CoinTracking than manual entry, but that's always a way to go.

Hopefully, you have downloaded the free trial so you can see what I'm referring to. On the Menu Bar, there is a link called "Enter Coins", from there you can pick your poison. If you only have a few trades to put in, pick "Overview & Manual Entry". Let's assume you have a lot of transactions to put in. There is not currently a way to automatically load the trades from gatehub so it will have to be a semi-manual effort. To do the import to CoinTracking, you have to be able to download some sort of transaction file from gatehub. If you can do that, it's just a question of manipulating that file to get the data into the right places in CoinTracking. CoinTracking will try to figure out what the columns represent by the header name, but you can fix that before the import. CoinTracking even gives you a preview of what the import will look like before you tell it to proceed. if you have ever imported an address book from one application to another, the process is much the same. A good thing about Cointracking is that you can make a backup of your database before you do anything, so if you create a mess on your first attempt, you can just restore from the backup and start again.

So the best way to be sure this answer works for you is to download the free version, download a transaction file from gatehub (a csv will do fine). Then just see how easy/hard the whole process will be for you.

I hope this helps!

Steve

There is currently no gatehub import, but you can of course enter your XRP manually like all other currencies.

Best, Dario

Is there a way to import gatehub transactions? Or at least manually enter my XRP?

Hey Steve,

as you know we really appreciate your suggestion and feature requests.

I´ll put this on our todo list as well as your other ideas.
Thanks for contributing. Happy Tracking.

Greetings,
Keven

Hey @Liquid71,

thanks for your question. We understand such concerns and take special care about it.

I want to give you some points on our security activities.

- All data is stored secure and only on our own server, plus it will stay there.
- All databases are protected and completely shielded.
- User data is stored fully encrypted.
- The whole website is running on a SSL certification base.
- All data we delete, is deleted directly and forever. No data is left behind.
- You can register completely anonymous, nothing of your personal data is required.
- All user statistics are calculated without personal details.

To name just a few security features.

Hope this is going to help you.

Also @sgjenks01 thanks a lot for submitting an answer.

Best regards,
Keven

Hey @Tap Project,

thank you for the compliment.

We try our best to make our platform as useful as even possible. We are working on it every single day.

And yes, it´s probably a lot easier than the old excel files for most of the people.

Wish you happy tracking.

Best regards,
Keven

Hi @moftkhor,

thank you for asking about this.

Currently we are not able to add XRP as a wallet import, because we are working with a Multi-Blokchain-API and we mostly track data from there.
Unless you can name a Blockchain-API source we could implement, where this Coin is already added. In this case we would try to start an integration.

However, we hope the Multi-Blokchain-API is going to add this Coin soon.

For now you could use our bulk importers or the manual import.

Kind regards,
Keven