Help! Need an advise about calculating "equity"

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

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.

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

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.

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

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