Wrong text format after a MT4 download in Excel

[Deleted] 2012.10.24 22:38

I have a fxcm metatrader system and using the mt4 version. The download is okay but I am facing problems with the format in my Excel sheet. When the value is above 1 like the eurusd the input has to be divided by 100.000 to achieve the right value. When the value is less then 1 like the usdcad then the input has the right value but it is formatted as a textvalue formula and it is impossible to do arithmetics on such a figure. The excel sheet generates a failure message like #value!. I hope there is a simple solution.

writing data to excel problem
Importing live data from MT4 to excel
Excel DDE syntax for using 'MT4|BID!....... in connection with an excel cell .... e.g. 'MT4'|BID!(B7) .... what syntax do i need to use?

phi nuts 2012.10.25 03:44 #1

Well, try this : open your historical data on a chart, press Ctrl + S to save it and see if excel can open it.

[Deleted] 2012.10.25 10:13 #2

phi.nuts:

Well, try this : open your historical data on a chart, press Ctrl + S to save it and see if excel can open it.

Sorry , but it is not a solution.

New comment