Holdings comparison report compares the underlying holdings of two investments to identify the common holdings.
To create a new Holdings Comparison report: on the New menu, point to Reports, and then choose Holdings Comparison.
Identify top unique and common holdings of two competitive investments to discover the fundamentals driving their return differences.
Quantify the redundancy of your investments to make sure your portfolios are well diversified.
Decompose holdings similarity to broad asset class levels � equity and bond.
Compare stock holdings, bond holdings, or both together.
Define the portfolio date.
This section details the composition of the top 20 unique holdings for each investment.
This section details the composition of the top 20 unique holdings for each investment and compares the weights of these holdings within each portfolio.
This section quantifies the similarity of stock and/or bond holdings between two investments.
The percentage of assets for the subject investment which are held in common with the compared investment, as a percentage of the subject investment's market value.
The percentage of each investment's market value considered in the report.
The sum of the common holdings percentages for the investment as a percent of that investment's market value considered in the report. The calculation divides the Common Holdings % by the Stock and/or Bond Holdings %.
4Similarity Score Calculation Detail
For this calculation, we find the common holdings for the two investments. Then we determine the percent each common holding represents in the two investments separately. We then sum these percentages within each investment and divide by the percent of assets considered in the comparison (based on the Compare setting).
For example, if Portfolio I and Portfolio II have three holdings in common, we can list the proportion the holdings represent in each portfolio.
Portfolio I
Compare Stocks: stocks represent 90% of portfolio holdings
Holding A 2%
Holding B 3%
Holding C 5%
Portfolio II
Compare Stocks: stocks represent 50% of portfolio holdings
Holding A 3%
Holding B 4%
Holding C 1%
In this example, the common holdings A, B, and C represent 10% of Portfolio I (2%+3%+5%). Dividing by 90%, we find the similarity figure for Portfolio I: 11%. This percentage is displayed in the row corresponding to Portfolio I versus the column for Portfolio II.
The common holdings represent 8% of Portfolio II. Dividing by 50%, the similarity figure for this portfolio is 16%. This percentage is displayed in the row corresponding to Portfolio II versus the column for Portfolio I.
In other words, considering the stock holdings of Portfolio I, 11% are held in common with Portfolio II. Considering the stock holdings of Portfolio II, 16% are held in common with Portfolio I.
The sum of the minimum percentages of each common holding.
4Common Holdings Score Calculation Detail
For this calculation, we find the common holdings for the two investments. Then we determine the percent each common holding represents in the two investments separately. We discern which is the lesser percentage and then sum these lesser percentages.
For example, if Portfolio I and Portfolio II have three holdings in common, we can list the proportion the holdings represent in each portfolio.
Portfolio I
Holding A 2%
Holding B 3%
Holding C 5%
Portfolio II
Holding A 3%
Holding B 4%
Holding C 1%
In this example, Holding A represents 2% of Portfolio I and 3% of Portfolio II. For the calculation, we use 2% to represent the common holding % of Holding A. Likewise, we take 3% for Holding B and 1% for Holding C. Summing these percentages, the common holdings score for these portfolios is 6%.
Using this calculation setting creates a symmetrical matrix. In our example, 0.06 is displayed in both the row for Portfolio I versus the column for Portfolio II and in the row for Portfolio II versus the column for Portfolio I.
The Active Share measure was developed by professors Antti Petajisto and Martin Cremers.
4Active Share Calculation Detail
For this calculation, we take (1 - Common Holdings Score).