Техническое задание
Thinks are simple i need to parse the mt5 history to mysql database , this need to be done in real time ,
this article is what i need https://www.mql5.com/en/articles/5436.
This need to run as a EA , so if its the first time the EA is running they will need to collect all the history and parse to mysql db , and in case is not the first time they need to send just new changes.
So the EA need to be able to read the history in realtime and upload new data to mysql.
I already have this done but is in a primitive and very slow way , I automatic upload html report to my server and whit php i parse the html tags to my db , the problem whit this method are 2
first is the size of reports file is too big if i have too many reports to be read , the second is the slow , if i need to parse a very big html this take too long and is not optimal ,
So i need a ea to be able upload history data and also opened positions ( like the html report generated)
the open positions data need to have a timer so i can define in how much time i will allow the open positions to be sync whit the server.
the article i show in this post have the read structure done , and this will requiere a mysql integration to be able upload in the server
we can deal this in 2 ways , one we can directly upload to mysql server based on the timer and second we can create a python socket and parse in realtime the data on everytick.
both ways are fine for me , i dont need this to be realtime sync , if this can be 30 or 40 seconds delay or even 1 minute delay is not a problem , because this is just to show my investors how they account are growing and what is been done whit his money
is not a difficult task . All the code are in internet in the codebase , is just copypaste and code small adjusts to make this fit
servers for test and mysql db is ready so you dont need to spend in any structure for test this