Greetings dear fellow forex traders. Today I’m going to briefly show how you can get your MetaTrader account history performance statement to show the profit or loss in PIPs. I’m pretty sure there must be a few of you out there who’ve always wondered how to get MT4 to do this. Unfortunately the bad news is that MT4 by default cannot do this. What is required is a little bit of work.
What you gotta do is open the statement file with MS Excel (technically it should work with other spreadsheet programs as well) and use the following function:
=IF(AND(F6<20;C6=”buy”);(J6-F6)*10000;IF(AND(F6<20;C6=”sell”);( F6-J6)*10000;IF(AND(F6>20;C6=”buy”);(J 6-F6)*100;(F6-J6)*100)))
or
=IF(AND(F6<20,C6=”buy”),(J6-F6)*10000,IF(AND(F6<20,C6=”sell”),( F6-J6)*10000,IF(AND(F6>20,C6=”buy”),(J 6-F6)*100,(F6-J6)*100)))
Here it is in action:
*If you’re curious to know, that’s a sample image I found on the net, it’s not my screenshot – I’m not Greek*
That’s it! Hopefully the next version of MetaTrader – aka MetaTrader 5 (MT5) – supports this ability by default (MetaQuotes are you listening?) because in my opinion it is a very useful feature for those of us who think in pips instead of dollars.
Ok, that about does it for this tutorial. I hope you found it useful. If so give me a shout (leave a comment) letting me know 🙂
Cheers,
Alan
http://alansforexblog.com