Metatrader to Excel and back | Page 5 | 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

  • #81
  • Jan 28, 2020 1:03pm Jan 28, 2020 1:03pm
Quoting hatef3000
Hi nondisclosure00 Is it possible for you to provide an option to run an excel macro from MQL? or enlighten me a little how to edit the dll file in order to add more option to it?
I don't know. But look in the first post of this thread, there's a link to the source code for the dll you can download and edit for your own use.
  • #82
  • Edited 3:18pm Jan 28, 2020 3:07pm | Edited 3:18pm
Hi,

I just wanted to know if this tool would work like downloading historical data from stock quotes (D1 data) first manually and then modify the fields or column accordingly. OR I import via excel scripting to format just like the excel column fields produced by this tool. And then, use this tool to import the stock data (as offline data) on to any pair that I don't trade (e.g. USDHKD, USDTRY, etc...).

As far as I know, MT4 can't create a custom instrument/pair for offline analysis but for custom timeframes (e.g. H2, H3, H8... etc.) you can.

The idea is to have my own setup tools for technical analysis (of a stock) that are available only for MT4.

Example of stock historical:
https://finance.yahoo.com/quote/AAPL/history?p=AAPL

Thanks
Since Frank Sinatra sings in his own way, my chart sing... I did it, my way
  • #83
  • Jan 29, 2020 9:32am Jan 29, 2020 9:32am
Quoting v2vboni
Hi, I just wanted to know if this tool would work like downloading historical data from stock quotes (D1 data) first manually and then modify the fields or column accordingly. OR I import via excel scripting to format just like the excel column fields produced by this tool. And then, use this tool to import the stock data (as offline data) on to any pair that I don't trade (e.g. USDHKD, USDTRY, etc...). As far as I know, MT4 can't create a custom instrument/pair for offline analysis but for custom timeframes (e.g. H2, H3, H8... etc.) you can. The...
As far as downloading historical data, you'd have to do a 'for' loop in your mql code.

As far as everything else, no.
  • #84
  • Feb 14, 2020 7:36am Feb 14, 2020 7:36am
Quoting hatef3000
Hi nondisclosure00 Is it possible for you to provide an option to run an excel macro from MQL? or enlighten me a little how to edit the dll file in order to add more option to it?
Hi,

You can make a macro run by hooking onto the Worksheet_Calculate event. All you need to do is force a calculation of sort when Excel updates, and use the sub Worksheet_Calculate to execute any macro code. You need to know a bit of VBA though. No change to the dll required.
  • #85
  • Feb 14, 2020 9:27am Feb 14, 2020 9:27am
Quoting Wanderer272
{quote} Hi, You can make a macro run by hooking onto the Worksheet_Calculate event. All you need to do is force a calculation of sort when Excel updates, and use the sub Worksheet_Calculate to execute any macro code. You need to know a bit of VBA though. No change to the dll required.
Thanks.
  • #86
  • Feb 18, 2020 12:31am Feb 18, 2020 12:31am
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:...

Interesting.
  • #87
  • Feb 19, 2020 4:44am Feb 19, 2020 4:44am
Quoting nondisclosure00
{quote} I don't know. But look in the first post of this thread, there's a link to the source code for the dll you can download and edit for your own use.
Hi nondisclosure00
I downloaded the source code which you mentioned and without any changes I compiled it to dll. the size of new dll is 16 kb which is less than yours( the size of dll in the first post is 18 kb). the new one also does not work. it seems something ( maybe a file) is missed in the sorce code. could you please check this problem?
Thanks
  • #88
  • Feb 19, 2020 9:15am Feb 19, 2020 9:15am
Quoting hatef3000
{quote} Hi nondisclosure00 I downloaded the source code which you mentioned and without any changes I compiled it to dll. the size of new dll is 16 kb which is less than yours( the size of dll in the first post is 18 kb). the new one also does not work. it seems something ( maybe a file) is missed in the sorce code. could you please check this problem? Thanks
I downloaded the source code and re-compiled. Tested, works fine here.
  • #89
  • Feb 20, 2020 4:43am Feb 20, 2020 4:43am
Quoting nondisclosure00
{quote} I downloaded the source code and re-compiled. Tested, works fine here.
Thanks for the good job and your prompt reply.
  • #90
  • Mar 12, 2020 10:32am Mar 12, 2020 10:32am
Hi,

Just downloaded this and tried it but not suceeded

My log states
Error on PutDouble_Cell: System.Runtime.InteropServices.COMException (0x8002000B): Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
at Microsoft.Office.Interop.Excel.Sheets.get__Default(Object Index)
at MetatraderToExcel.Class1.PutDouble_Cell(Double dbl, String shts, String cell)

which doesn't help me !

Obviously it opened the log.txt (with above) and opened the Book1 but then failed with the error
2020.03.12 15:20:38.986 Unhandled exception 0xE0434352
2020.03.12 15:20:38.797 test dll EURUSD,H1: initialized

I run Windows 10 Pro and Office / Excel 2016

any help appreciated
  • #91
  • Mar 12, 2020 11:15am Mar 12, 2020 11:15am
Quoting peterhw
Hi, Just downloaded this and tried it but not suceeded My log states Error on PutDouble_Cell: System.Runtime.InteropServices.COMException (0x8002000B): Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) at Microsoft.Office.Interop.Excel.Sheets.get__Default(Object Index) at MetatraderToExcel.Class1.PutDouble_Cell(Double dbl, String shts, String cell) which doesn't help me ! Obviously it opened the log.txt (with above) and opened the Book1 but then failed with the error 2020.03.12 15:20:38.986 Unhandled exception 0xE0434352 2020.03.12...
paste your call to PutDouble_Cell in here.
  • #92
  • Mar 12, 2020 12:37pm Mar 12, 2020 12:37pm
Hi

Apologies - I tried changing the sheet name and forget to change back to Sheet1
Thanks for you help
  • #93
  • Mar 18, 2020 4:46am Mar 18, 2020 4:46am
Hi nondisclousre00
Thanks again for both this valuable work and the time you spend for the questions. I installed the latest version of visual studio 2019 (.NET framework 4.7.03056) and tried to compile the source code. But the Class1.cs file produces many errors. I’ll appreciate if you can guide me to solve this problem. please see attached Screenshot.
Thanks!
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 342 KB
  • #94
  • Mar 18, 2020 10:24am Mar 18, 2020 10:24am
Quoting hatef3000
Hi nondisclousre00 Thanks again for both this valuable work and the time you spend for the questions. I installed the latest version of visual studio 2019 (.NET framework 4.7.03056) and tried to compile the source code. But the Class1.cs file produces many errors. I’ll appreciate if you can guide me to solve this problem. please see attached Screenshot. Thanks! {image}
I think it's Ctrl-F5 to update/get the Nuget packages. I have a couple in there. VS quit getting them automatically a few revisions back.
  • #95
  • Edited 6:25am Mar 22, 2020 4:15am | Edited 6:25am
Dear nondisclousre00
based on your guidance I installed the missing packages and the related errors are solved now but as it's indicated in the attached screen shot, by pressing Ctrl-F5, new errors occurs (which i think are caused by coding). whats your opinion?
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot3.png Size: 319 KB
  • #96
  • Mar 22, 2020 6:08pm Mar 22, 2020 6:08pm
IG Markets has an Excel RTD.
  • #97
  • Mar 23, 2020 9:55am Mar 23, 2020 9:55am
Quoting hatef3000
Dear nondisclousre00 based on your guidance I installed the missing packages and the related errors are solved now but as it's indicated in the attached screen shot, by pressing Ctrl-F5, new errors occurs (which i think are caused by coding). whats your opinion? {image}
That depends on what you have your variable declared as. My guess is that excelWorksheet isn't declared as an excel worksheet object.
  • #98
  • Jun 19, 2020 2:17am Jun 19, 2020 2:17am
This is excellent! Thanks to the author!
How can I read and hide Excel without opening Excel on the display screen?
  • #99
  • Jun 19, 2020 3:56pm Jun 19, 2020 3:56pm
Quoting kourosh1347
This is excellent! Thanks to the author! How can I read and hide Excel without opening Excel on the display screen?
Honestly, I haven't looked at that.
  • #100
  • Jun 20, 2020 5:02am Jun 20, 2020 5:02am
Thanks for your reply. Is there a command to close Excel. And reopen the read and close.
0 traders viewing now