I've started using excel to keep track of profits and losses.
I bought twice now without selling, at slightly different prices. how would I go on about calculating profit taking into account the two different buy prices?
also will bittycoin ever go back to 1070?!
Profit = sum(sell_price * num_shares) - sum(buy_price * num_shares)
Pretty simple stuff mane
>>1800259
i like to calc the differences in separate columns first and calculate percentages then create various sums, but yeah that simple.
basically i go
name of asset; number of units; buy unit price; buy price; current unit price; current price; percent
>>1800164
you should really do elementary school arithmetic before trading
not even memeing this is for ur own good
>>1800630
Literally made this exact table chart yesterday for my investments... I also had the issue of buying at various different price ranges through XMR/BTC and therefore its hard to calculate the conversion of:
Firstly XMR to BTC on multiple purchases
Plus the conversion of BTC to USD on the varying purchases
Also I live in the UK, so then a conversion is made from USD to GBP for ease of viewing for myself
Eventually, I just estimated my capital investment from my bank outgoings compared to the XMR charts... still >200% profit over 5 months.
>tfw to intelligent to subtract too numbers
>>1800630
Also yes... Bitcoin will go back to, and push through 1070... But that doesn't mean it is the most promising investment in the cryptocurrency world and this moment in time
avg of the two prices lol
price 1 + price 2 = x
x / 2 = avg price
>>1800647
Its too intelligence btw?