Can an EA communicate with Excel?

Hi,

I would like an EA to open a trade (with fix TP/SL, say both always 10 pips) taking the Lot Size and direction of the trade from 2 defined cells of Excel.

Then the EA should position the result of the trade (1= TP, 0=SL) in a third Cell, before to open the next trade (as the 2 cells Lot Size and Direction would depend from the previous result).

Is that possible, and if yes how ?

Many thanks for your attention.

There have been a number of discussions about this. I think the latest was this summer. But the consensus was that this is difficult to do and requires a lot of coding. I believe there is a third party interface that someone recommended. I doubt if there is anything free; this is much too work to give away.

Many thanks CodeMeister for your kind and fast reply !

Yes, I agree about the need of a third interface working as a kind of "bridge".

I would appreciate a lot if anybody could give me any information where to find one (even if not free).

Thanks again.

There is only one solution. Its called MexcelTrader. It bridges MT4 to Excel and vica versa. It aint cheap but you can a free fully functional 10 day trial. It is sold by fxdialogue

Hi,
Here's a link to a guy who offers a coding service. I remember his history shows that he has done something with Excel and Metatrader. He gave me a bit of advice on something I was working on and was very helpful.

https://www.elance.com/s/esalem1/10183

Hi,
here is a free EXCELLINK ADDON for MetaTrader4
you need to register to get the free software.

www.fx1.net/excellink.php

-----

Features:

Written in C++ to have optimal speed
Using Microsoft Native API to make the addon compatible with almost all versions of Excel
Send/Receive String/Value/Float values to/from Excel with simple commands
Capability to format cells fontsize, color
Capability to optionally autofit cells
Loading and Saving excel compatible files through Addon
Capability to send calculation commands like =sum(a1+a2)
Rename Sheets for better overview via commands
Supports sheets for all operations. Its possible to send output, read input or calculate on specified sheet
Free of charge

-----

InterProcessCommunication
Several of us have posted FREE code to do this.
Perhaps the best was done by sangmane.
Search for Pipes (no not the smoking kind)
and MailSlots (no not the letter kind).

Thank you all for your precise, fast and kind replies !

I will have a look at all your suggested links.