Is there a way import files or connect api to expert advisor?

New comment
 

Hi all

I need using strategy tester for back test results I have collected in excel file.

Is there a way reading excel file ?

How can I do that?

 
Hi, if you have results closed position in pips or cash you can filter in excel, just use formula. Regards Greg
 
Greg Pawlak:
Hi, if you have results closed position in pips or cash you can filter in excel, just use formula. Regards Greg

indeed I need somehow relate API or JASON files to metatrader ?

My goal is back testing of strategy tester .  as strategy tester works on  any ticket it is more accurate

 

mohammad1001362: Is there a way reading excel file ? How can I do that?

Excel is a binary, proprietary file format. Do you have its specification?

Instead save the spread sheet as CSV file and you can read it with the standard calls.

 
William Roeder:

Excel is a binary, proprietary file format. Do you have its specification?

William, Excel (xslx) is a XML format in a ZIP container, it's not binary and is an open format, it can be read/write directly with mql.

Handling ZIP Archives in Pure MQL5
Handling ZIP Archives in Pure MQL5
  • www.mql5.com
Once this article's author got attracted by an interesting feature of CryptDecode function, in particular its ability to decompress a ZIP array transferred to it. This modifier was introduced by the developers of MetaTrader 5 trading platform in order to extract answers from several servers using the standard WebRequest function. However, due...
New comment