cTrader Data Replication Push Service to MySQL – Spotware cTrader Reporting Server Alternative

WE ❤️ DEVELOPERS!

This cTrader Synchronization Service is for brokers, marketers, and developers who require efficient, local access to cTrader data for various applications. 

Brokers can leverage the service to generate customized reports, enabling them to monitor client activity, analyze trading data, and gain insights tailored to their business requirements. 

Developers can use this data to build custom referral and IB payout logic, build Forex risk applications, integrate Forex Marketing Suites, implement custom Prop firm triggers and more.  

The web service functions as a middleware layer between an cTrader trading server and a MySQL database. Its main role is to retrieve and process live trading data from the cTrader server and maintain an up-to-date mirror in the local database for reporting, analysis, and operational monitoring purposes.

cTrader Reporting Server Alternative includes:

• cTrader Manager API Connector: This module connects to the cTrader server using the Manager API, performing secure authentication to access trading data and account management functions.
• Data Synchronization Service: A real-time service that fetches data from the cTrader server and synchronizes it with the local database. 
• Data Transformer: This component structures the raw data retrieved from the cTrader server to fit into the schema of the local database, ensuring consistency across the following tables.

Database Schema and Table Details:

• Groups: Stores user groups and associated trading permissions: Columns include: id, group_name, currency, markup, permissions, max_leverage, etc.
• Symbols: Contains live price data synchronized from the cTrader server: Columns include: id, symbol, buy_value, sell_value, spread, markup, etc.
• Timezone: Keeps track of the server’s current time and timezone: Columns include: id, server_time, timezone_offset, timezone_name.
• Positions-open: Stores all trades for each user, including active and closed positions: Columns include: id, user_id, position_type, symbol, price_open, price_close, volume, timestamp_open, timestamp_close, etc.
• Trades: Stores all trades for each user, including active and closed positions: Columns include: id, user_id, position_type, symbol, price_open, price_close, volume, timestamp_open, timestamp_close, etc.
• Traders: Holds client data with personal and trading account details: Columns: id, username, email, group_id, address, registration_date, account_status, etc.
• Equity: Contains equity data for each user: Columns include: id, user_id, live_equity, highest_equity, lowest_equity, timestamp.
• Daily Reports: Provides end-of-day summaries of trading activity: Columns include: id, report_date, total_volume, balance, active_users, closed_positions, etc.
• Securities: Lists all securities available on the platform with settings and markups: Columns include: id, symbol, security_name, type, margin, markup, trade_enabled, etc.
• In addition Kenmore Design will add any data-points required for your project.

Synchronization Workflow:

• Data Pull: The service initiates API calls to the cTrader server at set intervals or following the server pre-defined API retrieving data changes across trades, users, equity, and other pertinent tables.
• Data Transformation and Validation: Incoming data is transformed to fit the local schema. Additional validation ensures data consistency, removing or flagging any anomalies.
• Database Update: The processed data is inserted or updated in the local database, maintaining a mirrored state of the cTrader server.
• Synchronization Speed: In general the sync speed varies. It depends on the Trading server limitations, geographical distances, network throughput, and general requirement of the client. It is possible to synchronize Equity values faster than updating User info for example. 
• Post-Disconnect catch up: In case the connection with database or trading server is lost the server will go back in time and will catch up/re-sync missing data updates.
• Logs: the system keeps logs for troubleshooting.
• Notifications: The system can post critical notification to a Slack channel or provide web-hooks for events.

Get access to documentation and consultation for the cTrader Data Push

Expert knowledge, replication push service details, documentation, pricing, guides, resources, and tools.

Get started

Choose cTrader PUSH Database Replication Service for hassle-free data access with no per-use or usage limitations — all for a simple flat monthly fee. With over 15 years of expertise and a reputation for reliability, we’re the trusted choice to keep your business data effortlessly synchronized and ready to power your custom applications and reports.