작업 종료됨
명시
I have many different MT4 accounts setup on different virtual servers. I would like to build a web based reporting system where I can see the P/L of all of them on the same page. I will create the web based system myself but I need someone to write me some code to automatically get the data from my mt4 accounts and insert them into MySQL (or upload it as an XML)
What I am looking for is:
To install the system on each of my MT4 accounts (each account on different vps and logged in 24/7).
To give details of MySQL (host name, db name, username, password) on each MT4 terminal.
To give a name or number to each of my mt4 terminals. This can be anything that I can recognize.
When the P/L balance changes on any of my MT4 terminals, the system inserts the date, time, name of the terminal, account balance and the P/L for that day, number of trades currently open and current DD into the MySQL database. (triggers every time the balance changes)
For everyday, it only enters 1 line in the database for each terminal. So, the first query should be an insert query and the ones after that must just update the balance for the same day until the date changes.
Date and time must be set to UK time (or the server time is ok too).
My MT4 terminals are up and running 24/7 but if for some reason they are down for a while, it should send an update to the database as soon as the terminal is back up and running.
Example of how the entries that are written to the database would look:
Date LastUpdate TerminalName PL Balance No of currently open trades Current DD or Profit for open trades
2017-02-17 13:15 Terminal 1 123.50 10000 5 -130.35
2017-02-17 17:15 Terminal 5 -135.40 9617 0 0.00
2017-02-17 11:55 Terminal 3 250.17 3788 9 -735.85
If MySQL connection is not possible, than uploading an xml file to a server I define is also acceptable. In that case I should be able to enter a different file name for each MT4 terminal or it can take the terminal name I define as the file name.
All codes will be uniquely created for myself with no reselling rights for the author.
Please give me a quotation.
Thank you