[Boards: 3 / a / aco / adv / an / asp / b / bant / biz / c / can / cgl / ck / cm / co / cock / d / diy / e / fa / fap / fit / fitlit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mlpol / mo / mtv / mu / n / news / o / out / outsoc / p / po / pol / qa / qst / r / r9k / s / s4s / sci / soc / sp / spa / t / tg / toy / trash / trv / tv / u / v / vg / vint / vip / vp / vr / w / wg / wsg / wsr / x / y ] [Search | Free Show | Home]

I've started using excel to keep track of profits and losses.

This is a blue board which means that it's for everybody (Safe For Work content only). If you see any adult content, please report it.

Thread replies: 9
Thread images: 2

File: images.jpg (7KB, 225x225px) Image search: [Google]
images.jpg
7KB, 225x225px
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.
>>
File: 1474777733213.png (108KB, 357x368px) Image search: [Google]
1474777733213.png
108KB, 357x368px
>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?
Thread posts: 9
Thread images: 2


[Boards: 3 / a / aco / adv / an / asp / b / bant / biz / c / can / cgl / ck / cm / co / cock / d / diy / e / fa / fap / fit / fitlit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mlpol / mo / mtv / mu / n / news / o / out / outsoc / p / po / pol / qa / qst / r / r9k / s / s4s / sci / soc / sp / spa / t / tg / toy / trash / trv / tv / u / v / vg / vint / vip / vp / vr / w / wg / wsg / wsr / x / y] [Search | Top | Home]

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible.
Read more on this topic here - https://archived.moe/talk/thread/1694/


If you need a post removed click on it's [Report] button and follow the instruction.
DMCA Content Takedown via dmca.com
All images are hosted on imgur.com.
If you like this website please support us by donating with Bitcoins at 16mKtbZiwW52BLkibtCr8jUg2KVUMTxVQ5
All trademarks and copyrights on this page are owned by their respective parties.
Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.
This is a 4chan archive - all of the content originated from that site.
This means that RandomArchive shows their content, archived.
If you need information for a Poster - contact them.