Export to Excel in Real Time

Hi Simnz,

You can possibly use the IB API to generate .hst offline charts for MT4. This will not allow trading operations though, for that you will need an EA that can also talk to the API. That is all I can think of, maybe someone else has a better idea.

Regards

I am specificallly intrested in pulling CME options Open Interest data for analysing in MT4 environment.
Not trading.

In that case using the IB API to create offline charts in MT4 would be the way to do it.

Hi Wanderer272,

Do you know by any case that the excel library is still working with the last version of MT4.

I am getting DdeConnect error: 0x4006 (16390):

1. A parameter failed to be validated by the DDEML. Some of the possible causes follow:
2. The application used a data handle initialized with a different item name handle than was required by the transaction.
3. The application used a data handle that was initialized with a different clipboard data format than was required by the transaction.
4. The application used a client-side conversation handle with a server-side function or vice versa.
5. The application used a freed data handle or string handle.
6. More than one instance of the application used the same object.

Do you know ways I can explore for a solution?

Best Regards

Hi @sangmane,

This DDE solution does not work anymore, and I don't know why. The DDE init fails at some point, probably at:
DdeConnect(idInst, iService, iSheet, 0);

I just don't know how to solve it.
Can you assist?

hi dear
i need to ea or indicator for export the pivot's of the symbols.
could you help me?

i have a question concerning the original post in this thread.. if i were to download the two files in the original post, one of which is a compiled EX4 file, isnt that a really really huge security risk to run an ex4 file that i dont know what the source code really does?

a compiled ex4 file could contain any kind of raw windows system calls, it could read and write any file on my computer and it could also open up a back door into my computer, and since probably most firewall systems have already been given the green light to allow metatrader to communicate in and out of my computer, a renegade ex4 file could absolutely violate my computer system's security defenses.

is this true or not?

EDIT: if this is true, then it is a security risk to run any metatrader bot for which you do not possess the source code.

Does is have ExcelRead function also? Thanks