• Home
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • User/Email: Password:
  • 7:42pm
Menu
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • 7:42pm
Sister Sites
  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 600 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

  • Platform Tech
  • /
  • Reply to Thread
  • Subscribe
  • 20
Attachments: Metatrader to Excel and back
Exit Attachments
Tags: Metatrader to Excel and back
Cancel

Metatrader to Excel and back

  • Last Post
  •  
  • 1 Page 23456 7
  • 1 Page 234 7
  •  
  • Post #21
  • Quote
  • Jan 22, 2018 1:34pm Jan 22, 2018 1:34pm
  •  nondisclosure00
  • Joined Apr 2007 | Status: Gettin' kick in the nutz every day! | 835 Posts
Quoting newpips
Disliked
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
Ignored
The DLL will work with either version. However, the indicator was written for MT4.
 
 
  • Post #22
  • Quote
  • Edited 11:52am Jan 23, 2018 11:40am | Edited 11:52am
  •  newpips
  • | Joined Jul 2010 | Status: Member | 6 Posts
Hi nondisclosure00

I have attached a screenshot of the error message I am receiving.

I have followed your instructions and copied the files into their respective folders (mt4), I have also tried to download the latest .Net framework and the installation would not proceed as I already have an up to date version.

Is there anything that I might be missing? I have enabled .dll imports, autotrading etc

Thanks
Attached Image (click to enlarge)
Click to Enlarge

Name: test dll 1.JPG
Size: 161 KB
 
 
  • Post #23
  • Quote
  • Jan 23, 2018 12:19pm Jan 23, 2018 12:19pm
  •  nondisclosure00
  • Joined Apr 2007 | Status: Gettin' kick in the nutz every day! | 835 Posts
Quoting newpips
Disliked
Hi nondisclosure00 I have attached a screenshot of the error message I am receiving. I have followed your instructions and copied the files into their respective folders (mt4), I have also tried to download the latest .Net framework and the installation would not proceed as I already have an up to date version. Is there anything that I might be missing? I have enabled .dll imports, autotrading etc Thanks {image}
Ignored
Make sure your Book1.xlsx and Log.txt exist first.

The error is a generic .Net file system error. It could be anything from it can't find the files to you don't have access to said files, etc.

I have re-compiled the code for the latest .Net versions. But the source for the DLL is out on GitHub. You can download and compile it for the latest version.
 
 
  • Post #24
  • Quote
  • Jan 23, 2018 12:20pm Jan 23, 2018 12:20pm
  •  newpips
  • | Joined Jul 2010 | Status: Member | 6 Posts
Quoting nondisclosure00
Disliked
{quote} Make sure your Book1.xlsx and Log.txt exist first. The error is a generic .Net file system error. It could be anything from it can't find the files to you don't have access to said files, etc. I have re-compiled the code for the latest .Net versions. But the source for the DLL is out on GitHub. You can download and compile it for the latest version.
Ignored
That must be why, those files don't exist. Thank you for the quick response, I will try again tomorrow
 
 
  • Post #25
  • Quote
  • Edited 10:38am Jan 24, 2018 4:32am | Edited 10:38am
  •  newpips
  • | Joined Jul 2010 | Status: Member | 6 Posts
Quoting newpips
Disliked
{quote} That must be why, those files don't exist. Thank you for the quick response, I will try again tomorrow
Ignored
Seems to be working now.
 
 
  • Post #26
  • Quote
  • Jan 24, 2018 1:20pm Jan 24, 2018 1:20pm
  •  nondisclosure00
  • Joined Apr 2007 | Status: Gettin' kick in the nutz every day! | 835 Posts
Quoting newpips
Disliked
{quote} Seems to be working now.
Ignored
You're welcome.
 
 
  • Post #27
  • Quote
  • Apr 29, 2018 4:36pm Apr 29, 2018 4:36pm
  •  jamthejame
  • | Joined Feb 2018 | Status: Member | 23 Posts
Hi,

I recently decided to run MT4 on Linux as it seems to work much better than on any Windows. However, I took Excel 2003 and wanted to get excellink.dll to work, but experienced some issues. Wine emulated Win 7 OS.

Everything, I start MT4, it works great no issues, but the minute I initiate EA for excel link, it opens Excel and then both programs crash. Is there a reason why something like that would be happening? Also, on what excel, windows os and mt version would the given excellink.dll work best. Perhaps there are some compatibility issues. Thank you and look forward to reply.

P.S. Created Book1 and Log files.
 
 
  • Post #28
  • Quote
  • May 16, 2018 3:33pm May 16, 2018 3:33pm
  •  nondisclosure00
  • Joined Apr 2007 | Status: Gettin' kick in the nutz every day! | 835 Posts
Quoting jamthejame
Disliked
Hi, I recently decided to run MT4 on Linux as it seems to work much better than on any Windows. However, I took Excel 2003 and wanted to get excellink.dll to work, but experienced some issues. Wine emulated Win 7 OS. Everything, I start MT4, it works great no issues, but the minute I initiate EA for excel link, it opens Excel and then both programs crash. Is there a reason why something like that would be happening? Also, on what excel, windows os and mt version would the given excellink.dll work best. Perhaps there are some compatibility issues....
Ignored
From the first post:
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)

....And Excel 2003 won't work either.

This is a Windows OS and Excel 2013 minimum work.
 
 
  • Post #29
  • Quote
  • Jun 8, 2018 11:17am Jun 8, 2018 11:17am
  •  aearle1
  • | Joined Jun 2018 | Status: Member | 6 Posts
Quoting nondisclosure00
Disliked
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:...
Ignored
Hi there, thanks for the help. I am looking for the 'open', 'high', 'low' & 'close' as well as 'volume' all to be displayed on my excel sheet with the choice of changing the time frame say with a drop down choice menu. (change from 1m data to 1h data). Does your instructions do this? If so please could you explain to me where the 'include folder' is, thanks
 
 
  • Post #30
  • Quote
  • Jun 8, 2018 4:56pm Jun 8, 2018 4:56pm
  •  aearle1
  • | Joined Jun 2018 | Status: Member | 6 Posts
So I have finally got this all up and running, however, the StringConcatenate function on allows up to 63 pieces of data, I am looking for more. Does anyone have any ideas what I can replace it with and how I would go about it? Thanks
 
 
  • Post #31
  • Quote
  • Jun 11, 2018 12:52pm Jun 11, 2018 12:52pm
  •  aearle1
  • | Joined Jun 2018 | Status: Member | 6 Posts
Quoting nondisclosure00
Disliked
{quote} From the first post: 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) ....And Excel 2003 won't work either. This is a Windows OS and Excel 2013 minimum work.
Ignored
So I am having some very frustrating issues with this. I am repeating the StringCon... now to get all of my data onto excel (more than 63). However, excel is not always getting all the information for some reason. From time to time it gets all of the information but the majority of the time it is showing excel as a blank doc or partially filled.
Image 1 shows the rare occasion it is collecting all the info, image 2 shows what happens the majority of the time. Pleasseeee help me
Attached Images
 
 
  • Post #32
  • Quote
  • Jun 11, 2018 12:53pm Jun 11, 2018 12:53pm
  •  aearle1
  • | Joined Jun 2018 | Status: Member | 6 Posts
Quoting jamthejame
Disliked
Hi, I recently decided to run MT4 on Linux as it seems to work much better than on any Windows. However, I took Excel 2003 and wanted to get excellink.dll to work, but experienced some issues. Wine emulated Win 7 OS. Everything, I start MT4, it works great no issues, but the minute I initiate EA for excel link, it opens Excel and then both programs crash. Is there a reason why something like that would be happening? Also, on what excel, windows os and mt version would the given excellink.dll work best. Perhaps there are some compatibility issues....
Ignored
What was the fix for this error. I am not having excel crash but only load part of the data
 
 
  • Post #33
  • Quote
  • Jun 11, 2018 1:10pm Jun 11, 2018 1:10pm
  •  aearle1
  • | Joined Jun 2018 | Status: Member | 6 Posts
Quoting aearle1
Disliked
{quote} So I am having some very frustrating issues with this. I am repeating the StringCon... now to get all of my data onto excel (more than 63). However, excel is not always getting all the information for some reason. From time to time it gets all of the information but the majority of the time it is showing excel as a blank doc or partially filled. Image 1 shows the rare occasion it is collecting all the info, image 2 shows what happens the majority of the time. Pleasseeee help me {image} {image}
Ignored
Below is the Log file
Attached File(s)
File Type: txt Log.txt   38 KB | 467 downloads
 
 
  • Post #34
  • Quote
  • Jul 16, 2018 1:21pm Jul 16, 2018 1:21pm
  •  nondisclosure00
  • Joined Apr 2007 | Status: Gettin' kick in the nutz every day! | 835 Posts
Quoting aearle1
Disliked
{quote} Below is the Log file {file}
Ignored
Do one line per StringCon...

Also, I haven't tried putting multiple lines in one StringCon.. to send over to Excel. I wouldn't try it.
 
 
  • Post #35
  • Quote
  • Jul 16, 2018 1:22pm Jul 16, 2018 1:22pm
  •  nondisclosure00
  • Joined Apr 2007 | Status: Gettin' kick in the nutz every day! | 835 Posts
Quoting aearle1
Disliked
{quote} Hi there, thanks for the help. I am looking for the 'open', 'high', 'low' & 'close' as well as 'volume' all to be displayed on my excel sheet with the choice of changing the time frame say with a drop down choice menu. (change from 1m data to 1h data). Does your instructions do this? If so please could you explain to me where the 'include folder' is, thanks
Ignored
If you're talking a drop down in Excel and then back to Metatrader, I don't see why not. I haven't done it. You just read a cell's value.
 
 
  • Post #36
  • Quote
  • Nov 11, 2018 4:03am Nov 11, 2018 4:03am
  •  davood13
  • | Joined Jun 2015 | Status: Falling | 234 Posts
Quoting nondisclosure00
Disliked
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:...
Ignored

Hi, thanks for sharing it.
it's my first time using expert and i don't know how to use this.
i just want to export simple moving average indicator to excel or CSV file.

i go through your tips and create a txt file named "log" and excel file named "book1" but still i get this error (test dll not initialized and unhandled exception)
And falling's just another way to fly...
 
 
  • Post #37
  • Quote
  • Nov 12, 2018 11:33am Nov 12, 2018 11:33am
  •  nondisclosure00
  • Joined Apr 2007 | Status: Gettin' kick in the nutz every day! | 835 Posts
Quoting davood13
Disliked
{quote} Hi, thanks for sharing it. it's my first time using expert and i don't know how to use this. i just want to export simple moving average indicator to excel or CSV file. i go through your tips and create a txt file named "log" and excel file named "book1" but still i get this error (test dll not initialized and unhandled exception)
Ignored
Post your mq4 code and we can take a look.
Also, make sure you've enabled DLL use in metatrader.
Attached Image
 
 
  • Post #38
  • Quote
  • Dec 4, 2018 2:35pm Dec 4, 2018 2:35pm
  •  kishan7029
  • | Joined Dec 2018 | Status: Junior Member | 1 Post
i want live data from mt5 to excel please help nondisclosure007
 
 
  • Post #39
  • Quote
  • Jan 4, 2019 4:41pm Jan 4, 2019 4:41pm
  •  nondisclosure00
  • Joined Apr 2007 | Status: Gettin' kick in the nutz every day! | 835 Posts
Quoting kishan7029
Disliked
i want live data from mt5 to excel please help nondisclosure007
Ignored
I haven't tried it in MT5, but I don't see a reason why you couldn't.
 
 
  • Post #40
  • Quote
  • Apr 17, 2019 5:58pm Apr 17, 2019 5:58pm
  •  Hambone
  • | Joined Oct 2015 | Status: Member | 87 Posts
Hi nondisclosure00: Thanks for posting these tools. Very helpful thus far. Got them installed and working on Windows 10. The EA writes the data to the excel file just fine as long as the datafile remains untouched. If I reference the cells that are receiving the "put" values from another tab in the worksheet, the updates stop with the following recorded to the log file:

Error on PutDouble_Cell: System.Runtime.InteropServices.COMException (0x800AC472): Exception from HRESULT: 0x800AC472
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.set_Value(Object RangeValueDataType, Object A_2)
at MetatraderToExcel.Class1.PutDouble_Cell(Double dbl, String shts, String cell)

Several questions:
1. Why does this happen and how can it be overcome?
2. Do you have the code in the MetradertoExcel.dll configured to retry the write if an error is thrown?

Thanks for any insights to help resolve this problem.
 
 
  • Platform Tech
  • /
  • Metatrader to Excel and back
  • Reply to Thread
    • 1 Page 23456 7
    • 1 Page 234 7
0 traders viewing now
  • More
Top of Page
  • Facebook
  • Twitter
About FF
  • Mission
  • Products
  • User Guide
  • Media Kit
  • Blog
  • Contact
FF Products
  • Forums
  • Trades
  • Calendar
  • News
  • Market
  • Brokers
  • Trade Explorer
FF Website
  • Homepage
  • Search
  • Members
  • Report a Bug
Follow FF
  • Facebook
  • Twitter

FF Sister Sites:

  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Forex Factory® is a brand of Fair Economy, Inc.

Terms of Service / ©2023