Bitcoin Forum
May 26, 2024, 10:49:36 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
  Home Help Search Login Register More  
  Show Posts
Pages: [1]
1  Alternate cryptocurrencies / Service Announcements (Altcoins) / Re: CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies on: March 25, 2017, 03:26:55 PM
> I will use your CSV import idea as that makes sense.    Thank you!

Dario - I figured it all out eventually.  I knew that I had either made too many manual transactions in USD with Coinbase for USD Wallet stuff, and didn't trace down the withdrawals and where they went to, and the corresponding deposits in those other places.

How I fixed it:  What I did was make a backup and a full CSV export (just in case), deleted all trade data, then went exchange by exchange and did the automated imports if it allowed, then checked the deposits and withdrawals at each exchange since they typically don't get imported with the bulk imports.  This is where I had issues before, because not only did I not put in there things like purchases (my cointracking upgrade was one of them!) and marking my hashnest mining purchase as an import over at hashnest account, but I had several bitcoin transfers from my main wallet to other exchanges not input or reflected at all.

Now the BTC balance in cointracking.info is exactly what I added up manually at the 7 different exchanges.  All the other currencies (~30 of them) look correct as well.

--

Then for the mining, what I did was export all the transactions to a local file, then I split it into three different files - one with just mining earnings, one with just mining fees, and one with just mining trades/deposits.  I had to manipulate the data by removing the "no" and "balance" columns and I added a currency column (BTC).  One neat feature would be to be able to override some things like Currency in case the import file doesn't have it.  For example, we can set an exchange over on the right side of the "Custom Exchange Import" page.  

I also tried to research the hashnest wallet thing since the address I can deposit to at hashnest only had the two transactions (my .75 btc deposit in and a btc withdrawal to somewhere).  I realized I could check the destination address and see what that had in it, but it only had a couple transactions that might have some fee, and then I saw where THAT went, and then it went to an address with way too many transactions that would match my account (ie, there were transactions from January but I started in March), so they must be obscuring it somewhere.

I'll let you know if Hashnest supports a better export, or I can send you what the file looks like and maybe you can more easily parse the mining earnings, fees and deposits.  It would even be neat if cointracking.info supported GHS as a currency (ie, they call it ANTS9 and ANTS7 for two of their current "currencies").  In the report, they show a "trade" of (x) BTC for (y) ANTS9.  It actually exports in XLS but has chinese characters in the workbook name and doesn't import well in your generic parser.

Here's a sample:

No.   Date   Amount   Balance   Type   Comment
1   3/24/2017 20:39   -0.00138888   0.96746603BTC   Trade   Sale taker fee AntS9 amount 7716.0 at price 0.00012
2   3/24/2017 20:39   0.92592   0.96885491BTC   Trade   Sale AntS9 amount 7716.0 at price 0.00012
3   3/24/2017 20:39   -7716   0.0ANTS9   Trade   Sale AntS9 at price 0.00012

Last note - since Coinbase Exchange changed to GDAX, maybe that importer should be renamed as well.  The help file should at least be updated.

thanx again - wonderful tool and I'm glad for it being very flexible for all the complicated things I'm wanting to do.

2  Alternate cryptocurrencies / Service Announcements (Altcoins) / Re: CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies on: March 24, 2017, 09:25:52 PM
You wrote:
> But they must send those BTC to your address. Right?
> Maybe hashnet is not displaying the BTC address inside their app, but once they are sent to your wallet, you have the address.

I don't know all the details, as their FAQ doesn't explain this, but what I see is I have a wallet there, and I can get a btc address to deposit.  I did so, and it showed up.  I then bought some things internal to hashnet (they have a market place where you can buy hashing power at (x) btc per GHS).  That purchase came out of the same wallet address.  When I imported this wallet address into cointracking, or looked at blockchain, there are only those two transactions, and they're for identical amounts.    So, no, they're not sending earnings or taking fees from my address.

None of the mining earnings or maintenance fees are touching that wallet.  However, hashnest's website tells me there's (x) amount available to me for withdrawal, and I can send money there.  But they must be tracking earnings and fees separately or internally.  I can just get the XLSX spreadsheet, which I need to modify some to get it to import.  

I will use your CSV import idea as that makes sense.    Thank you!

(side note) Interestingly, I had put in a sell order a few days ago for my GHS at a certain rate and it sold just after I posted my mining question to you.  So not only have I mined some bitcoin through cloud mining... about $30 USD in 2 wks.. but I also made some money selling the GHS back to the market.  The fee is low (0.15%) so it was definitely worth playing with cloud mining in my case.  In my personal case, for those interested, I had deposited .75 bitcoin, purchased 7716 GHS for .749xxxx BTC, mined for a while, then sold my GHS and my total withdrawal is .967xxxx BTC.  After taking into account the BTCUSD value at time of purchase and sale [where btc has declined quite a bit], I still netted $45 USD after fees.  I think I'll try it again when my own Antminer S9 comes in.
3  Alternate cryptocurrencies / Service Announcements (Altcoins) / Re: CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies on: March 24, 2017, 08:30:04 PM
Gotta say, Dario... what a great site! I quickly decided to go pro even though I'm not to the 200 trades yet, as I'm very appreciative of this wonderful tool.

I've been playing with manual import, import from various exchanges, and the bulk import.  I'm doing pretty well with the 28 different altcoins with 7 different exchanges, and I love the graphs.  I think I messed up with how deposits are tracked (coinbase specifically, and trying to track USD wallet there differently than using an external bank account for purchases) but I think I'm good on that.

Two remaining questions:

Q1: Mining. (cloud mining - are these deposits/withdrawals?)
I just started playing with mining, and I'm using hashnest.  I bought some GHS on the market and it regularly deposits BTC into what looks to be a private wallet (they don't display the address) and they withdraw the fees.  I can export the transactions, which comes in an xlsx file with a chinese workbook name, so I can't import. So I convert to CSV and I'm good.

This is what it looks like
No.   Date   Amount   Balance   Type   Comment
1   2017-03-14 23:05:32   -0.00013285   0.01444857BTC   Mining   Maintain Fee 457266:AntminerS9:Duration Time 2 h 42 m 35 s
2   2017-03-14 23:05:31   0.00016203   0.01458142BTC   Mining   Earnings 457266:AntminerS9:Duration Time 2 h 42 m 35 s

I figure I can remove "No." and "Balance" because that doesn't matter to the import. 

When I drag and drop the CSV into custom exchange import, it sees all the data.  But I don't know if:
  • I should make two separate CSV files, one with all the fees and one with all the earnings, and import them separately
  • or if it will automatically understand positive is earnings and negative is fee
  • if I do make two separate CSV files, do I do the override to say "this is deposit/withdrawal"
  • or if this is even supposed to be deposit/withdrawal

So, what's the best practice for tracking cloud mining?

Q2: How best to try and track down discrepancies, like with BTC?

I'm noticing that what cointracker thinks is my bitcoin balance and what I've verified it to be is off.  As an example, let's say cointracker says my btc balance is 2.15 but when I go check all of my exchanges manually, I only count 1.9.  There's a delta there.

First thing I did was double check all my imported and manually entered transactions for typos.  I didn't find any, so I checked again.  Maybe there's a fee, transfer or something else that I'm missing.  I went to the trade list and put in "BTC" and the exchange name so I could just see all the transactions there, and then I would go to the exchange and do the same thing.  Didn't find anything.  I also checked the daily balance report (great report) to see if there were any issues there.

What would you recommend as to help try to track down discrepancies?   Maybe another report or comparison I should try?
Pages: [1]
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!