Expert Advisors: MT5 DDE - Server - page 7

New comment
 
Hello friends, very good comments, it was a great help. I have one more question? How do I set the RSI?
 
THE PRICES ARE REFRESHED IN SECONDS. HOW TO MAKE PRICES UPDATE IN MILLISECONDS?
 
cant we  Input Variables

to change symbol

 
Tom Sasson #:

This post is quite old, but still relevant.

This tool is amazing, and can be used to integrate data even from multiple instances of MT4 or multiple EAs.

If any of the previous questions is still relevant, please re-post them and I will answer.

The same goes for MQL4 questions, since I can help with MQL4 also.

Hello.


I hope that I can still get an answer from you. I am able to get the default data from the DDE server (Company name, time and EMA) into excel. However, after getting the DDE to display ticks/quotes for various instruments on its own interface, I can not display the quotes in excel. Can you please help me with the formula to display the quotes in Excel?


Thank you.

 
IlyshikBTC #:
if(!CheckItem("BID","EURUSD")) AddItem("BID","EURUSD");
if(!CheckItem("ASK","EURUSD")) AddItem("ASK","EURUSD");
SetItem("BID","EURUSD",(double)SymbolInfoDouble(Symbol(),SYMBOL_BID));
SetItem("ASK","EURUSD",(double)SymbolInfoDouble(Symbol(),SYMBOL_ASK));

Greetings. 

The code worked for me, and now the DDE displays the bid and ask price quotes. My problem now is that I cannot display the quotes in Excel. The default data that comes with the DDE,  that I am able to display in excel, but not the price quotes. 

Could you please help me with the formula to display the quotes in Excel?

Thank you.

 
Conrade Nyandoro #:

Greetings. 

The code worked for me, and now the DDE displays the bid and ask price quotes. My problem now is that I cannot display the quotes in Excel. The default data that comes with the DDE,  that I am able to display in excel, but not the price quotes. 

Could you please help me with the formula to display the quotes in Excel?

Thank you.

=MT4DDE|BID!EURUSD - with dot in excel cell
=MT4DDE|ASK!EURUSD

=ЗАМЕНИТЬ(MT4DDE|BID!EURUSD;2;1;",")
=ЗАМЕНИТЬ(MT4DDE|ASK!EURUSD;2;1;",")

=REPLACE(MT4DDE|BID!EURUSD;2;1;",") - with comma in excel cell
=REPLACE(MT4DDE|ASK!EURUSD;2;1;",")
 
mzee_zaki #:

I tried using your code but it only get me the Ask/Bid of the first currency pair in the list of symbols in MT5 regardless of the currency symbol I add in the code.

For example, I have USDCAD as the first symbol in MT5 symbols list. I write the code you provided with EURUSD, but the Ask price I get is the USDCAD one not the EURUSD one. How to fix that?

Also, do you have any suggestions on how to connect ask price of all currency pairs/symbols to Excel?

Thanks!

it`s working. I try now. 

=ЗАМЕНИТЬ(MT4DDE|ASK!EURAUD;2;1;",") - to excel cell with comma!

 
ISergeyevich # : =MT4DDE|BID!EURUSD - com ponto na célula do Excel =MT4DDE|ASK!EURUSD =ЗАМЕНИТЬ(MT4DDE|BID!EURUSD;2;1;",") =ЗАМЕНИТЬ(MT4DDE|ASK!EURUSD;2; 1;", ") =REPLACE(MT4DDE|BID!EURUSD;2;1;",") -  com vírgula na célula do Excel =REPLACE(MT4DDE|ASK!EURUSD;2;1;",")

When I use this command in my Excel, I have #REF!...

Auto-translation applied by moderator
 
@webvarzea #: When I use this command in my Excel, I have #REF!...
Auto-translation applied by moderator
On this the English forum, please post in English. Either use the automatic translation tool, or post in one of the other language forums.
 
Fernando Carreiro #: On this the English forum, please post in English. Either use the automatic translation tool, or post in one of the other language forums.

OH SORRY my man, its a mistake.

you know something about this problem to help me? im a like 6 hours trying to make working...

12345678
New comment