MT4 Reporting System Google Sheets or AirTable and MyFXBook

Project Title: Automated MT4 Reporting 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.

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 or Airtable database with this data.
   • The format of the report should be easy to read and manipulate for further calculations.