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 a feature setup that will input the Sunday opening price as a horizontal ray on any chart and can be used by another EA as part of a trading strategy. Like this TradingView example below
    I need a mobile phone EA that is similar to no limitz EA mobile bot which will use an ea converter for scalping strategy that will execute trade automatically, set tp and sl for different pairs using integrated trading strategies . It must hedge for both action to buy and sell under 1 min and 5 min based on scalping strategy to execute trades
    Hello everyone, I am looking for a talented developer who can help me create my EA. I have several indicators that I want to combine in the EA. I will take care of the integration of the indicators and the trading strategy myself, I need someone to program all the trading operations for me. This is probably absolutely standard, someone with experience has certainly programmed this several times before. Here are the
    Hi there, I am looking for someone to build a Martingale/Cost Averaging Expert Advisor (EA) with the following features and functions: Martingale and Cost Averaging Features: 1. **Martingale Calculation Settings:** - Standard Martingale system allowing the trader to set the initial trade size and the pip step for subsequent trades. - Option for averaging up and averaging down: - **Averaging Up:** Lot size
    Job Title: MQL5 Trading Bot Code Debugging and Optimization** **Description:** We are seeking an experienced MQL5 developer proficient in debugging and optimizing trading bot codes. The current project involves fixing existing code that runs into debugging issues without errors and optimizing it for efficient performance in live trading environments. **Responsibilities:** - Debug existing MQL5 trading bot code to
    need a very skilled developer to create ea from indicator .i have source code for the indicator and it is non repainting. More details will be provided .i need parameters like take profit/stop/loss/loss recovery and few more
    Active expert 250+ USD
    hi, I must do changes to a dashboard with manual input of trader and active expert. Budget 250$ Can do? the budget is correct based on job to do. If you want me to increase the budget you can message me
    HELLO DEAR DEV'S. I'VE AN EA BUT IT STOP WORKING WHEN MT4 HAS BEEN UPDATED TO THE LATEST VERSION (1420). SO I NEED A GOOD DEVELOPPER THAT COULD UPDATE THIS EA TO THE LATEST VERSION OF MT4 SO I CAN USE IT. NB: IT'S A SINGLE FILE (.EX4) AND THE PRICE CAN BE NEGOCIATED TO BE SUITABLE FOR BOTH PARTIES. THANK YOU
    hey friends, I am looking to build a smart trading robot, for the capital market. He knew how to trade in all the different types of trade. Example - in shares, currencies, index, indices, ETFs, funds, commodities, options, futures and so on. Suitable for trading on all stock exchanges in the world. It will be possible to install the trading robot in the MetaTrader 5 trading software. But it will also be possible to
    STI EA 30 USD
    I need to convert this MT4 indicator into MT5 EA/indicator. The problem is I only have the .ex4 file bt not .mq4 file and it is also a repainting indicator. I need preliminary assessment if the conversion can be done based on .ex4 file first before exploring the EA details further. Attached is the indicator Budget below is just indicative for the assessment. We can discuss further once the conversion can be done and

    プロジェクト情報

    予算