You are here: Home > Back Office Solutions > Data Aggregation    

SHG Data Aggregator

Internet driven investment management and trading applications and services are rapidly gaining momentum and quickly approaching critical mass. The Internet provides users with a wide range of choices for inexpensive rapid access to financial information and trading opportunities.

However, access to this data and related services is stilled plagued by a number of problems that make Internet trading and portfolio management less than ideal, especially for large investors. Specifically, lack of standards between vendors and no unified or normalized data formats, as well as lack of overall redundancy hamper the efforts of serious investors from fully utilizing the Internet.

Consolidating data records obtained from different custodians, brokers and FCMs is a daunting task. Each source often uses its own symbol sets, asset categories, transaction codes, price quotes, and trade date conventions. In addition, trades, purchases and sales, collateral activity, commissions, and other items are often represented by different record types based on the record holder's accounting system practices. These differences must be resolved before data records from different sources can be consolidated into a single portfolio view.

SHG Services provides a solution for all of these problems:  SHG Aggregator. SHG Aggregator provides a uniform data format for portfolio management across multiple custodians and brokers. Immediate, automatic electronic access to nightly and even intra-day data. SHG Aggregator deals with the diversity of data formats, record layouts, and information encoding schemes by maintaining a separate set of translation rules and tables for each data source. These rules and tables are used during the data loading process to transform the original source data into a uniform database structure.

In addition to it's own internal system, SHG has engineered multiple custom tailored automatic data translation and distribution systems, for the delivery of both nightly custodial data, as well as futures and commodities brokerage data to institutional clients. This same technology is easily adapted to any institutional investor, advisor or consultant environment.

SHG Services has over 13 years experience in designing and implementing data collection, consolidation and normalization systems. SHG Services provides either custom solutions or can license and apply it's own internal data format to provide many-to-one-to-many data transferal.

Summary of SHG  Aggregator Services
------------------------------------------------------------------------------------------------

Multiple Custodial Data Feeds To

  • Portfolio Accounting Systems
  • Performance Reporting Systems
 

FCM/Broker Data Feeds To

  • Order Management Systems
  • Back Office Systems
  • VAR Systems
     

3rd Party Data System Feeds

  • Pricing Vendors to PAS and PRS
  • Holdings Data Vendors to PAS and PRS
  • Ancillary Data Aggregation
 

Data Cleansing & Scrubbing

  • We can provide the tools and training for your own Operational cleansing
  • We can also provide short to longer term data cleansing and normalization support
     

Web Based Reporting Systems

  • SHG Services provides experts the design and implementation of custom web based Account and Performance reporting systems.
  • From systems that automatically generate Quarterly Report Books to dynamic web driven reports, SHG Services has the experts to help you design the ideal reporting system.
   

Portfolio Accounting Systems Operations Personnel

  • SHG Services can provide experts in the loading and recon process for multiple PAS Systems.
  • SHG Services can provide short to longer term PAS support personnel. From initial consultation and installation work to ongoing operations.