Investics DARTS Investment Manager Evaluation Analytics (iMEA)

By applying Cumulative Sum (CUSUM) theory to detect whether the quality of a process is normal, improving or deteriorating, this service calculates a Precision Weighted Excess Return (PWER) score, along with other statistics, to measure if a particular fund or investment management firm are more likely to outperform peer group funds on a consistent basis, and by how much.

Developed by Northfield Information Services, Inc. and not publically available until now, this service and its underlying theory  has been applied on some very high profile events over the years in the institutional investment industry, including assisting the SEC in determining that it was highly unlikely Bernie Madoff could achieve the performance results claimed based on the fund's objectives, leading to his eventual arrest . Click [here](https://www.google.com/search?q=northfield+madoff+dibartolomeo &rlz=1CAMISA_enUS992US992&sxsrf=ALiCzsaIYyltwCFl3sbXvcfbgnlluMAUig%3A1666880585795&ei=SZRaY76LMMieptQP0-qb8AI&ved=0ahUKEwj-08uJzoD7AhVIj4kEHVP1Bi4Q4dUDCBA&uact=5&oq=northfield+madoff+dibartolomeo&gs_lp=Egdnd3Mtd2l6uAED-AEBMgQQIxgnMgQQIxgnMgQQIxgnwgIKEAAYRxjWBBiwA8ICBRAhGKABkAYESKscUMwPWIETcAJ4AMgBAJABAJgBkgGgAYsCqgEDMC4y4gMEIE0YAeIDBCBBGADiAwQgRhgAiAYB&sclient=gws-wiz) see related press articles.

This service offers a monthly download of data for approximately 25,000 investment funds, 700 investment management firms and 160 peer groups, as well as access to a series of interactive dashboards to search, screen, look up and download PWER scores, along with related statistics and underlying supporting information including alpha, correlation, variance, tracking error and percentile ranks.

If a fund no longer correlates tightly with its original peer group (often set by the investment management firm at fund inception), this service automatically identifies and tracks the PWER against the more highly correlated reclassified peer group in order to recognize the type of return pattern a fund is likely to achieve in the future. A demonstration version of the service containing the current month’s top 10 funds and investment managers PWER scores and supporting data for each of the over 150 peer groups can be accessed through a complementary dashboard by clicking here .

• Update Frequency | Monthly
• Geographic coverage | US
• Number of funds covered | >24k
• Time period coverage | Current and historic
• Is historical data “point-in-time” | YES
• Dataset Formats | CSV, JSON (as well as GlueParquet, Parquet, AVRO, ORC, Tableau HYPER & XML filetypes when subscribed in conjunction with the Investics Cloud Ecosystem (ICE))
• Compression Formats Available | Snappy ,GZIP, LZ4, Bzip2, Deflate & Brotli when subscribed in conjunction with the Investics Cloud Ecosystem (ICE)

As a value added enrichment, Investics DARTS is designed to deliver datasets ready for downstream software consumption (BI Tools, report writers, cloud services, data lakes, data warehouses, databases and spreadsheets, just to name a few) by normalizing content across different data sources and remediating common anomalies which can cause data to be misinterpreted, rejected, dropped, misaligned or require additional redundant manual steps to make the data usable.

For Investics DARTS subscribers who also subscribe to the Investics Cloud Ecosystem (ICE) and along with many other Investics ICE benefits, your Investics DARTS data files will automatically be propagated to your Investics ICE Bucket immediately after the DARTS AWS Data Exchange dataset revisions are added to the subscribed Investics DARTS product offerings. The Investics ICE framework can provide great assistance directly in investment analysis, as well as automating the flow of data from Investics DARTS to other systems, software and processes. For additional information on Investics ICE, please see below.

These Investics DARTS files are renamed when they arrive in the Investics ICE Bucket with date and time stamp for archiving and retrieval purposes and can be found in your AWS S3 Investics ICE Bucket under the folder\file names (with no spaces): \ Investics \ DARTS \ {vendor name} \ {vendor product name} \ {vendor sub-product name(s)} \ {filename} _ {date time stamp} . {filetype} . {compression filetype (if any)}

Background - ICE is a native cloud investment data and analytics platform-as-a-service (PaaS) which can be hosted by Investics as a managed service or provided standalone in a client’s own AWS environment. ICE can help institutional investors achieve “The Complete Investment Picture” across the multi-asset class risk and return spectrum. Running on Amazon Web Services (AWS), Investics ICE is a next generation native cloud investment data and analytics platform which combines data collection, aggregation, modeling and management with dynamic calculation engines and visualizations to meet common institutional investor industry requirements including performance measurement, risk analytics, investment compliance and regulatory reporting.

ICE has four primary components:​

1. DARTS Data Aggregation Remediation Transformation Service - DARTS is a data delivery supermarket delivered through AWS Data Exchange. Subscribers can easily procure vendor data modeled and optimized for immediate use in downstream cloud and non-cloud software, BI Tools and systems. Data available through DARTS today include portfolio holdings and transactions, ESG, risk statistics, characteristics, benchmarks, security master and reference.
2. Fusion Data fabric construct - manage and govern the stitching and modeling of different institutional investor datasets for almost any downstream investment data and analytics use case. Data wrangling recipes provided via crowdsourcing. Automatically generate fit-for-purpose materialized views, data cubes and data marts.
3. IMPRES In-Memory Performance Risk Engine System - next generation performance and risk analytical engine which has maximum flexibility to instantly calculate in real time a truly customized risk and return service. IMPRES can accommodate some of today’s toughest performance measurement challenges including ABOR to IBOR to PBOR transformation, appropriate handling of private investments, flexible hierarchies,attribution and risk.
4. Vision Data visualization - produce highly customized interactive dashboards and reports with embedding capabilities to seamlessly integrate visualizations into clients’ own websites.

All of the ICE components are designed to deliver datasets ready for downstream software consumption (BI Tools, report writers, cloud services, data lakes, data warehouses, databases and spreadsheets, just to name a few) by normalizing content across different data sources and remediating common anomalies which can cause data to be misinterpreted, rejected, dropped, misaligned or require additional redundant manual steps to make the data usable. In addition, all of the ICE components can work independently or in tandem with each other. In fact, ICE will automatically flow DARTS subscription data, along with its metadata, straight through into ICE in order to automatically stitch related data together (including holdings and reference data) and generate materialized views, data cubes and data marts instantly connectable to value added data management capabilities, calculation engines and visualizations to accommodate an almost unlimited set of use cases.

For existing subscribers to AWS, it takes only about 10 minutes and costs virtually nothing to subscribe to ICE. ICE itself takes about 3 minutes to spin up once a subscriber has clicked through the subscription agreement options and provided some contact information. Upon verification by an Investics support staff member, a new subscriber receives a link to their hosted ICE environment via email and they are up and running. After a subscription to either ICE and a new DARTS offering it takes about 36 hours for DARTS subscription data and ICE to synchronize and begin to automatically update your Investics ICE Bucket.

For further information on the Investics Cloud Ecosystem (ICE), please click [here.](https://aws.amazon.com/marketplace/pp/B0891NJKK2?qid=1616106875447 &sr=0-3&ref_=srh_res_product_title)

Do not hesitate to contact us at info@investics.com  or +1.781.472.2163 (during normal EST business hours).