HomeLatest News Performance & Risk Systems
Performance & Risk Systems: Lessons Learnt from Implementing such Solutions in Asset Managers
Background
This article has been written by David King, who runs the consultancy function at FusionExperience, who have been very active in the performance and risk arenas over the past 2 years. David provides some insight into the lessons learnt from such projects.

What Do We Mean By Performance & Risk?
As a consultancy company advising our customers on products and services available in the market, it is sometimes quite difficult to distinguish between the solutions which have been traditionally aimed at the needs of the performance or risk manager and the solutions aimed at the fund manager or quant analyst.

The market for risk systems is littered with a large number of suppliers, many of whom can be very small in terms of company size and numbers of client implementations. Such tools tend to be proprietary and aimed at individual users’ need to manipulate portfolio, benchmark and fundamentals data to satisfy specific requirements at a point in time. Risk systems tend to provide ex-ante risk modelling algorithms which allow future forecasting of portfolio characteristics based on certain event types. Similarly, this can be applied to back testing of the resilience of portfolios were such events to occur in the past.

Performance systems are by their very nature backward looking in terms of investment returns. Resilience of past returns can be measured in the form of ex-post risk measures through statistical analysis of the volatility of returns and expressed in the form of statistics such as Sharpe ratio. Where we have seen confusion is in areas such as UCITS 3 fund reporting, which requires the ex-post analysis of portfolio Value at Risk (VaR). Such analysis is currently only available through risk type systems.

Organisational changes within asset management organisations have tended to try to align the risk and performance management functions under a single management structure. This makes sense in terms of ensuring a consistency of methodology, but is often a problem for the fund managers who see ex-ante risk modelling as their own tool to assist in the construction of portfolios.

Instruments, Products, Fund Types…
The landscape becomes more complex when we introduce new instruments or products and new fund types. One aspect that we at FusionExperience always look at in the selection of a supplier, is their heritage – where have they come from?

One of the issues around fixed income performance attribution, for example, is that the majority of players in the traditional performance attribution market come from an equity background. It is a major step for such suppliers to move into the fixed income market. One might argue that it may be an impossible step to move into the fixed income OTC market; the skill of supplier selection is making intelligent bets and subsequently backing them up with risk mitigation strategies around implementation.

At FusionExperience, our product and supplier scoring mechanisms tend to focus not only on the product but the heritage of the supplier, and the number of degrees by which they have had to adjust their core focus to provide the services that our client is now asking for. The size and agility of the supplier concerned is also a key factor. In most cases big is not better; but on the other hand small is not necessarily beautiful….

Project Scope
Any performance project is heavily reliant on data. Implementation of performance systems can be made simpler by a significant factor if the supplier of the system also provides data. However, be careful what this means. There are certain suppliers that offer a data aggregation service; that means that they receive market data from multiple sources and validate it prior to providing it to you in a single format. Other vendors may offer benchmark and other data but charge you a premium for collecting it from the various benchmark providers without providing a validation/cleansing service.

It is also important to establish, up front, whether you sign just one master contract with the supplier of the performance system in order to receive market data or whether you must enter into separate agreements with the market data vendors too. In short, be aware of the service you are receiving and be clear on any premium that you are paying in price terms and how that elates to improved service.

The performance team itself will have a number of differing requirements ranging from measurement of returns on a buy & hold basis, full daily time weighted stock level returns, attribution based on equity style models (such as Brinson, Karnovsky-Singer), fixed income attribution (such as the GRAP methodology), global GIPS compliance under CFA Institute standards, specialist drill down into performance effects and downstream dissemination of performance data.

From a downstream perspective, the performance system needs to deliver return information to many parts of the business including marketing & client services, fund managers and front office, client reporting and risk management. How such information is provided is important to determine.

Components Of A Performance Application Strategy
Based on the overall scope of the requirement to provide information on performance returns, there are a number of components to consider:
Component Consideration
1 Business process optimisation Ahead of implementing any technology solution it is essential to investigate ways in which the current business processes can be improved. This should be performed hand in hand with an understanding of the likely software products in the market.
2 Market data provision Choices between market data aggregators (expensive to buy) or individual benchmark providers (expensive to implement). Consideration between storing centrally in a data hub (strategic) or direct provision to performance system (tactical or partially strategic).
3 Transactions/positions upload Buy & hold returns can be calculated using holdings and prices on a daily (or other) basis. Simple implementation but not GIPS compliant nor very accurate for active funds. Full transaction load is expensive to implement; easier to categorise by performance ”flows”.
4 Historical performance returns upload You can save yourself a lot of time and cost by loading historical performance returns instead of full transaction history. Ensure that your chosen supplier can use historical returns in its chain linked performance calculations.
5 Data upload ETL ETL (Extract, Transform and Load) of data can range from manually sourced figures to full automation. If you are looking for complex performance analysis then you need to invest in a good tool which provides two dimensional data cleansing (by stock across dates and by stock across source provider). Clean data is the single most important part of the process.
6 OTC valuation engine If you deal in OTC products then you need to provide a valuation as part of the performance process. You need to decide on whether values are provided internally (to the performance product) or actually calculated by the performance engine. Think about the governance process over such valuation models.
7 Returns calculation engine Actually the easy bit! These range from expensive, global solutions to quite simple and potentially ASP based. Chose the solution which is fit for purpose based on i) complexity of instruments and ii) volume.
8 Benchmark validation Do not rely on portfolio and benchmark data having the same underlying price, exchange rate and (in the case of fixed income) AI data. You may need to revalue benchmark data.
9 Attribution methodology Relatively straightforward to agree for equities. Fixed Income attribution methodologies tend to differ from fund manager desk to fund manager desk and certainly between investment houses. There are some emerging standards. See the GRAP methodology as one such example in Europe.
10 Data storage A huge issue for the global provision of performance information. 1st and 2nd generation of performance systems have tended to store derived statistics in relational databases. Because of the nature of the type of analysis required, these databases have become extremely large and cumbersome. The latest generation of solutions utilises “cube” technology which stores data into memory and is capable of reanalysing the data very quickly.
11 Information provision Understanding the nature of data required for downstream applications and people has often been the area of a performance product which is underestimated. This is down to project management laziness or the “that will be in the next phase” type of de-scoping. It is important to understand the who, what and how type questions early on in the project. The most advanced systems will employ a self service mechanism for retrieving, reformatting and presenting data using tools designed for analysis of data in multi dimensional cubes.
12 Good old fashioned project management The most undervalued of all components of any project…
Conclusion
The world of performance and risk measurement & attribution is clearly complex and rapidly changing. Like any problem, it is important to decompose it to the basic components and then to build a sensible implementation approach from there.
Print » Email »
 
 
 
 
Quarterly snapshot of the Financial Services market:
Read the latest on topical industry issues and new technology - our free newsletter gives you expert commentary, direct to your inbox.
submit