Output test results to SQL database

New comment
 

I would like to run some strategy tests and output results to a SQL Database so that I can run some reports and see which ones are more profitable. Has anyone achieved this before?

Al 

 
Maka4Tune:

I would like to run some strategy tests and output results to a SQL Database so that I can run some reports and see which ones are more profitable. Has anyone achieved this before?

Al 

I don't think that will work.
 
Marco vd Heijden:
I don't think that will work.

Thanks for the relentless positivity. 

 Is it possible to send http requests, I could build something that receives values in a URL and writes it into a DB?

 
Maka4Tune:

Thanks for the relentless positivity. 

 Is it possible to send http requests, I could build something that receives values in a URL and writes it into a DB?

I meant the part about seeing which ones are more profitable.

More profitable in what sense ?

 

Hello,

I've used this library: https://www.mql5.com/en/articles/862

Uses SqLite database, wich works well if you run only one instance of the EA and write only one record at a time because it is mono user. The advantage is that it is easy to use.


And this one: https://www.mql5.com/en/forum/718

It works very well with multiple instances of the EA because it uses SQL Server database which is a robust db. More tricky, if you aren't experienced with databases, expect to put some efforts in learning, specially the connection. You also need to recompile the DLL if you use a 64 bit system.

SQL and MQL5: Working with SQLite Database
SQL and MQL5: Working with SQLite Database
  • 2014.04.18
  • o_O
  • www.mql5.com
This article is intended for developers who would be interested in using SQL in their projects. It explains the functionality and advantages of SQLite. The article does not require special knowledge of SQLite functions, yet minimum understanding of SQL would be beneficial.
 
twalk:

Hello,

I've used this library: https://www.mql5.com/en/articles/862

Uses SqLite database, wich works well if you run only one instance of the EA and write only one record at a time because it is mono user. The advantage is that it is easy to use.


And this one: https://www.mql5.com/en/forum/718

It works very well with multiple instances of the EA because it uses SQL Server database which is a robust db. More tricky, if you aren't experienced with databases, expect to put some efforts in learning, specially the connection. You also need to recompile the DLL if you use a 64 bit system.

That's awesome, thank you. Just what i was looking for :-) 

New comment
Reason: