Need Help With Communicating Mt4 with Excel

Hi Everyone,

Can anyone tell me if you can link your metatrader platform account to Excel so that you can automaticlly have Excel calculate your profit or loss. What I mean is let's say that If I had 10 different orders open on 3 different pairs all opened at different prices is there a way that you could have Excel running at the same time, sort out the different pairs and quickly look and see what the profit or loss would be on each individual pair. Also, if there is a better way than what I want to do to be able to accomplish this please let me know.

Thanks

MT4 has a DDE server that sends price info out, so if you put your orders into excel and hook up the dde server, you can calculate profit/loss.

You might look in these threads for people doing similar things and help setting up the DDE server

http://www.forexfactory.com/showthread.php?t=61693
http://www.forexfactory.com/showthread.php?t=11066

Thank You 4xcoder I will check into this. I was really wondering if excel could read your account instead of working off of just the price feed through the DDE

Thank You

All metatrader will send is price and time data. What you could do is have an indicator write the data to a file every tick and then have excell read that data

Thanks Magnum do you no if there are any such indicatirs written already I am not very good a writting code.