In a previous article, I sang the praises of the Quintessence Implementation Team. I would now like to take some time to focus on one key capability within this team – the business analysts. The best way to describe this capability is to present their work. Towards this end, I will focus a series of articles on how arithmetic performance attribution was tamed by the Quintessence business analysts. I have chosen this example as it is a familiar problem in the investment management industry. Furthermore, many investment professionals understand the challenges that arise when using one particular methodology over another and will thus understand how our analysts overcame these obstacles.
Attribution analysis encompasses a variety of algorithms and methodologies designed to quantify the value (alpha) of the various investment decisions made in managing a fund. The particular methodology implemented is dependent on the investment process of the management firm under consideration. For example, bottomup equity stockpickers are only interested in stock selection effects. Asset allocation and sector selection effects come to the fore when the investment process implements a topdown allocation strategy that constrains the bottomup company selection process.
There are various flavours of attribution analysis. The underlying mathematics changes drastically when one is dealing with different instrument types. For example, fixedincome attribution breaks the alpha into parts that are due to
On the other hand, equity attribution focuses on breaking the alpha into
Attribution analysis algorithms can also be formulated using a geometric as opposed to an arithmetic model. Geometric models have the trait that geometric alphas for subperiods “multiplyup” to the total geometric alpha over the whole period. On the other hand, most arithmetic models suffer from the characteristic that arithmetic alphas for subperiods do not “addup” to the total arithmetic alpha over the said period.
The graphic below shows an example of the generic inputs, data requirements and consequent output of performance attribution algorithms.
Most arithmetic attribution analysis algorithms are based on the Brinson–Hood–Beebower and Brinson–Fachler models. As mentioned, arithmetic attribution models suffer from the malady that the attribution alphas don’t “addup” over multiple periods. This is the one challenge that our analysts solved. In this first article, I will therefore consider the special case when
In other words, I am dealing with
Description  Notation  Relationship 

Total Return in day by Instrument in the Benchmark  See Equation 3 in the table below.  
Total Return in day by Instrument in the Portfolio  See Equation 3 in the table below.  
Trading execution effect  The instrument return in the portfolio is the same as that in the benchmark. This will imply no trading execution effect as shown in the rows below.  
Stock Selection Effect  According to the Brinson, Hood and Beebower Model published in 1986, this will be zero. (See Equation 1,2 and 3 in the table below.)  
Interaction Effect  According to the Brinson, Hood and Beebower Model, this will also be zero. (See Equation 1,2 and 3 in the table below.) 
This simplification allows one to easily formulate the problem statement and identify the “additive” issues that arise. The solution can then be extended (in further articles) to include multitier cases and trading execution effects, resulting in the arithmetic performance attribution malady being tamed by the Quintessence business analysts .
Consider a portfolio and a benchmark. The union of the universe of instruments in the portfolio and benchmark are subscripted by . For a given day , we define the following variables:
Description  Notation  Relationships  Equation # 

Portfolio weight in Instrument at the start of day  1  
Benchmark weight in Instrument at the start of day  2  
Total Return (the greek letter rho) in day by Instrument Note that since we assume no trades, we only need one variable . In later articles when we incorporate the trading execution effect, we will require , the total return of the instrument in the portfolio and , the total return of the instrument in the benchmark.  3  
Portfolio Total Return in day  4  
Index Total Return (greek rho) in day  5  
Arithmetic Alpha in day for the portfolio relative to the benchmark.  6  
Geometric Alpha in day for the portfolio relative to the benchmark  7 
Some important points are relevant to the above definitions. Equations 4 and 5 (and consequently equation 9 further down) hold if and only if
In our definitions, the subscript refers to a day. This can however be any fixed period. One can think of this subscript as a point in time. The only constraint is that between t and t+1, the holdings remain fixed. Now, the purpose of attribution analysis is to break down the total alpha (Equation 6) for a period into the composite parts that represent the investment decisionmaking process. For a single day, the formula to calculate the arithmetic contribution to the alpha from the active bet in the underlying instrument is provided in equation 8 below.
Description  Notation  Relationships  Equation # 

Contribution to arithmetic alpha from Instrument for day  8 
Using equations 1,2,4 and 5, one can show that this formula behaves as expected; the contributions from each instrument add up to the total alpha for the day.
Description  Proof  Equation # 

The proof that the contributions of each instrument adds up to the arithmetic alpha of the day  9 
We can thus conclude equation 10 below:
Description  Proof  Equation # 

Contributions of all instruments add up to arithmetic alpha for the day  10 
What the above analysis shows is that for a period where the holdings remain constant (in both the portfolio and the benchmark), Equation 8 above will give the correct contribution to arithmetic alpha. The next section will show that this simple algorithm hits problems when one calculates contributions over multiple days. In particular, this is due to the fact that alphas compound – simply adding up alphas does not incorporate this compounding effect.
It is common knowledge that the simple analysis above breaks down when one tries to perform the calculation described above over multiple periods. It needs to be emphasized that this statement is true even if the portfolio and benchmark holdings remain constant over the period under analysis. Equation 7 above defined the concept of a geometric alpha for the sole purpose of comparing it to the arithmetic alpha. In particular, the key difference between the geometric and the arithmetic alphas defined in equations 6 and 7 is that daily geometric alphas can be multiplied up to obtain the geometric alpha over the whole period. This is because of the compound nature of returns, as shown in the following derivation:
Description  Proof  Equation 

Daily Geometric Alphas multiply up correctly to give one the Geometric Alpha for the whole period.  11 
It is important to observe that this property is not shared in the case of arithmetic alphas. In other words, arithmetic alphas do not add up to the total arithmetic alpha over the whole period. A simple example will clarify this point. Consider a period of 2 days. To emphasise the point that this has nothing to do with trading or portfolio / benchmark changes, let us assume that the holdings remained constant over this period. Assume the following numbers for the portfolio and benchmark total return:
Description  Calculation  Ref # 

Portfolio Total Returns in day 1 and day 2  12 

Benchmark Total Return in day 1 and day 2  
Arithmetic Alphas for day 1 and day 2  
Portfolio Total Return for whole period T = [1,2]  
Benchmark Total Return for whole period T = [1,2]  
Arithmetic Alpha for period T = [1,2] 
What example 12 above shows is that the daily arithmetic alphas do not add up to the total alpha for the period. This is precisely the arithmetic attribution challenge that needs to be tamed by the Quintessence analyst.
Description  Relationship  Equation # 

Daily arithmetic alphas do NOT add up to the arithmetic alpha of the period.  13 
The fact that one can’t just add up arithmetic contributions (Equation 13) over multiple periods means one cannot define the total contribution of an instrument over the whole period as just being the sum of its daily contributions:
Description  Expression  Equation # 

The contribution of an Instrument k over the whole period T  14  
Defining the total contribution of an instrument for the whole period as being the sum of the daily contributions will not add up to the correct alpha due to equation 13:  15  
We therefore cannot define the contribution of an instrument over the whole period T to be the simple sum of the daily contributions  16 
Everything discussed above is common knowledge; nothing new or unexpected. This is why some people choose to only consider geometric attribution methodologies. Some investment managers however, find geometric contributions counter intuitive. They want a methodology whereupon contributions add up to the total alpha for the day. For this reason, our analysts identified a mechanism to make this possible.
Equations 17 and 18 below is the key to the methodology implemented.
Firstly, we define .
Description  Relationship  Equation # 

Define as being a value that ensures that the daily arithmetic alphas add up to the period arithmetic alpha. This must be true for all periods 1 ≤ τ ≤ T  17 
It is important to note that the criteria that the numbers sum correctly for any period completely determines . In particular, we can conclude that . Further, it can be shown that for
Description  Equation  Equation # 

One can prove that defined here in Equation 18 uniquely satisfies equation 17 above  18 
Looking back at example 12, we see how equation 18 ensures that the daily arithmetic alphas now add up correctly.
Description  Calculation  Reference # 

Portfolio Total Returns in days 1 and 2  19  
Index Total Return in days 1 and 2  
for days 1 and 2 as per equation 17  
for days 1 and 2 as per equation 18  
Daily arithmetic alphas add up to the correct total alpha 
The problem now comes in deciding how to distribute this daily delta over all the instruments for the day. This is best achieved by stating it as an optimisation problem. Equations 20 to 24 define this nonlinear quadratic optimisation problem:
Description  Quadratic Optimisation Statement  Equation # 

The variable we want to identify is the adjusted daily contribution of each instrument to alpha.  20  
We want these adjusted contributions to be as close as possible to the original ones calculated using the simple formulae in equation 8. Mathematically, we therefore want to minimise the distance between the adjusted contribution and the original ones calculated using Equation 8. We take the standard Euclidean distance as our measure.  21  
The adjusted contributions must add up to the adjusted alphas for the day. Because of equation 17, this will ensure that we can then define the total contribution for an instrument over the whole period to be the sum of the daily contributions.  22  
Contribution order must be preserved. The instrument contributions calculated in equation 8 are exact for 1 day. Therefore, if (using equation 8) instrument contributed more than instrument on day then this must remain the same when calculating the adjusted contributions.  23  
The relative contribution size must also remain identical  24 
The solution to this optimisation problem is shown in equation 26 below:
Description  Quadratic Optimisation Solution  Equation # 

Define the total number of instruments in the union of the portfolio and benchmark on day  25  
Adjusted Contribution to arithmetic alpha from Instrument for day  26  
The Total Contribution from Instrument for the whole period is defined as the sum over the daily contribution  27  
The total contributions add up correctly to the total alpha  28 
These 4 expressions summarise how arithmetic attribution was tamed by the Quintessence analysts, ensuring that the subperiod alphas add up to the alphas over the complete period.
Description  Equation  Equation # 

Simple Contribution to arithmetic alpha from Instrument for day  8  
Daily Alpha Adjustment to ensure correct period summation  18  
Adjusted Contribution to arithmetic alpha from Instrument for day  26  
Total Contribution to arithmetic alpha from Instrument for the whole period  27 
Two articles to come will show how these concepts are extended to cater for classification structures and execution costs. Feel free to contact me for more information regarding our domain knowledge and how we can assist you in overcoming your challenges.
Contact us to find out how we can assist you or book a demo to experience Quintessence firsthand.