Bitcoin Forum
October 20, 2018, 10:40:41 PM *
News: Make sure you are not using versions of Bitcoin Core other than 0.17.0 [Torrent], 0.16.3, 0.15.2, or 0.14.3. More info.
 
   Home   Help Search Donate Login Register  
Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 [15] 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 ... 74 »
  Print  
Author Topic: CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies  (Read 91130 times)
sgjenks01
Member
**
Offline Offline

Activity: 91
Merit: 10


View Profile
May 13, 2017, 07:29:06 PM
 #281

Dario,
The import from Bittrex worked perfectly. However, when I tried to import from Coinbase, everything appeared to go just as smoothly except there are no trades listed for Coinbase. I looked at the content of the .CSV files (BTC,LTC and ETH) from withing CoinTracking and there appears to be trade info in those files, but nothing shows up when I update the calculations.

Do you have any ideas about how to debug this problem?

This trade tracking platform is so exciting. I can't wait to get it up and running with all my trades.
1540075241
Hero Member
*
Offline Offline

Posts: 1540075241

View Profile Personal Message (Offline)

Ignore
1540075241
Reply with quote  #2

1540075241
Report to moderator
1540075241
Hero Member
*
Offline Offline

Posts: 1540075241

View Profile Personal Message (Offline)

Ignore
1540075241
Reply with quote  #2

1540075241
Report to moderator
Visit and contribute to reddit.com/r/Bitcoin
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1540075241
Hero Member
*
Offline Offline

Posts: 1540075241

View Profile Personal Message (Offline)

Ignore
1540075241
Reply with quote  #2

1540075241
Report to moderator
1540075241
Hero Member
*
Offline Offline

Posts: 1540075241

View Profile Personal Message (Offline)

Ignore
1540075241
Reply with quote  #2

1540075241
Report to moderator
1540075241
Hero Member
*
Offline Offline

Posts: 1540075241

View Profile Personal Message (Offline)

Ignore
1540075241
Reply with quote  #2

1540075241
Report to moderator
Dario3000
Hero Member
*****
Offline Offline

Activity: 744
Merit: 512


CoinTracking - Crypto Portfolio & Tax Management


View Profile WWW
May 13, 2017, 09:15:31 PM
 #282

Hey and thanks a lot.

Really? I just tested it with my Coinbase CSV file and it worked well.
Are you sure, you have exported the "Buys, sells, and merchant payouts" file from Coinbase?

Best,
Dario

CoinTracking.info - Your Profit / Loss Portfolio Monitor and Tax Calculator for all Digital Currencies
Simply the best way to track your digital assets accurately. Get live data for more than 5000 coins, assets and commodities. Track Gains & Balances from all your exchanges and wallets.
Need help? CoinTracking FAQ
Plick9
Newbie
*
Offline Offline

Activity: 3
Merit: 0


View Profile
May 13, 2017, 09:53:43 PM
 #283

Ok thanks! I hope i am able to afford it one day. Smiley

BTW I used transaction history to import from coinbase Report > New report

At the bottom of cointracking it says "use transaction history"

Hope that helped the guy asking about csv files not uploading.
sgjenks01
Member
**
Offline Offline

Activity: 91
Merit: 10


View Profile
May 13, 2017, 10:19:23 PM
 #284

Dario said: Are you sure, you have exported the "Buys, sells, and merchant payouts" file from Coinbase?

Actually, I had it set on "Transaction History" just like Plick9 said he did (but CoinTracking didn't import anything.

At your suggestion, I set the New Report to "Buys, sells, and merchant payouts" and THAT file comes out empty, so no import.  Angry

BTW, I opened the "transaction history" report using Notepad and there is definitely data in that file.

Here's what Cointracking says after importing the file with data in it.

Import Report:
Validation: Datasets in import file: 13, Trades: 0
Notes: Duplicate Trades found: 0
Errors: Empty Timestamps: 0, Empty values: 0

Your import data looks good.


Dario3000
Hero Member
*****
Offline Offline

Activity: 744
Merit: 512


CoinTracking - Crypto Portfolio & Tax Management


View Profile WWW
May 13, 2017, 11:50:52 PM
 #285

Hey,

I would recommend the "Buys, sells, and merchant payouts" export.
The "Transaction" file from Coinbase is kinda broken and far away from being a good readable csv file.

I'm surprised the "Buys, sells, and merchant payouts" file was empty.
Have you uploaded all of them with a proper time range?
You know, you have to export one file each Coinbase Account (USD, BTC, ETH, LTC...), since Coinbase is the only exchange out there not able to put all transactions into one file.

If you have exported only one account (like ETH) and you do not have any trades in ETH, the file will be empty.
Once you have imported them all, the data should be correct.

Best,
Dario

CoinTracking.info - Your Profit / Loss Portfolio Monitor and Tax Calculator for all Digital Currencies
Simply the best way to track your digital assets accurately. Get live data for more than 5000 coins, assets and commodities. Track Gains & Balances from all your exchanges and wallets.
Need help? CoinTracking FAQ
sgjenks01
Member
**
Offline Offline

Activity: 91
Merit: 10


View Profile
May 14, 2017, 01:57:30 AM
 #286

Dario said: I'm surprised the "Buys, sells, and merchant payouts" file was empty.

Dario,
Everything I've reported was due to carelessness/inattentiveness on my part. The BTC file I got was empty because I had exported the Coinbase Vault info. I have never used the vault, so of course the transactions were empty!

I went back and very carefully exported everything per your instructions: "Buys, sells, and merchant payouts" for all time, for each wallet individually. Then I made a new error: When I was importing the LTC trades, I selected LTC in the drop down, but apparently failed to hit "Save". Of course, it defaulted to BTC. The result was I had nearly hundred thousand dollars in BTC value, which was very far from the truth. Once I changed the BTC to LTC, everything fell into place.

I do have a couple more question: I have transferred coins from Coinbase to Bittrex. Whenever I do that, there is a network fee, but I don't think that gets captured anywhere, or does it?

The same is true for my hardware wallet, there is a network fee whenever coins are transferred to and from the hardware wallet. Are those fees captured anywhere?

Thanks for a great tool!

Steve

 
Dario3000
Hero Member
*****
Offline Offline

Activity: 744
Merit: 512


CoinTracking - Crypto Portfolio & Tax Management


View Profile WWW
May 14, 2017, 02:54:10 AM
 #287

If deposits and withdrawals are listed in the CSV file, they will be added into CT, including all fees.
If not, you will have to enter them manually.

Wallet imports will import all values with the sent or received amount.
When you send 1 BTC to your wallet and you pay a network fee of 0.001 BTC, the imported amount will be 0.999 BTC.

Dario

CoinTracking.info - Your Profit / Loss Portfolio Monitor and Tax Calculator for all Digital Currencies
Simply the best way to track your digital assets accurately. Get live data for more than 5000 coins, assets and commodities. Track Gains & Balances from all your exchanges and wallets.
Need help? CoinTracking FAQ
sgjenks01
Member
**
Offline Offline

Activity: 91
Merit: 10


View Profile
May 14, 2017, 04:12:06 AM
 #288


Dario,
I put in all the deposits manually, so the USD amount is correct (instead of negative). However, I don't see any transfer transactions on moves from wallet to wallet in the CSV files. Is that something that can be exported from Coinbase and/or Bittrex? If so, how?

Also, the hardware wallet I'm using is a Ledger Nano S. It doesn't appear to provide the ability to export/download transactions at all. Are you aware of any such capability?

Thanks, and sorry to be such a bother.

Steve
Arkaen
Newbie
*
Offline Offline

Activity: 29
Merit: 0


View Profile
May 14, 2017, 10:53:45 AM
 #289

Hey Arkaen and thanks a lot.

1) I have added "cryptocurrency" into the Google Trend Chart

2) Yeah, I know. I have tried to add %-changes into the summary box but it was to much information.
What do you think of this?
https://cointracking.info/dashboard-test.php (just a test version)

Best regards,
Dario

Awesome! It's great how responsive you are to feedback, Dario. The big chart in the previous version had a nice look and feel. But, since it doesn't fit, I think this layout makes more sense for presenting the key information. I know how tricky it can be to fit things (used to work as a UI designer).

With the "Hide all coins if less or equal" filter added, this would be excellent.

I also like how you've removed the "quick links" at the top. Cleans up the interface and doesn't hurt usability (at least, to me).

Question: The last few days, the page https://cointracking.info/gains.php is giving me the following error: "DataTables warning: table id=trade_table_sell - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1"

It happens on all browsers I've tried. Are other people having this issue, or is it likely something caused by my trade data the last few days?

Big thanks!

Tim
Dario3000
Hero Member
*****
Offline Offline

Activity: 744
Merit: 512


CoinTracking - Crypto Portfolio & Tax Management


View Profile WWW
May 14, 2017, 12:45:50 PM
 #290

@Steve,
For Coinbase and Bittrex they are unfortunately not listed in the CSV file.
But the Bittrex API import can read out deposits and withdrawals.

If you know the BTC Address or Extended Public Key, Ledger Nano created for you, you can import the transactions using the "Bitcoin Wallet Import".


@Tim,
Thanks a lot. I will try to included those features.

Sees like there are not allowed characters in some of your entries.
Could be a comment or a trade-id.
I have done some fixes. Can you please check again.
If it's still not working, can you please send me your CT username as PM and I will fix it asap.

Thanks a lot,
Dario

CoinTracking.info - Your Profit / Loss Portfolio Monitor and Tax Calculator for all Digital Currencies
Simply the best way to track your digital assets accurately. Get live data for more than 5000 coins, assets and commodities. Track Gains & Balances from all your exchanges and wallets.
Need help? CoinTracking FAQ
Arkaen
Newbie
*
Offline Offline

Activity: 29
Merit: 0


View Profile
May 14, 2017, 01:06:54 PM
 #291

@Tim,
Thanks a lot. I will try to included those features.

Sees like there are not allowed characters in some of your entries.
Could be a comment or a trade-id.
I have done some fixes. Can you please check again.
If it's still not working, can you please send me your CT username as PM and I will fix it asap.

Thanks a lot,
Dario


Thanks for the fast reply, Dario. It was caused by the ~ symbol I used in a trade description. All working now.

Just a thought on the new dashboard layout you proposed: Decreasing the height of the total value chart, e.g., giving it a 3:2 aspect ratio rather than 1:1, might help the visualization in the long run. With a few years worth of data, the time compression and amplitude scaling of a 1:1 chart may look odd given how steeply these markets can climb and fall. This would also mean more of the chart is visible without scrolling, for people with smaller screens.

Your discretion, of course. Right now my data looks fine, whether it's 1:1 or 3:2.
Dario3000
Hero Member
*****
Offline Offline

Activity: 744
Merit: 512


CoinTracking - Crypto Portfolio & Tax Management


View Profile WWW
May 14, 2017, 01:12:12 PM
 #292

giving it a 3:2 aspect ratio rather than 1:1, might help the visualization in the long run.
Done Smiley

CoinTracking.info - Your Profit / Loss Portfolio Monitor and Tax Calculator for all Digital Currencies
Simply the best way to track your digital assets accurately. Get live data for more than 5000 coins, assets and commodities. Track Gains & Balances from all your exchanges and wallets.
Need help? CoinTracking FAQ
Arkaen
Newbie
*
Offline Offline

Activity: 29
Merit: 0


View Profile
May 14, 2017, 01:26:59 PM
 #293

giving it a 3:2 aspect ratio rather than 1:1, might help the visualization in the long run.
Done Smiley

Nice! I like it.
sgjenks01
Member
**
Offline Offline

Activity: 91
Merit: 10


View Profile
May 14, 2017, 09:47:25 PM
 #294

Dario said:

Re transfers between exchanges and wallets:
For Coinbase and Bittrex they are unfortunately not listed in the CSV file.
But the Bittrex API import can read out deposits and withdrawals.

If you know the BTC Address or Extended Public Key, Ledger Nano created for you, you can import the transactions using the "Bitcoin Wallet Import".

I used the Bittrex API import and it added some lines of transactions, so I think we're good with Bittrex.

However, when I tried to do the "Bitcoin Wallet Import", using the Extended Public Key from the Ledger Nano S, nothing happened (0 imports reported). I also used the "receive" Bitcoin address from the Ledger Nano S and also got zero imports.

Any ideas?

Steve
Dario3000
Hero Member
*****
Offline Offline

Activity: 744
Merit: 512


CoinTracking - Crypto Portfolio & Tax Management


View Profile WWW
May 14, 2017, 10:33:36 PM
 #295

I used the Bittrex API import and it added some lines of transactions, so I think we're good with Bittrex.

However, when I tried to do the "Bitcoin Wallet Import", using the Extended Public Key from the Ledger Nano S, nothing happened (0 imports reported). I also used the "receive" Bitcoin address from the Ledger Nano S and also got zero imports.

Any ideas?

Steve


Hey Steve,
The Extended Public Key can only import new transactions.
This means, all tx from now on will be imported, but not the past tx.

However the transaction import will handle ALL transactions.
Are you sure your "receive" address was correct?
You can check your address for example here: blockchain.info/de/address/YOUR-ADDRESS
All transactions shown there will be imported by CoinTracking.

Best,
Dario

CoinTracking.info - Your Profit / Loss Portfolio Monitor and Tax Calculator for all Digital Currencies
Simply the best way to track your digital assets accurately. Get live data for more than 5000 coins, assets and commodities. Track Gains & Balances from all your exchanges and wallets.
Need help? CoinTracking FAQ
sgjenks01
Member
**
Offline Offline

Activity: 91
Merit: 10


View Profile
May 14, 2017, 11:20:41 PM
 #296

Dario,
I checked the "receive" address on a checker I found using Google ( https://thomas.vanhoutte.be/tools/validate-bitcoin-address.php ). It said it's a valid address, but when I asked to show transactions for this address on the blockchain, nothing showed up. I don't know which address CoinTracking used, but it picked up my purchase of CoinTracking Pro from the Ledger Nano S wallet. This is the Bitcoin Receive Address for the wallet: 12wiP3bVZ59aBzr1P9tW3c4FErNnwiyh7x

It makes no sense that there are no transactions showing on the blockchain for that address. It's the address I gave to Coinbase and Bittrex to put the BTC in the wallet in the first place.

The result of all this is that CoinTracking shows that my wallet has a negative balance. It also shows that I have BTC and LTC at Coinbase when all my balances at Coinbase are zero because I transferred those balances to either Bittrex or the Ledger Nano S wallet. All the Bittrex balances shown in CoinTracking are correct. It's the wallet and Coinbase balances that are wrong for both BTC and LTC.

Nobody told us that we would have to become our own bankers and accountants in this brave new world of cryptocurrencies.  Undecided

Thanks,

Steve

Dario3000
Hero Member
*****
Offline Offline

Activity: 744
Merit: 512


CoinTracking - Crypto Portfolio & Tax Management


View Profile WWW
May 15, 2017, 12:32:52 AM
 #297

Hey,
I've never used a Ledger Nano wallet, so I'm not sure how they generate them.
Maybe it's just a forwarding address or a unused one?

It could be easier for you to just enter your Coinbase withdrawals and your wallet deposits manually Smiley

CoinTracking.info - Your Profit / Loss Portfolio Monitor and Tax Calculator for all Digital Currencies
Simply the best way to track your digital assets accurately. Get live data for more than 5000 coins, assets and commodities. Track Gains & Balances from all your exchanges and wallets.
Need help? CoinTracking FAQ
sgjenks01
Member
**
Offline Offline

Activity: 91
Merit: 10


View Profile
May 15, 2017, 08:04:39 PM
 #298

Hey,
I've never used a Ledger Nano wallet, so I'm not sure how they generate them.
Maybe it's just a forwarding address or a unused one?

It could be easier for you to just enter your Coinbase withdrawals and your wallet deposits manually Smiley

Dario,
Great minds think alike. I had already started putting them in by the time you wrote this.  Cheesy

I'm just glad I found this great tool before I had hundreds of transactions. Even if I always have to put in the transactions to and from the wallet, this is just so much better than trying to keep things on a spreadsheet! And you guys just keep improving it, which is just awesome.

Thank you for your support and for such a great tool.

Steve

Dario3000
Hero Member
*****
Offline Offline

Activity: 744
Merit: 512


CoinTracking - Crypto Portfolio & Tax Management


View Profile WWW
May 15, 2017, 08:14:00 PM
 #299

Dario,
Great minds think alike. I had already started putting them in by the time you wrote this.  Cheesy

I'm just glad I found this great tool before I had hundreds of transactions. Even if I always have to put in the transactions to and from the wallet, this is just so much better than trying to keep things on a spreadsheet! And you guys just keep improving it, which is just awesome.

Thank you for your support and for such a great tool.

Steve

Thanks a lot Steve,
Really appreciate it.

BTW:
I have created today a new wallet import for over 200 different currencies (LTC, DASH, ...).
I'm finalizing it right now and will publish it tomorrow.
I guess that's a big help for all the miners out there Smiley

Dario

CoinTracking.info - Your Profit / Loss Portfolio Monitor and Tax Calculator for all Digital Currencies
Simply the best way to track your digital assets accurately. Get live data for more than 5000 coins, assets and commodities. Track Gains & Balances from all your exchanges and wallets.
Need help? CoinTracking FAQ
sgjenks01
Member
**
Offline Offline

Activity: 91
Merit: 10


View Profile
May 16, 2017, 02:47:46 AM
 #300

Dario,
Especially if the wallet plays nicely with CoinTracking!

By the way, do you know of any exchanges where it's possible to trade "cross pairs". In other words, trade LTC for XRP for example. At Bittrix, it appears that I have to trade the LTC for BTC and then buy the XRP with the BTC, which makes for 2 trades instead of one.  Undecided

Thanks,

Steve
Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 [15] 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 ... 74 »
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!