EA with MySQL connection

MQL5 专家 积分

指定

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



 


    反馈

    1
    开发者 1
    等级
    (13)
    项目
    24
    42%
    仲裁
    3
    33% / 0%
    逾期
    4
    17%
    空闲
    2
    开发者 2
    等级
    (54)
    项目
    64
    42%
    仲裁
    5
    20% / 60%
    逾期
    4
    6%
    空闲
    3
    开发者 3
    等级
    (62)
    项目
    140
    46%
    仲裁
    19
    42% / 16%
    逾期
    32
    23%
    空闲
    相似订单
    I need help getting pineconnector working in mt5 the alerts from TV to mt5 work fine What is happening now is that if I am in a long position and a short position comes through it is not closing off the original position to only then keep the short position open. I have tried hedging - netting in the pineconnector settings but still no luck. The issue is that if I am in a long position and then alerts come through to
    Hi I need access to Pocket option OTC charts where I can apply my tradingview indicator. I have the indicator but I need access to OTC charts to apply them! Please help
    Tenho um endereço de API que retorna informações, a cada 1 minuto faremos uma consulta e mostraremos em um painel, é necessário validar se todos os tempos gráficos retornaram, em alguns momentos pode não retornar todos os dados. https://integra.tasdigital.com.br/GetIndicadoresForexDataAtualProducao/XAUUSD
    Hi, Do you have an indicator or expert and would like to protect and control it? What you will get protection and control Customer control panel The number of products is unlimited. You can add any number of your own experts and consultations You can give a trial period for your product, for example a week or a month, after which the customer subscribes Monthly, annually, or for life, depending on the customer’s
    I need an EA to automate Tradingview alerts on MT4 using webhook alerts. The bridge/connector should be python based GUI. Required features at a minimum Mapping Tradingview alert formats to MT4 Automating market, limit and stop orders with entry price, stop loss, multiple TPs and trailing stop Lot sizing - fixed/% of balance/fixed amount breakeven, partial close and trailing stop Mapping pair name prefixes/suffixes
    Hello, I am looking for an experienced and professional developer to create a trade copier that transfers trades from MetaTrader 5 (MT5) to NinjaTrader 8 (NT8). I am looking for a developer with a strong track record in creating MT5 to NT8 trade copiers and who can deliver a robust and reliable solution. Thank you, and I look forward to your proposals
    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
    NB: Given price is a placeholder only. Fees are negotiable. I’m looking for a developer who could make an expert advisor (EA) that will Auto copy telegram signals to an MT4 account. 1. Read and copy trading signals posted in specific telegram channels with different formats to MT4. 2. Copy all the signals including entry price, stop loss, and take profit levels 1 to 3 (if any). 3. Read customized messages on telegram
    1. Combination of Market Profiles on daily basis a) this should be combined if the bell curve is similar to the previous day. Rotational day (volume - standard deviation). b) If breakout, new range should be drawn Conclusion: Market profile should be combined on daily after the market is closed 2. Use Vwap indicator, with 0.5 - slow trend, 1.0 - normal trend, 1.5 fast trend. The stop loss should be under the trend
    I want to find a Developer to perform this work and settle payments in this Application. I undertake not to communicate with Applicants anywhere else except this Application, including third-party messengers, personal correspondence or emails. I understand that violators will be banned from publishing Orders in the Freelance service. I have read the Rules of using the Freelance service and accept them. I agree

    项目信息

    预算