Secure MT4 EA and Python (Server) Communication Setup

Develop a system where a MetaTrader 4 (MT4) Expert Advisor (EA) securely connects to our server, listens for trading commands, and executes them only if the account number in the command matches the MT4 account. The account number is retrieved from a MySQL database for security verification.

System Requirements:

MT4 EA Development:

• The EA should connect to our server and continuously listen for incoming messages.
• Upon receiving a message, the EA should verify if the account number in the message matches the MT4 account number.
• If the account numbers match, the EA executes the trading command; otherwise, it ignores the command.
• The EA must process all data dynamically, without hardcoded values.

Server-Side Setup:

• A Python script on our server will retrieve the AccountNumber from a MySQL database and send trading commands to multiple MT4 clients, including the account number.
• The server must maintain active connections with all MT4 clients.
• Ensure secure communication using SSL/TLS, preferably via a domain with Cloudflare or a secure IP connection.

Database Structure (MySQL):

• Table Name: forex

Table Structure:

Security and Reliability:

• Use SSL/TLS for secure communication between the server and MT4 EAs.
• Implement error handling and automatic reconnection for reliability in case of disconnection.
• The account number from the database must match the MT4 account for the command to be executed, ensuring an additional layer of security.

Scalability:

• The system should support multiple MT4 clients on different networks or machines.
• Design the solution to be scalable for future expansion.

Example Command from Python Server:

Technology Stack:

• MT4 EA: Developed in MQL4.
• Server-Side: Python
• Database: MySQL to retrieve the account number for command verification.