Specification
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