Automated MT4 Reporting and Dashboard System

Project Title: Automated MT4/MT5 Reporting and Dashboard System

Project Objective:

1. To develop a tool that extracts and reports the balance and performance data of all my 50 MT4 and MT5 trading accounts, on a monthly basis. This data should be updated onto a Google Sheet (or e.g. airtable database) for further calculations.

2. The system should also create a dashboard where the current balance for all accounts gets updated automatically every day.

Preferred Platform: Myfxbook API for data extraction; Google Sheets or Airtable for data visualization.

Requirements

Functional Requirements:

1. Data Extraction:

   • The system should use the Myfxbook API to extract the balance and profit/loss data from each of the 50 MT4 and MT5 accounts.

2. Data Reporting:

   • The system should compile a monthly report with balance and performance data from each account and automatically update a Google Sheet with this data.
   • The format of the report should be easy to read and manipulate for further calculations.

3. Data Visualization:

   • The system should also have a dashboard which displays the current balance of each account, updated automatically on a daily basis.

Non-Functional Requirements:

1. Reliability:

   • The system should be reliable in extracting data from the Myfxbook API and updating the Google Sheet / Airtable with accurate information.

2. Scalability:

   • The system should be able to handle any increase in the number of accounts in the future.

3. Security:

   • The system should securely handle sensitive trading data, ensuring it remains confidential.