Pages:
Author

Topic: Calculating Profit or Loss - page 2. (Read 267 times)

legendary
Activity: 1414
Merit: 1118
...gambling responsibly. Do not be addicted.
December 19, 2023, 06:37:10 PM
#2
Final price divided by the initial price.
0.6 1÷ 0.6 = 1.0167

(Final price divided by initial price) multiply by your trading money.
1.0167 * 2000 = 2033

You trade with $2000
You make $2033
You earn $33

$33 of $2000 makes it $33 of 100% ($2000) money used to trade.

33 = x
2000 = 100

Cross multiply

X * 2000 = 33 * 100

X = 33 * 100 ÷ 2000

X = 1.65%

Which means $33 that you gained is 1.65% of $2000 that you used to trade.

I do not know if this can have a single formula that can be used.
jr. member
Activity: 35
Merit: 13
December 19, 2023, 06:23:43 PM
#1
I'm trying to create a Google Sheets tracker or my Crypto trades.

How would I calculate a percentage gain or loss on my account balance?

Let's say I have $2000 in my trading account, and I place a trade that goes from 0.6000 to 0.6100 (100 ticks).

How would I calculate that as a percentage gain and a monetary gain on my account?

Appreciate the help,

JH
Pages:
Jump to: