Importing Data To Excel | Page 2 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Importing live data into excel? 19 replies

Need help with importing prices from MT4 into Excel spreadsheet 1 reply

Importing UK100 data to excel 0 replies

Importing FF news into Excel 4 replies

Importing forward/backward tests into Excel 3 replies

Attachments: Importing Data To Excel
Exit Attachments

Importing Data To Excel

  • #21
  • Aug 21, 2012 12:36am Aug 21, 2012 12:36am
This is now bugging me!
Do hope that someone can shed some magic light.

My final thought....

It appears that XL is not recognising the link

Does your broker use a different naming standard?
Some use something like EURUSDm

M.
If you think I'm mad, I must be mad
  • #22
  • Aug 21, 2012 6:49am Aug 21, 2012 6:49am
Quoting Reh
Hi , yes it hangs , well actually I get N/A in all the cells
Do you mean close the Google tool bar ?
I have tried the attached example DDE-Sample.xls and it only gives the N/A in all the cells
I got this to work on the first try. Although I'm using OpenOffice instead of Excel.
I was not able to get that format to work. I'm using =DDE("MT4";"BID";"GBPUSD")

Basically 2 steps:
Enable DDE Server in the MT4 Tool>Options Menu
DblClick on the DDE-Sample.xls in the MT4 folder
  • #23
  • Edited 10:27am Aug 21, 2012 10:21am | Edited 10:27am
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Quoting futurespec
This is now bugging me!
Do hope that someone can shed some magic light.

My final thought....

It appears that XL is not recognising the link

Does your broker use a different naming standard?
Some use something like EURUSDm

M.
Thank you futurespec for your persistance, This is what was causing my Excel 2010 not to recognise the link --->
Some use something like EURUSDm
My Broker is InterBank fx.... seems they need the "m" at the end of the equation.
Example ='MT4'|BID!GBPUSDm ..... Also Excel 2010 requires the Apostrophes.... Thanks again.
  • #24
  • Aug 21, 2012 10:22am Aug 21, 2012 10:22am
Hooray!

Glad it is solved :-)

M.
If you think I'm mad, I must be mad
  • #25
  • Edited 12:00pm Aug 21, 2012 11:54am | Edited 12:00pm
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Continuing saga of Streaming data from MT4 to Excel 2010 spreadsheet....
Now that I have these formulas all running great.
='MT4'|BID!EURUSDm
='MT4'|ASK!EURUSDm
='MT4'|HIGH!EURUSDm
='MT4'|LOW!EURUSDm
='MT4'|TIME!EURUSDm
DDE check box checked in, Platform Tools , Options .....
Broker = IBFX ( InterBankfx)

I am unable to get the following data to stream ....
Excel says there is some kind of problem with "MT4.Exe" ??

='MT4'|OPEN!EURUSDm
='MT4'|CLOSE!EURUSDm
The Open and Close data does not stream to Excel...... Any Ideas as to why not...
I started this whole quest because these were the only two data streams I needed to stream to Excel ... hahahahaha and they are the only two that will not stream...
  • #26
  • Aug 21, 2012 12:01pm Aug 21, 2012 12:01pm
You are now allowed to swear!!

Open/close are not available in DDE

That is the beauty of MT4 ;-)
If you think I'm mad, I must be mad
  • #27
  • Aug 21, 2012 12:05pm Aug 21, 2012 12:05pm
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Quoting futurespec
You are now allowed to swear!!

Open/close are not available in DDE

That is the beauty of MT4 ;-)
%^$&*&$@#@##?>?<(*^& !!! Thank you .... LOL wouldn't you know :-)
  • #28
  • Aug 21, 2012 7:53pm Aug 21, 2012 7:53pm
Reh: The first price on a new day/* is the open.
It's also the close of the previous day (well, as close as you can get).
day/* (or whatever your bar represents)

If you really must have the exact numbers, use a script to write them to a csv file and read them in with vba.
  • #29
  • Aug 21, 2012 9:35pm Aug 21, 2012 9:35pm
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Quoting Kenz987
Reh: The first price on a new day/* is the open.
It's also the close of the previous day (well, as close as you can get).
day/* (or whatever your bar represents)

If you really must have the exact numbers, use a script to write them to a csv file and read them in with vba.
That looks like a great idea....but I do not have another life time left to learn Excel VBA programming.... :-) Wish I could !
  • #30
  • Aug 22, 2012 1:47am Aug 22, 2012 1:47am
What is it that you are actually trying to achieve?
Can you not do it in MT4 anyway?
If you think I'm mad, I must be mad
  • #31
  • Aug 22, 2012 8:53am Aug 22, 2012 8:53am
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Quoting futurespec
What is it that you are actually trying to achieve?
Can you not do it in MT4 anyway?
First I am not a programmer , wish I could, but I have a nice little indicator I have breen working on and have been using it and Excel to help with my trading. The above DDE attempt would have been away for me to make the indicator a little more automated.... I am currently manualy placing my indicator on MT4.... I know SLOW but when some thing works, you use it... I have been trying to learn how to program indi's for MT4 but that is going to be a slow process also.... My goal is to turn it into an EA but that is too far into the future to think about.... Guess I am riding a Turtle in a Sprinters race... Have a great one.. :-)
  • #32
  • Aug 22, 2012 8:59am Aug 22, 2012 8:59am
Tempting the Gods here (don't have oodles of time to spare) but if you are prepared to tell what you are trying to do then I or someone else may be able to help.

If you prefer then PM me.

M.
If you think I'm mad, I must be mad
  • #33
  • Dec 26, 2012 5:51pm Dec 26, 2012 5:51pm
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Quoting mda7
Hello guys,

You should do this steps (That is very Easy):

1- copy "DT Data Exporter v01.ex4" in indicators folder
2- Run it on any chart and any time frame that you want
3- Open a blank excel file
4- Go to "DATA" (On top of excel)
5- Choose "From Text" (on left)
6- Find your mt4's Folder in you hard drive and go to Expert=>Files
7- Find a currency that you run "DT Data Exporter v01.ex4" on that
8- Press "Next"
9- Tick the "Comma" and press "Next"
10- Press "Finish"
11- Press "Properties"
12- Untick "Prompt for file name on...
-----------------------------------------------------------------------------
Hi , I have tried the above steps and have gotten this to work , But there seems to be a very large delay before the update occurs after a new candle opens..... Is there a fix to this ?
  • #34
  • Dec 27, 2012 12:54pm Dec 27, 2012 12:54pm
Quoting Reh
-----------------------------------------------------------------------------
Hi , I have tried the above steps and have gotten this to work , But there seems to be a very large delay before the update occurs after a new candle opens..... Is there a fix to this ?
Hi Dear Reh,

If you set "1" in cell (Like attached file) you will receive data every 1 minutes.
http://uploadimage.co.uk/images/11-1356634330.jpg
  • #35
  • Dec 27, 2012 4:41pm Dec 27, 2012 4:41pm
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Hi Mda7
I have done that mda7 , many times , no matter what time period you set to , there is always a delay between when the platform opens a new candle and when Excel recieves it's updated data for the new candle..... I need instant data sent to Excel the moment the new candle forms.... 20 to 30 seconds delay could mean the trade potential is already over with. I guess I may need to look for a company that sends platform data to Excel in a purchasable software..... Thanks again.
  • #36
  • Feb 21, 2013 12:55pm Feb 21, 2013 12:55pm
Hi,

I got the same issue and the problem was caused by wrong instrument name. So there was no EURUSD instrument on my brokers MT4, but EURUSD.pro instrument.
After entering =MT4|BID!GBPUSD.pro instead of =MT4|BID!GBPUSD, the N/A message has changed to 1.52466 :-)
  • #37
  • Jan 3, 2014 2:40am Jan 3, 2014 2:40am
Hello ,
I'm using FXCM broker and trying to use the DDE option to link to excel 2010 but it doesn't work .
However it works fine on other broker .


Since I'm trading with FXCM I wanted to use the data feed from FXCM MT4 .
Does anyone know how to connect FXCM MT4's DDE to Excel 2010 ???


I tried the above solution but it doesn't work ..
  • #38
  • Jan 16, 2014 3:38pm Jan 16, 2014 3:38pm
Quoting juniorlcq
Hello , I'm using FXCM broker and trying to use the DDE option to link to excel 2010 but it doesn't work . However it works fine on other broker . Since I'm trading with FXCM I wanted to use the data feed from FXCM MT4 . Does anyone know how to connect FXCM MT4's DDE to Excel 2010 ??? I tried the above solution but it doesn't work ..
Hi Junior,

Is your MT4 account on No Dealing Desk (NDD) or Dealing Desk (DD) forex execution? If your account is on DD, then it's important to note that the symbol names on the data feed are slightly different. For example, you would have to enter something like "=MT4|ASK!EURUSDdd" instead of "=MT4|ASK!EURUSD"

Also do you want the prices in Excel to update in real time or are you simply looking for static data. If static data is all you need, then it's simpler to log into Trading Station instead of MT4 (the same login will work for both platforms), open a Marketscope chart, go to File > Export to Excel. That will load static data for you.

Please let me know if either of those suggestions work for you. If not, I can put you in touch with one of our tech specialists to help you further.

Thanks,
Jason
  • #39
  • Jan 24, 2014 2:41am Jan 24, 2014 2:41am
Quoting Jason Rogers
{quote} Hi Junior, Is your MT4 account on No Dealing Desk (NDD) or Dealing Desk (DD) forex execution? If your account is on DD, then it's important to note that the symbol names on the data feed are slightly different. For example, you would have to enter something like "=MT4|ASK!EURUSDdd" instead of "=MT4|ASK!EURUSD" Also do you want the prices in Excel to update in real time or are you simply looking for static data. If static data is all you need, then it's simpler to log into Trading Station instead of MT4 (the same login will work for both...

Hi Jason , mine is a NDD account . Can it import real time tick volume data as well ??
  • #40
  • Mar 8, 2014 5:25pm Mar 8, 2014 5:25pm
hi all members

I'm trying to use dde sample to export mt4 values to excel. and it works.

But when i want to put that data into a another formula for my trading needs as =10/('MT4'|BID!EURCHF) it shows me #VALEUR (in french). It may be #VALUE in english.
I think it's a excel issue (not a mt4 problem) but if i u could help me i'll be very graceful.

thx a lot
0 traders viewing now