Bitcoin Forum

Economy => Trading Discussion => Topic started by: user11001 on June 04, 2017, 12:54:28 PM



Title: How to calculate relative profit based on previous trades ?
Post by: user11001 on June 04, 2017, 12:54:28 PM
OK, so I want to make a little profit calculator for myself based on my trade history from Poloniex.
Here's a purely fictional and simplified example:

Quote
BUY  10 ETC for 0.01 BTC (0.0010 BTC / ETC)
BUY  50 ETC for 0.04 BTC (0.0008 BTC / ETC)
SELL 50 ETC for 0.05 BTC (0.0010 BTC / ETC)
BUY  10 ETC for 0.03 BTC (0.0015 BTC / ETC)
SELL 15 ETC for 0.02 BTC (0.0020 BTC / ETC)

Current ETC price: 0.0022 BTC

In this example, I still have 5 ETC, which at the current rate is worth 0.011 BTC

But here's what I'm struggling with:

What is the percentage change of my current balance (5 ETC), relative to my previous transactions ?

Remember, I bought and sold at different rates!
I would like the percentage change to reflect a positive number, because overall, I still gained a profit of the ETC that I kept, even though I also sold most of it with a profit already.

Could someone please explain the steps on how I can calculate this? It would help a lot!


Title: Re: How to calculate relative profit based on previous trades ?
Post by: 2bfree on June 04, 2017, 03:23:47 PM
When you buy and sell on the exchange there are total BTC 2 times one of them is slightly smaller for the small commission amount so use that total to subract when you sell then you will know true profit.


Title: Re: How to calculate relative profit based on previous trades ?
Post by: user11001 on June 04, 2017, 06:37:22 PM
Thanks @2bfree for your input. I am aware that exchange fees still need to be accounted for. However, right now I am trying to find the relative percentage change of my last balance, accounting for all the previous transactions. I don't know what formula exactly I should be using for this.