Order Book

BDM 'Order Book' is an optional add-on to our 'Broker Dealer Management' application. It is accessible (If installed) by clicking on the 'Order Book' button from the 'Broker Dealer Management' main menu.

Note: You can navigate to additional information by clicking on the words highlighted in red at the top of Fig.1.

Fig. 1 shown below is the form used to enter/edit orders (shown with filter form not visible). The screen is dynamically opened to show

• Orders for a specific department (if the user is a trader)
• Orders for specific customers (if the user is a sales rep)

In order words, when someone logs on to the database, the system will know whether he or she is from admin, a trader or a sales rep. The system also knows his or her default department. If that user then opens the order-book, data will be displayed as follows

• If he or she is from admin then all orders will be displayed
• If he or she is a trader then only orders relating to his or her department will be displayed
• If he or she is a sales rep then only orders related to his or her customers will be displayed.

In addition if the user is a trader he or she will be able to add, edit, execute or cancel an order. If the user is a sales rep then he or she would be able to add or edit open orders only. A drop-down box allows the user to specify if and how customer notification is to be achieved. Current choices for customer notification as none and email.
The right hand portion of the orders form shows execution details (Trade ticket ID, Quantity, price and balance remaining to complete the order.

This screen also
• Allows access to audit information
• Allows access to the order book blotter
• Has button to close the form
• Has buttons to execute or cancel an order ( Not available to sales reps)
• Has button to turn filter form on or off
• Has button to refresh the screen with the latest data
• Has button to (edit) cancel and replace an order
• Has drop-down box for easy access to all actions
• Displays date and time of last update
• Has button to create a new order
• Has button to save current order
• Has button to print a specific order
• Has drop-down box to specify whether the order is in Principal or agency mode
• Has button to modify notes (without having to cancel and replace the order) only

Fig. 1

Fig.2 shows the orders form with the filter form visible at the bottom

Fig. 2

With the filter on a user can filter for orders based on any or all of the following
• Buy or sell
• Open or executed
• Price
• Quantity
• Sales rep (by RRCode)
• Security (based on CUSIP.ISIN,ADP,Symbol or description)
• Customer (this drop-down list is dynamically filled depending on the user)
Fig. 3 shows the filter for the inquiry and trade history browse form.

Fig. 3

This form allows the user to filter for and open the Inquiry and trade history browse form based on any or all of the following
• Customer
• Security (based on CUSIP,ISIN,ADP, Symbol or Description)
• Date range (Maximum 30 days)
• Price
• Trades, Inquiries, Orders or all
• Buy or Sell
Fig. 4 shows the Inquiry and trade history browse form (Continuous format)

Fig. 4

To the left of the data labeled securityID is a small button which when clicked displays the security description and CUSIP. The form’s data is color coded to show rows in different colors depending on
• Executed
• Open
• Cancelled
Also color coded is the Buy/sell column
The form may be filtered by using the filter section at the bottom left (shown In grey) or sorted by using the sort-by drop-down box also at the bottom. Sorting may be by description, date, customer or sales rep.
This form is read only
Fig. 5 show the Audit Orders form

Fig. 5

The audit Orders form is accessed from the orders form via a button labeled ‘Audit Orders’ It dynamically opens to show audit information relevant to the particular order.Single-order print out.
It is possible to have a printout of the specific order displayed by clicking on the 'print order' button. Fig. 6 shows a sample printout.

Fig. 6

Order history printout
Fig. 7 shows a sample of an order history report.

Fig. 7