Management Reporting





Trading Activity Report

ACTREPT is a complete daily audit trail of trades that have been entered, deleted, modified, abandoned or declared for that day's business. All trades for a given product are shown by delivery month and within price sequence. Also shown is the commission charged and which broker the trade was dealt through. Each product term is then totalled giving the number of lots and also the contract values which can be reconciled with exchange reports.

ACTREPT is available in any one of four formats which can be selected by the user:

  • Product - Term order
  • Deal Number order
  • Account - Product - Term order
  • All of the above
  • Client Detailed Open Position

    EQUITY details all open positions within product date and price order and values them against the closing prices. It also works out the deposit requirements, forward commissions, details of option premiums, declaration dates, net position and average bought and sold prices, value at risk.

    In calculating deposit requirements the specific mathematical algorithms for that particular exchange are used in accordance with the exchange rules. Detailed strategy breakdowns for futures versus options, options versus option and inter-product spreads are detailed after each product and totalled at the end of the equity report.

    The opening ledger balance is shown followed by any fiscal entries such as cash/journal entries, followed by settlements showing trade details and commissions charged, bringing forward a new ledger balance. Total variation margins for futures and options are then added or subtracted to produce an equity figure. Forward commissions and deposits are then deducted to produce a net equity figure.

    A detailed report is created for the back office as well as a summary for the dealing desk. As CADRE is a real time system, amended trade or price corrections can be done instantaneously and new equity reports produced as and when needed.

    Fiscal Entries Audit Trail

    FSEND is a complete daily audit trail of all fiscal entries for that day's business broken down by currency. All fiscal entries are shown in account order and are also split between cash paid, cash received, journals, settlements, option prerniums, securities and all adjustrnents to these. All fiscal entries balance back to zero and can be easily reconciled with the totals produced by the financial control totals report, produced daily.

    Trade Valuation Report

    This report displays each product within term and option strike price, splitting settlements between brokers and clients and values all open positions, splitting open trade equity between brokers and clients.

    By taking the constituent parts, XONTROL reports should balance to zero for each product term. Should a position be altered incorrectly then the report will highlight the discrepancy at that particular product and term.

    Option & FOREX Declarations

    DECLPRMT shows details of all options traded that are due to be declared within the next seven working days as well as all FOREX and LME metals due for delivery within the same time scale.

    End of day audit trail report.

    Data that has been altered by any of CADRE's maintenance programs is listed by the ENDDAY report.

    Net positions by account.

    BCNET is produced in product/account order listing net positions in each product/term for a rapid overview of accounts net positions in any product.

    Client Segregation - FSA RULE 18

    Client segregation is calculated to the exact specifications of the FSA. A daily report is automatically produced showing in detail all s egregated client, brokers and bank accounts producing a net figure in your base currency. It is also produced for all non-segregated accounts.

    Daily Financial Control Totals

    XCTLSUMM produces a summarized report detailing the day's activity which is divided into four categories by currency - client, house, broker and ledger. Under these four sections are listed the respective debit, credit and net columns for settlements, option premiums, foreign exchange, commissions, exchange fees, VAT, cash, journals. The summation of these make up the clients, house, broker, ledger accounts ledger balances. Directly below ledger balances are normal margins, option margins, foreign exchange margins, forward commission on futures open, initial margins, securities held and finally, producing a net figure for each category.

    Daily Interest Calculations

    The INTCALC report shows on a daily basis each day's calculation of interest by account and within currency. Details of client's ledger balance, variation margin, initial margin and interest rates applied each day are displayed on the INTCALC report.

    Commission Report

    CADRE facilitates the posting of commissions for selected accounts to a currency different to the currency the products are in. The commission report also allows for selected accounts to be debited on a half turn basis i.e. debiting the commission on the date of the trade. Other comprehensive features include detailing source of commission, splitting futures from options, reporting number of lots and commissions earned by product and account.

    © 2002-2003 Data Exchange Systems, Ltd. All rights reserved.