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

[mohammad1001362]

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?

[[Deleted]]

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

[mohammad1001362]

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

[William Roeder]

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.

[Alain Verleyen]

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.