Help! Need an advise about calculating "equity"
Nov 09, 2010 at 22:12
Vistas 832
6 Replies
Nov 09, 2010 at 22:12
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
Miembro desde Apr 11, 2010
posts 9
Nov 10, 2010 at 15:06
Equity = balance + floating position
Everything should be included, it may help to think of it as the amount you would get if you closed your account at this very moment.
Everything should be included, it may help to think of it as the amount you would get if you closed your account at this very moment.
Life getting tough? God fears your progress.
Nov 10, 2010 at 15:16
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
Miembro desde Apr 11, 2010
posts 9
Nov 10, 2010 at 15:25
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
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
Miembro desde Apr 11, 2010
posts 9
Nov 11, 2010 at 11:36
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.
Miembro desde Nov 09, 2010
posts 61
Nov 13, 2010 at 10:45
(editado Nov 13, 2010 at 10:45)
No need for that, ur broker suppose to do that automatically and place it in ur platform to see
Slow But Steady
*El uso comercial y el spam no serán tolerados y pueden resultar en el cierre de la cuenta.
Consejo: Al publicar una imagen o una URL de YouTube, ésta se integrará automáticamente en su mensaje!
Consejo: Escriba el signo @ para completar automáticamente un nombre de usuario que participa en esta discusión.
