Menu
Sister Sites

Options

Bookmark Thread

First Page First Unread Last Page Last Post

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

  • Post #1
  • Quote
  • First Post: May 3, 2015 11:45am May 3, 2015 11: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 | 830 downloads
File Type: mq4 ExcelExportTest.mq4   1 KB | 956 downloads
Tt was coded for MT4. Did it work on MT5?
Hi sangname
indeed it worked on MT4.
Can you help me to let it work on MT5?

Thx
let me try
Excel library for MT5 (export only)
Attached File(s)
File Type: ex5 sangmaneExcelLib.ex5   6 KB | 662 downloads
File Type: mq5 sangmaneExcelTest.mq5   < 1 KB | 705 downloads
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
Go to http://www.forexfactory.com/showthread.php?t=400606
I posted Excel Export for MT4.
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
Hi sangmane
any idea why it does not work?

Cheers
Fabio
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,043 downloads
File Type: ex4 ExcelExportLib.ex4   6 KB | 974 downloads
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
You're welcome

I'll make an Excel Lib for importing Excel into MT4 if I see there is sufficient demand for it
Hi sangmane,
may I contact you via private mail?
I want to talk about a project I have in mind

Cheers
Fabio
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
I post a job on Elance ;-)

Let me know if you got it

Thx
Fabio
Quoting Fabio69
I post a job on Elance ;-) Let me know if you got it Thx Fabio
I got it. Thanks!
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%
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
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
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 | 356 downloads
0 traders viewing now