EA with MySQL connection

MQL5 Experts Integração

Termos de Referência

I need an EA with the following features

  1. takes the news calendar into account - the robot does not enter the market in a 15 before and after a news release and does not trade at night from 10 p.m. to 4 a.m. (server time)

  2. on chart buttons/inputs, similar to SAFE EA: https://www.mql5.com/en/market/product/11738
    1. On/Off (iONOFF) – enable/disable the robot
    2. Sell (iSELL), Buy(iBUY) – by clicking Sell or Buy buttons, you can enable (green) or disable (red) opening a new order (position)
    3. x1 (iX2) – first-time lot increase (2-4 times). Any enabling of x1 will increase the lot once again. 
    4. x2 (iX14) – second-time lot increase (4-10 times).
    5. Coef. lot (iKLOT) – lot ratio (20 000 and higher) for defining the minimum (base) lot for opening a new order: minlot= BalanceValue / Coef. lot
    6. Pr1 (iPR1), Pr2 (iPR2)– minimum standard order closing points-pips (virtual TP, Pr1 – for a minimum lot, Pr2 – for a increased lot [see x1/x2])
    7. Drawdown (iDrawdown)– virtual SL in % of the balance (drawdown by funds), at which an order is closed


    8. Inputs only, not on chart:
      1. mysql address/ip
      2. mysql username
      3. mysql password
      4. mysql database_name
      5. mysql insert every x seconds
      6. mysql select every x seconds


  3. connect to a MySQL database and do the following steps, once every x seconds (we should be able to configure this as  from 0.1 to 100 seconds)
    1. do a MySQL query: INSERT query with the following values: symbol; date-time; ask price; bid price
    2. do a MySQL query: SELECT from a table using current symbol; time;
    3. based on the select result, the robot will:
        1. open a new order with the SL and TP from the mysql query, using iKLOT (see above)
        2. if an order already exists; based on mysql query:
          1. increase order lot size
          2. close order

  4. the robot will need to be able to calculate the lot size that will be increased - see x1 / x2. do some tests with SAFE EA to better understand the idea and approximate values

  5. your feedback, recommendations, experience, support and know-how are highly appreciated as we are doing this experiment for the first time

 

 

 

Some examples on how it will perform:

The robot is installed on multiple pairs and checks+sends data periodically to a MySQL server.

We will have a MySQL table where the robot writes the quotes (ask and bid price) for each pair he's configured on.


Table "market", with the following columns: symbol; datetime (downto microseconds); bid; offer; 

datetime= eg: 2015-07-01 00:00:16.919


We will have a MySQL table from where the robot reads what actions needs to do

Table "actions" with the following columns: symbol; datetime (downto seconds); action; predicted; increase

symbol= varchar for identifying a pair, eg: EURUSD

datetime= date and time for the prediction/action, has year-month-day hour-minute-seconds eg: 2015-07-01 00:00:16

action= can have the following values: buy sell wait

predicted= the predicted value of a pair. this value is used if the robot needs to increase the lot size in order to close the trade on profit if the market reaches the predicted value

increase= can have the following numeric values: 0 (do not increase) 1 (increase)

closenegative= can have the following numeric values: 0 (do not close trades) 1 (close trades)



Examples on how it needs to perform:

1. The robot reads from a MySQL table "actions", eg: SELECT * FROM actions WHERE datetime<=DATE_SUB(NOW(), INTERVAL 10 SECOND) AND symbol='EURUSD'

the return from the database, action is: buy

there are no open trades on "EURUSD" buy

the robot opens a new trade on EURUSD, the lot size is calculated using this formula: balance / Coef. lot (iKLOT)

the robot sets stop loss using the Drawdown value

the robot sets take profit using Pr1 value > profit of Pr1 pips


2. The robot reads from a MySQL table "actions"

the return from the database, action is: buy; increase=1

there is an open trade on "EURUSD" buy

the robot increases the lot size and uses the predicted to calculate how much to increase in order to close the trade on profit if the market reaches predicted value, by Pr2 pips


3. The robot reads from a MySQL table "actions"

the return from the database, action is: sell; closenegative=1

there is an open trade on "EURUSD" buy

the robot closes the trade even it it's on loss



 


    Respondido

    1
    Desenvolvedor 1
    Classificação
    (13)
    Projetos
    24
    42%
    Arbitragem
    3
    33% / 0%
    Expirado
    4
    17%
    Livre
    2
    Desenvolvedor 2
    Classificação
    (54)
    Projetos
    64
    42%
    Arbitragem
    5
    20% / 60%
    Expirado
    4
    6%
    Livre
    3
    Desenvolvedor 3
    Classificação
    (62)
    Projetos
    140
    46%
    Arbitragem
    19
    42% / 16%
    Expirado
    32
    23%
    Livre
    Pedidos semelhantes
    Hi there ,I am seeking for some who can I integrate MT4+MT5 into Matlab!We need our indicator window of MT4+MT5 viewable in Matlab so we can execute more research on Matlab Best regards Richie
    I wan to oder a product for copytrade online like that : - master on mt4 - slaver (copier) by python that mean MT4 open an oder, python will open the same on client account => python will click the mouse then results will show manual (not expert) value : autolot (ratio with receiver balance) - fixed lot - Smart ratio (ratio with master account) trade on many pairs get source for manage license hide everything that
    We trading using C# application running via API https://www.mtsocketapi.com to send orders and some other commands to MT5. We have to read UT bot alert indicator in our C# application
    I NEED TO HAVE MY INDICATOR CONVERTED TO PINESCRIPT. IF YOU CHARGE PER LINES PLEASE ADVISE ALSO I NEED THIS DONE QUICKLY. IF YOU ARE ABLE FINISH WITHIN A DAY OR 2 PLEASE APPLY. THE INDICATOR IS BASED OFF ZIG ZAG AND RSI

    Informações sobre o projeto

    Orçamento