AU2002314841A1 - System and method for trade settlement tracking and relative ranking - Google Patents

System and method for trade settlement tracking and relative ranking

Info

Publication number
AU2002314841A1
AU2002314841A1 AU2002314841A AU2002314841A AU2002314841A1 AU 2002314841 A1 AU2002314841 A1 AU 2002314841A1 AU 2002314841 A AU2002314841 A AU 2002314841A AU 2002314841 A AU2002314841 A AU 2002314841A AU 2002314841 A1 AU2002314841 A1 AU 2002314841A1
Authority
AU
Australia
Prior art keywords
trade
accordance
trading
entities
failed
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Abandoned
Application number
AU2002314841A
Inventor
Thomas Campfield
Warren Master
John Phinney
Matthew P. Rosedale
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
JPMorgan Chase Bank NA
Original Assignee
JPMorgan Chase Bank NA
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by JPMorgan Chase Bank NA filed Critical JPMorgan Chase Bank NA
Publication of AU2002314841A1 publication Critical patent/AU2002314841A1/en
Abandoned legal-status Critical Current

Links

Description

SYSTEM AND METHOD FOR TRADE SETTLEMENT TRACKING
AND RELATIVE RANKING
CROSS REFERENCE TO RELATED APPLICATIONS
[01] This Application claims priority to Provisional Application number
60/295,397 filed on June 1, 2001, the entirety of which is incorporated by reference.
FIELD OF THE INVENTION
[02] This invention relates generally to the evaluation and analysis of the post-trade settlement process, and more particularly to a system and method for measuring post- trade settlement performance in terms of failed trades.
BACKGROUND OF THE INVENTION
[03] Financial trading transactions typically involve two or more parties exchanging a financial instrument, such as a security, in exchange for value. After the parties agree to enter into the transaction, they make arrangements to settle the transaction, i.e., to actually effectuate the transfer of the securities to the buyer. The post-trade settlement process may also include independent third parties such as escrow agents and custodians, who hold the property or payment of one party in anticipation of the future transfer of securities. However, there is always a risk to the parties that the transaction may never actually settle. [04] In the global securities market, the risk of settlement failure is increased by the complexity of the transactions. For example, an orderer, who is either a buyer or a seller, will issue a trade instruction to his broker/dealer who executes the trade and sends a notice of execution back to the orderer. The orderer then transmits the trade details and allocations to his broker/dealer who either accepts or rejects the trade details and allocations and transmits an acceptance or rejection back to the orderer. If the trade details and allocations are accepted, the broker/dealer provides additional information related to the trade and transmits a trade confirmation to the orderer. The orderer must then validate the information included in the trade confirmation and respond with an affirmation - representing the formation of a legally binding contract for the transaction. Both the orderer and the broker/dealer then transmit the trade to their respective settling agents who
/ must arrange for the instructed exchange of funds and securities on the settlement date.
[05] The number of parties and exchanges involved complicates the post- trade process, lengthening settlement times and consequently increasing the risk to parties of settlement failure. To minimize this risk, markets worldwide have attempted to standardize a deadline for completion of the settlement procedures to within a set number of days of the trade date. In the United States, the Securities and Exchange Commission, which regulates transactions involving the transfer of securities and the exchanges that operate the markets where securities are traded, has mandated that U.S. securities must be settled within three days of the trade date. Transactions that are not settled within this time frame result in settlement failure and represent a significant risk to both brokers and traders.
[06] There are known systems in the art that enable parties tb evaluate the performance of their brokers in the post-trade settlement process. For example, WO 01/75730 A2 to Skuriat describes a system in which the performance of brokers in the post-trade settlement process is evaluated based on how much time it takes the broker to complete each step in the post-trade process. The longer the amount of time taken by the broker, the lower his ranking in the Skuriat system.
[07] There is, however, no system currently available that tracks the settlement fail rate of brokers or that evaluates brokers in terms of their ability to settle trades within the time frame required by the market.
SUMMARY OF THE INVENTION
[08] In accordance with an embodiment of the present invention, a distributed computer system is provided that enables end users to evaluate a broker's trade settlement performance by market and across multiple markets in terms of how many of the broker's trades failed. Trades are defined as having failed when the actual settle date exceeds the date on which the trade should have settled. In accordance with an embodiment of the present invention, the system analyzes trade settlement statistics about each broker within the context of a selected broker peer group, and ranks and compares a broker's settlement performance relative to the peer group. The system also ranks the brokers based on a set of metrics relative to the selected peer group. A broker's peer group is defined in terms of the broker's relative size within the trade universe as determined by trade count.
BRIEF DESCRIPTION OF THE DRAWINGS
[09] For the purposes of illustrating the present invention, there is shown in the drawings a form which is presently preferred, it being understood however, that the invention is not limited to the precise form shown by the drawing in which: [10] Figure 1 is block diagram depicting the components of a distributed system in accordance with an embodiment of the present invention;
[11] Figure 2 depicts a view of the Preferences screen in accordance with an exemplary embodiment of the present invention;
[12] Figure 3 depicts a view of the Account Enquiry screen in accordance with an exemplary embodiment of the present invention;
[13] Figure 4 depicts a view of the Group Enquiry screen in accordance with an exemplary embodiment of the present invention;
[14] Figure 5 depicts a view of the Country Summary screen in accordance with an exemplary embodiment of the present invention;
[15] Figure 6 depicts a view of the Principal Broker Summary screen in accordance with an exemplary embodiment of the present invention;
[16] Figure 7 depicts an Ultimate Parent Summary screen in accordance with an exemplary embodiment of the present invention.;
[17] Figure 8 depicts a view of a User's broker summary screen containing a list of brokers in accordance with an exemplary embodiment of the present invention.;
[18] Figure 9 depicts a view of a Statistics by Market for Principal Broker screen in accordance with an exemplary embodiment of the present invention;
[19] Figure 10 depicts a view of a User-Specific Broker Analytics screen in accordance with an exemplary embodiment of the present invention;
[20] Figure 11 depicts a view of Fail Trade Summary screen in accordance with an exemplary embodiment of the present invention; [21] Figure 12 depicts a view of Fail Trade Details screen in accordance with an exemplary embodiment of the present invention;
[22] Figure 13 depicts a Fail Reason History screen in accordance with an exemplary embodiment of the present invention;
[23] Figure 14 depicts a view of an Ultimate Parent Rankings screen, in accordance with an exemplary embodiment of the present invention;
[24] Figure 15 depicts a Market Performers screen in accordance with an exemplary embodiment of the present invention;
[25] Figure 16 depicts an Ultimate Parent Search screen in accordance with an exemplary embodiment of the present invention;
[26] Figure 17 depicts a Broker Search screen in accordance with an exemplary embodiment of the present invention;
[27] Figure 18 depicts a Parent Broker Analytics screen in accordance with an exemplary embodiment of the present invention;
[28] Figure 19 depicts a Principal Broker Analytics screen in accordance with an exemplary embodiment of the present invention;
[29] Figure 20 depicts a Fail Reason Summary screen in accordance with an exemplary embodiment of the present invention;
[30] Figure 21 depicts a Principal Clearer Broker Analytics screen in accordance with an exemplary embodiment of the present invention. DETAILED DESCRIPTION OF THE INVENTION
[31] Figure 1 is block diagram depicting the components of a distributed computer system 100 in accordance with an exemplary embodiment of the present invention. A Web server 110, an application server 120, and a database 130 may reside on a separate computers connected by way of a conventional data communications network. Alternatively, Web server 110, application server 120, and database 130 may exist as separate processes running on the same host computer.
[32] The application server 120 hosts the server-side software components of a distributed network application that tracks trade settlement failure and ranks brokers in terms of failed trades (the "Application"). The database 130 is preferably a relational database such as Microsoft SQL Server®. The Application running on the application server 120 is programmed to query the database 130, retrieve data, and generate trade settlement failure and broker ranking data. The application server 120 is programmed to dynamically generate pages to the Web server 110. The Web server 110 transmits these pages to the workstations 140. The pages are preferably formatted using Hypertext Markup Language (HTML), Extensible Markup Language (XML), or any other variant capable of being displayed by a conventional Web browser running on the workstations 140. The Web server 110 and the workstations 140 are preferably connected to each other via a TCP/IP based network such as the Internet. Although described in terms of an Internet based configuration, it will be appreciated by those skilled in the art that the system 100 of the present invention may operate entirely on a Local Area Network (LAN), a Wide Area Network (WAN), or through dial-up connections from the workstations 140 to, for example, the application server 120.
[33] Although in this exemplary embodiment the workstations 140 are preferably personal computers running Web browsers, in alternative embodiments a workstation 140 may be any device that can be connected to the Internet, including Personal Digital Assistants (PDAs), cellular telephones, interactive televisions, and other mobile communication devices.
[34] The general methodology by which the Application ranks brokers in terms of failed trades will now be explained. The Application ranks brokers by calculating a relative measure of each individual broker's operational performance, specifically in relation to a broker's ability to settle trades in a timely fashion. The ranking is preferably assessed on a "five-star" scale, the brokers with the best trade settlement performance receiving five stars. The Application awards these stars based on a computed score each broker receives as a result of the methodology algorithm.
[35] In order to understand the Application's methodology, some terms must first be defined. The "trade date" is the date on which a trade was executed in the market place. The "settle date" is the deadline for settlement, and is set in accordance with standard market practice (e.g., in the United States, the SEC requires that all trades settle within three days of the trade date). The "actual settle date" is the date on which the trade actually settles. A "failed trade" is a trade in which the actual settle date extends beyond the settle date.
[36] The underlying statistics used by the Application are preferably based on standard daily market trade transaction data aggregated by month. Although the trade transaction data for a particular month will include all the trades executed in that month, the Application only considers data relating to those trades that have actually settled.
[37] The trade statistics generated by the Application represent the aggregated trade count and total monetary amount for each broker's respective transactions for a given monthly period. That is to say, the trade statistics generated by the Application are aggregate representations of the received daily market transaction data.
[38] The metrics used by the Application to rank the brokers are calculated from each broker's trade statistics, benchmarked against the aggregate total for a user-selected representative population. The user of the Application is able to define the representative broker population by defining peer groups and by filtering the trade statistics by certain pre-defined categories. At all levels, the broker's ranking, trade statistics, trade metrics, and the aggregate population are dynamic depending on the peer group and filtering criteria selected by the user.
[39] Before selecting any filtering criteria, the user must first specify the default parameters for a broker peer group. Peer group specifications are preferably a mandatory and a primary filtering criteria.
[40] The peer group determines the particular subset of brokers, from the applicable universe of brokers, against which any given broker will be ranked across all levels of analysis. A peer group is defined by the relative size of the brokers as measured by transaction count. The end user can define the parameters for the peer groups by segmenting the peer groups by percentile e.g. Peer Group 1 equals the top n % of brokers as determined by size, Peer Group 2 equals the next m %, etc.
[41] After peer group parameters have been set, the user then has the ability to filter the representative data set for several filtering criteria. The first major filtering criteria is the period over which the end user wishes to view the data. The Application also includes additional filtering functionality to enable the user to focus on the particular factors which may be the cause of any given broker's poor relative ranking. The Application preferably includes six criteria by which the user may filer their results: [42] 1. Time Period - defines the time dimension for the data universe;
[43] 2. Transaction Type - user can select to view buys or sales;
[44] 3. Payment Indicator - allows the user to distinguish between "Pay"
(Delivery vs. Payment or Receipt vs. Payment) transactions and "Free" transactions, where there is either no cash associated with the trade or cash settlement is done by a separate transaction;
[45] 4. Security Type - user can choose to view transactions for a particular security type, specifically categorized by Debt, Equity, or Other security types. Other security types include derivatives (futures and options); insurance contracts and annuities; mutual funds; unit investment trusts ("UITs"); and repurchase agreements ("repos").
[46] 5. Country - at the Ultimate Parent, Parent, and principal broker level, the user can choose to look at the transaction activity in a specified market or across multiple markets. When focused on a specific principal/clearer combination, only one given market applies as a clearing broker implies a local market by default; and
[47] 6. Region - at the Ultimate Parent and Parent level, the user can choose to view transaction activity in a specific geographical region.
[48] The trade statistics and metrics are sensitive to the peer group definitions and to whatever filtering the end user has chosen to apply. That is to say, the brokers are ranked relative to the group defined by the user-selected peer group and filtering criteria.
[49] The analysis of brokers' trade settlement performance is done at four distinct levels within the Application: Ultimate Parent (i.e., the holding company or parent corporation); Parent (i.e., the distinct broker/dealer entity); Principal Broker (i.e., the entity corresponding to an individual Broker Identification Code (BIC) which may be a SWIFT Bank Indentifier Code, Depository Trust Company Participant Code, FINS code, etc.); and Principal/Clearer combination. The four levels are hierarchical: each principal broker is mapped to its respective parent entity, and each parent is matched to its ultimate parent. Analysis at the Parent and Ultimate Parent levels is performed on the aggregated trade statistics for all of the individual Principal Brokers comprised by the Parent or Ultimate Parent entity.
[50] For each Principal Broker, Principal/Clearer combination, Parent, or
Ultimate Parent known to the Application, a series of trade statistics and calculated metrics are displayed, regardless of the level chosen. The trade metrics are based on and calculated from a set of trade statistics, that preferably includes: total trade count; failed trade count; settlement amount for all of the trades (including those that failed); and settlement amount (for the failed trades only).
[51] From these primary trade statistics, a core set of metrics is derived. The metrics are applied across the four levels of broker analysis in the Application, regardless of the filtering criteria that the end user has chosen to apply. The metrics that are preferably incorporated into the Application's methodology include:
[52] 1. Individual Trades to Aggregate Trade Count - an individual broker's trade count as a percentage of the total trade count for all the brokers;
[53] 2. Individual Failed Trade Count to Aggregate Trade Count - the individual broker's failed trade count as a percentage of the total trade count for all brokers;
[54] 3. Individual Fail Count to Aggregate Fail Count - "the individual broker's failed trade count as a percentage of the total count of all failed trades for all brokers; [55] 4. Individual Fail Rate - the quantity of an individual broker's failed trades as a percentage of their own total individual trade count;
[56] 5. Individual Settle Amount to Aggregate Settle Amount - the individual broker's trade settlement amount as a percentage of the total settlement amount of all trades for all brokers;
[57] 6. Individual Fail Settle Amount to Aggregate Settle Amount - the individual broker's failed trade settlement amount as a percentage of the total settlement amount for all brokers' trades;
[58] 7. Individual fail settle amount to Aggregate Fail Settle Amount - the individual broker's failed trade settlement amount as a percentage of the total settlement amount for all brokers' failed trades;
[59] 8. Individual Settle Amount Fail Rate - the individual broker's failed trade settlement amount as a percentage of their own individual total settlement amount; and
[60] 9. Average Fail Duration - the average number of days past value date
(the date the trade was supposed to settle), for all failed trades for each broker, calculated for both business and calendar days.
[61] Each broker is ranked based on its score for each individual metric. In addition, each broker is also assigned a composite ranking which is indicative of its overall operational settlement performance. This composite ranking is preferably calculated by taking the simple average of the individual rankings for the following four metrics: Individual Trades to Aggregate Trade Count; Individual Fail Count to Aggregate Fail Count; Individual Fail Rate; and Average Fail Duration. [62] At the Ultimate Parent and Parent levels, the Application ranks brokers across all markets for which there is trade activity in the Application's database. Thus, the Application is able to generate a "worldwide" ranking for trade settlement performance of all brokers relative to a peer group. At the Principal Broker level, the user is able to evaluate a broker's performance in any individual market or any combination of markets. At the Principal/Clearer Combination level, the user is able to evaluate a broker's performance solely within a specific market, since the clearing broker function is performed in the local market.
[63] When the Application performs composite rankings of Principal
Brokers, Parents, or Ultimate Parents across more than one market, an additional performance metric is calculated called the Market Complexity Factor. Thus, the composite ranking across multiple markets is the based on the simple average of the individual broker rankings for five metrics: Individual Trades to Aggregate Trade Count; Individual Fail Count to Aggregate Fail Count; Individual Fail Rate; Average Fail Duration; and the Market Complexity Factor.
[64] The Market Complexity Factor is a metric that is used to rank brokers based on the complexity of the markets in which the brokers are executing and settling trades. The Market Complexity Factor may be, for example, an efficiency ratio calculated by security type for each market that is considered in the Application's trade data universe.
[65] Each market is assessed on a series of characteristics related to the efficiency of trade settlement within the specific market based on security type. The following eight categories are preferably considered in the efficiency ratio (although, as will be appreciated by one of skill in the art, any set of efficiency characteristics may be employed) and a brief description of the attributes of the market they assess:
[66] The efficiency measures are assessed from best practice to worst practice and the results are given a numeric score. For the purpose of applying the Market Complexity Factor within the Application, a broker's trade count within each market is multiplied by the computed efficiency ratio score. The resulting figures for each security type within each market are then added together, and the total sum is divided by the broker's total trade count to come up with a weighted- average figure based on the complexity of the markets in which the broker operates. This weighted-average market complexity figure is then ranked against all members within the broker's peer group.
[67] Each broker is assigned a ranking for each of the above-described metrics, which is a relative measure of the Broker's standing for each metric. The ranking is assessed on a scale of one-half to five "stars" depending on which percentile the broker resides within for each respective metric. The break points for the percentiles are preferably as follows, where X is any given Ultimate Parent, Parent, Principal Broker, or Principal/Clearing Broker pair:
[68] The operation of the Application will now be described. In accordance with an exemplary embodiment of the present invention, a user of the Application, who may be an individual at any trading entity, such as a custody account holder, an asset manager, or a broker/dealer, has a choice between three different views of the statistics generated by the Application. The first view is of statistics relating to trades executed and settled by brokers for an asset manager's individual portfolios, preferably held in custody accounts, i.e., a My Accounts view. The second view is of overall broker rankings within the data universe, i.e., a Broker Rankings view. The third view is of the trade data and metrics for each individual broker within the universe, i.e., a Broker Analytics view.
[69] Figure 2 depicts a view of a User Preferences screen in accordance with an exemplary embodiment of the present invention. Along the top of User Preferences screen 200 is a horizontal menu bar 210, which is preferably present on every screen of the Application. Horizontal menu bar 210 enables users to navigate between the My Accounts view, the Broker Rankings view, and the Broker Analytics view.
[70] The My Accounts view, accessible from hyperlink 215, displays trade settlement performance statistics, organized by market, for those trading entities that have executed trades on behalf of the user. The Broker Rankings view, which is accessible from hyperlink 220, displays trade settlement performance statistics for the entire universe of brokers known to the Application. The statistics may be organized by market, as well as by Ultimate Parent broker, Parent broker, individual Principal Broker, and Principal/Clearer Pair.
[71] The trade data and calculated metrics underlying the trade settlement performance statistics for each broker are available from within the Broker Analytics view, accessible from hyperlink 225. The user may arrive at the Broker Analytics content by drilling down through the My Accounts and Broker Rankings views. Alternatively, the user may directly access a specific broker's Broker Analytics screen by searching the Application's databases for a particular broker at any level within the Ultimate Parent/Parent Principal Broker hierarchy.
[72] The Preferences view 200 is accessible via the preferences hyperlink
230. The Preferences view 200 allows the user to personalize certain Application settings and associate those settings with the user's unique login name. The currency denomination drop down box 235 allows the user to set the currency denomination in which the trade settlement statistics will be displayed. Within the Preferences component the user may also be given the option of customizing certain Application display settings, such as the font size 245. The user may also change the settings that control how data is exported from the Application using the file downloads text boxes 240.
[73] Within the Preferences component, the user may also define and manage his peer group settings. How these peer group settings are defined directly affects the relative ranking of trading entities within the Application. The peer group settings portion 250 of the screen 200 includes, for example, four text boxes 250a, 250b, 250c, and 250d, in which the user may specify percentile boundaries for each of four respective peer groups. For example, if a user were to insert the number "25" in textbox 250a, "25" in textbox 250b, "25" in textbox 250c, and "25" in textbox 250d , he will have defined four quartiles, with Peer Group One comprising the top 25 percent, Peer Group Two comprising the next 25 percent, etc.
[74] The peer groups themselves, as was previously explained, comprise a set of brokers of similar "size," where size may be determined by trade count. For example, if Peer Group One were limited to the top 5% of brokers, it would comprise the top 5% in terms of trade count within a data universe previously defined by the filtering criteria selected by the user. Filtering criteria will be described in greater detail below.
[75] Although there are four textboxes 250a-d set forth in this exemplary embodiment, a user need not create four peer groups, but may create anywhere between one and four peer groups as he sees fit. For example, a user may create a single peer group by placing the number "100" in textbox 250a (which corresponds to Peer Group One), and zeros in the rest of the textboxes 250b-d. Likewise, a user could create two peer groups by placing the number "50" in the first textbox 250a, "50" in the second textbox 250b, and zeros in the third and fourth textboxes 250c-d. The numbers inserted in textboxes 250a, 250b, 250c and 250d preferably add up to one hundred.
[76] A user may select the My Accounts hyperlink 215 to access the My
Accounts view. The My Accounts view is preferably accessible to only users who are asset managers and hold a custody account(s) and whose login identifications are successfully authenticated by the Application.
[77] Once authenticated, the user is presented with the Account Enquiry screen 300, which is depicted in Figure 3 in accordance with an exemplary embodiment of the present invention. The Account Enquiry screen may also be accessed by selecting the Account Enquiry hyperlink 320. At the Account Enquiry screen 300, a user may search for one or more custody accounts to which he is authorized access, and about which he would like to view trade settlement statistics and ranking data.
[78] The user has the option of searching through his accounts using account number textbox 310 or account name textbox 315. An asterisk symbol ("*") may be inserted in either textbox 310 or textbox 315 as a wildcard character that will cause the Application to return a list of all the accounts which the user is authorized to access. Upon returning the search results, the Application will prompt the user to select one or more of the accounts listed in order to view broker settlement statistics by country.
[79] Figure 4 depicts a Group Enquiry screen in accordance with an exemplary embodiment of the present invention. In addition to viewing settlement statistics and ranking data about a trading entity's performance on individual accounts, a user may view performance data for a defined group of custody accounts. To do so, a user may employ the Group Enquiry screen 400, accessible by selecting the Group Enquiry and Management hyperlink 325. At the Group Enquiry screen 400, groups of custody accounts may be defined by selecting the Add New Group hyperlink 415. The user may search for one or more previously defined groups using textbox 410, or may enter the wildcard character "*" to list all the groups available to the user .
[80] The results 420a of the Group Enquiry search are displayed in result display area 420. The user may select the edit/delete hyperlink 425 to either edit or delete a group . The user may also select the country hyperlink 430, Ultimate Parent Broker hyperlink 435, or Parent Broker hyperlink 440 to view trading activity statistics for the selected group, organized respectively by country, Ultimate Parent, or Parent.
[81] Figure 5 depicts the Country Summary screen in accordance with an exemplary embodiment of the present invention. The country summary lists trade and failed trade statistics for a user's accounts organized by country. The Country Summary screen 500 looks the same whether the user has arrived at it by way of the Group Enquiry screen 400 or by way of the Account Enquiry screen 300.
[82] By default, the countries listed in the Country Summary screen 500 are sorted in descending order of total trade count. The user may re-sort the countries by selecting any of the column headings corresponding to the statistics displayed, for example, Total Trade Count 510a, Total Trade Vol. (in user-specified currency) 510b, Fail Trade Count 510c, Fail Trade Volume (in user-specified currency) 510d, and Fail Rate 510e. The user may also filter the displayed statistics by selecting various filtering criteria available on the Filter Navigation Bar 515, such as, for example, by time period 515a, by transaction type 515b, by payment indicator 515c, or by security type 515d.
[83] Figure 6 depicts a Principal Broker Summary screen in accordance with an exemplary embodiment of the present invention. Selecting any one of the country hyperlinks 505 from the Country Summary screen 500 takes the user to a Principal Broker Summary screen 600, which displays a list of all the Principal Brokers 610 in the selected country that have executed trades on the user's behalf. The Principal Broker Summary screen 600 displays trade and failed trade statistics for each listed Principal Broker 610. The Principal Brokers are listed in descending order by their Total Trade Count 605 statistics. As in the Country Summary screen 500, the user may re-sort the Principal Brokers by a different statistic, by selecting the hyperlinks 605a, 605b, 605c, 605d, and 605e that correspond to the desired statistic. The trade and failed trade data displayed in the Principal Broker Summary screen 600 is dynamically generated in response to changes in the user's selection of filtering criteria contained in the Filter Navigation Bar 515.
[84] As was previously mentioned, at the Group Enquiry screen 400 the user may choose to view a summary of trade and settlement statistics at the Ultimate Parent or Parent level by selecting the Ultimate Parent Broker hyperlink 435 or the Parent Broker hyperlink 440 respectively. Figure 7 depicts an Ultimate Parent Summary screen in accordance with an exemplary embodiment of the present invention.
[85] The Parent Summary screen (not shown), is displayed in the same format as the Ultimate Parent Summary screen 700. A list of all the Ultimate Parents 705 that performed trades for the selected user accounts (or group of accounts) is displayed, sorted in alphabetical order by default. Trade and failed trade statistics for each respective broker are listed in columns 710a-e, preferably including: Total Trade Count 710a, Total Trade Volume (in user-selected currency) 710b, Fail Trade Count 710c, Fail Trade Count Vol. (in user-selected currency) 710d, and Fail Rate 710e. Selecting a column heading 710a-e causes the list of Ultimate Parents 705 to be re-sorted in terms of the selected column's set of statistics. [86] Column 715 includes, for each Ultimate Parent broker, a Markets hyperlink 715a, a Parents hyperlink 715b, and a Brokers hyperlink 715c. Selecting the Markets hyperlink 715a for an Ultimate Parent displays a Country Summary Screen 500 that lists the countries where the Ultimate Parent traded on behalf of the user's selected custody accounts. Selecting the Parents hyperlink 715b or the Brokers hyperlink 715c will cause trade and settlement data to be displayed for each of an Ultimate Parent's constituent members that performed trades on behalf of the user's selected custody accounts. Additionally, the Ultimate Parent Summary screen 700 includes an Active Filter Bar 720, that informs the user what filtering is being applied.
[87] Figure 8 depicts a screen containing a list of brokers in accordance with an exemplary embodiment of the present invention. Selecting the Brokers hyperlink 715c brings up a List of Brokers screen 800. The List of Brokers screen 800 lists the Principal Brokers 805 and, their corresponding BICs (Broker Identification Codes) in column 820 and names of their respective Parents 825. Columns 810a-e contain trade and failed trade statistics for each respective broker, preferably including: Total Trade Count 810a, Total Trade Volume (in user- selected currency) 810b, Fail Trade Count 810c, Fail Trade Count Vol. (in user- selected currency) 810d, and Fail Rate 810e. The list of Broker Names 805 may be re-sorted by any displayed category of statistic by selecting the column headings 810a-e corresponding to the desired statistic.
[88] A links column 815 provides a Markets hyperlink 815a that links to a screen that displays trade and failed trade statistics, organized by country, for each Broker Name. This Statistics by Market for Principal Broker screen 900 is depicted in Figure 9 in accordance with an exemplary embodiment of the present invention. Screen 900 includes columns of statistics organized by Market 915, preferably including: Total Trade Count 910a, Total Trade Volume (in user- selected currency) 910b, Fail Trade Count 910c, Fail Trade Count Vol. (in user- selected currency) 910d, Fail Rate 910e, and Average Fail Duration (in days) 91 Of.
[89] Each ISO country code 920 corresponds to a Market 915a, and is preferably a hyperlink to a User-Specific Broker Analytics Screen 1000, depicted in Figure 10 in accordance with an exemplary embodiment of the present invention. A User-Specific Broker Analytics Screen 1000 can also be accessed by clicking on any of the hyperlinked BICs 610 in Figure 6. Screen 1000 displays settlement performance statistics and ranking data for the individual broker named in the Broker Name portion 1002, organized by the market specified in a market drop-down box 1025. The broker-specific Statistics Column 1010 preferably lists the following metrics: Total Individual Trade Count 1010a; Total Individual Fail Count 1010b; Total Individual Trade Amount (in user-specified currency) 1010c; Total Individual Fails Amount (in user-specified currency) lOlOd; Trade Count Fail Rate lOlOe; Amount Fail Rate (in user-specified currency) lOlOf; Average Fail Duration in Business Days lOlOg; and Average Fail Duration in Actual Days lOlOh. Each metric lOlOa-h has two statistics associated with it. The first statistic, located in the My Trades column 1035, describes the broker's performance for the user's trades with that broker in the market specified in dropdown box 1025. The second statistic, located under the Distinct Broker's Universe column 1005, describes the broker's performance in aggregate for the market specified in drop-down box 1025. To view My Trades 1035 and Distinct Broker Universe 1005 statistics for a different market, the user may select a different country using the market drop-down box 1025.
[90] At the bottom right portion of the User-Specific Broker Analytics screen
1000, the broker's composite ranking 1010 in the market is displayed. As was previously described, the broker's composite ranking 1010 is relative to any filtering the user has applied using Filter Navigation Bar 515, and is also a function of the peer group settings specified in the User Preferences screen 200. Peer Group box 1015 displays the peer group that the broker falls within, and the number of members in the peer group.
[91] At the top of User-Specific Broker Analytics screen 1000, underneath the broker's name 1002, there is a broker's BIC hyperlink 1020. From here, the user may link through to the particular broker's Broker Analytics screen (depicted in Figures 18 and 19 and discussed more fully below).
[92] Figure 11 depicts a Fail Trade Summary screen in accordance with an exemplary embodiment of the present invention. A user may access the Fail Trade Summary screen 1100 by selecting the View Trade Details hyperlink 1030 from the User-Specific Broker Analytics screen 1000. The Fail Trade Summary screen 1100 displays certain information about the specific failed trades attributed to the broker. The information contained in the Fail Trade Summary screen 1100 is driven by fail codes which are populated in the industry-standard SWIFT trade instructions used by agent banks in markets around the world. The Application uses the SWIFT fail codes to determine whether the broker was at fault for a trade failure. Where the SWIFT code indicates that the broker was not at fault, the Application removes the trade failure from the broker's failed trade count.
[93] The information contained in the Fail Trade Summary screen 1100 preferably includes: the trade's reference number 1105; the custody account number 1110 associated with the trade; the type of transaction 1115; the number of actual days the trade was late 1120; the number of business days the trade was late 1125; a description of the reason the trade failed 1130; a description of the type of security that was to be traded 1135; a description of the number of units that were to be traded 1140; the amount that the failed trade was worth (in user- selected currency) 1145; and the name of the clearer 1150.
[94] The Detail hyperlink 1155 takes the user to the Fail Trade Details screen
1200, depicted in Figure 12 in accordance with an exemplary embodiment of the present invention. Screen 1200 displays more detailed information about the failed trades listed in the Fail Trade Summary screen 1200. The History hyperlink 1160 links to the Fail Reason History screen, which is depicted in Figure 13 in accordance with an exemplary embodiment of the present invention, and displays, for each failed trade the date 1305 and reason 1310 for each fail indication received by the Application.
[95] Up until now, the focus has been on describing those screens available from within the My Accounts view of the Application. The Broker Rankings view will now be described. Figure 14 depicts a screen from within the Broker Rankings view in accordance with an exemplary embodiment of the present invention. The screens available from the Broker Rankings view are all the same in appearance and layout. As an example, Figure 14 depicts the Ultimate Parent Ranking screen, which is displayed by default if the Broker Rankings hyperlink 220, is selected.
[96] The results returned will be the top n brokers worldwide within Peer
Group One as defined by the user in textbox 250a in the User Preferences screen 200 (see Figure 2). The user has the ability to view ranking tables at any level of the broker hierarchy simply by clicking on the respective hyperlinks entitled Ultimate Parent 1405, Parent 1410, Principal Broker 1415, Principal/Clearer 1420 or Market Performers 1425. Furthermore, the data can be filtered dynamically using the Filter Navigation Bar 515 in order to affect the relative rankings of the brokers; the rankings are entirely contingent upon the criteria the user has chosen to be relevant in their analysis or assessment.
[97] The ranking table header 1430 specifies the quantity of records
(brokers) returned in the table as well as in what order they are listed - 'Top' indicating the relative best and 'Bottom' indicating the relative worst. The quantity and order may also be controlled using the Select box 1435 of the Filter Navigation Bar 515.
[98] In alternative embodiments the ranking table header 1430 may also supply the user with other information pertaining to the record set he is viewing. For example, the header may display the hierarchy level for which the rankings are displayed as well as for what location(s) the rankings are relevant. The header may also tells the user by what criteria the statistics in the ranking table are sorted.
[99] The ranked results may be re-sorted by any of the trade statistics column headings 1440a through 1440h. If the user clicks once on a trade statistics column heading 1440a through 1440h, the results are ranked from best to worst. If the user clicks a trade statistics column heading 1440a through 1440h a second time, the results are then re-sorted in the reverse order.
[100] Just below the header in box 1445, the user is given information about the peer group for which he is viewing the rankings. Since the ranking tables are displayed for one peer group at a time, the user has the ability to toggle between peer groups by using the peer group drop-down box 1450 in the Filter Navigation Bar 515. The drop-down shows the percentile bands that the user has specified in Preferences and also lists the number of brokers that fall within each percentile band for the peer groups.
[101] Depending on which level of the hierarchy the user is viewing a ranking table for, there may be differences in how data may be filtered. For example, the Ultimate Parents and Parents levels, a region filtering criterion 1455 is available in the Filter Navigation Tool Bar 515 whereby the user may filter by region. Furthermore, at Ultimate Parent and Parent levels, the user has the ability to view broker rankings across all markets, effectively viewing a worldwide ranking for trade settlement performance. [102] Within the ranking tables, for each row in the table which represents a unique ultimate parent, parent, principal broker, or principal/clearer pair, the user has several options in terms of linking to different pages. There are several potential hyperlinks in the "Links" column 1460 of the broker ranking table, depending on the level of the hierarchy for which the table is displayed. The potential links are Markets 1460a, Parents 1460b, and Brokers 1460c. In the ranking table, each broker's name 1465 is also a hyperlink that will take the user to another screen. All of these hyperlinks take the user to the Broker Analytics component (discussed in greater detail below).
[103] Figure 15 depicts the Market Performers screen in accordance with an exemplary embodiment of the present invention. The Market Performers screen 1000, which is accessible from the Market Performers hyperlink 1525, displays an aggregate of a month's worth of trade data, at the country level, within the Application's database. Using the Market Performers screen 1500, the user may assess operational risk concerning trade settlement performance at a macro level within a given market. The layout of the Market Performers screen 1500 is similar to that of the Ultimate Parent Level Rankings screen 1400. In one embodiment, the Filter Navigation Bar 515 may differ slightly in that the user may be offered greater, or fewer, filtering options.
[104] For example, in Figure 15, the Filter Navigation Bar 515 for the Market Performers screen 1500 does not include the peer group drop-down box 1450 shown in Figure 14 in connection with the Ultimate Parent Level Rankings screen 1400. But the Filter Navigation Bar 515 for the Market Performers screen 1500 shows two additional filters: the activity filter 1505 and the metric filter 1510.
[105] The activity filter 1505 allows the user to restrict the market performer result set to either active or less active markets. The activity is determined by trade count whereby active markets are the top quartile of markets and less active markets represent the lower seventy-five percent. The quantity of countries that will be returned is a maximum of twenty from each group, both active and less active.
[106] The metric filter 1510 is a drop-down box which contains a small set of criteria that the user may select to view the representative list of best or worst performing markets. Similar to the ranking tables 1400, the table headings 1515 indicate active or less active markets, and the metric filter 1510 selected will be displayed in brackets in the heading 1515 as well. In the Market Performers list, each of the countries' ISO codes 1520 is hyperlinked. When the user selects one of the ISO codes 1520, the user is transferred to a ranking table for the best principal brokers in that respective market. The displayed "market performers" will be the relative best brokers from peer group one in light of the user's peer group settings and any filtering the user has selected for the data.
[107] Finally, the Broker Analytics view will be discussed. The Broker Analytics view allows the user to access all of the underlying trade statistics and metrics for every broker within the Application. All of the other components previously of the Application are linked to the Broker Analytics component. By selecting the Broker Analytics hyperlink 220 in the top menu bar of any page in the Application, however, the user may search the Application's database for a particular broker's analytics or underlying trade settlement performance data.
[108] Figure 16 depicts the Ultimate Parent Search screen in accordance with an exemplary embodiment of the present invention. Selecting the Broker Analytics hyperlink 220, directs the user to the Ultimate Parent Search screen 1600 by default. There are three submenu search items within Broker Analytics: Ultimate Parent 1605; Parent 1610; and Principal Broker 1615. Each submenu search item 1605, 1610 and 1615 directs the user to a search function for each respective level in the Broker Analytics hierarchy. [109] The Ultimate Parent search box 1620 enables the user to search the Application's database using ether a partial or full spelling of an Ultimate Parent's name. The user has the option of selecting "Starts With" or "Contains" in the adjoining drop-down box 1625 to assist in searching. The functionality of the Parent search is the same as that for the Ultimate Parent search.
[110] Figure 17 depicts a Principal Broker search screen in accordance with an exemplary embodiment of the present invention. The Principal Broker search box 1700 allows the user to perform a more directed search. The Principal Broker level is much more granular compared to the Ultimate Parent and Parent levels within the hierarchy. All trade data in the Application's data universe includes a BIC on the trade instructions. Thus, in addition to allowing the user to search for Principal Brokers by name using textbox 1705, the user may search for brokers by BIC or by a partial BIC using textbox 1710. If the user chooses to search by name, he may further narrow his search by also specifying the domicile of the Principal Broker using domicile drop-down box 1715.
[I l l] Figure 18 depicts a Broker Analytics screen in accordance with an exemplary embodiment of the present invention. As was previously mentioned in connection with the description of screen 1400 in Figure 14, the user may jump from any broker rankings screen 1400 directly to the respective Ultimate Parent, Parent, or Principal Broker's analytics screen by selecting any of the hyperlinked Ultimate Parent or Parent names, or a Principal Brokers BIC corresponding to 1465 respectively. In such a case, all filtering done with the ranking table will carry forward to the Broker Analytics screen 1800. As may be seen from Figure 18, the user may determine what filtering options are currently being applied to the data displayed on the Broker Analytics screen 1800 by examining the Filter Navigation Bar 515 bar to see which radio buttons remain selected. Additionally, the Broker Analytics screen 1800 includes an Active Filter Bar 1805, that informs the user what filtering is being applied. [112] The top box 1810 of the Broker Analytics screen 1800 lists the broker's name 1810a and the relative ranking 1810b for the broker, given the peer group and any filtering that has been applied. Below the broker's name 1810a is an Entity Level/Peer box 1815 that supplies the user with information that puts the broker's size and relative rank in context. First, the user is reminded by the hierarchy entity level indicator 1815a of the level in the hierarchy that they are viewing. In the example shown in Figure 18, the analytics are for the parent entity Parentl. To the right of the hierarchy entity level indicator 1815a, are hyperlinks 1815b and 1815c that enable the user to drill up or down in the hierarchy to see the comparable analytics page for the Ultimate Parent and Children (Principal Broker BICs) of Parentl.
[113] Below the hierarchy entity level indicator 1815a is a peer group indicator 1815d, by which the user is informed about the peer group the particular broker lies within, and the number of members in that peer group. For example, Figure 18 shows the user that Parentl is in Peer Group Two [Between 3-10% (9 Total Members)]. This specific peer grouping is dependent on the time period and other filtering on the database shown in the Filter Navigation Bar 515 and in the Active Filter Bar 1805.
[114] To view the ranking table for the specific broker relative to its peers, the user may click on the View Members hyperlink 1815e. The Application will then display the ranking table for that broker's peer group, taking into account all selected filtering criteria.
[115] Below the headers 1810 and 1815 are two boxes with trade statistics. The Total Individual Statistics box 1820 shows the unfiltered trade counts 1820a, fail counts 1820b, and fail rate 1820c for the broker across all markets given the time period filter specified. The respective filtered trade statistics appear below the active filter bar in the Filtered Trade Statistics box 1830. The Aggregate Figures for All Brokers box 1825 shows the trade count 1825a and fail count 1825b and monetary volumes 1825c for all brokers.
[116] The aggregate figures in box 1825 are dynamic and reflect whatever filtering parameters the user has specified. The figures in box 1825 are representative of the entire broker population given the filtering criteria; the numbers are not solely representative of the peer group within which specific broker in question falls.
[117] Displayed below the Active Filter Bar 1805 are all of the filtered statistics and calculated metrics for the broker. The first group of numbers is the Filtered Trade Statistics box 1830, which is a pure representation of the numbers as they exist in the Application's database. The second group of figures is the Calculated Metrics Box 1840, which relates attributes about the broker's trade settlement performance and size in the market within the Application's universe. The metrics are mainly derived as ratios of the broker's individual filtered statistics compared to the aggregate trade statistics.
[118] There are also two metrics 1840a and 1840b called Average Fail Duration, one for business days 1840a and another for calendar days 1840b, which are indicative of the broker's timely resolution of failing trades. The figures for each calculated metric are listed in a column 1840c and next to that column is also a relative ranking 1840d for each of the individual metrics. These rankings are all relative to the broker's peer group and any filtering criteria chosen by the user. A subset of these metrics rankings are used to calculate a composite rank value which is then used to calculate the broker's overall ranking 1810b.
[119] Figure 19 depicts a Principal Broker Analytics screen, in accordance with an exemplary embodiment of the present invention. When the user views the underlying Principal Broker Analytics screen 1900, a drop-down box 1905 appears below the name header 1910. The drop-down box 1905 lists all the clearing brokers that the specific principal broker uses in the specified market. Each clearer name listed represents a unique BIC.
[120] From the Principal Broker Analytics screen 1900, users have the ability to select a Fail Reason Summary hyperlink 1915 that provides a root cause summary for the broker's respective failed trades. Figure 20 depicts a Fail Reason Summary screen in accordance with an exemplary embodiment of the present invention. As was previously discussed in connection with Figure 11, the Fail Reason Summary 2000 is driven by the fail codes which are populated in the SWIFT trade instructions. Any nondescript fail codes are labeled "Unspecified" as no further details are available.
[121] Within the Principal Broker Analytics screen 1900, if the user selects the search button 1920 next to the Clearing Broker drop-down box 1905, a broker analytics screen for the distinct Principal/Clearer combination will be displayed. Figure 21 depicts a Principal/Clearer Broker Analytics screen in accordance with an exemplary embodiment of the present invention. The general layout for the Principal/Clearer Broker Analytics screen 2100 is similar to the Principal Broker Analytics screen 1900, except that there is additional information added to the trade statistics as well as to the calculated metrics. This additional information pertains to the quantity and ratio of trades that the specific clearing broker handled for the principal broker as opposed to considering solely the principal broker's activity in the market independent of the clearers used.
[122] The filtered trade statistics preferably include three additional columns 2105, 2110, and 2115. The Principal Only column 2105 displays the trade statistics for the principal broker independent of the clearer used. The Principal/Clearer column 2110 contains the trade statistics for the distinct principal/clearer pair. The Ratio column 2115 lists the ratios for the specific clearer' s contribution towards the overall principal broker's trade statistics. [123] There are also an additional two columns in the lower half of the Principal/Clearer Broker Analytics screen 2100: the Principal/Clearer Combo's Metrics column 2120, and the Principal/Clearer Ranking column 2125. For each of the individual calculated metrics, the statistics and relative ranking are still displayed for the principal broker in column 2130, independent of clearers used. However, the distinct principal/clearing combination's trade statistics are displayed in column 2120 and the relative ranking is displayed in column 2125 relative to the Principal/Clearer combination's own peer group. As such, the relative ranking of the Principal/Clearer combinations has no direct relation to the relative ranking of the Principal brokers, since the trade statistics and metrics are different and the peer groupings are distinct as well.
[124] Although the present invention has been described in relation to particular embodiments thereof, many other variations and modifications and other uses will become apparent to those skilled in the art. For example, the present invention for evaluating trading entities on the basis of settlement performance can be combined with other trading entity evaluation tools such as research and trade execution evaluators. It is preferred, therefore, that the present invention be limited not by the specific disclosure herein, but only by the appended claims.

Claims (114)

What is claimed is:
1. A distributed computer system for performing analysis on trade settlement performance, the system comprising: a data communications network; a database connected to the communications network, wherein the database stores: first data uniquely identifying one or more trading entities, second data identifying one or more trades in which the trading entities engaged, and third data describing a date on which one or more of the trades engaged in by the trading entities actually settled; a server connected to the communications network and to the database, wherein the server is programmed to: retrieve the first, second and third data, use the third data to identify which of the trades included in the second data is a failed traded, wherein a failed trade is a trade that actually settles on a date beyond a settlement date, and wherein the settlement date is a date by which the trades included in the second data should have been settled, and rank the trading entities based on their failed trades; and a plurality of workstations operatively connected to the communication network, wherein each workstation provides a user with access to the server.
2. The computer system in accordance with claim 1, wherein the server is further programmed to filter the second data and display the filtered data to the user.
3. The computer system in accordance with claim 2, wherein the filtered data may be filtered based on one or more criteria selectable by the user.
4. The computer system in accordance with claim 3, wherein the user- selectable filtering criteria includes a criterion selected from the group consisting of: a time period; a transaction type; a payment type; a security type; a geographic region; and a country.
5. The computer system in accordance with claim 4, wherein the transaction type includes buys or sells or both.
6. The computer system in accordance with claim 4, wherein the payment type includes paid transactions, or free transactions, or both.
7. The computer system in accordance with claim 4, wherein the security type includes equity, debt, other security types, or all.
8. The computer system in accordance with claim 2, wherein the server is further programmed to display the filtered data organized by market.
9. The computer system in accordance with claim 2, wherein the server is further programmed to display the filtered data organized by trading entity.
10. The computer system in accordance with claim 2, wherein the server is further programmed to display the filtered data organized by ultimate parent.
11. The computer system in accordance with claim 2, wherein the server is further programmed to display the filtered data organized by parent.
12. The computer system in accordance with claim 2, wherein the server is further programmed to display the filtered data organized by principal broker.
13. The computer system in accordance with claim 2, wherein the server is further programmed to display the filtered data organized by clearer.
14. The computer system in accordance with claim 2, wherein the server is further programmed to rank trading entities in terms of a metric selected from the group consisting of: a particular trading entity's individual total trade count as compared to an aggregate total trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total failed trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to its individual total trade count; a particular trading entity's individual total trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total failed trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to its own individual total settlement amount; and for all of a particular trading entity's failed trades, the average number of days past the settlement date that the trades actually settled.
15. The computer system in accordance with claim 14, wherein the server is further programmed to rank trading entities in terms of a market complexity factor that represents the complexity of a particular market in which a particular trading entity has executed and settled trades.
16. The computer system in accordance with claim 15, wherein the market complexity factor is calculated by: multiplying a particular trading entity's total trade count within a particular market by an efficiency ratio score for the particular market, wherein the efficiency ratio score is based upon an efficiency characteristic for the particular market, the efficiency characteristic selected from the group consisting of: trade matching requirements; a settlement type; a securities type; existence of a central depository or registry; a required lag time between a trade date and a settlement date; extent of regulatory oversight; and a securities legal framework.
17. The computer system in accordance with claim 2, wherein the server is further programmed to rank entities in terms of a particular trading entity's individual total failed trade count as compared to an aggregate total trade count for a group of trading entities.
18. The computer system in accordance with claim 2, wherein the server is further programmed to rank entities in terms of a particular trading entity's individual total failed trade count as compared to an aggregate total failed trade count for a group of trading entities.
19. The computer system in accordance with claim 2, wherein the server is further programmed to rank entities in terms of a particular trading entity's individual total failed trade count as compared to its individual total trade count:
20. The computer system in accordance with claim 2, wherein the server is further programmed to rank entities in terms of a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities.
21. The computer system in accordance with claim 2, wherein the server is further programmed to rank entities in terms of a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total failed trade settlement amount for a group of trading entities.
22. The computer system in accordance with claim 2, wherein the server is further programmed to rank entities in terms of a particular trading entity's individual total failed trade settlement amount as compared to its own individual total settlement amount.
23. The computer system in accordance with claim 2, wherein the server is further programmed to rank entities in terms of for all a particular trading entity's failed trades, the average number of days past the settlement date that the trades actually settled.
24. The computer system in accordance with claim 2, wherein the server is further programmed to rank trading entities in terms of: a particular trading entity's individual total trade count as compared to an aggregate total trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total failed trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to its individual total trade count; a particular trading entity's individual total trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total failed trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to its own individual total settlement amount; and for all a particular trading entity's failed trades, the average number of days past the settlement date that the trades actually settled.
25. The computer system in accordance with claim 24, wherein the server is further programmed to rank trading entities in terms of a market complexity factor that represents the complexity of a particular market in which a particular trading entity has executed and settled trades.
26. The computer system in accordance with claim 25, wherein the market complexity factor is calculated by: multiplying a particular trading entity's total trade count within a particular market by an efficiency ratio score for the particular market, wherein the efficiency ratio score is based upon an efficiency characteristic for the particular market, the efficiency characteristic selected from the group consisting of: trade matching requirements; a settlement type; a securities type; existence of a central depository or registry; a required lag time between a trade date and a settlement date; extent of regulatory oversight; and a securities legal framework.
27. The computer system in accordance with claim 1, wherein the server is programmed to rank the trading entities relative to a peer group.
28. The computer system in accordance with claim 27, wherein the peer group is defined by the relative size of the trading entity as measured by the number of trades in which the trading entity engaged.
29. A method of analyzing trade settlement performance, the method comprising: retrieving first data that uniquely identifies one or more trading entities; retrieving second data that identifies one or more trades in which the trading entities engaged; retrieving third data describing a date on which one or more of the trades engaged in by the trading entities actually settled; using the third set of data to identify the trades included in the second data which failed, wherein a trade failed if it actually settles on a date beyond a settlement date, and wherein the settlement date is a date by which the trades included in the second data should have been settled; and ranking the trading entities based on their failed trades.
30. The method in accordance with claim 29, further comprising: filtering the second data; and displaying the filtered data to the user.
31. The method in accordance with claim 30, wherein the filtering step further comprises filtering based on one or more criteria selectable by the user.
32. The method in accordance with claim 31, wherein the filtering step includes filtering by a criterion selected from the group consisting of: a time period; a transaction type; a payment type; a security type; a geographic region; and a country.
33. The method in accordance with claim 32, wherein the transaction type filtering criteria includes buys or sells or both.
34. The method in accordance with claim 32, wherein the payment type includes paid transactions or free transactions, or both.
35. The method in accordance with claim 32, wherein the security type includes equity, debt, other security types or all.
36. The method in accordance with claim 30, further comprising displaying the filtered data organized by market.
37. The method in accordance with claim 30, further comprising displaying the filtered data organized by trading entity.
38. The method in. accordance with claim 30, further comprising displaying the filtered data organized by ultimate parent.
39. The method in accordance with claim 30, further comprising displaying the filtered data organized by parent.
40. The method in accordance with claim 30, further comprising displaying the filtered data organized by principal broker.
41. The method in accordance with claim 30, further comprising displaying the filtered data organized by clearer.
42. The method in accordance with claim 30, further comprising the step of ranking each trading entity in terms of a metric selected from the group consisting of: a particular trading entity's individual total trade count as compared to an aggregate total trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total failed trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to its individual total trade count; a particular trading entity's individual total trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total failed trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to its own individual total settlement amount; and for all of a particular trading entity's failed trades, the average number of days past the settlement date that the trades actually settled.
43. The method in accordance with claim 42, further comprising the step of ranking trading entities in terms of a market complexity factor that represents the complexity of a particular market in which a particular trading entity has executed and settled trades.
44. The method in accordance with claim 43, further comprising the step of calculating the market complexity factor by: multiplying a particular trading entity's total trade count within a particular market by an efficiency ratio score for the particular market, wherein the efficiency ratio score is based upon an efficiency characteristic for the particular market, the efficiency characteristic selected from the group consisting of: trade matching requirements; a settlement type; a securities type; existence of a central depository or registry; a required lag time between a trade date and a settlement date; extent of regulatory oversight; and a securities legal framework.
45. The method in accordance with claim 30, further comprising the step of ranking each trading entity in terms of a particular trading entity's individual total failed trade count as compared to an aggregate total trade count for a group of trading entities.
46. The method in accordance with claim 30, further comprising the step of ranking each trading entity in terms of a particular trading entity's individual total failed trade count as compared to an aggregate total failed trade count for a group of trading entities.
47. The method in accordance with claim 30, further comprising the step of ranking each frading entity in terms of a particular trading entity's individual total failed trade count as compared to its individual total trade count.
48. The method in accordance with claim 30, further comprising the step of ranking each trading entity in terms of a particular trading entity's individual total failed frade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities.
49. The method in accordance with claim 30, further comprising the step of ranking each trading entity in terms of a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total failed trade settlement amount for a group of trading entities.
50. The method in accordance with claim 30, further comprising the step of ranking each trading entity in terms of a particular trading entity's individual total failed trade settlement amount as compared to its own individual total settlement amount.
51. The method in accordance with claim 30, further comprising the step of ranking each trading entity in terms of, for all a particular trading entity's failed trades, the average number of days past the settlement date that the trades actually settled.
52. The method in accordance with claim 30, further comprising the step of ranking each trading entity in terms of: a particular trading entity's individual total trade count as compared to an aggregate total trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total failed trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to its individual total trade count; a particular trading entity's individual total trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total failed trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to its own individual total settlement amount; and for all of a particular trading entity's failed trades, the average number of days past the settlement date that the trades actually settled.
53. The method in accordance with claim 52, further comprising the step of ranking trading entities in terms of a market complexity factor that represents the complexity of a particular market in which a particular trading entity has executed and settled frades.
54. The method in accordance with claim 53, further comprising the step of calculating the market complexity factor by: multiplying a particular trading entity's total trade count within a particular market by an efficiency ratio score for the particular market, wherein the efficiency ratio score is based upon an efficiency characteristic for the particular market, the efficiency characteristic selected from the group consisting of: trade matching requirements; a settlement type; a securities type; existence of a central depository or registry; a required lag time between a trade date and a settlement date; extent of regulatory oversight; and a securities legal framework.
55. The method in accordance with claim 29, wherein the server is programmed to rank the brokers relative to a peer group.
56. The method in accordance with claim 55, wherein the peer group is defined by the relative size of the trading entity as measured by the number of trades in which the trading entity has engaged.
57. A distributed computer system for performing analysis on trade settlement performance, the system comprising: a data communications network; a database connected to the communications network, wherein the database stores: first data uniquely identifying one or more trading entities; second data identifying one or more trades, for a specified account, in which the trading entities engaged; and third data describing a date on which one or more of the trades engaged in by the trading entities; a server connected to the communications network and to the database, wherein the server is programmed to: retrieve the first, second and third data; use the third data to identify which of the frades included in the second data is a failed traded, wherein a failed trade is a trade that actually settles on a date beyond a settlement date, and wherein the settlement date is a date by which the trades included in the second data should have been settled, and rank the trading entities based on their failed trades; and a plurality of workstations operatively connected to the communication network, wherein each workstation provides a user with access to the server.
58. The computer system in accordance with claim 57, wherein the server is further programmed to: filter the second data; and display the filtered data to the user.
59. The computer system in accordance with claim 58, wherein the filtered data may be filtered based on one or more criteria selectable by the user.
60. The computer system in accordance with claim 59, wherein the user- selectable filtering criteria includes a criterion selected from the group consisting of: a time period; a transaction type; a payment type; a security type; a geographic region; and a country.
61. The computer system in accordance with claim 60, wherein the transaction type includes buys or sells or both.
62. The computer system in accordance with claim 60, wherein the payment type includes paid transactions, or free transactions, or both.
63. The computer system in accordance with claim 60, wherein the security type includes equity, debt, other security types, or all.
64. The computer system in accordance with claim 58, wherein the server is further programmed to display the filtered data organized by market.
65. The computer system in accordance with claim 58, wherein the server is further programmed to display the filtered data organized by trading entity.
66. The computer system in accordance with claim 58, wherein the server is further programmed to display the filtered data organized by ultimate parent.
67. The computer system in accordance with claim 58, wherein the server is further programmed to display the filtered data organized by parent.
68. The computer system in accordance with claim 58, wherem the server is further programmed to display the filtered data organized by principal broker.
69. The computer system in accordance with claim 58, wherein the server is further programmed to display the filtered data organized by clearer.
70. The computer system in accordance with claim 58, wherein the server is further programmed to rank trading entities in terms of a metric selected from the group consisting of: a particular trading entity's individual total trade count as compared to an aggregate total frade count for a group of trading entities; a particular trading entity's individual total failed frade count as compared to an aggregate total frade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total failed trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to its individual total trade count; a particular trading entity's individual total trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed frade settlement amount as compared to an aggregate total failed frade settlement amount for a group of trading entities; a particular trading entity's individual total failed frade settlement amount as compared to its own individual total settlement amount; and for all of a particular trading entity's failed trades, the average number of days past the settlement date that the trades actually settled.
71. The computer system in accordance with claim 70, wherein the server is further programmed to rank trading entities in terms of a market complexity factor that represents the complexity of a particular market in which a particular trading entity has executed and settled trades.
72. The computer system in accordance with claim 71, wherein the market complexity factor is calculated by: multiplying a particular trading entity's total trade count within a particular market by an efficiency ratio score for the particular market, wherein the efficiency ratio score is based upon an efficiency characteristic for the particular market, the efficiency characteristic selected from the group consisting of: trade matching requirements; a settlement type; a securities type; existence of a central depository or registry; a required lag time between a trade date and a settlement date; extent of regulatory oversight; and a securities legal framework.
73. The computer system in accordance with claim 58, wherein the server is further programmed to rank entities in terms of a particular trading entity's individual total failed trade count as compared to an aggregate total trade count for a group of trading entities.
74. The computer system in accordance with claim 58, wherein the server is further programmed to rank entities in terms of a particular trading entity's individual total failed frade count as compared to an aggregate total failed trade count for a group of trading entities.
75. The computer system in accordance with claim 58, wherein the server is further programmed to rank entities in terms of a particular trading entity's individual total failed trade count as compared to its individual total trade count.
76. The computer system in accordance with claim 58, wherein the server is further programmed to rank entities in terms of a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total trade settlement amount for a group of frading entities.
77. The computer system in accordance with claim 58, wherein the server is further programmed to rank entities in terms of a particular trading entity's individual total failed frade settlement amount as compared to an aggregate total failed trade settlement amount for a group of frading entities.
78. The computer system in accordance with claim 58, wherein the server is further programmed to rank entities in terms of a particular frading entity's individual total failed trade settlement amount as compared to its own individual total settlement amount.
79. The computer system in accordance with claim 58, wherein the server is further programmed to rank entities in terms of for all a particular trading entity's failed trades, the average number of days past the settlement date that the trades actually settled.
80. The computer system in accordance with claim 58, wherein the server is further programmed to rank trading entities in terms of: a particular trading entity's individual total trade count as compared to an aggregate total trade count for a group of frading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total failed trade count for a group of frading entities; a particular trading entity's individual total failed trade count as compared to its individual total trade count; a particular trading entity's individual total trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total frade settlement amount for a group of trading entities; a particular trading entity's individual total failed frade settlement amount as compared to an aggregate total failed trade settlement amount for a group of trading entities; a particular frading entity's individual total failed trade settlement amount as compared to its own individual total settlement amount; and for all of a particular trading entity's failed frades, the average number of days past the settlement date that the trades actually settled.
81. The computer system in accordance with claim 80, wherein the server is further programmed to rank trading entities in terms of a market complexity factor that represents the complexity of a particular market in which a particular trading entity has executed and settled trades.
82. The computer system in accordance with claim 81, wherein the market complexity factor is calculated by: multiplying a particular trading entity's total trade count within a particular market by an efficiency ratio score for the particular market, wherein the efficiency ratio score is based upon an efficiency characteristic for the particular market, the efficiency characteristic selected from the group consisting of: trade matching requirements; a settlement type; a securities type; existence of a central depository or registry; a required lag time between a trade date and a settlement date; extent of regulatory oversight; and a securities legal framework.
83. The computer system in accordance with claim 57, wherein the server is programmed to rank the trading entities relative to a peer group.
84. The computer system in accordance with claim 83, wherein the peer group is defined by the relative size of the trading entity as measured by the number of trades in which the frading entity engaged.
85. A method of analyzing trade settlement performance, the method comprising: retrieving first data that uniquely identifies one or more frading entities; retrieving second data that identifies one or more frades, for a specified account, in which the trading entities engaged; retrieving third data describing a date on which one or more of the trades engaged in by the frading entities for a specified account actually settled; using the third set of data to identify the trades included in the second data which failed, wherein a trade failed if it actually settles on a date beyond a settlement date, and wherein the settlement date is a date by which the trades included in the second data should have been settled; and ranking the trading entities based on their failed trades.
86. The method in accordance with claim 85, further comprising: filtering the second data; and displaying the filtered data to the user.
87. The method in accordance with claim 86, wherein the filtering step further comprises filtering based on one or more criteria selectable by the user.
88. The method in accordance with claim 87, wherein the filtering step includes filtering by a criterion selected from the group consisting of: a time period; a transaction type; a payment type; a security type; a geographic region; and a country.
89. The method in accordance with claim 88, wherein the transaction type filtering criteria includes buys or sells or both.
90. The method in accordance with claim 88, wherein the payment type filtering criteria includes paid transactions or free transactions, or both.
91. The method in accordance with claim 88, wherein the security type filtering criteria includes equity, debt, other security types, or all.
92. The method in accordance with claim 86, further comprising displaying the filtered data organized by market.
93. The method in accordance with claim 86, further comprising displaying the filtered data organized by trading entity.
94. The method in accordance with claim 86, further comprising displaying the filtered data organized by ultimate parent.
95. The method in accordance with claim 86, further comprising displaying the filtered data organized by parent.
96. The method in accordance with claim 86, further comprising displaying the filtered data organized by principal broker.
97. The method in accordance with claim 86, further comprising displaying the filtered data organized by clearer.
98. The method in accordance with claim 86, further comprising the step of ranking each trading entity in terms of a metric selected from the group consisting of: a particular trading entity's individual total trade count as compared to an aggregate total frade count for a group of trading entities; a particular frading entity's individual total failed trade count as compared to an aggregate total frade count for a group of trading entities; a particular frading entity's individual total failed trade count as compared to an aggregate total failed frade count for a group of trading entities; a particular trading entity's individual total failed frade count as compared to its individual total frade count; a particular trading entity's individual total trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular frading entity's individual total failed trade settlement amount as compared to an aggregate total failed trade settlement amount for a group of trading entities; a particular trading entity's individual total failed trade settlement amount as compared to its own individual total settlement amount; and for all of a particular trading entity's failed trades, the average number of days past the settlement date that the trades actually settled.
99. The method in accordance with claim 98, further comprising the step of ranking frading entities in terms of a market complexity factor that represents the complexity of a particular market in which a particular trading entity has executed and settled trades.
100. The method in accordance with claim 99, further comprising the step of calculating the market complexity factor by: multiplying a particular trading entity's total trade count within a particular market by an efficiency ratio score for the particular market, wherein the efficiency ratio score is based upon an efficiency characteristic for the particular market, the efficiency characteristic selected from the group consisting of: trade matching requirements; a settlement type; a securities type; existence of a central depository or registry; a required lag time between a frade date and a settlement date; extent of regulatory oversight; and a securities legal framework.
101. The method in accordance with claim 86, further comprising the step of ranking each trading entity in terms of a particular trading entity's individual total failed trade count as compared to an aggregate total trade count for a group of trading entities.
102. The method in accordance with claim 86, further comprising the step of ranking each trading entity in terms of a particular frading entity's individual total failed trade count as compared to an aggregate total failed trade count for a group of trading entities.
103. The method in accordance with claim 86, further comprising the step of ranking each trading entity in terms of a particular trading entity's individual total failed trade count as compared to its individual total trade count.
104. The method in accordance with claim 86, further comprising the step of ranking each trading entity in terms of a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total frade settlement amount for a group of trading entities.
105. The method in accordance with claim 86, further comprising the step of ranking each frading entity in terms of a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total failed frade settlement amount for a group of trading entities.
106. The method in accordance with claim 86, further comprising the step of ranking each trading entity in terms of a particular trading entity's individual total failed trade settlement amount as compared to its own individual total settlement amount.
107. The method in accordance with claim 86, further comprising the step of ranking each trading entity in terms of, for all a particular trading entity's failed trades, the average number of days past the settlement date that the frades actually settled.
108. The method in accordance with claim 86, further comprising the step of ranking each trading entity in terms of: a particular frading entity's individual total trade count as compared to an aggregate total trade count for a group of trading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total frade count for a group of frading entities; a particular trading entity's individual total failed trade count as compared to an aggregate total failed frade count for a group of trading entities; a particular frading entity's individual total failed frade count as compared to its individual total trade count; a particular trading entity's individual total trade settlement amount as compared to an aggregate total frade settlement amount for a group of frading entities; a particular trading entity's individual total failed trade settlement amount as compared to an aggregate total trade settlement amount for a group of trading entities; a particular trading entity's individual total failed frade settlement amount as compared to an aggregate total failed frade settlement amount for a group of trading entities; a particular trading entity's individual total failed frade settlement amount as compared to its own individual total settlement amount; and for all of a particular frading entity's failed trades, the average number of days past the settlement date that the trades actually settled.
109. The method in accordance with claim 52, further comprising the step of ranking trading entities in terms of a market complexity factor that represents the complexity of a particular market in which a particular trading entity has executed and settled frades.
110. The method in accordance with claim 53, further comprising the step of calculating the market complexity factor by: multiplying a particular trading entity's total trade count within a particular market by an efficiency ratio score for the particular market, wherein the efficiency ratio score is based upon an efficiency characteristic for the particular market, the efficiency characteristic selected from the group consisting of: trade matching requirements; a settlement type; a securities type; existence of a central depository or registry; a required lag time between a frade date and a settlement date; extent of regulatory oversight; and a securities legal framework.
111. The method in accordance with claim 110, further comprising the step of ranking frading entities in terms of a market complexity factor that represents the complexity of a particular market in which a particular frading entity has executed and settled frades.
112. The method in accordance with claim 111, further comprising the step of calculating the market complexity factor by: multiplying a particular frading entity's total frade count within a particular market by an efficiency ratio score for the particular market, wherein the efficiency ratio score is based upon an efficiency characteristic for the particular market, the efficiency characteristic selected from the group consisting of: trade matching requirements; a settlement type; a securities type; existence of a central depository or registry; a required lag time between a frade date and a settlement date; „ extent of regulatory oversight; and a securities legal framework.
113. The method in accordance with claim 85, wherein the server is programmed to rank the brokers relative to a peer group.
114. The method in accordance with claim 113, wherein the peer group is defined by the relative size of the frading entity as measured by the number of trades in which the frading entity has engaged.
AU2002314841A 2001-06-01 2002-05-31 System and method for trade settlement tracking and relative ranking Abandoned AU2002314841A1 (en)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US60/295,397 2001-06-01

Publications (1)

Publication Number Publication Date
AU2002314841A1 true AU2002314841A1 (en) 2002-12-16

Family

ID=

Similar Documents

Publication Publication Date Title
US7401048B2 (en) System and method for trade settlement tracking and relative ranking
US11823263B2 (en) Apparatus, method and system for providing an electronic marketplace for trading credit default swaps and other financial instruments, including a trade management service system
US7720742B1 (en) Computer trading system method and interface
US7827080B2 (en) Fixed income securities ratings visualization
US8036966B2 (en) System and method for facilitating foreign currency management
US6408282B1 (en) System and method for conducting securities transactions over a computer network
US7430532B2 (en) System and method for trade entry
US20010056398A1 (en) Method and system for delivering foreign exchange risk management advisory solutions to a designated market
US8630937B1 (en) System and method for analyzing and searching financial instrument data
US20030182220A1 (en) Method and system for providing financial information and evaluating securities of a financial debt instrument
US20030154151A1 (en) System and method for multiple account single security trading
US20020152151A1 (en) Integrated investment portfolio management system and method
US20110125672A1 (en) Method and system for providing electronic information for risk assesement and management via dynamic total net worth for multi-market electronic trading
WO2000052619A1 (en) A system and method for conducting securities transactions over a computer network
US8548885B2 (en) Fixed income securities ratings visualization
US20070282759A1 (en) Method of reporting and analyzing financial and investment data and information
WO2008070388A1 (en) Financial management system and related methods
AU773465B2 (en) Global investor client access system
US20030187777A1 (en) System and method for updating valuation data relating to pass-through securities
US7219077B1 (en) System and method for creating model investment portfolios
AU2002314841A1 (en) System and method for trade settlement tracking and relative ranking
WO2005094284A2 (en) Method and system for effecting straight-through-processing of trades of various financial instruments
JP2004527020A (en) Apparatus and method for facilitating online financial transactions
CA2548568A1 (en) Method of reporting and analyzing financial and investment data and information