EA to collect trade data and store in data base for slippage calculation

EA to collect trade data and store in data base for slippage calculation

1. Develop the Expert Advisor (EA)

Purpose: To collect trade data from each account.

Functionality:

Monitor and log each trade executed.

Collect data points such as trade ID, requested price, executed price, timestamp, and account details.

Format the data into JSON or XML.

Periodically send the collected data to a central server.

2. Set Up a Central Server

Purpose: To store the trade data and requested price data.

Functionality:

Create a REST API endpoint to receive JSON/XML data from the EA.

Store the received data in a database.

Create an interface for manually uploading requested price data.

3. Database Design

Tables:

Trades: Store trade details (trade ID, account ID, requested price, executed price, timestamp).

RequestedPrices: Store the requested price data (instrument, requested price, timestamp).

4. Manual Input of Requested Prices

Interface:

Web-based form for inputting requested prices.

Upload requested price data in bulk via CSV/Excel.

5. Slippage Calculation

Server-Side Processing:

Calculate slippage by comparing the requested price with the executed price for each trade.

Store the slippage data in the database.

6. Generate Slippage Logs

Interface:

Dashboard for viewing slippage logs.

Filter by client, date range, or instrument.

Export logs as CSV/Excel for reporting.

Pls reply with estimated time and budget