Importing live data from MT4 to excel

To add comments, please log in or register
jongreenwairoa
19
jongreenwairoa  

Hi everyone,


I am new to trading and would like to understand how to import live data from MT4 to Excel (Excel 2013).

I have looked through other threads posted on here previously that advise on this and still cannot seem to make it work.


Thus far I have tried to simply import a bid price to excel, what I have done looking at other threads is the following:


1. in Excel go to File _> Options -> Advanced scroll down to the general section and uncheck Ignore other applications that use Dynamic Data Exchange (DDE)

2. On an Excel spreadsheet type in the following formula ='MT4'|Bid!EURUSD

What I get is an error of N/A but not #N/A

What am I not doing correctly?


I want to be able to import realtime into Excel from MT4

Is there a reference somewhere for the functions/forumlas you can use in Excel to import the data?

Apologies if I am not being clear in my any part of my question 

jongreenwairoa
19
jongreenwairoa  

Bump - with decreasing hope :(

Carl Schreiber
Moderator
8268
Carl Schreiber  
Have you enabled in the terminal: Tools => Options => Server => Enable DDE Server?
nicholi shen
2383
nicholi shen  

https://www.metatrader4.com/en/trading-platform/help/service/dde

Export of Quotes - Tools - MetaTrader 4 Help
Export of Quotes - Tools - MetaTrader 4 Help
  • www.metatrader4.com
BID     request:    = MT4|BID!USDCHF         result:  1.5773    ASK     request:    = MT4|ASK!USDCHF         result:  1.5778    HIGH    request:    = MT4|HIGH!USDCHF        result:  1.5801    LOW     request:    = MT4|LOW!USDCHF         result:  1.5741    TIME    request:    = MT4|TIME!USDCHF        result:  21.05.02 9:52...
Fernando Carreiro
4916
Fernando Carreiro  
jongreenwairoa: Bump - with decreasing hope :(

There is actually quite a few threads on how to do this, but currently, the website's search function is not working properly!

Unfortunately, since most of the power users here don't use the DDE Services for Excel, and since neither you or we can find those related threads at the moment, the only reference information we can offer, is the very link to the official documentation that @nicholishen has already given you.

justinf
82
justinf  

Instead of  =MT4|ASK!EURUSD

it's now       ='MT4'|ASK!EURUSD


I can confirm in my setup:  Win 2008 R2, MT4 & Excel 2010 this is working.


Thanks go to:  https://social.technet.microsoft.com/Forums/lync/en-US/144ddf0b-a3b7-4f18-b13f-36ccba7ad7c8/dde-link-between-mt4-excel-2010-no-longer-works-on-windows-81-64bit?forum=officeitproprevious

DDE link between MT4 & Excel 2010 no longer works on Windows 8.1 64bit
  • social.technet.microsoft.com
Question I have a DDE link between EXCEL 2010 & Metatrader (MT4)  that has worked flawlessly up until yesterday. Now the spreadsheet just hangs when i attempt to update. I had not changed anything on my machine prior to the problem, but have since repaired then reinstalled Office and reinstalled MT4 but the problem persists. The link still...
ras_vee
5
ras_vee  

hello

i am looking for RTD-excel advisor and if is for sale how can i purchase it

thanks in advance!!

AndreasDel
12
AndreasDel  
nicholi shen:

https://www.metatrader4.com/en/trading-platform/help/service/dde

Hi,


The formula that you mentioned for bid, ask etc prices works fine when used for symbols that have the following format EURUSD, EURUSD. or DAX30


But when used for symbols that also include ( -  i.e. Brent-Apr19  )  then it does not extract the quotes


Is there a way to work around this and get the live quotes for this type of symbols as well?


Thanks

Isabella
14
Isabella  
AndreasDel:

Hi,


The formula that you mentioned for bid, ask etc prices works fine when used for symbols that have the following format EURUSD, EURUSD. or DAX30


But when used for symbols that also include ( -  i.e. Brent-Apr19  )  then it does not extract the quotes


Is there a way to work around this and get the live quotes for this type of symbols as well?


Thanks

I use Windows 7, Open Office, not excel. Syntax for open Office for instance       = DDE("MT4";"BID";"EURUSD";1)       works ok for all FX.

Other pairs: GOLD, OIL-xxx, Ger30Cash ... are showing errors since today, so I think it is a prob of new Version MT4,

edit_2019_02_23; 21:34 GMT: tried out now my above mentioned OpenOfficeSheet (existing more then 1 year) using Laptop(win10) - not PC(win7): works well under Windows10 for all underlyings, eg FX, different indices, commodities

edit_2019_02_24; 13:00 GMT: DDE works well now, via Windows 10 and Windows 7 too

Isabella
14
Isabella  
ras_vee:

hello

i am looking for RTD-excel advisor and if is for sale how can i purchase it

thanks in advance!!

The amount of data you can transport via DDE is very limited, but productive.

How you combine the data --- is the main topic to think about. (Choice of underlings, tf, decisive changes within the day, correlations ...)

You have to think that over. The rest are colorful pictures. Why to pay for this?

bosslife
188
bosslife  

is it possible to get data for any candle i want??


12
To add comments, please log in or register