Gather profit or loss from multiple accounts into excel spreadsheet and convert base currencies to AUD based on current exchange rate

I have over 20 MT5 accounts that I want to obtain the Profit and loss on in each account from the 1st of the current month to the end of each day or when the program is run. Currently in MT5 I have to go to history, select month which gives the last 30 days profit, change the calendar to the 1st of the current month to obtain the profit for that account and repeat 22 times. I want an automated process that goes out and gathers the data from the trade account and collates it for all the accounts and exports to an excel sheet in a specific order

Profit exporter

Input fields to the program will be:

1. From Date Type: date in dd/mm/yy format – if a date picker pop-up can be easily added that would be nice, but not necessary. Either way I should be able to overtype the date. From date will default to the first of the current month, but can be set to get profit over different time periods e.g it could be overtyped to 01/01/22 to get profit from 1 ^stof January 2022. I presume the trade data should be gathered based on the broker server time from 12am of the From date.
2. To date Type: date in dd/mm/yy format. By default todays date but can be updated for specified period reporting
3. Account Label – text to 30 characters – this is manually specified label for the account)
4. Broker Server – a combo drop down list that can have broker servers added. The current servers I use include:

ICMarkets-MT5

Coinexx-Live

ICMarkets-MT5-2

FPMarkets-Live

5. Username – numeric field 6 characters
6. Password - text field 12 characters.
7. Currency – can this be picked up from the account automatically? Otherwise Combo Drop down selection list from AUD,USD,ETH,BTC

Table row control buttons on right:

·         Order – allows the row to be moved up or down in the table

·         Add – Adds a new row below the current row for adding a new account

·         Del – Deletes the current row account or blank row

·         Ins – Inserts a blank row in the table. The output table will have links to it from another spreadsheet, so it will be important to have the correct accounts order and spacing rows to match the linking spreadsheet.

·         Sub – Adds sub total row below the current row that totals profits to the top of the table or the last sub total row

·         Save and test – Saves the settings entered for that row and tests access to the account. Returns result Success pop up with close button and updates the output data for that row if it successfully access the account. Returns account not found/authentication failure etc to indicate what problem it has connecting accessing the account

It will gather the P/L from the broker, get the current exchange rate from the base currency to AUD and return the profit for each account. The gathered data and calculations will be: 

1. Gross Profit in base currency  (AUD,USD,ETH,BTC)
2. Swap fees
3. Lots traded on the account in the specified date range
4. Commissions
5. Net profit
6. Exchange rate  (AUD,USD,ETH,BTC to AUD) – the program will need to source the current rate. As there is no direct rates for BTCAUD ETHAUD it could be calculated by getting metatrader data for BTCUSD/AUDUSD = BTCAUD e.g BTCUSD = $44429 AUDUSD = 0.75148 BTCAUD = $44429/0.75148 = $59121. Same calculation method for ETHAUD. USDAUD = 1/AUDUSD
7. Profit = Net profit in the selected currency x Exchange rate. Changing the Profit currency will update the exchange rate calculation to match the selected currency. E.g if USD is selected the rate for a USD based account becomes 1.0, for the AUD based accounts is 0.75148 and for BTC based accounts would use the current BTCUSD rate $44429

Top control buttons

·         Using the Save and test button will update that row, the subtotal for that group and the total

·         Pressing Update to the right of the dates will update all the accounts, sub totals and total at once

·         Save As.. will prompt to download the excel sheet with the columns selected at the bottom “Include in Export”

·         Email To will email the sheet to the specified email address field

·         To change email, type over the current address and press update to the right

·         Schedule will invoke the option to automatically send/save the export daily at 12am from 1 ^stcurrent month to the end of the prior days trade data 11:59:59. The schedule options can be checked on to email and/or save to a specified folder path on the computer where it is running.

General

·         The programs will run on any windows computer with MT5 installed and provide an easy to use and attractive interface

·         The attached excel spreadsheet provides the ideal layout for the fields and outputs

·         It can run on a  24/7 vps to provide schedule file saves and emails, and also be run on my local office desktop on an ad hoc basis to view/export current profit data.

·         I will be provided with source code and retain rights in case future updates are required and you are not available