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.
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.
Attached File(s)
PL calc.xls
30 KB
|
1,606 downloads