To calculate the percentage gain or loss on your account balance, you would need to know the initial and final values of your trade. Here's how you can do it:
- Calculate the difference between the final value and the initial value of your trade. In your case, the difference is 0.6100 - 0.6000 = 0.0100.
- Calculate the gain or loss by multiplying this difference with your account balance and the number of units traded. If you traded 1 unit, the gain would be 0.0100 * $2000 = $20.
- Calculate the percentage gain or loss by dividing the gain or loss by the initial account balance and multiplying by 100. The percentage gain would be ($20 / $2000) * 100 = 1%.
Here's how you can do this in Google Sheets:

A       B       C       D       E       F
1   Initial   Final   Difference   Balance   Gain    Percentage Gain
2   0.6000    0.6100  =B2-A2       $2000     =C2*D2  =(E2/D2)*100

In this table:
- Column A is the initial value of the trade.
- Column B is the final value of the trade.
- Column C calculates the difference between the final and initial values.
- Column D is your account balance.
- Column E calculates the gain by multiplying the difference with the balance.
- Column F calculates the percentage gain by dividing the gain by the balance and multiplying by 100.
I hope this helps!