Trading using Excel and MT4? | Page 2 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 612 replies

How to copy profiles in MT4? How to use Excel with MT4? 7 replies

MetaTrader and Excel using DDE 8 replies

Using Excel data and building platform 2 replies

Looking for Help with using Excel and MetaTrader 4 5 replies

Attachments: Trading using Excel and MT4?
Exit Attachments

Trading using Excel and MT4?

  • #21
  • May 16, 2017 3:32am May 16, 2017 3:32am
Hi, new to this forum. I have a question
I have the following data in excel,

Currency Pair: Entry Order Price Stop loss Take profit Trade Risk Profile
AUDNZD BUYSTOP 1.0791 1.0751 1.1087 0.005

I want to create an EA/script or anything that when i click (in excel) will trigger and read the excel cells and create a (buystop) pending order on my MT4 platform.
Is this a possibility?

Any input or feedback will be much appreciated.

Thank you very much
  • #22
  • May 16, 2017 10:00am May 16, 2017 10:00am
Raj007, what you are asking for is possible but takes coding effort. Read the entire thread and perhaps it will become clearer.
  • #23
  • May 16, 2017 10:23pm May 16, 2017 10:23pm
Quoting CodeMeister
Raj007, what you are asking for is possible but takes coding effort. Read the entire thread and perhaps it will become clearer.
Thank you for your reply. But the use of pipes by sangmane (which i believe you are referring to ) gives me a compile error as attached. I think its because i am running a 64bit Excel and the pipe is only for 32bit? Therefore I wasnt able to experiment around with it.
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot2.png Size: 56 KB
  • #24
  • May 16, 2017 11:47pm May 16, 2017 11:47pm
I didnt realize you had coding skills when I replied. I thought you might try one of the third party solutions. Sangmane's code has been used by others successfully if my memory is correct, but it is dated and he doesnt seem to be active. I am not a VB expert, my choice of languages is C#. Perhaps a VB guy will drop by and help.
  • #25
  • May 17, 2017 3:40am May 17, 2017 3:40am
Quoting CodeMeister
I didnt realize you had coding skills when I replied. I thought you might try one of the third party solutions. Sangmane's code has been used by others successfully if my memory is correct, but it is dated and he doesnt seem to be active. I am not a VB expert, my choice of languages is C#. Perhaps a VB guy will drop by and help.
Could i ask how to reference the code in MQL4 to read from a excel file ? So something like,

int Price = C:\user\test.xls , cell A1

Actually i am new to MQL4, still trying to figure out as i go along.
  • #26
  • May 17, 2017 10:13am May 17, 2017 10:13am
There is no simple answer. It depends on which interface or API you use and each will have its own implementation. The only delivered functionality with MT4 is DDE, which you can learn from the docs.
  • #27
  • May 18, 2017 2:02pm May 18, 2017 2:02pm
Quoting raj007
Hi, new to this forum. I have a question I have the following data in excel, Currency Pair: Entry Order Price Stop loss Take profit Trade Risk Profile AUDNZD BUYSTOP 1.0791 1.0751 1.1087 0.005 I want to create an EA/script or anything that when i click (in excel) will trigger and read the excel cells and create a (buystop) pending order on my MT4 platform. Is this a possibility? Any input or feedback will be much appreciated. Thank you very much
There are several threads related to M$ Excel and MT4 via DDE. Just refine your search and you surely find what you are looking for.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #28
  • May 18, 2017 2:06pm May 18, 2017 2:06pm
Quoting CodeMeister
There is no simple answer. It depends on which interface or API you use and each will have its own implementation. The only delivered functionality with MT4 is DDE, which you can learn from the docs.
Since MT4 comes with a DDE server and is not a client itself, it will not work to send data from M$ Excel directly to MT4. There are only a few commands available. On Internet, there are some commercial versions available they have more functionalities/commands.

Jibala
PDF & BCC (Patience Discipline Focus & Belief Confidence Consistency)
  • #29
  • May 18, 2017 10:16pm May 18, 2017 10:16pm
Quoting JibalaPasan
{quote} Since MT4 comes with a DDE server and is not a client itself, it will not work to send data from M$ Excel directly to MT4. There are only a few commands available. On Internet, there are some commercial versions available they have more functionalities/commands. Jibala
yes, exactly. All that I have found is extracting feed/spread/data from mt 4 to excel sheet. Which i have in place already. But i cant seem to find how to push data from Excel to Mt4 (eg pending order request) and being just a student i cant afford the commercial options at the moment.
  • #30
  • Last Post: Feb 23, 2024 8:11am Feb 23, 2024 8:11am
Hello CodeMeister. I would like to order an EA robot based on only indicator - 123Patterns v6.
I am also willing to pay for the work. Please contact me -{ email address deleted by staff }, Toomas
0 traders viewing now