Systems and methods for analysis of portfolio returns and trade cost measurement based on fiduciary roles
Preferred embodiments of the present invention comprise, for example, a method for measuring trade costs, comprising (1) capturing trade data over a predetermined time period; (2) capturing time stamp data corresponding to said trade data, wherein said time stamp data comprises open events and close events, data regarding when an order is received by a buy-side trading desk from a portfolio manager; data regarding when execution of said order is completed, and data regarding when a manager decides to engage in trading regarding said order; and (3) performing an investment level analysis based on said trade data and said time stamp data. Further embodiments comprise systems and software for implementing the above method (and others) and utilizing information obtained therefrom.
1. A computer system for measuring and analyzing trade costs, comprising
a computer programmed to
capture trade data, including corresponding time stamp data, over a predetermined time period;
choose items from the data;
arrange results from the choosing into groups;
summarize items within each group, including per-item gains/losses that result from time delays according to the time stamp data;
apply summation formulae to the summarized items; and
display the results; and
a database or database server for storing the data.
2. A computer system for measuring and analyzing trade costs, comprising:
a computer programmed to
capture trade data, including corresponding time stamp data, over a predetermined time period, and
an online analytical processing (OLAP) system for storing the data;
the computer being further programmed to
arrange results from the OLAP system into groups, and store the results in the OLAP system;
store an aggregation specification of configuration data that describes combinations of group dimensions to be pre-calculated;
the OLAP system being configured to
pre-calculate aggregations defined by the aggregation specification, including per-item gains/losses that result from time delays according to the time stamp data;
the computer being further programmed to
choose items from the pre-calculated aggregations based on the query or report specification;
apply summation formulae to the chosen aggregations; and
display the results.
3. A system according to claim 2 , wherein the computer is further programmed to produce an aggregation specification based on input data statistics.
4. A system according to claim 1 , wherein the computer is further programmed to determine average order execution prices for each item, multiply the result by a share amount and total the resulting number.
5. A system according to claim 2 , wherein the computer is further programmed to determine average order execution prices for each item, multiply the result by a share amount and total the resulting number.
6. A system according to claim 3 , wherein the computer is further programmed to determine average order execution prices for each item, multiply the result by a share amount and total the resulting number.
7. A system according to claim 1 , wherein the computer is further programmed to choose items from the data based on a stored query or report specification.
8. A system according to claim 2 , wherein the computer is further programmed to choose items from the data based on a stored query or report specification.
9. A system according to claim 3 , wherein the computer is further programmed to choose items from the data based on a stored query or report specification.
10. A system according to claim 1 , wherein the computer is further programmed to be responsive to the query or report specification for arranging results from the choosing into groups in accordance with the query or report specification, such that each group corresponds to one detail line in a final display or report.
11. A system according to claim 2 , wherein the computer is further programmed to be responsive to the query or report specification for arranging results from the choosing into groups in accordance with the query or report specification, such that each group corresponds to one detail line in a final display or report.
12. A system according to claim 1 , wherein the computer is further programmed to apply summation formulae to selected aggregations to provide a series of rows, each containing an identifier from the results arranged into groups and a principal traded amount for that identifier and related results.
13. A system according to claim 2 , wherein the computer is further programmed to apply summation formulae to selected aggregations to provide a series of rows, each containing an identifier from the results arranged into groups and a principal traded amount for that identifier and related results.