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

Dario,
I have Chrome 64 Bit Latest, but I guess it doesn't matter, because I was unable to reproduce the problem just now. This despite the fact that I was able to replicate it several times before I reported it. I guess that's what sometimes happens when you get tech support involved. 

Thanks for looking into it.

Steve

Hey sgjenks01,

Actually this should not happen. I have tested it multiple times and do not have the same behavior.
The search is always checking ALL entries of a table and not just the shown page.
As the filtering happens in your browser and not on our server, it may be something there.
What browser and version are you using?
Have you tried it with another one?

Thanks also for answering the questions of BitBadger

Best,
Dario

 

@Dario,
I just found a minor bug in CT. In the trades table, if the number of rows is set to, say 10, and then you search for something that's in the table, but not in the first 10 rows, CT will return no rows. Then, if you change the row count to be big enough to include the rows in question, CT still returns nothing. To get CT to work properly, you have to clear the search box and re-enter the search term.

It seems to me that CT should return the rows searched for, regardless of whether they are displayed at the time the search term is entered.

Steve

Thanks Steve for the detailed advice, that sounds pretty good. Ive looked around and tried a few other alternatives, and CoinTracking seems the best choice for me right now.

Ive already tried the free version, as I said I used up all the free trades.  I deleted the old trades for 4 months ago and imported my trades from just one exchange, but its already full. So Ive decided to purchase the full version for one year and start using it right away as I need all my trade data and the full API data feeds, no point otherwise.  So we'll see how it goes for this first year.

@bm303
I think you have identified the problem an it's easy to fix. Just open the Trades Table and add "In"/Deposit transactions for your deposits and assign them to the exchange where they went. I'm guessing Pol isn't off because you may have only transferred coins in and did not actually make a deposit there?

@Kevin and Dario. This would be another great item for the "Quick Start Guide".

Steve

@ Kevin and Dario,
It would be nice if CT "remembered" the user's choice for the number of rows to display. When I'm working on transactions, I often go run a report to see if what I did is correct. Then when I go back to the Table, I have to select the number of rows again. Not a big deal, but an annoyance just the same.

Also, I thought of a better name for "READ THIS FIRST". Call it a "Quick Start Guide". Not an original name, but would draw the eye of a new user.

Steve

@BitBadger
I'm a new user, but I have used CoinTracking extensively. I thought I would give you my thoughts from the perspective of a user.

Re the real time API. It depends on how "real time" you want/need. CT will automatically import once a day. However, once you have set up the job, you can do this manually once an hour. (Enter Coins => Automatic API imports). If that's not often enough, that will need to be addressed by Dario/Kevin

Splitting trades by portfolio can be done (Enter Coins => Overview and Manual Imports), Once there, you must change to View:Extended (at the bottom of the table). I would also set Inline Editing:On  Set up that way, you should be able to see Groups and be able to click on a trade and assign it to a group to create the "sub-portfolios".  Done at this level, you could assign a transaction for BTC to one Trade Group and another BTC transaction to a different trade group, regardless of what Exchange it was done on. I recommend that you actually set up all this with the 100 trades that will be in CT once you set up all the Imports and Groups. For this test, you don't have to assign real groups just to test it out and one of your groups can be blank for this test (or later), so you don't have to put a lot of effort into checking out if this would work for you.

From my own experience, if you use CT, you will want to assign those groups as soon as the import is done because it could quickly get away from you as to what belongs where. It's also possible to export the entire table to Excel, add the Groups (you could assign multiple transactions this way) and then import the finished spreadsheet. This is where Bulk Delete would come in handy, because you would want to empty the table before you uploaded the revised spreadsheet, otherwise you would probably get double entries. If you take this approach, you would want to put API Imports on Manual so that when you empty the table it stays that way. You can also back up your table before doing any of this so it's easy to recover from any mistakes.

Once you have some groups assigned to some trades, you can view a report (Reporting => Balance by Exchange). At the top of the report, there is a button titled: Group by Trade-Group. This is referring back to the Groups you defined above. That probably isn't exactly what you want for a report, but you can see how it works. I think the report you would want is Reporting => Realized & Unrealized Gains. Unfortunately, that page is only displayable by currency right now. However, I'm guessing that Dario could add a couple of buttons to toggle back and forth between Currencies and Trade Groups. He might even be able to have the Groups report give the user Gains/Losses grouped by Trade Group, then by Currency.

So, my recommendation to you is to use your free access to test out these ideas to see if it will meet your needs and go from there.

I hope this helps.

Steve

So I got everything imported from the 3 exchanges I use. Bittrex, Kraken, Pol. The issue is that I am 5 BTC negative. I can't figure out why. Is Bittrex not importing my deposits and only importing my trades? Same for Poloniex? Kraken is the only one with the correct BTC balance. The rest are negative. Very confused here. Thanks.

@ Dario re Bulk Delete. There was no indication that it was doing anything. That's a problem for impatient users. 

Hi, I registered to use CoinTracking free version at the start of the year and used it for a short while (I soon reached the max free trades) and then forgot about it.

I've just come back to have a look again. I'm a professional trader so I am looking for a portfolio management system which can meet most or all of my requirements.

I need a system which automatically records and updates my trades with real time API data, produces reports, stats and graphics, and also produces accurate tax information (for Germany where I am currently based). So CoinTracking looks pretty good on these points. 

I long since reached the free trades limit back at the start of the year as I'm a high volume trader so I would be looking to purchase the pro version.

What I ideally also need is the functionality to split the portfolio into different sub-portfolios as I work on my trades according to different criteria according to which portfolio each coin/position belongs to. 

Obviously I need a total overview of all positions, but I also need to be able to assign coins/positions to different sub-portfolios.

Is it possible to do this with CoinTracking? Or if not, can such a facility be programmed?


 

Hey sgjenks01,
Sounds to me like your bulk delete was not finished when you have reloaded the page.
There will be a message in the bulk delete box, once all trades have been deleted.
Best, Dario

Kevin,

First, re Bulk Delete: I checked the box at the very top that says "Delete all trades". That was the only box I checked.

When I just tried to log in to be sure what the box was actually called, I got this: "cointrracking info says: DataTables warning: table id=trade_table - An error occurred while connecting to the database 'my-btc'. The error reported by the server was: SQLSTATE[0804] [1040] Too many connections"

I hit refresh and the table loaded. Sounds like a possible capacity issue?

Steve

Hey again @sgjenks01,

I wanted to say thank you for going into so many details and the work you put into this.
It shows you understand our software very well.

I like the idea of a “READ THIS FIRST” file, we are going to talk about it and if that would be a good way to improve the user experience on our website. Nice idea.  
Most of the things are either already mentioned in the FAQs, the descriptions or the documentation, but maybe to read about them bundled before starting is a good thing.

Also thanks for your ideas and suggestions. I pick them up. We will take every single one very serious and we are going to talk about a possible integration.

Your contribution is really much appreciated and we are proud to have such active users like you. This helps us to become better every day.

Enjoy the day.
Greetings,
Keven

Update:
I just read your problem with filtering the bulk deletion. Please be sure you picked an option in the upper section of the Pop-up window. Otherwise nothing can be filtered. Please read the text below. Hope this solves the problem.

Hi @sgjenks01

thanks for your question.

Please create two seperate jobs if you have two seperate adresses. This could be the cause of the error.
If you do this, it should solve your problem quickly. Please try it and let me know if it worked.

Best regards,
Keven

Dario,
I have worked with CT a LOT during the past several days and have learned some things the hard way that I wish I could have read about instead. Perhaps you could create a “READ THIS FIRST” file. I think it would cut down on questions here in BitCoinTalk and also improve user experience. There are probably more ideas that could be include, but these are things that I think should be in such a file:

•   CoinTracking assumes all Buy/Sell and transfer amounts are the Gross cost of the transaction. This means the Buy/Sell amounts should include all exchange and network fees. This way it shows you the Profit and Loss after expenses. If you believe an exchange or wallet is sending Net values in the amounts columns, please let us know so we can investigate and correct the issue.
•   The Fee column, together with the underlying Currency the fee is reported in is there to help you keep track of expenses. What you put in these columns has NO effect on your balances. There is a reporting function called Trading Fees where CoinTracking converts all the fees to USD for you. Be sure that the underlying currency column has a currency listed or CoinTracking will ignore that transaction cost. This is easy to check. Simply sort the table by Fee and then look at all the transactions with an associated fee that don’t have a currency reported.
•   When CoinTracking does an import from anywhere, it looks to see if there are any transactions were already imported and ignores them. It is important that you NOT edit any imported field values. CoinTracking will re-import any transactions that you may have edited and then you have duplicate transactions.  
•   ShapeShifter allows one to exchange coins without having to move the funds to an exchange and then back to your wallet afterward. Many users find this a good approach to keeping their currencies safe. Shapeshift doesn’t require the user to provide any personal information to execute the trade. Because of this, you need to either write down or take screenshots of the information about the exchange as it happens. If you don’t, you will have no record of what was exchanged for what or what the fees were.

Moving on, I have some ideas that I think will help users maintain their data.

•   The “Table Backup” function should be somewhere on the menu structure. Right now, it’s just buried as a link on an import page.
•   I see a fair amount of dialog in BitCoinTalk about needing to change the table to Extended View to perform certain functions. I suggest you simplify by eliminating the choice and just have an Extended View.
•   The advanced search function is awesome. The link should be a bit more prominent. I didn’t know it was there for quite a while. Using it from the beginning could have saved me a lot of time.
•   One thing I do when trying to figure out what might be wrong about a transaction is use the filter to find a transaction. Then I want to see the transactions around that transaction, so I turn off the filter. Then, of course I have no idea where the transaction actually was that I just found. You could solve this by numbering all the rows of transactions. These numbers shouldn’t change when filtering is done. That way, the user can go right to the transaction after turning off the filter.
•   When working with CoinTracking, I discovered that the Bulk Delete button doesn’t do anything. It brings up a dialog that allows some customization of the bulk delete, but once the selections are made, nothing is deleted.
•   In the section above, I recommended cautioning users about editing imported transactions. You could aid in that by somehow highlighting the rows that were imported vs manual entries. You could either bold the imported rows or put an asterisk on the imported rows.

Sorry this turned into such a book, but I had a lot of ideas.  

Steve

I tried to edit a job in the Alt Coin import area because i had two addresses and transactions for DASH and noticed that I could include both addresses in one job, but when I clicked on edit, it brought up the details of the job, but no way to edit them.

Thanks,

Steve

Sure, much appreciated what you guys are doing keep it up

Hi @Pietpiraat

thank you for submittig this problem.

I added this one to our todo list and we try to fix it as soon as it is possible.

Please be patient, our list is long at the moment.

Best regards,
Keven

When viewing balance by day and i try to make a pdf from it, it isn't showing all currencies correctly and it seems its not fitting on the paper,
Can you make it that it fits ?

Hey again @dp_

thanks for the reply. (:

You know the Cryptocurrency business is a really fast moving branch.
We do our best to stay always up to date in this continously changing field. But sometimes we have to decide either for one option or another, to keep things going.

Sure, we try to improve our service all the time and hope to find a solution if this is going to be a major problem, for many users.

We are going to discuss your suggestion and hope to find a good compromise.

Thank you for contributing.

Best regards,
Keven