EA with MySQL connection

Tarea técnica

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



 


    Han respondido

    1
    Desarrollador 1
    Evaluación
    (13)
    Proyectos
    24
    42%
    Arbitraje
    3
    33% / 0%
    Caducado
    4
    17%
    Libre
    2
    Desarrollador 2
    Evaluación
    (54)
    Proyectos
    64
    42%
    Arbitraje
    5
    20% / 60%
    Caducado
    4
    6%
    Libre
    3
    Desarrollador 3
    Evaluación
    (62)
    Proyectos
    140
    46%
    Arbitraje
    19
    42% / 16%
    Caducado
    32
    23%
    Libre
    Solicitudes similares
    I would like an EA that follows exactly this steps to trade de daily candle. Watch the video and then see if you can do the task. https://www.youtube.com/watch?v=g3oDYq4P9ZE Document is one this link https://cdn.discordapp.com/attachments/1135977927469703230/1135978751461695598/Daily_Bias-TTrades_edu.pdf?ex=669a9a27&amp ;is=669948a7&hm=96de195f7e695a381c1261b065f67b94fae319d02a0c88641b146f8b2978320c& Should have
    I have a custom EA that works fine in the live market trading, but when doing a back test in the strategy tester , it does not open sell orders. There are no errors or warnings; it just doesn't open sell orders. I've checked every possible reason that might be the reason why it does not open sell orders, but I can't find anything, especially since it works fine in the real market and it opens both buys and sells
    The Expert Advisor would use two built-in indicators as entry/exit signals and our own risk management strategy with customizable inputs. The goal is to create a reliable and efficient trading tool that can automate our trading process on the MT5 platform
    Hi, I have an indicator from my friend, I want to copy it to my own MT5 can you do that for me. Here is the link
    I installed the E.A. into the Experts folder in MT4. When I double click on it nothing happens. When I right click and "attach to chart" nothing happens. The E.A. is not grayed out, it simply will not attach. Any help would be greatly Appreciated
    I have an EA and want to add few new logic to fetch profit taking factors and other values from an external master data and use it in existing EA
    Hello Every one, Good day, I want from someone professional to create an EA is working on Mt5, This EA is working by depend on some indicators, and all those indicators must be working on MACD window, not on the chart, for more details please read my attached pdf file carefully. Many Thanks
    I'm looking for an expert MQL5 developer that can create an EA that's based on my price action trading strategy with no indicators. The EA must analyze trades based on my price action rules, enter trades based on my price action rules, manage trades based on my price action rules and exit trades based on my price action rules
    hi hi there i have an strategy on tradingview and i want to automate it like metatrader EA so i want the strategy to open and close trade automaticlly on tradingview
    We are looking for an experienced Expert Advisor Developer who can build a customized MT5 Expert Advisor for us. The Expert Advisor would use two built-in indicators as entry/exit signals and our own risk management strategy with customizable inputs. The goal is to create a reliable and efficient trading tool that can automate our trading process on the MT5 platform. Skills required: - Strong understanding of

    Información sobre el proyecto

    Presupuesto