Hello , to whom may concern ,
I want to connect my excel files with FXCM MT4 's DDE server .
I had tick enable DDE server and allow my FXCM MT4 to run , but the data is not coming to my excel .
Here's what I type in my excel column , example ='MT4'|BID!GBPJPY ; the data is not coming to my excel files.
I had also tried running FXCM MT4 as administrator , that didn't work out either .
I saw that it is possible to do it with ForexConnect API , however I also need the COM files as I will be using excel's VBA ( I read this here http://fxcodebase.com/wiki/index.php/Us ... ect_in_COM)
I'd downloaded and installed ForexConnectAPI-1.3.0-win32 and also ForexConnectAPI-1.1.3-win32-COM
My problem now is 3 main thing .
1) How do I login with excel using forexconnect
2) How do I retrieve current live data to excel using forexconnect ( Like the one I mention above , but it should bit a slight different )
3) How do I get historical data to excel using forexconnect , is it possible for this historical data which had export to my excel files to refresh it AUTOMATICALLY every given time ( Let say I wanted to retrieve previous hour data from mt4 , can it overwrite the old data replace in with the new one automatically ? )
I hope I had explain my situation well .
Thank you .