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

Okay, I've been using the copy import for a little while now and thats been going okay but here's a major bug I've been running into:
LTC/USD    buy    0.1 LTC    10.35 USD    1.035 USD    10.04.14 08:54
LTC/USD    buy    0.1 LTC    10.35 USD    1.035 USD    10.04.14 08:54
LTC/USD    buy    14.4 LTC    10.35 USD    149.04 USD    10.04.14 08:54
LTC/USD    buy    0.1 LTC    10.35 USD    1.035 USD    10.04.14 08:54
LTC/USD    buy    0.1 LTC    10.35 USD    1.035 USD    10.04.14 08:54
LTC/USD    buy    0.1 LTC    10.35 USD    1.035 USD    10.04.14 08:54
LTC/USD    buy    0.1 LTC    10.35 USD    1.035 USD    10.04.14 08:54
LTC/USD    buy    0.1 LTC    10.35 USD    1.035 USD    10.04.14 08:54
LTC/USD    buy    0.1 LTC    10.35 USD    1.035 USD    10.04.14 08:53

putting aside the 14.4, guess how much LTC i've bought according to the portfolio? 0.2 LTC. I get that detecting duplicate trades seems like a good idea at first for people that don't know how to copy paste but it's a major inconvenience when you are copying a few pages of trades to have to either copy them into excel first to combine them all into a single trade, import pages unchanged and try to catch and fix them, change values so that it's like:
LTC/USD    buy    0.1 LTC    10.35 USD    1.034 USD    10.04.14 08:54
LTC/USD    buy    0.1 LTC    10.35 USD    1.035 USD    10.04.14 08:54
LTC/USD    buy    0.1 LTC    10.35 USD    1.036 USD    10.04.14 08:54
which is also a pain. At some point I remember thinking "well I'll just use the 'test import' button to see where the dupes are then fix it." Big mistake, since test import doesn't detect dupes. Recently I copied in about 8-10 pages of trades throughout 2 days that I thought I fixed the dupes on and only noticed after that something got messed up. My option is to delete everything and start over, try to find the mess-up by comparing trade history side-by-side, or to spend an hour or two deleting every trade after a specific date and time (I say hours because there is no way to delete more than one trade or less than all of them at a time, you have to click delete. popup confirm. page load. scroll. why not some simple checkbox by each trade and then a delete button? it could still popup a list of each selected one to confirm)
And it's not like I can say "well I just won't buy/sell the same amount/price at the same time" If a user puts in 50 sells for 0.1 at 10.35USD thats how it gets filled when I enter 'buy 5 LTC at 10.35"
I hope I've made the case that this feature is clearly a bug. I can't see many users being helped by this and can imagine users constantly having their trade history distorted by it,  so can we get a simple disable option for dummy duplicate warnings, or rather make it so that its just a warning and not a forced purge?

Thanks for reading and your anticipated response,
tuna

Hey,
yeah I still hope, BTC-E will fix it in the next days.
I really hope it.

If not, I will have to make a workaround like a loop till all the imports are done.
Let's give them one week. If not I will take care of another solution.
But I prefer a clean solution over the BTC-E API.

Best wishes, Dario

LOL. good one, btc-e support doing anything ASAP is hilarious. I mean I hope so too, just don't have much faith in their support staff.
 Assuming there is no fix from them do you think it will be possible to tweak the way you query the API so that it only retrieves trades after X date? I'd kind of prefer this anyway even if btc-e fixed their end since I have not much use for trade data from 2012 and whatnot, I really just want to be able to "start" from the past couple months. If there was a way to do this then I'd feel alot better about getting a year of unlimited membership.

I still think the site is coming along very well and encourage you to keep up the good work, there is enough people trading cryptocoins that a site like this could be very valuable to you and the community.

Hey TwinWinNerD, thanks a lot


Hi tunafish, It's a problem we currently have with BTC-E. We have tried all possible things and increased all limits, but their API only imports a maximum of 2000 trades, what really sucks.
I have an open ticket at BTC-E (ticket no: #GCB-871-47852 - created: 29 March 2014 04:54 AM) and I hope they will solve it ASAP.
I think it's just a kind of restriction, that they need to disable for coinreporting.com
So I'm pretty sure, it will work in the next days.

BTW: I think this is the reason why some of your coins are negative, because it did not import all of your trades.
This should be fixed once all your trades are imported

I haven't used the service in a while but I logged in for the first time in a while and saw how much things had came along and decided to give it a go and upgraded to pro. I used the btc-e import tool to bring over my transactions but I have way more than 1700 (or whatever the limit is) so I decided to try for ultimate for a year. However when I imported my API data from btc-e there is always only 1880 transcations, the newest being 70+ days old, even though on the btc-e API page it says "last trade: today's date"
Also I have negative NVC, CNC, etc. and i'm not sure how.
If there was a way to either get all my transactions or set it so it only queries the past year of trading that would be great.
At any rate some help would be much appreciated.

Awesome website. As mentioned in the german thread i really like your "easy enter" feature. One of my topused bookmarks

Hey Dave,
currently there is no way in import this CSV format, but I am already on a solution to import these files and also import custom trades over excel.
I think I will finish it in April.

And then you will be able to insert every trade once so you can see an overview of every single trade.

Best wishes,
Dario

Thanks for this info.  That explains why my mining history hasn't shown up after entering the mining addresses.

Is there a way to import the mining data from the core bitcoin wallet software?  It has an export feature that creates a csv file that looks like this:

"Confirmed","Date","Type","Label","Address","Amount","ID"

Otherwise I'd have hundreds of entries to make by hand.

If I do succeed in getting the data into the system somehow, will it be able to automatically generate the cost basis for the mined coins, and use it to calculate the capital gains for the other transactions?

Hi Dave,
let me answer your questions

1) if you have more then one account and you upgrade to pro, of course all your accounts will get pro.
The same if you upgrade now to pro and you join more accounts in the future. All the accounts will get pro.

2) The BTC Wallet Job don't count every single "transaction". It checks your BTC balance every 10 minutes and will insert the difference into your account.
Lets say you have now 1 BTC in your wallet and in 10 minutes you have 1.5 BTC. So the system creates a trade into Coinreporting with 0.5 BTC.

3) The answer to the question "one or two accounts" depends on what's the best solution for you.
In my case, I have one account for long term tradings (will not be sold in the next years), one account for daily trades and one account for mining.
So I have all actions seperate.
If you have more than one account, you will get a TOTAL view, where you can see the value of all your accounts togehter.

But if you sell all your mined BTC in USD or EUR instantly, it could be easier to make both in one account.

I would suggest, you should try both versions and see what is the best solution for you.
so create two accounts (or even three) and just try it.
You can delete groups of trades any time (for example all BTC Wallet Job trades at once) and you can also unjoin your accounts anytime.

I hope this will help you. If not, please let me know

Best wishes and a nice weekend.
Dario

Also -- my goal would be to first calculate my mining income, and then secondly when a purchase/donation/trade for USD occurs to join that in a first-in/first-out way, to the basis for the mined coins.

For example, say I mine a certain amount of BTC over the course of a year, all at various dates and valued differently depending on bitcoin price on the day it was mined.

Then I have various bitpay transactions, bitcoin donations, and trades for USD that I want to deduct from the mined balance and have it calculate the capital gain using the various bitcoin values when the various coins were mined as the cost basis.

Would I want it all in one account, or two separate accounts to do that?

I'm trying this out in an attempt to keep track of income from mining.

I've put my incoming mining addresses into the "BTC Wallet Job for Miners and Donations" page and I noticed that it recommended creating a second account for trades.

What counts as a "trade"?  Is each mining transaction a separate trade?  Is a bitpay purchase or bitcoin donation a trade?

If I upgrade my first account to "pro" and then create a second account for trades and join it to the first one, does it get included as "pro" or does each account need to be upgraded separately?

Thanks.

sure, you can try this one:


Index: you can ignore this, because we don't track it
Date: must be in this format: yyyy-mm-dd hh:mm:ss
Type: in = buy | out = sell
Info: must be in this format: BTC bought: [tid:10003] X.XX BTC at $X.XX
   tid must be increasing or at least unique
   X.XX BTC is the BTC value but I think it can be ignored
   $X.XX is the USD value
Value: is the BTC value
Balance: Ignore it, because it is the GOX account value after this trade. Just write 0 or nothing

If you think this one is complicated... this is the easy one :-)
There is also an advanced import where you have to upload both CSV files.
Yeah... that is/was GOX :-)

Let me know if you have some problems

Best, Dario
   

Wow amazing service... if this is how most bitcoin services could be run we will be doing very well... thanks for helping me.

I wonder, could someone post an example of correctly formatted Gox export. I have data but I brought it into my main spreadsheet and something has changed preventing me from uploading in to coinreporting.

If I could see an original I can make my data fit this and hopefully I will succeed in uploading.

Thanks again!

Hey gibbtek,
thanks for your message.

So...
your support ticket is done. There was a copy&paste error in the key.

On our Todo list, there is a feature to import trades from an excel sheet or a CSV file.
So exactly what you need.
I hope, I can finish it in the next weeks.

In the meantime:
Our GOX CSV uploader is still working, so if you have your CSV (the BTC file is enough), you can import all your trades.

And we also got a manually multi import function, where you can import up to 100 trades at once.
It's the second link in the Enter Coins dropdown in the navigation and it is also working with altcoins like LTC.

But I will do my best to finish the excel import as soon as possible.
If there is anything else, just let me know.

Best wishes,
Dario

Hi,

Just signed up for Pro account!

I did have my trades loaded in from CSV, but after upgrading to pro, clearing my transactions and trying the API import I seem to be having some issues... (I've sent support ticket)

However I do have a feature request...

I would like to be able to enter my transactions in a faster way then through the form.. For example my problem is that I do have old Gox history in my spreadsheet, but some of the data is not correct (some characters have changed) but the important stuff is still there i.e date, values, amount. But I can't upload into your system because there's probably some formatting issues + I don't have both BTC and EUR csv files

But to enter this manually in fields like:

Buy Amount, Sell Amount, Data, Time

.. is going to take me a loooong time. Filling in the form is way too much work.

What I'd like to see is big fat text area where you have defined a format for trade data. So I can make my own CSV data and paste it in here then your system will parse this data and create trades in my account.

So I want to be able to paste something like this (these numbers are just made up)


The headers would be something like "Date, Amount, Price, Fee, Symbol, Exchange "

I hope you know what I mean. I could easily format the data I have in what ever format was defined by the textarea.

This way I can upload my data from any exchange (even dead ones!)

The reason for this is that I don't think I can or will ever be able to get the original Gox exports (we all know what happened) but I want to be able to see these trades in my portfolio and because I already have the data I want some way to get it in faster then typing them in one by one!

I also have account on another exchange but is not listed (for LTC) and again way too much work to add these with a form.

Thanks for your time and for making a nice service for this!

Thanks!
Ohh, you mean on the Balance page?
Yes, this should be "per 1 Coin" and not "pro". I will fix the wording asap.
It is the average price for 1 coin.
So if you bought 5 BTC for $100 each and 5 BTC for $200 each, you've got 10 BTC with a purchase value of $1500. The price per coin is $150.

Thanks for your note.
Best, Dario

- Monitoring of your coin value and calculation of your profit / loss
- View your coins in many charts, tables or as text
- Support of Bitcoins and 27 other alt-coins
- Calculation of the purchase value of your coins (for how much you need to sell in order to achieve as much profit)
- Manual entry of your coins
- Importing function for Mt.Gox, Bitstamp, Vircurex, BTC-E, bitcoin.de and more
- Mining and donation functions like automatic monitoring of your coins over the blockchain or APIs
- Multiple accounts to look at coins in different currencies or different exchanges separately
- Compare your purchase and sales prices
- E-mail reports and alerts if your coin value rises or falls
- Display your purchases and sales directly in the history chart to see if you have traded at or below the price
- Market trends and analysis for Bitcoin, and other digital currencies
- Export function in several templates including tax declaration
- and many more...

nice looking site!

Ohh... now I see.
I don't like the idea of automatically group all trades by day, because a lot of people like to see every single trade.
Also it's important for the tax to display every single buy and sell.

But I have changed the import function last week for Mt.GOX CSVs. Now the import is running as a background job and don't have a timeout.
I will do this also for the other CSV uploads.

The other way would be to split up your CSV files.
Once all your trades are included, you only need to enter the last trades and not all thounds.

best, Dario

it could be decided during import. say the file exceeds X megabyte, then the import function automatically consolidates all trades within one day into ONE BUY and ONE SELL trade.
this is called "netting".

I think your system is too slow to actually perform this function on 10thousands on already entered trades.