Metatrader to Excel and back | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 612 replies

Connecting two Metatrader to Excel with DDE ? 22 replies

MetaTrader and Excel using DDE 8 replies

Metatrader + Excel 1 reply

Looking for Help with using Excel and MetaTrader 4 5 replies

Attachments: Metatrader to Excel and back
Exit Attachments

Metatrader to Excel and back

  • #1
  • First Post: Jun 19, 2017 5:48pm Jun 19, 2017 5:48pm
It's simple really.

1. Put MetatraderToExcel.mqh in your include folder
2. Put test dll.mq4 in your experts folder
3. Put the dll contained in the zip file in your libraries folder (the libraries folder under your MQL4 directory).
4. Review the test dll.mq4 file.

There are 3 "put" functions and 3 "get" functions. Each with 3 overloads. The overloads are on how you want to address each cell.

The 2 inputs that are used is:

1. Where is the excel file you're going to be writing to
2. Where do you want to write any errors the DLL generates to

Some notes:

1. You need the full version of the .Net framework 4.6 installed (https://www.microsoft.com/en-us/down....aspx?id=48137)
2. When you run the "Start" function, it will open a new instance of Excel and a new instance of your file if it isn't already open.

Source code for the DLL can be found here: https://github.com/Nondisclosure/MT4toExcel

Have fun!
Attached File(s)
File Type: mqh MetatraderToExcel.mqh   9 KB | 2,892 downloads
File Type: mq4 test dll.mq4   3 KB | 2,755 downloads
File Type: zip MetatraderToExcel.zip   6 KB | 3,182 downloads
  • #2
  • Jun 20, 2017 11:08am Jun 20, 2017 11:08am
Quoting nondisclosure00
It's simple really. 1. Put MetatraderToExcel.mqh in your include folder 2. Put test dll.mq4 in your experts folder 3. Put the dll contained in the zip file in your libraries folder (the libraries folder under your MQL4 directory). 4. Review the test dll.mq4 file. There are 3 "put" functions and 3 "get" functions. Each with 3 overloads. The overloads are on how you want to address each cell. The 2 inputs that are used is: 1. Where is the excel file you're going to be writing to 2. Where do you want to write any errors the DLL generates to Some notes:...
Wow, this is really awesome! Thanks for sharing!
  • #3
  • Jun 20, 2017 12:20pm Jun 20, 2017 12:20pm
Quoting Nicholishen
{quote} Wow, this is really awesome! Thanks for sharing!
Thanks! And you're welcome!
  • #4
  • Oct 27, 2017 9:31am Oct 27, 2017 9:31am
Hi, thanks for your awesome work..

This is the best solution i ever had, but i have problem with error "Unhandled exception 0xE0434352".

the error occur when i try with windows10(can't install .Net framework 4.6), then i try to my second notebok win7 with .Net framework 4.6 it do a great job. but the error still occur if i click at excel cells or delete some data.

Is there any way to counter this error?Please help me, really need this ea.

sorry for my broken english
Attached File(s)
File Type: mq4 testdll.mq4   7 KB | 724 downloads
  • #5
  • Oct 27, 2017 11:22am Oct 27, 2017 11:22am
hello, can you pls put me through on how l can achieve this.
If possible diagram or image to explain better.
  • #6
  • Oct 27, 2017 9:52pm Oct 27, 2017 9:52pm
sorry, it running well at win10.. just need to make sure don't click anything at cells when data being transfer, if not the error will occur.

last question, is it possible to do something like this

if(GetDouble("Sheet1","B1")!=iOpen(Symbol(), 0, 0)){PutDouble(iOpen(Symbol(), 0, 0),"Sheet1","B1");}

I got about 300 data to transfer to excel, it take about 10-20sec to transfer all data. Main idea code above is when the data at excel same as before don't update, just update changes data only.. It is possible? already try this, same error occur "Unhandled exception 0xE0434352" & uninit reason8.
  • #7
  • Oct 28, 2017 1:59pm Oct 28, 2017 1:59pm
Nevermind solved the problem.. For GET function just need to make sure excel cells not blank. To get string, need to make sure excel cell have some word, and for int and double pls make sure at cell got some number in there..

Thanks again for sharing your awesome work
  • #8
  • Nov 2, 2017 12:14pm Nov 2, 2017 12:14pm
Sorry gang. Just came into this thread. Let me get caught up.

FF never sent me emails that people were posting.
  • #9
  • Nov 2, 2017 12:15pm Nov 2, 2017 12:15pm
Quoting WanHuzaifah
Hi, thanks for your awesome work.. This is the best solution i ever had, but i have problem with error "Unhandled exception 0xE0434352". the error occur when i try with windows10(can't install .Net framework 4.6), then i try to my second notebok win7 with .Net framework 4.6 it do a great job. but the error still occur if i click at excel cells or delete some data. Is there any way to counter this error?Please help me, really need this ea. sorry for my broken english {file}
That's a generic Windows error. You're getting from not having .Net framework 4.6 installed.
  • #10
  • Nov 2, 2017 12:16pm Nov 2, 2017 12:16pm
Quoting sesikaz
hello, can you pls put me through on how l can achieve this. If possible diagram or image to explain better.
Achieve what exactly?
  • #11
  • Nov 2, 2017 12:19pm Nov 2, 2017 12:19pm
Quoting WanHuzaifah
Nevermind solved the problem.. For GET function just need to make sure excel cells not blank. To get string, need to make sure excel cell have some word, and for int and double pls make sure at cell got some number in there.. Thanks again for sharing your awesome work
Thanks for sharing the info!
  • #12
  • Nov 2, 2017 12:46pm Nov 2, 2017 12:46pm
Quoting nondisclosure00
It's simple really. 1. Put MetatraderToExcel.mqh in your include folder 2. Put test dll.mq4 in your experts fold..................un! {file} {file} {file}
Super work Is it possible to get data from MT5 platform to excel and back fill to Mt4 (old disconnected from mt4 server) platform?

Any arrangement possible to export any live market data available in excel , back-fill to Mt4 ( older disconnected from server version) ?

Just Curious.
  • #13
  • Nov 2, 2017 1:05pm Nov 2, 2017 1:05pm
Quoting johnston
{quote} Super work Is it possible to get data from MT5 platform to excel and back fill to Mt4 (old disconnected from mt4 server) platform? Any arrangement possible to export any live market data available in excel , back-fill to Mt4 ( older disconnected from server version) ? Just Curious.
I don't think so. You're talking about 2 separate and different instances of terminal.exe reaching into the same object (excel). But I could be wrong.
  • #14
  • Nov 2, 2017 1:59pm Nov 2, 2017 1:59pm
Hi,

Can you please help with sending back and forth time - time[0]. Please help.

Looking forward to your favorable reply.

Thanks,
Prem
  • #15
  • Nov 2, 2017 2:37pm Nov 2, 2017 2:37pm
Quoting sspremj
Hi, Can you please help with sending back and forth time - time[0]. Please help. Looking forward to your favorable reply. Thanks, Prem
You can use any of the PutStr methods. You just need to convert the time to a string in MQL4. I think it's TimeToString() or TimeToStr() or something like that.
  • #16
  • Nov 3, 2017 2:42am Nov 3, 2017 2:42am
Hi Nondisclosure00,

Thanks for the idea.
  • #17
  • Nov 3, 2017 5:12pm Nov 3, 2017 5:12pm
Quoting sspremj
Hi Nondisclosure00, Thanks for the idea.
You're welcome.
  • #18
  • Nov 3, 2017 5:45pm Nov 3, 2017 5:45pm
Any idea how can i update excel only when the data change.. it still lag if got many data export to excel..already tried if get(excel value) not same with now(value on ea) then put(update excel)..still same
  • #19
  • Nov 13, 2017 3:14pm Nov 13, 2017 3:14pm
Quoting WanHuzaifah
Any idea how can i update excel only when the data change.. it still lag if got many data export to excel..already tried if get(excel value) not same with now(value on ea) then put(update excel)..still same
Inside of MQL4, create a "last"variable.

Example.
Inserted Code
double CloseLast=0.0;
if(Close[0]!=CloseLast)
{
   //Update Excel with whatever method you're using
   CloseLast=Close[0]
}
  • #20
  • Jan 22, 2018 11:20am Jan 22, 2018 11:20am
Hello

Does this work in MT4 or MT5?

I had the "Unhandled exception 0xE0434352" error even though I have the latest .Net framework (running windows 7),

I then thought this may only work in MT5, but I cannot see the indicator appear in the experts list.

Thanks
0 traders viewing now