Job finished
Specification
I require an expert advisor to take and close positions from a MySQL server table, the idea is: from a table of positions available in MySQL server, the expert advisor connect and consume this to open and close positions, continuously, with more details :
The table is arranged in MySQL server contains the following fields :
1) Order_id : an identifier of the order is taken
2) pair_name : symbol eg EURUSD parity
3) TIME_ID : minute registration time and date in which to take the position
4) ammount : Number of items to put in the position
5 ) sl : stop loss
6) tp : yake profit
7) state: the state of the position is open or closed
8) ticket: Ticket registration platform that is thrown when a position is taken
9) mode_id Identifies the model from which the position was defined .
fields 1 , 2, 3 , 4, 5 , 6 and 9 will be completed based on the work of modeling with other packages , but the fields 7 and 8 will be completed by the expert advisor , it is important to clarify that the table must feed every minute , so that few second after the table is updated in their fields 1-6 and 9 (which is done every 60 seconds ), the expert advisor must complete the fields 7 and 8 should also do so every 60 seconds . With the above table for each record contains an order to buy or sell .
Importantly, a position must be closed (apart from reaching the SL or TP ) through an opposite order , ie if at first an order to buy is thrown and misses the SL or TP , and the next minute the table adds another record amount of same parity and generate an effect of closing the position initially taken .
i have a code, but dont work.