Daily Equity Swaps Application - Example Screenshots
Portfolio ManagementData ManagementProcessingReporting
Portfolio Management
Contracts for Difference on Equities System (CDE) runs under Microsoft® NT4 or later and manages the input, processing and reporting of equity difference contracts for brokers and clients. It is a self-contained system, but can supply and extract external data in a variety of universal formats.
General portfolio details are presented in a browser which can be filtered and sorted by various criteria as shown at the top of Figure 1, above. Trade details can be managed through an integral editor. New trades can be entered at any time, with intelligent defaults assigned to most elements which ensures rapid, consistent and accurate trade data capture. The default trade values are based on client and trade type (short or long) combinations: change one of these and the corresponding criterion on all subsequent trades will reflect new value. Any default can of course be modified at the trade level.
Click here to view the editor
Portfolio ManagementData ManagementProcessingReportingBack to top
Data Management
The supplementary, or static, data is fully maintainable including counterparties, securities, currencies and users. Business day calculations incorporate a user definable holiday list. Only users who are specified by your system administrator will have access to the CDE system and read, edit and printing rights are fully programmable.
Click to view:
Portfolio ManagementData ManagementProcessingReportingBack to top
Processing
End of day processing of the trades portfolio lies at the heart of the system and provides the mechanism to calculate margin, difference, interest and other payments. These payments can be used to create site-specific journal files for account postings. Interlocks exist to prevent multiple processing of the clients for any one day. In the event of mis-keyed data entry, the current day's processing can, at the simplest level, be rewound in order to effect changes before processing again.
Communication with clients is made through various reports that can be output immediately and automatically after each processing session. You can select the combination of reports required for the day. One mouse click then starts the processing and prints the reports, leaving you free for other tasks. Our unique Diff-o-Matic provides a colourful indicator of progress in order to estimate the remaining time to completion.
A wide variety of reports is available for client and in house consumption. Client reports can be printed as statements ready for posting or faxing; or e-mailed as rtf or HTML pages.
Portfolio ManagementData ManagementProcessingReportingBack to top
Reporting
Client Reporting includes:
- P & L Statement : a comprehensive daily statement of all trading activity showing opens & closeds, open positions with actual P & L, cash transactions and cash balance summary.
- Trade Confirmations : a schedule of all opened and closed bargains made today.
- Trade Transactions Statement : a breakdown of the client's portfolio giving today's detailed transactions for the various trade cash components (difference, margin, interest streams etc.). A valuable resource for reconciling against accounting journals.
- Balance Statement : a schedule of trade component balances for a selected date range. The day on day differences can be reconciled against the total movements given in the Trade Statement.
Broker Reporting comproses of:
- CRR breakdown by client.
- FSA schedule of trades for direct entry into the FSA interface program, or alternatively, preparation of a Direct Reporting text file for immediate upload to the FSA.
- Stock Positions : the current open position of all stocks used across the all clients' portfolios.
- Commission breakdown by salesman and client.
- Account Postings: all daily transactions that generate cash movements are reduced to a series of DR and CR entries to client and book ledgers for post processing accounting. The data will be written, generally, to a flat text file for universal compatibility with accounting and settlement systems. Some local customisation of this component will be necessary to suit individual site requirements.
- Trader P & L: a broker's profit is essentially generated by trade commission and the spread on clients' interest payments. Given the context of the CDE product within the broker's operation, this report shows the P & L on the portfolios (books) including interest earned on client money, interest paid to client and cost of borrowing etc.
- All CDE data browsers permit the printing of currently displayed data and saving to an Excel spreadsheet.
- Complete trade history is available for on-line inspection, complete with optional binding of an open trade and all associated close trades.
Portfolio ManagementData ManagementProcessingReportingBack to top