Position size, Pips and Leverage calculation...

Hi there, this is my first post/thread, so I'm not sure if this is the right forum's section to post it ! =)

I have doubts regarding the proper calculation of position size, pips and leverage.

I've put together an excel spreadsheet in order to have them calculated, but unfortunately it does not seem to reflect reality when I compare it to my MT4 terminal demo account history...

I've attached the spreadsheet as well as a screenshot of the MT4 terminal.

According to the terminal, the trade's profit was US$ 194.00. However, when I calculate it in excel, the trade's profit should have been US$ 19.40.

Am I doing something wrong ? Is my calculation wrong ? Or the MT4 terminal has not been properly set up ?

Gray cells are the inputs. Beware that there are 2 selectable menus (light blue) to make it easier...

Thank you in advance for your help.

Regards,

Beto.

mini lots will most likely be 0.1 with your broker your purchases were standard lots 1.0 and 2.0

It would be nice if you add 'SL' and not just 'exit'.

Guillo,

I've modified the spreadsheet (added SL calculation and put some color on it)... Would you please check it out ? I hope it meets your expectations... Please, let me know your thoughts about it. Do you think the calculation is correct, as well ? Thanks, once again.

Magnumfreak, thanks for advising. That may be the real "issue" ! =)

Beto Que created a pretty nice calculator : http://www.forexfactory.com/showthre...ght=calculator you may want to get a look at it. It is good you are doing this as it will help you understand the fine points if you can build it in as spreadsheet

Here is the one I use on every trade I take: http://currensys.com/FreeForex.php

It lives in my task tray and is there when I need it. It can be used on standard lots, mini lots, and micro lots. The results can be returned in any major currency.

Phil and MrGreen,

Thank you very much ! Both are great tools !!! Thanks once again.