Download MetaTrader 5

Problem importing ST EA to Excel

To add comments, please log in or register
Find out how to install MetaTrader on Mac OS
Marcelo Coutinho
1151
Marcelo Coutinho 2014.05.02 13:57 

Good Morning,

Have someone please experienced this ?

1. Run a Strategy Tester of some Expert Advisor

2 Get the results via OPTIMIZATION RESULTS tab

3. Export to XML MS Excel

4. Open Excel and import XM file and get the error below

Thanks in advance

Regards,

MRC


ERRO XML em Tabela
REASON:    Valor Inválido
FILE:    C:\Users\USUARIO\Desktop\ReportOptimizer-10001001.xml
GROUP:    Cell
TAG:    Data
VALUE:    -1.#IND

ERRO XML em Tabela
REASON:    Valor Inválido
FILE:    C:\Users\USUARIO\Desktop\ReportOptimizer-10001001.xml
GROUP:    Cell
TAG:    Data
VALUE:    -1.#IND

Rodrigo Malacarne
Moderator
9895
Rodrigo Malacarne 2014.05.02 14:04  
YouTrade:

Good Morning,

VALUE:    -1.#IND

Are you able to correctly see all optimization results? I mean, are you getting values for the optimization?

It would be interesting if you could attach screenshots to better describe the problem. 

Rogerio Figurelli
Moderator
39649
Rogerio Figurelli 2014.05.02 14:42  

Hi Marcelo,

Please try open direct the file C:\Users\USUARIO\Desktop\ReportOptimizer-10001001.xml using Excel.

There is any content? If so, can you share this file here?

As this is a XML file you can try opening it with Notepad or any other simple text editor to double check the content too. 

By the way, it always works fine for me, but this option is to export to a Open XML that in theory must be possible read in Excel.

Marcelo Coutinho
1151
Marcelo Coutinho 2014.05.02 14:56  
Malacarne:

Are you able to correctly see all optimization results? I mean, are you getting values for the optimization?

It would be interesting if you could attach screenshots to better describe the problem. 

Yes ... Values are okay.

Pictures attached

Files:
Capturar1.PNG 180 kb
Capturar2.PNG 87 kb
Marcelo Coutinho
1151
Marcelo Coutinho 2014.05.02 14:57  
figurelli:

Hi Marcelo,

Please try open direct the file C:\Users\USUARIO\Desktop\ReportOptimizer-10001001.xml using Excel.

There is any content? If so, can you share this file here?

As this is a XML file you can try opening it with Notepad or any other simple text editor to double check the content too. 

By the way, it always works fine for me, but this option is to export to a Open XML that in theory must be possible read in Excel.

It does not work ... Picture attached and file uploaded for you @ youtrade.pro.br/raiz/ReportOptimizer-10001001.xml

Files:
Capturar3.PNG 112 kb
Alain Verleyen
Moderator
30737
Alain Verleyen 2014.05.02 15:30  
YouTrade:

It does not work ... Picture attached and file uploaded for you @ youtrade.pro.br/raiz/ReportOptimizer-10001001.xml

Can you post or send by pm the xml file, so we can check if we are able to open it ?
Marcelo Coutinho
1151
Marcelo Coutinho 2014.05.02 15:34  
angevoyageur:
Can you post or send by pm the xml file, so we can check if we are able to open it ?
www.youtrade.pro.br/raiz/ReportOptimizer-10001001.xml
Marcelo Coutinho
1151
Marcelo Coutinho 2014.05.02 15:35  
YouTrade:

It does not work ... Picture attached and file uploaded for you @ youtrade.pro.br/raiz/ReportOptimizer-10001001.xml

www.youtrade.pro.br/raiz/ReportOptimizer-10001001.xml
Rogerio Figurelli
Moderator
39649
Rogerio Figurelli 2014.05.02 18:36  

Hi Marcelo, download of your url has no content, please Zip it and attach here as a file.

Are you saving this file in your local folder? If no, please try this and send exactly this file attached.

Looks like you are saving in a remote place and losing the content in some way.

Alain Verleyen
Moderator
30737
Alain Verleyen 2014.05.02 19:21  
figurelli:

Hi Marcelo, download of your url has no content, please Zip it and attach here as a file.

Are you saving this file in your local folder? If no, please try this and send exactly this file attached.

Looks like you are saving in a remote place and losing the content in some way.

Even, it crashes my Firefox when I clicked the link
Rodrigo Malacarne
Moderator
9895
Rodrigo Malacarne 2014.05.02 19:31  
The file is 64MB large... I'm trying to open it in Excel and I'm getting a "corrupt file" message.
12
To add comments, please log in or register