Data export to DB

[[Deleted]]

Maybe this helps someone :

The fastest way to export lots of values from metatrader is to build an Expert

and not to bind it directly to the database engine via DLL (for example MySQL),

but to write SQL queries like (alter,create table, insert row) to a file

and manually run mysql import.

Also, do not use a lot of string additions like "OPEN_M1"+iOpen()+"CLOSE_M1"+..+..+,

because I found out that this is really slowly in MetaTrader language and consumes much memory.

[I ran into 500MB of memory allocated by the terminal when using it and exporting data]

Hope this helps someone,

miro

[[Deleted]]

mkrsjak wrote >>

Maybe this helps someone :

The fastest way to export lots of values from metatrader is to build an Expert

and not to bind it directly to the database engine via DLL (for example MySQL),

but to write SQL queries like (alter,create table, insert row) to a file

and manually run mysql import.

Also, do not use a lot of string additions like "OPEN_M1"+iOpen()+"CLOSE_M1"+..+..+,

because I found out that this is really slowly in MetaTrader language and consumes much memory.

[I ran into 500MB of memory allocated by the terminal when using it and exporting data]

Hope this helps someone,

miro

I find this approach very useful and would like to have more details.

My goal is to export tick quotes from MT4 into a trade application built in VB6.

It apprears that quotes can be exported via DDE to VBa/Excel, However I'm using

VB6 not VBa. So it seems writing a text file from MT4 which is read by

VB6 is the best way to trasnfer the quotes from one application to another.

Do you have a script for an Expert that can wite quotes to a file?

John