Possible to send buy/sell orders from Excel DDE Sample to MT4? | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Excel hangs with MT4 DDE Link 14 replies

Good with MT4, DDE and microsoft excel? Need help! 1 reply

MT4 DDE for Excel 2007 1 reply

Taking two different mt4 price into one excel via DDE 6 replies

Unusual Bug with DDE and Excel Scripts in MT4 8 replies

Possible to send buy/sell orders from Excel DDE Sample to MT4?

  • #1
  • First Post: Dec 12, 2013 6:04am Dec 12, 2013 6:04am
Is it possible send orders to buy or sell from Excel DDE Sample to MT4?

I export live price MT4 from Excel DDE Sample, and ask:

What is the formula that I enter in Excel to open a pending order SELL LIMIT?

What is the formula that I enter in Excel to open a pending order BUY LIMIT?

What is the formula that I enter in Excel to open a pending order BUY STOP?

What is the formula that I enter in Excel to open a pending order SELL STOP?

thanks
  • #2
  • Dec 12, 2013 6:56am Dec 12, 2013 6:56am
It takes lots of behind the scenes coding to do what you want. You can find some products with search.
  • #3
  • Dec 12, 2013 7:52am Dec 12, 2013 7:52am
Quoting CodeMeister
It takes lots of behind the scenes coding to do what you want. You can find some products with search.
Dear Mr. Code Meister,

I am newbie. I don't know how to ask a new query. I want an Alert when New Candle opens below / ABove 5 ema at 4Hr Time frame. Could you please help me

Rgds,
anandakuttan
  • #4
  • Dec 12, 2013 11:16am Dec 12, 2013 11:16am
How to write a pieces of code to suspend EA for a few hours? After hours expires EA should resume normal operation.
  • #5
  • Dec 12, 2013 1:22pm Dec 12, 2013 1:22pm
Quoting anandakuttan
{quote} Dear Mr. Code Meister, I am newbie. I don't know how to ask a new query. I want an Alert when New Candle opens below / ABove 5 ema at 4Hr Time frame. Could you please help me Rgds, anandakuttan
Try this:

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

or this:
http://www.forexfactory.com/showthread.php?t=381813
  • #6
  • Dec 12, 2013 2:31pm Dec 12, 2013 2:31pm
Quoting promisedea
How to write a pieces of code to suspend EA for a few hours? After hours expires EA should resume normal operation.
you have to check the day and times.
for example one codesnippet (from basa ea by steve hopwood, google it):
Inserted Code
      //TimeDay 5 = friday, 0 = sunday, so TimeDay >= StopTradingDay does not hurt (if TimeDay = 0, then 0 >= 5 is false) ...
      if (StopOpenPositionsFridayEvening && TimeDayOfWeek(TimeLocal()) >= StopTradingDay && TimeHour(TimeLocal()) >= StopTradingLocalHour) {
        //close all open trades also? This only takes place if SendAlertNotTrade=FALSE, of course ...
        if (OrdersTotal()!=0 && CloseAllOpenTradesAlso && TimeHour(TimeLocal()) >= FridayCloseAllLocalHour && !SendAlertNotTrade) ForceTradeClosure=true; //close all open trades on friday?        
       return(false);
      }//end if (StopOpenPositionsFridayEvening && TimeDayOfWeek(TimeLocal())
PM me with coding requests and I'll probably put you on my ignore list
  • #7
  • Dec 12, 2013 2:41pm Dec 12, 2013 2:41pm
Quoting fxdaytrader_
{quote} you have to check the day and times. for example one codesnippet (from basa ea by steve hopwood, google it): //TimeDay 5 = friday, 0 = sunday, so TimeDay >= StopTradingDay does not hurt (if TimeDay = 0, then 0 >= 5 is false) ... if (StopOpenPositionsFridayEvening && TimeDayOfWeek(TimeLocal()) >= StopTradingDay && TimeHour(TimeLocal()) >= StopTradingLocalHour) { //close all open trades also? This only takes place if SendAlertNotTrade=FALSE, of course ... if (OrdersTotal()!=0 && CloseAllOpenTradesAlso && TimeHour(TimeLocal()) >= FridayCloseAllLocalHour...
Thanks for your reply. However, if I want to suspend EA when spread spike greater than maxspread (user defined) for three hours. after three hours spread become normal and below max spread, ea should automatically resume trading. What is the code look like?
  • #8
  • Dec 12, 2013 6:18pm Dec 12, 2013 6:18pm
As I know the EA checks the spread also, so:
Quoting fxdaytrader_
for example one codesnippet (from basa ea by steve hopwood, google it)
PM me with coding requests and I'll probably put you on my ignore list
  • #9
  • Dec 13, 2013 4:49am Dec 13, 2013 4:49am
Quoting CodeMeister
{quote} Try this: http://www.forexfactory.com/showthread.php?t=317213 or this: http://www.forexfactory.com/showthread.php?t=381813


Thx a lot
  • #10
  • Last Post: May 16, 2017 1:31am May 16, 2017 1:31am
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
0 traders viewing now