How do you Export MT4 price to Excel?

Hi,

I like to know how do we export the real price (from mt4) BID and ASK to Excel?

You could write an EA to write to a csv file as often as you want. Take a look in the MetaEditor help file at the file functions (filewrite etc.)

Lux

http://www.metatrader.info/node/142
http://docs.mql4.com/files/FileWrite
http://docs.mql4.com/files/FileSeek
http://articles.mql4.com/44 (bottom of page)

Code example that attaches data to the end of a comma delimited excel file
Each write is a row entry. The file will be at .../experts/files/data.csv/
Without FileSeek file contents will be overwritten each time.
-------------------------------------------------------------------
int h1;
h1 = FileOpen("data.csv", FILE_CSV | FILE_WRITE | FILE_READ, ',');
FileSeek(h1, 0, SEEK_END);
FileWrite(h1, Bid, Ask, Close[1], Volume[1]);
FileClose(h1);

HI, maybe is on the topic...one question,

Does anybody know if you can export your open positions into excel? or some kind of base? To the base! From x MT4 to the base?? Any experience exporting from MT4??

thanks
http://cdn.forexfactory.com/images/misc/progress.gif

Hey!

This is a great method for saving live data information for the future, but is there a way to get also the history of ASK prices?

As far as I've seen you can easily export from metatrader the history of bid prices, but I haven't found a way to get the history of the ASK prices.

Since the build in mt4 strategy tester only work with fixed spread, I am trying to find a way to export both bid and ask historical prices and test my EA's externally.

Thanks!

MT4 saves the bid prices only. You would need to have a script/EA running continuously to capture the ask prices.

Hanover,

Is there any way for mt4 DDE to work with MSFT Excel 2007/2010 ?

It crashes on me whenever I port the formulas from 2003 to the new legacy format xlsx

=DDE("MT4";"BID";"GBPUSD")

Works fine for me.