Importing Data To Excel | 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

  • #1
  • First Post: Apr 17, 2007 3:46pm Apr 17, 2007 3:46pm
Hi all

I've heard there's a way to set up Excel so that it automatically imports prices from MT, does anyone know how to do this ? Actually if anyone knows of any websites where u could learn about Excel it'd be greatly appreciated.
  • #2
  • Apr 18, 2007 3:32am Apr 18, 2007 3:32am
I am Learning how to do this to. I haven't got it figured out yet, but i do know that you can bring up a list that will show you what all excel will extract data from. Go to insert, and then object
, and it will give u the list
You never fail in any feat, you just find out how not, to do it again
  • #3
  • Apr 18, 2007 2:14pm Apr 18, 2007 2:14pm
First, in your MetaTrader, under Tools -> Options, make sure that "Enable DDE Server" is checked.

In your MT installation directory (e.g., C:\Program Files\Interbank FX Trader 4), there is a sample spread sheet called DDE-sample.xls. Use that for starters.

Over at the Forex-TSD forum, I believe, there is someone who has done something more elaborate. Go there and search for "Excel".
  • #4
  • Apr 18, 2007 2:36pm Apr 18, 2007 2:36pm
Ok thanks, i got to the importing the DDE sample part but thought u could set it up to import data automatically, i.e. at the close of each day, will check out Forex TSD and see what comes up, thanks for the help
  • #5
  • Apr 18, 2007 8:13pm Apr 18, 2007 8:13pm
This is all you have to do: Start mt4 first. then open excel. format the cells that you want the data to feed into: =MT4|BID!USDCHF this will give you the bid if you want the high or the low replace the word BID with high or low. It should start worling right away if not, close it down and open it back up, as you are opening it back up (excel) click on enable macros and update.
  • #6
  • Apr 22, 2007 5:15pm Apr 22, 2007 5:15pm
Thanks for all the replies, got it figured out now i just have to get used to Excel !
  • #7
  • Jul 19, 2012 4:37am Jul 19, 2012 4:37am
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 refresh"
13- Tick "refresh every" and put in it a number that you want" and press "OK"
14- Press "OK" and enjoy it

*: Your data will Refresh every Period that you fill in step 13.
Attached File(s)
File Type: ex4 DT Data Exporter v01.ex4   4 KB | 3,303 downloads
  • #8
  • Edited 10:07am Aug 20, 2012 9:55am | Edited 10:07am
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Hi , I have tried the suggested examples to get streaming data from the MT4 platform to an Excel 2010 spreadsheet , and non of them have worked so far. I have clicked the DDE tab to activate it... I have clicked the security tabs in Excel to allow transfer ... I have used the following formulas =MT4|BID!GBPUSD etc and yet nothing works.... can someone please give a detailed explaination on how to do this... Thanks a million , It would be very much appreciated....
Robert H
  • #9
  • Aug 20, 2012 10:06am Aug 20, 2012 10:06am
Are you getting the loading symbol in XL that does not go away? i.e. does it appear to hang?
If so close Google if you are running it and try XL again... this has turned out to be the problem for me on a number of occasions.

Does the attached work?


M.
Attached File(s)
File Type: xls DDE-Sample.xls   17 KB | 2,960 downloads
If you think I'm mad, I must be mad
  • #10
  • Edited 10:15am Aug 20, 2012 10:10am | Edited 10:15am
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Quoting futurespec
Are you getting the loading symbol in XL that does not go away? i.e. does it appear to hang?
If so close Google if you are running it and try XL again... this has turned out to be the problem for me on a number of occasions.

Does the attached work?


M.
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
  • #11
  • Aug 20, 2012 10:15am Aug 20, 2012 10:15am
Close the Google browser.
Restart XL (or it may connect ok anyway)
You can then restart Google if you need it and XL will continue to
connect to MT4.

Never managed to figure out why it does this???

ANYONE HAVE AN ANSWER TO THIS?


M
If you think I'm mad, I must be mad
  • #12
  • Aug 20, 2012 10:17am Aug 20, 2012 10:17am
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Quoting futurespec
Close the Google browser.
Restart XL (or it may connect ok anyway)
You can then restart Google if you need it and XL will continue to
connect to MT4.

Never managed to figure out why it does this???

ANYONE HAVE AN ANSWER TO THIS?


M
I do not use Google browser.... I do not even have it on my computer. Thanks for your suggestions though.
  • #13
  • Aug 20, 2012 10:34am Aug 20, 2012 10:34am
Assuming you definitely have DDE enabled in MT4...

Try (no guarantees I am not an XL whizz)

XL/ Options/Trust Centre/ Trust centre settings / Trusted locations/
Add new location ... the full filepath to your MT4 directory.
If you think I'm mad, I must be mad
  • #14
  • Aug 20, 2012 10:45am Aug 20, 2012 10:45am
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Quoting futurespec
Assuming you definitely have DDE enabled in MT4...

Try (no guarantees I am not an XL whizz)

XL/ Options/Trust Centre/ Trust centre settings / Trusted locations/
Add new location ... the full filepath to your MT4 directory.
Added path to MT4 directory , still I only get N/A in all cells....
  • #15
  • Aug 20, 2012 10:56am Aug 20, 2012 10:56am
Sorry no more answers.
XL has too many bells & whistles so it could be a multitude of combinations.

See you are using 2010 .... don't know if that has something different. Could try compatability with earlier versions.

Also if not tried try Data / refresh all.

One other try ... add apostrophe around MT4 (think I recall something about this previously)

='MT4'|BID!GBPUSD

No more ideas :-(

GL

M.
If you think I'm mad, I must be mad
  • #16
  • Aug 20, 2012 11:27am Aug 20, 2012 11:27am
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Quoting futurespec
Sorry no more answers.
XL has too many bells & whistles so it could be a multitude of combinations.

See you are using 2010 .... don't know if that has something different. Could try compatability with earlier versions.

Also if not tried try Data / refresh all.

One other try ... add apostrophe around MT4 (think I recall something about this previously)

='MT4'|BID!GBPUSD

No more ideas :-(

GL

M.
The addition of the Apostrophe helped with the Excel 2010 version , but still not getting data stream , same with older Excel version .... seems you do not need the Apostrophe in earlier versions..
  • #17
  • Aug 20, 2012 11:35am Aug 20, 2012 11:35am
If your MT4 Tools / Options looks like the attached then I feel it must be an XL thingy but what is the big Q.

The only other thing would be to try an XL forum

M.
Attached Image
If you think I'm mad, I must be mad
  • #18
  • Aug 20, 2012 11:41am Aug 20, 2012 11:41am
The only other thing in XL I can think of...

Options/ Advanced (attached)

If you have Ask to update ticked I assume that you accepted that on opening.
Attached Image (click to enlarge)
Click to Enlarge Name: MT4 XL.jpg Size: 72 KB
If you think I'm mad, I must be mad
  • #19
  • Aug 20, 2012 2:49pm Aug 20, 2012 2:49pm
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Quoting futurespec
Sorry no more answers.
XL has too many bells & whistles so it could be a multitude of combinations.

See you are using 2010 .... don't know if that has something different. Could try compatability with earlier versions.

Also if not tried try Data / refresh all.

One other try ... add apostrophe around MT4 (think I recall something about this previously)

='MT4'|BID!GBPUSD

No more ideas :-(

GL

M.
Thank you Futurespec for your help.... Unfortunatley I still am unable to get any data to stream... I have been to both types of forums, Excel and MT4 , What I have found is there are alot of people that say they have it running on their spread sheets , but non of them are willing to give a detailed explanation of how they did it. If there is anyone who has this working on their Excel spread sheet and would feel at ease to share it , I would be very appreciative...... thank you
  • #20
  • Aug 20, 2012 8:12pm Aug 20, 2012 8:12pm
  •  Reh
  • | Joined Mar 2012 | Status: Vanity.... ALL is Vanity !!!! | 55 Posts
Quoting futurespec
Sorry no more answers.
XL has too many bells & whistles so it could be a multitude of combinations.

See you are using 2010 .... don't know if that has something different. Could try compatability with earlier versions.

Also if not tried try Data / refresh all.

One other try ... add apostrophe around MT4 (think I recall something about this previously)

='MT4'|BID!GBPUSD

No more ideas :-(

GL

M.
Thanks futurespec , I have tried everything I could think of also... If there is anyone who has this type of transfer working on their Excel spreadsheet and would feel comfortable sharing in detail how they got it to work , please submit Thank you very much....
0 traders viewing now