Edit Your Comment
Help! Need an advise about calculating "equity"
Nov 09, 2010 at 22:12
Membre depuis Nov 05, 2010
posts 3
Hello,
I can`t figure out how to calculate my equity at the end of each day with the provided information from my statement. Basically i want to be able to make the same graphic(with both balance & equity line) here in the site, but in my worksheet. For example: i`ve opened position at 22:00 and closed it at 00:04 with loss . Should i consider the swap?. Which price(at what time,open or close price etc.) i should get as my mark for calculating what was my equity before the new day starts. Eventually to get the same results as they are here in the site( i hope they`re accurate). I know that the answer lays in my question, but what ever i make i can`t get the same results as here. Hope you can clear me out that confusion.
Thank you,
Regards
I can`t figure out how to calculate my equity at the end of each day with the provided information from my statement. Basically i want to be able to make the same graphic(with both balance & equity line) here in the site, but in my worksheet. For example: i`ve opened position at 22:00 and closed it at 00:04 with loss . Should i consider the swap?. Which price(at what time,open or close price etc.) i should get as my mark for calculating what was my equity before the new day starts. Eventually to get the same results as they are here in the site( i hope they`re accurate). I know that the answer lays in my question, but what ever i make i can`t get the same results as here. Hope you can clear me out that confusion.
Thank you,
Regards
Membre depuis Apr 11, 2010
posts 9
Nov 10, 2010 at 15:16
Membre depuis Nov 05, 2010
posts 3
Hello TraderHotch,
I know that equity is = balance + floating position. How to calculate that floating position (which price to be my mark). I just can`t get the same results as in myfxbook. Simply how "myfxbook" calculates the floating positions?
Thank you,
Regards
I know that equity is = balance + floating position. How to calculate that floating position (which price to be my mark). I just can`t get the same results as in myfxbook. Simply how "myfxbook" calculates the floating positions?
Thank you,
Regards
Membre depuis Apr 11, 2010
posts 9
Nov 10, 2010 at 15:25
Membre depuis Apr 11, 2010
posts 9
Well, the sum of the P/L of all your open trades is your floating profit.
To get individual profit you do size/pip*pips from open.
Your broker probably does this.
If you show us what your open positions are and what myfxbook is quoting it can probably be sorted out.
To get individual profit you do size/pip*pips from open.
Your broker probably does this.
If you show us what your open positions are and what myfxbook is quoting it can probably be sorted out.
Life getting tough? God fears your progress.
Nov 10, 2010 at 16:08
Membre depuis Nov 05, 2010
posts 3
Hello TraderHotch,
Ok, i`ll give information for 1 day trading(with a floating position).
10/20/2010 16:08 Deposit 0 0 0 0 0 0 500.00
10/20/2010 16:35 10/20/2010 18:13 EURUSD Sell 0.1 1.3987 1.3817 1.3837
1.3987 0 0 -150 -150.00
10/20/2010 16:52 Deposit 0 0 0 0 0 0 250.00
10/20/2010 18:13 Deposit 0 0 0 0 0 0 1.00
10/20/2010 22:05 10/20/2010 22:21 USDCHF Buy 0.1 0.9623 0.9653 0.9633
0.9623 0 0 -10 -10.39
10/20/2010 22:21 Deposit 0 0 0 0 0 0 1.04
10/21/2010 0:04 Deposit 0 0 0 0 0 0 1.00
10/20/2010 22:02 10/21/2010 0:04 EURUSD Sell 0.1 1.3968 1.3938 1.3955
1.3960 0 -1.77 -13 -13.00
myfxbook quoting: balance = 591.65 equity = 571.65
Regards
Ok, i`ll give information for 1 day trading(with a floating position).
10/20/2010 16:08 Deposit 0 0 0 0 0 0 500.00
10/20/2010 16:35 10/20/2010 18:13 EURUSD Sell 0.1 1.3987 1.3817 1.3837
1.3987 0 0 -150 -150.00
10/20/2010 16:52 Deposit 0 0 0 0 0 0 250.00
10/20/2010 18:13 Deposit 0 0 0 0 0 0 1.00
10/20/2010 22:05 10/20/2010 22:21 USDCHF Buy 0.1 0.9623 0.9653 0.9633
0.9623 0 0 -10 -10.39
10/20/2010 22:21 Deposit 0 0 0 0 0 0 1.04
10/21/2010 0:04 Deposit 0 0 0 0 0 0 1.00
10/20/2010 22:02 10/21/2010 0:04 EURUSD Sell 0.1 1.3968 1.3938 1.3955
1.3960 0 -1.77 -13 -13.00
myfxbook quoting: balance = 591.65 equity = 571.65
Regards
Membre depuis Apr 11, 2010
posts 9
Nov 11, 2010 at 11:36
Membre depuis Apr 11, 2010
posts 9
I can't really understand that as you just gave figures, without telling what they mean but I'm guessing...
Assuming it's in USD.
$500 deposit, then a further $253.04 deposited throughout the day.
Sold 0.1 EUR/USD at 1.3837 and closed at 1.3987 (150 pip loss, so $150 loss).
Bought 0.1 USDCHF at .9633, and closed at .9623 (10 pip loss, $10.39 loss).
This gives you 592.65 as balance, so there's a dollar missing somewhere.
Is it that your open position is 13 pips off, and so there's another 7 gone, I'm not sure. To quote Asimov:
INSUFFICIENT DATA FOR MEANINGFUL ANSWER
Assuming it's in USD.
$500 deposit, then a further $253.04 deposited throughout the day.
Sold 0.1 EUR/USD at 1.3837 and closed at 1.3987 (150 pip loss, so $150 loss).
Bought 0.1 USDCHF at .9633, and closed at .9623 (10 pip loss, $10.39 loss).
This gives you 592.65 as balance, so there's a dollar missing somewhere.
Is it that your open position is 13 pips off, and so there's another 7 gone, I'm not sure. To quote Asimov:
INSUFFICIENT DATA FOR MEANINGFUL ANSWER
Life getting tough? God fears your progress.
Membre depuis Nov 09, 2010
posts 60

*Lutilisation commerciale et le spam ne seront pas tolérés et peuvent entraîner la fermeture du compte.
Conseil : Poster une image/une url YouTube sera automatiquement intégrée dans votre message!
Conseil : Tapez le signe @ pour compléter automatiquement un nom dutilisateur participant à cette discussion.