>Spend all day making this neat transactions / portfolio spreadsheet

File: excel.png (87KB, 1477x779px) Image search: [Google]

87KB, 1477x779px

Why reinvent the wheel?

>>3360524
to make a faster one

>>3360524
Wow, nice.

I guess mine is just more tailed to me and my simple portfolio I suppose.

If you send it here and I like it I'll give you 0.03 eth for it.

>>3360695
Hope you like it.

https://mega.nz/#!3cNU2RxZ!pLjK7619NT3MuEbp4_q_yBBPjR1ptEymN8nuN5oyT5Y

ETH: 0xab907b05Eaf8fBFdc2CeA6e2e2Fd57ddBE08F71f

does anyone have anything that accounts for the transfer of coins from exchanges to wallets?

This bookeeping has been a huge pain in my ass for me, because these services can't tell the difference between a withdraw and a sale.

If you guys have something please let me know. Right now I have over 400 trades to account for and losing my fucking mind.

I'm at a point where I think i may need to be a hermit for a weekend and spreadsheet everything one at a time linking their USD values at the time of trade...holy fuck i'm fucked.

>>3360397

I feel bad, I am up 20x from March, just under $80k, yet I don't even track my shit, just get blazed and pool into the latest shit coins for mad gaiinzz

>>3360397
how do you account for time of trade and value at the time of trade? this is the big issue I am having right now.

File: Floor.png (106KB, 256x256px) Image search: [Google]

106KB, 256x256px

>>3360896
mmyyyy boi

Also, if anyone knows visual basic pretty good could you help me to fix the code that pulls info from CoinMarketCap? I can pull numbers, but I can't pull strings like the symbol for currencies.

>>3360910
I put a column under transactions for the exchange rate you traded for, if that's what you mean. Just plug that in and amount you received, and it'll do some calculations on how much you paid.

>>3360837
>0xab907b05Eaf8fBFdc2CeA6e2e2Fd57ddBE08F71f
So to be honest I'm too much of a tinfoil hat man to actually open the spreadsheet. But I sent you 0.01 ETH anyway.

>>3360895
bitcoin.tax is good for bookkeeping. I pay for premium so my taxes are handled. You'll have to manually enter withdrawals though as a "fee" transaction

>>3360944
Wow, man. Thanks, I appreciate it.

The spreadsheet only runs a visual basic module that creates a function called cryptocurrency() that you can use in formulas to pull data from the CoinMarketCap API.

Any good desktop versions of blockfolio wherein I can have one coin but many transactions associated with it?

Currently using cryptocompare but it pisses me off because I have to add a whole new position even if it's the same coin.

I've got a page of OMG buys. I want just one OMG listing but it compiles all my orders into an overall position.

Thanks lads

>>3360397

I use google sheets and a custom IMPORTJSON script you can download and implement here:

https://gist.github.com/chrislkeller/5719258

Must more accurate/faster than coinmarketcap data since you can pull from the particular exchanges you actually give a shit about

>>3360946
I use bitcoin.tax, but I'm not sure how it's calculating everything on its back end.

I tried cointracking, but they want .44BTC for unlimited trades (holy fuck they're out of their fucking minds). But What I like about them is they actually have a place for deposits and withdrawls so you can balance your sheets. This way you can tell that a transfer to a wallet is NOT a sale.

>>3361062
Oh, that's pretty neat. I usually just use CoinMarketCap for checking stuff out since I don't do too much trading yet. Plus, I wanted something offline since google docs slows down my lil' Lenovo Thinkpad.

>>3360928
Here is the VB code: https://pastebin.com/raw/4NR4vWss

If anyone is a visual basic pro, I'd appreciate any help to get it to pull data as strings or as double if it's numerical.

Im working on a coin tracking app let me ask you fags some questions

1) desktop / mobile clients or website?
2) security concerns?
3) wanted features?
4) least liked things about your current tracker?

Do I have to pay a tax on every sale or only when I cash out of crypto?

>>3361272
>>3361321

What?

File: vb.jpg (27KB, 458x292px) Image search: [Google]

27KB, 458x292px

>>3360397
i love how you guys are bringing VB back... not really.

https://youtu.be/hkDD03yeLnU

>>3361321
supposedly, every trade you do for bitcoin is a taxable event. Crazy right?!

Since the IRS considers bitcoin as property, and it left your possession for another form of property, you then need to report how much at BTC was worth when you received it, and how much it was worth when you traded it. The difference is your capital gains.

Bitcoin is going to get taxed to death. I am in the same boat and trying relentlessly to track these trades and their valuations at the time of trade, while also accounting for transffers and fees from exchanges to wallets. HOLY FUCK THIS GOD DAMN KIKERY!!!!!!!!!!!!!

File: Clipboard01.jpg (69KB, 1287x110px) Image search: [Google]

69KB, 1287x110px

>>3361383
So I guess it's good that I'm keeping track of all that in my spreadsheet? I just wish Blockfolio took int account fees and such. That's one reason why I made this.

>>3361321
Every time you cash from X to BTC. So if you buy 50 USD of 1 BTC, then trade that BTC to ETH, then ETH goes up to a rate of 2 BTC, then you trade back to BTC, even if you don't cash it out to USD, you need to report the 1 BTC gain.

If you keep the gain in ETH, then you won't be taxed on it while it continues to make gains.

Now, what is not 100% clear is whether or not this applies to every other coin, or just BTC, so if I were you I would keep a looong list of all the trades you've done since this year's tax season just to be safe.

Remember: the tax man won't punish you for paying more taxes.

>>3361383
just dont pay your taxes then. cash out through localbitcoins. free 10% on top of your gains.

>>3360524
sauce

Also does this pull historical price data?

>>3361447
Yeah, don't do this btw >>3361478
The tax man always gets his cut, one way or another

File: marie_alofatela.jpg (125KB, 577x1024px) Image search: [Google]

125KB, 577x1024px

>>3360944
sending $3 out of nowhere. Who are you, Bill Gates?

0x25e36eff1a2136110fee53c81a187a48e765e507 beermoney for this saturday maybe?

>>3361478
lets be realistic here, I would like to be free from debt and live on a mortgage free property.

I would end up living like a "rich" nigger looking for small cash transactions.

>>3361469
ALL cryptos are considered the same class as BTC...which leaves another questions:

Can you claim "like-kind exchange 1031" and deffer the capital gains until you actually cash out?

>not just using cryptop

>>3361506
Any changes/additions you recommend to my spreadsheet to stay on top of things?

At the moment I've just reported cashing out for tax purposes... if I have to report every trade then I'm literally fucked.

File: gainloss.png (18KB, 2059x173px) Image search: [Google]

18KB, 2059x173px

>>3361727
I have a chart similar to yours except mine tracks gain rate as well entry exit dates. I would add a column so that you can see how much you are losing/gaining on your investments. I also have a coin chart that shows me my holdings at a glance, and I go to another chart to add the transactions to stay efficient, I have a column that holds the current rate for the coin at that time and I just update that whenever I feel like seeing different colors