Broker Reconciliation
Comprehensive reconciliation of broker positions, prices, margins and fees.
Current Business Challenges
EPIC addresses the most challenging obstacles faced by businesses today.
Connecting to multiple broker accounts and aggregating the information in one place
Reconciling intra-day and end-of-day trade attributes and open positions in internal trade capture systems to those reported by brokers
Calculating and reconciling broker fees
Calculating the Initial and Maintenance margin using the SPAN tools provided by ICE and CME as well as verifying the broker invoices
Top Day Trade Reconciliation
The Broker Reconciliation App allows users to run intraday trade reconciliations to ensure there are no errors in trade entries.
- Capture today’s trades from the customer’s trade capture system, and automatically align them with the trades downloaded from brokers.
- Reconcile the trades across a user-defined set of attributes and tag the trades that show a mismatch.
- Easily drill down to the trades for more in-depth analysis.
- Easily maintain the master list of exchange products being traded in the portfolio.
End-of-Day Position Reconciliation
The end-of-day open positions reconciliation feature in RPM’s Broker Reconciliation App seamlessly identifies breaks in the total open positions across all exchange-traded products.
- Automatically aggregate all open trades across multiple broker accounts and reconcile with the open positions information downloaded from brokers.
- Identify gaps in the errors as well as the marks against the values reported by brokers.
- Archive reconciliation results for trend analysis
- Easy drill-down to the trade level details on data captured from the customer’s own trade capture system as well as the data downloaded from brokers.
- Generate Excel-based reports, which allow users to further analyze the breaks.
- Timely report availability at the start of the business day.
Broker Fee Reconciliation
The Broker Reconciliation App comes with a powerful fee calculation and reconciliation feature. Customers can independently verify the fees charged by brokers before paying them.
- Calculate and reconcile the following types of fees:
- Clearing Fee
- Exchange Fee
- NFA Fee
- Execution Fee
- Broker Commission
- Easily drill down to the trade level details on data captured from the customer’s own trade capture system as well as the data downloaded from brokers.
- Archive reconciliation results for trend analysis
Margin Reconciliation
Get a comprehensive toolkit to calculate initial and maintenance margins using the Standard Portfolio Analysis of Risk (SPAN) margin system. The broker tool provides user-friendly front-end access to the SPAN margin system provided by CME and ICE.
- Built-in wrapper around the SPAN margin calculators provided by ICE and CME
- Out-of-box connectivity to ICE and CME Risk Arrays ISO monthly billing JE
- Easy maintenance of SPAN settings using the intuitive settings panel in the Broker Reconciliation App.
- Automatically determine when positions roll-off based on contract expiration dates, which are defined by an exchange holiday calendar and a date rule, usually articulated verbally in exchange rules.
- In addition to the Initial and Maintenance margin, the app also computes Open Trade Equity, Net Option Value and Margin Excess.
Other Features
Easy integration with powerful business intelligence tools like Tableau and Power BI
Intuitive Mappings UI
Easy maintenance of SPAN settings using the intuitive settings panel of apps
Trend analysis of open positions and margins across all FCM accounts and exchanges
Re-run reconciliation post trades are finalized in trade capture system to resolve exceptions
Plug n Play Apps
Purpose-built apps to support critical business functions from day one.