Export to Excel in Real Time - library for MetaTrader 4 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Exporting data from Metatrader into Excel in real time 33 replies

Export to Excel in Real Time 27 replies

Roffild's Library - Library for MQL5 (MetaTrader) with support 10 replies

[Excel] How to store time with real-time data? 0 replies

Boost Library Import Into Metatrader (MT4) Script File 1 reply

Attachments: Export to Excel in Real Time - library for MetaTrader 4
Exit Attachments

Export to Excel in Real Time - library for MetaTrader 4

  • #1
  • First Post: May 3, 2015 10:45am May 3, 2015 10:45am
On the old Mt4 build I used the script and libraries attached in order to export data from MT4 to excel (see attachments).

Now in mql5 I put:
ExcelExportLib under MQL4\Libraries and
ExcelexportTest under Script

It does not work anymore.

Can somebody help me ?

Thanks
Fabio
Attached File(s)
File Type: ex4 ExcelExportLib.ex4   6 KB | 1,003 downloads
File Type: mq4 ExcelExportTest.mq4   1 KB | 1,115 downloads
  • #2
  • May 3, 2015 11:41am May 3, 2015 11:41am
Tt was coded for MT4. Did it work on MT5?
  • #3
  • May 3, 2015 12:17pm May 3, 2015 12:17pm
Hi sangname
indeed it worked on MT4.
Can you help me to let it work on MT5?

Thx
  • #4
  • May 3, 2015 12:27pm May 3, 2015 12:27pm
let me try
  • #5
  • May 3, 2015 2:05pm May 3, 2015 2:05pm
Excel library for MT5 (export only)
Attached File(s)
File Type: ex5 sangmaneExcelLib.ex5   6 KB | 829 downloads
File Type: mq5 sangmaneExcelTest.mq5   < 1 KB | 915 downloads
  • #6
  • May 3, 2015 4:29pm May 3, 2015 4:29pm
Hi Sangmane,
I thank you very much, but this is mql5. I would like to have it for MT4 build 600 + (i.e.the build where mql5 was inserted).
May be I can include the files you sent me also on Mt4 build 600+?

Thx again
  • #7
  • May 3, 2015 6:49pm May 3, 2015 6:49pm
Go to http://www.forexfactory.com/showthread.php?t=400606
I posted Excel Export for MT4.
  • #8
  • May 4, 2015 2:35am May 4, 2015 2:35am
Hi sangmane,
first of all I want to thank you for your time.
I downloaded the ExcelExportLib and the ExcelExportTest for the new buil. Unfortunately it does not work: error : ExcelInit failed !!!!

Krgrds
Fabio
  • #9
  • May 5, 2015 9:28am May 5, 2015 9:28am
Hi sangmane
any idea why it does not work?

Cheers
Fabio
  • #10
  • May 5, 2015 11:20am May 5, 2015 11:20am
I reattached the files here.
1. Place ExcelExportTest.mq4 to Scripts folder
2. Place ExcelExportLib.ex4 to Libraries folder
3. Restart MT4
4. Make sure Excel is open, sheet name = Sheet1
5. Run ExcelExportTest script

What is your Excel language?
Attached File(s)
File Type: mq4 ExcelExportTest.mq4   1 KB | 1,177 downloads
File Type: ex4 ExcelExportLib.ex4   6 KB | 1,133 downloads
  • #11
  • May 5, 2015 11:35am May 5, 2015 11:35am
Hi sangmane
thanks a lot it WORKS

It should be very nice if you can make the ExcelLib also to read from Excel into MT4.

Can you try it ?

My best regards
Fabio
  • #12
  • May 5, 2015 12:00pm May 5, 2015 12:00pm
You're welcome

I'll make an Excel Lib for importing Excel into MT4 if I see there is sufficient demand for it
  • #13
  • May 5, 2015 4:32pm May 5, 2015 4:32pm
Hi sangmane,
may I contact you via private mail?
I want to talk about a project I have in mind

Cheers
Fabio
  • #14
  • May 6, 2015 2:26am May 6, 2015 2:26am
Quoting Fabio69
Hi sangmane, may I contact you via private mail? I want to talk about a project I have in mind Cheers Fabio
Fabio, you can hire me at Elance.com
  • #15
  • May 6, 2015 10:42am May 6, 2015 10:42am
I post a job on Elance ;-)

Let me know if you got it

Thx
Fabio
  • #16
  • May 6, 2015 10:56am May 6, 2015 10:56am
Quoting Fabio69
I post a job on Elance ;-) Let me know if you got it Thx Fabio
I got it. Thanks!
  • #17
  • Dec 20, 2017 3:10am Dec 20, 2017 3:10am
Quoting sangmane
You're welcome I'll make an Excel Lib for importing Excel into MT4 if I see there is sufficient demand for it
Hey sangmane,
I would really like also to import from Excel to MT4.
I've been searching all around for ways to do that but I cannot find any good ones.
I even tried writing an ExcelRead function, using DdeClientTransaction with other flags, but it didn't work.

Could you point me to the right direction?

By the way, I changed your ExcelWrite function to fit multiple characters transmission, it otherwise sent only the first char from the string.

Inserted Code
int ExcelRead(string CellAddress, string &CellValue)
{
int iItem = DdeCreateStringHandleW(idInst, CellAddress, 0);
char CellValueChar[256];
int iRet = DdeClientTransaction(CellValueChar, 256, iConv, iItem, CF_TEXT, XTYP_REQUEST, 1000, 0);
CellValue = CharArrayToString(CellValueChar);
Print("New value is: "+CellValue);
DdeFreeStringHandle(idInst, iItem);
return (iRet);
}
Thunder OM Flex Secondary All Time Return: -18.2%
  • #18
  • Apr 11, 2018 11:06am Apr 11, 2018 11:06am
I have the problem with me is not with excel
Everything is activated
Attached Image (click to enlarge)
Click to Enlarge Name: IMG_20180411_142444.jpg Size: 331 KB
  • #19
  • Nov 17, 2018 12:58am Nov 17, 2018 12:58am
Quoting sangmane
I reattached the files here. 1. Place ExcelExportTest.mq4 to Scripts folder 2. Place ExcelExportLib.ex4 to Libraries folder 3. Restart MT4 4. Make sure Excel is open, sheet name = Sheet1 5. Run ExcelExportTest script What is your Excel language? {file} {file}
Hello Sangmane,

I tried the script with MT4 ,the only output is I just have from Indonesia with love!

I just need to export the current chart OHLC to csv for some calculations.

Thanks

Ahmad
  • #20
  • May 16, 2020 2:37am May 16, 2020 2:37am
Hello, can you help me with this? I want my market scanner pro to be directed in my excel file that gives me the top 3 strong and weak currencies.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: CHFJPYm#H1.png Size: 45 KB
Click to Enlarge Name: USDJPYm#H1.png Size: 43 KB
Attached File(s)
File Type: xlsx Currency_Rev2--5ebe28e2d57e7.xlsx   25 KB | 505 downloads
0 traders viewing now