EA to write MT4 statement to MySQL

Hello Coders,

I have requirement of a MT4 statement up-loader EA to MySQL. EA should update after certain time interval set in EA.

(1) Should write open orders and working orders in two different csv file (one for open orders and second for working orders) with date and time and this file remain on local PC only i.e. these orders don't need to be uploaded in MySQL. This date and time must be of MT4 terminal date and time, not desktop time. EA should write trades in these files on every update even if those ticket no. already written.

(2) Should write closed transactions in MySQL database (use username and password for authentication). During update, EA should check whether there is any new closed trade. If there is any new closed trade/s then EA should write these new closed trades in MySQL without altering already stored entries. EA should not alter any already written entries.

(3) On every update, EA should write balance, floating p/l, equity, margin, free margin, absolute dd., maximal dd., relative dd. in MySQL.

Database strata may be like this:

Metatrader4statement (main database)

====== Closed transactions (this will remain inside main database and include closed trades)

====== Info (this will also remain inside main database and include balance, floating p/l, equity, margin, free margin, absolute dd., maximal dd., relative dd.)