Week 2 Notes Active
Week 2 Notes Active
Konark Saxena ∗
Abstract
∗
School of Banking and Finance, R316 UNSW Busines School, University of New South Wales, Sydney,
Australia. Email: k.saxena@unsw.edu.au.
1 The Basics of Active Investing
Active investing is a strategy employed by fund managers and investors aiming to
outperform a benchmark index or a predefined set of assets, often referred to as the
“benchmark”. The primary objective of active investing is to generate returns that are
higher than what the benchmark offers, while ideally controlling for benchmark-related
risks. Here we discuss some preliminaries required to understand portfolio management
concepts in active investing.
n
X
Portfolio Return (R) = wa,i · ri
i=1
Where:
- wa,i is the weight of asset i in the active portfolio. It is an element of the weight
vector wa
- ri is the return of asset i. It is an element of the return vector r Returns are ideally
at a horizon based on the time the weights were traded on to the next period when the
weights were re-examined.
Here’s how you can calculate the portfolio return step by step:
1. Multiply each asset’s weight in the active portfolio (wa,i ) by its corresponding return
(ri ).
2. Sum up the results of these multiplications for all assets in the portfolio.
2
The resulting value, denoted by ra , will be the return of the active portfolio. This
formula allows you to compute the portfolio return based on the weightings of assets in
the active portfolio and their individual returns.
In Excel, you can use the SUMPRODUCT function to calculate the return on a portfolio
by multiplying the weight column with the return column for each asset. Here are the
steps to do this:
And you want to calculate the return of the portfolio, which is the sum of (Weight *
Return) for each asset.
1. In an empty cell where you want the portfolio return to appear, enter the following
formula:
=SUMPRODUCT(B2:B6, C2:C6)
• B2:B6 refers to the range of weights (0.2, 0.3, 0.25, 0.15, 0.1).
• C2:C6 refers to the range of returns (0.1, 0.15, 0.12, 0.08, 0.18).
3
The SUMPRODUCT function multiplies each weight by its corresponding return, and
then it sums up these products. This effectively calculates the weighted sum of
returns for all assets in the portfolio.
The cell containing this formula will display the portfolio return, which is the sum of the
weighted returns for all assets in the portfolio.
In this example, if you follow these steps, the result will be:
This means that the portfolio’s return, based on the given weights and returns for
each asset, was 13.15%.
4
1.2.1 The Role of a Benchmark Provider
Benchmark providers are entities responsible for creating and maintaining benchmarks.
These providers offer critical services to portfolio managers, and one of their key roles is to
regularly send data on the weights of the benchmark components to portfolio managers.
Here’s how it works:
5
weighted indices, constitute a prevalent weighting methodology in financial markets for
constructing stock market indices and portfolios. These weights are contingent on the
market capitalization (market cap) of individual companies or assets within the index or
portfolio. Market capitalization is computed by multiplying the current market price of
a stock by its total outstanding shares. Below, we delve into the calculation of market
capitalization weights, accompanied by an Excel example:
Recall that market capitalization of an asset is the product of the Market Price ($)
and Number of Shares Outstanding.
Market capitalization weights, or simply cap-weights, measure the value of the asset
with respect to the total value of the portfolios.
Calculation of Total Portfolio Value (P ): The total value of the portfolio (P ) is the
sum of the market caps of all assets in the portfolio:
n
X
P = (P rice of Asset i × N umber of Shares of Asset i)
i=1
Where:
N umber of Shares of Asset i is the total number of shares of asset i held in the portfolio.
6
total portfolio value:
M arket Cap of Asset i
wp,i =
P
Where:
Excel Example Let’s illustrate market capitalization weights with an Excel example for
a portfolio of three stocks. The following table shows the data:
Total =SUM(D2:D4)
To calculate market capitalization weights:
(i) In cell E2, compute the market capitalization weight for Stock A:
D2
wp,i =
D5
= D2/D5
(ii). Copy cell E2 to the remaining cells to calculate the market capitalization weight
in column E.
Cells in column E will display the market capitalization weights for each stock in the
portfolio. These weights, denoted as (wb,i ), represent each stock’s proportion of the total
7
portfolio value.
For active fund managers, their role revolves around identifying what might be over-
looked or underestimated in the market’s valuations. Their goal is to outperform the
market by uncovering opportunities that the broader market may have missed or un-
dervalued. This involves conducting in-depth research and analysis to make informed
investment decisions that can potentially yield superior returns compared to those dic-
tated solely by benchmark weights. In essence, active managers aim to capitalize on
market inefficiencies and divergences from their assessments of a company’s true worth,
ultimately seeking to deliver added value to their clients’ portfolios.
8
1.3.1 Key Metrics and calculations
Relative Returns (rra ): Active management involves seeking positive relative re-
turns compared to a benchmark. Relative returns (rra ) are calculated as the difference
between the return of the active portfolio (ra ) and the return of the benchmark (rb ), using
the formula:
rra = ra − rb = (wa − wb )′ r,
where:
wa and wb are the weight vectors of the active and benchmark portfolios, respectively.
Excel Example for Relative Returns: Suppose you have an Excel spreadsheet with
columns for asset names, active portfolio weights (wa ), benchmark weights (wb ), and
asset returns (r). You have 5 assets in rows 2 to 6. You can calculate relative returns
(rra ) by first taking the difference of weights in a new column G, and then multiplying
this difference with the column C with the returns, and adding it up over all assets in the
rows of the spreadsheet:
This formula multiplies the difference between active and benchmark weights by the asset
returns and then sums the products.
9
Tracking Error is a metric used in finance to measure the difference in performance
between an investment portfolio, often a mutual fund or an exchange-traded fund (ETF),
and its benchmark index. It quantifies how well the portfolio tracks or replicates the
returns of the chosen benchmark. A tracking error is expressed as a percentage difference.
This measures the extent to which an active portfolio’s performance diverges from the
benchmark. It helps investors manage and control the overall risk in their portfolio while
seeking better returns through active management. TE is calculated as the standard
deviation of the relative returns:
rP
¯ a )2
(rra − rr
TE = ,
n−1
where:
Excel Example for Tracking Error : In Excel, assuming you have relative returns (rra )
calculated in a column G, you can compute tracking error in cell H2 using the formula:
T E := ST DEV.S(G2 : G6)
This formula calculates the population standard deviation of the relative returns.
10
Let’s consider an active fund that aims to outperform the ASX-100, while not taking
on too much active risk. So they replicate the performance of the ASX-100 index, which
represents the top 100 companies listed on the Australian Securities Exchange (ASX) for
most securities, but outperform on some. The active fund’s goal with a tight tracking
error target is to closely follow the returns of the ASX-100, while taking some active bets
to outperform it.
• The active fund records annual returns of 12%, 8%, and 10%.
• The benchmark index, which is designed to track the ASX-100, achieves annual
returns of 11%, 8%, and 8%.
Calculation of Tracking Error To calculate the tracking error, we’ll take the differences
between the active fund’s returns and the ASX-100’s returns:
Now, calculate the average of these differences to determine the relative return:
Where:
11
So, the average out-performance rra over 3 years is an average of 1%. This is also its
alpha, if the beta=1. Recall that rra = ra − βa rb .
Now, calculate the standard deviation of these differences to determine the tracking
error:
The tracking error is standard deviation of these returns (1%, 0, 2%), which is 1%.
Interpretation In this example, the tracking error of the active fund is 1%. This
indicates that, on average, over the three-year period, the active fund’s returns deviated
from the ASX-100’s returns by approximately 1%. This means that the fund returns an
out-performance or relative return of rra = 1% on average, though its performance in any
given year can be 1% above or below that of the average rra .
A lower tracking error suggests that the active fund is doing a good job of replicating
the ASX-100 index’s returns, as the deviations between the two are relatively small.
Investors would likely view this low tracking error as an indication that fund is not
taking on too much active risk. They might even conclude that it is essentially a closet
indexer, which means it is not taking too many active decisions or conducting much
active research. This makes it a suitable choice for those seeking performance similar
to the ASX-100, but with a little alpha (Assumings its r. However, other factors like
expenses, liquidity, and investment goals should also be considered when evaluating this
ETF for investment.
Beta (βa )
This measures the sensitivity of the active portfolio’s returns to systematic market move-
ments. This is the regression slope when the returns of active returns is the independent
12
variable, and the returns of the benchmark portfolio is the dependent variable. We will
discuss why this is a relevant measure of risk in more detail in future weeks.
Beta is calculated as the covariance of the active portfolio returns with the benchmark
returns divided by the variance of benchmark returns:
Cov(ra , rb )
βa = ,
Var(rb )
where:
Excel Example for Beta In Excel, you can compute beta (βa ) using the formula in cell
AA2:
βa := COV ARIAN CE.S(X2 : X7, Y 2 : Y 7)/V AR.S(Y 2 : Y 7)
qhere X2 : X6 are the cells with the active portfolio returns, and Y 2 : Y 6 are the
benchmark returns.
Equivalently, you can compute beta (βa ) using the regression slope formula:
Alpha (αa ) This represents the active portfolio’s excess return relative to the bench-
mark, adjusted for systematic risk (beta) of the active portfolio. Equivalently, it is the
regression intercept of a regression of the active portfolio returns on the benchmark re-
13
turns. It is calculated as:
αa = ra − βa · rb = wa′ α,
where:
Excel Example for Alpha Suppose you have an Excel spreadsheet with columns for
asset names, active portfolio returns (ra ) in Column X and benchmark return (rb ) in
Column Y. You can calculate alpha (αa ) using the formula:
Where AA2 is the beta of the active portfolio, and AB2 is the benchmark return.
To identify where the performance of the active portfolio is coming from, it sometimes
helps to calculate the alpha of each stock in the portfolio αi . With a column for αi in the
spreadsheet Column G, and the active weights in Column H, you can also calculate the
active portfolio αa as:
Active Share
14
Clients often wonder how actively their mutual fund manager is managing your in-
vestments. Active Share provides a way of measuring this.
In the world of finance, research has repeatedly shown that, on average, mutual fund
managers tend to underperform their benchmark indexes, especially after factoring in fees
and taxes. In 2006, Martijn Cremers and Antti Petajisto, researchers at the Yale School of
Management, introduced a novel method called Active Share to gauge the level of active
management employed by mutual fund managers and to identify those who outperform.
What is Active Share? Active Share is a metric that measures the percentage of a
portfolio’s stock holdings that differ from those in the benchmark index. Mutual fund
managers with a high Active Share have been found to outperform their benchmark
indexes, suggesting that Active Share is a significant predictor of fund performance.
Analyzing 2,650 funds spanning the period from 1980 to 2003, Cremers and Petajisto
discovered that the top-performing active funds, those with an Active Share of 80% or
higher, outperformed their benchmarks by 2-2.71% before fees and by 1.49-1.59% after
fees. This finding defies conventional wisdom, as other research has consistently shown
that, on the whole, active fund managers tend to underperform benchmark indexes.
Active Share is also valuable for identifying "closet indexers"—managers who claim
to be active but whose portfolios closely resemble the benchmark. Identifying closet
indexers is crucial because active management fees can hinder benchmark outperformance
for investors holding similar portfolios.
The study revealed that the percentage of assets managed by funds with an Active
Share below 60% surged from 1.5% in 1980 to 40.7% in 2003. Simultaneously, the per-
centage of assets managed by funds with an Active Share greater than 80% decreased
from 58% in 1980 to 28% in 2003. This shift cannot be entirely attributed to the growth
of index funds. In 1980, there were few non-index funds with an Active Share below 60%.
15
By 2003, funds with Active Share below 60% constituted 20% of funds and 30% of assets
under management.
Furthermore, Active Share and excess performance were higher among funds with
fewer assets under management. Recent studies confirm that, on average, actively man-
aged portfolios underperform benchmark indexes. From 2002 to 2017, only about 8% of
active funds outperformed passive indexes. When accounting for taxes and trading costs
generated by active management, this figure dwindled to just 2%.
How is Active Share Calculated? Active Share is calculated by summing the absolute
differences between the weight of each holding in the manager’s portfolio and the weight
of the same holding in the benchmark index, and then dividing by two.
N
1X
Active Share = |wa,i − wb,i |
2 i=1
For instance, if a benchmark index consists of only one stock, and a manager decides
to invest half the portfolio in that stock and half in another, the Active Share would be
50%. This result implies that 50% of the manager’s portfolio deviates from the benchmark
index.
Calculating Active Share Using Excel To demonstrate how Active Share is calculated,
let’s consider an example using an Excel file called active_investing.xlsx. This file
contains data for the ASX200 index. The dataset structure is as follows:
16
1. In cell E2, subtract the weight of the security in the active fund from the weight in
the passive index for each security. For example, in cell E2:
= D2 − C2
2. In cell F2, calculate the absolute difference for each security. In cell F2:
= ABS(E2)
3. In cell F3, calculate the sum of absolute differences for all securities. In cell F3:
= SU M (F 2 : F n)
= F 3/2
= (F 4) × 100%
Now, cell F5 will display the Active Share percentage for your portfolio.
Remember to replace n with the row number of the last security in your dataset,
and adjust F3 and F4 to refer to column F and rows n + 1 and n + 2.
While the Active Share study offers intriguing insights, investors should exercise cau-
tion when applying its findings. The benchmark-beating results of high Active Share
17
managers represent an average performance, not a guarantee of individual fund perfor-
mance.
Assuming that all high Active Share managers will outperform their benchmarks would
be misleading. The data merely suggests that, on average, managers with high Active
Share portfolios outperform their low Active Share counterparts.
Ultimately, it is possible that some high Active Share managers may underperform
their benchmarks, while others excel. Relying solely on Active Share to choose a manager
could lead to selecting one who falls short of benchmark performance.
In conclusion, Active Share is a valuable tool for evaluating mutual fund investments.
However, it should be considered alongside other analysis tools for a comprehensive as-
sessment of performance potential.
18
2 Active Investing
Constructing an excel sheet to calculate alpha is much easier than finding alpha.
Finding good active positions is a complex task. Simply relying on intuition is inade-
quate, given the vast number of experienced managers and market participants. As more
investors pile into underpriced securities, their prices tend to rise, eroding their under-
pricing status. To succeed, active managers must identify securities that others have not
yet recognized as underpriced or overpriced.
The active manager must choose strategic deviations from a benchmark to seek su-
perior returns, while managing risks. Active managers employ various techniques and
insights to identify opportunities that can lead to outperformance. It’s a dynamic and
rigorous approach to investing that requires expertise and a deep understanding of the
markets in which they operate.
[Scene: A sleek and modern meeting room with floor-to-ceiling windows overlooking
the stunning Sydney Opera House. Sarah, the superannuation fund manager, enters the
room, her curiosity piqued as she anticipates an insightful meeting with a renowned active
fund manager specializing in China investments.]
19
this fund manager’s expertise. Maybe there’s something intriguing to learn here.
[As Sarah takes her seat at the conference table, the active fund manager, Mr. Chen,
steps forward, projecting an air of confidence and experience.]
Mr. Chen (Active Fund Manager): [With a warm smile] Welcome, Sarah. It’s a
pleasure to have you here today. I understand you’re keen to explore the potential of our
active fund in the Chinese market.
Sarah: [Nodding] Yes, Mr. Chen. I’ve heard great things about your track record in
navigating the Chinese investment landscape. I’m eager to learn more about your active
strategy.
Mr. Chen: [Eager to share his insights] Of course, let’s dive right in. China has
certainly witnessed its share of rapid growth, but we’re now in a phase of mature growth.
This shift poses both challenges and opportunities, and we’re well-prepared to navigate
this dynamic landscape.
Mr. Chen: [Explaining] We recognize that in many sectors, the era of hyper growth
may be behind us. However, we’ve honed our expertise in identifying firms that are
positioned to thrive in this competitive, mature environment. Our active approach means
we’re not afraid to seek out value and opportunity, even amidst uncertainty.
Sarah: [Impressed ] I see. And what about the recent changes in the global investment
landscape?
20
uncover hidden gems that passive strategies may overlook.
Sarah: [Intrigued ] So, you’re saying that your fund can thrive in this changing envi-
ronment?
Active Strategies: [Mr. Chen shifts the conversation to their active investment
strategies.]
Mr. Chen: [Explaining] To achieve our goal of outperforming the market, we employ
a variety of active strategies. Finding good active positions is a complex task. Relying
solely on intuition is inadequate, given the vast number of experienced managers and
market participants. As more investors pile into underpriced securities, their prices tend
to rise, eroding their underpricing status. To succeed, active managers must identify
securities that others have not yet recognized as underpriced or overpriced. Let me explain
how we approach this.. [Mr. Chen’s wave his hands in the air and starts counting with
his fingers the different ways in which his active strategies can generate value.]
Unique Strategies: [Mr. Chen leans forward, emphasizing their unique approach.]
We go to great lengths to gather insights. We may use unconventional data sources,
such as satellite imagery, to analyze a company’s operations. We’ve even used private
helicopters to visit remote areas critical to a business. These unique strategies help us
21
uncover insights that others may miss.
Challenges and Adaptation: [He acknowledges the challenges of the mature growth
phase.] It’s important to acknowledge that the era of hypergrowth in many sectors may be
over. However, this doesn’t mean that opportunities have disappeared. Instead, it requires
a shift in focus towards finding firms that are well-positioned to succeed in this more
competitive and mature environment. Many companies in China are already adjusting
to this new reality, and their ability to navigate these challenges will determine their
long-term success.
Sector Opportunities: [Mr. Chen leans back, painting a broader picture.] In the
long term, we expect certain sectors, especially those beyond the property market, to
perform exceptionally well. Chinese companies aiming to expand internationally, coupled
with government policies that encourage this trend, create opportunities for investors who
position themselves strategically.
Policy Response and Data Dependence: [He continues to discuss their adaptive
investment strategy, long-term focus, and their assessment of China’s policy response and
data dependence. Mr. Chen emphasizes their commitment to a long-term vision and the
potential for market share growth for Chinese companies expanding overseas.]
Sarah: [Impressed by the pitch] Well, Mr. Chen, your insights and approach are
certainly compelling. I appreciate your transparency and expertise. It’s clear that your
active fund has a unique edge in the evolving Chinese investment story.
Mr. Chen: [Grateful for the opportunity] Thank you, Sarah. We believe that part-
nering with your superannuation fund could be mutually beneficial. Our goal is to help
you seize the potential for growth in this ever-changing landscape.
[As Sarah leaves the meeting, she’s not only impressed by Mr. Chen’s insights but also
intrigued by the potential for growth in China. She can’t help but feel optimistic about
22
the possibilities presented by the active fund’s strategy in China. The meeting overlooking
the iconic Sydney Opera House has provided her with valuable insights and a potential
investment opportunity for her superannuation fund.]
2. Balancing Act: Active portfolio managers face a balancing act. On one hand, they
strive to overweight or underweight certain securities or asset classes to potentially
generate alpha (excess returns) and beat the benchmark. On the other hand, they
must be cautious about deviating too far from the benchmark to manage tracking
error, which measures the portfolio’s deviation from the benchmark’s returns.
3. Risk Management: Portfolio managers must manage risk effectively. They are
often given a maximum allowable tracking error, which represents the expected
deviation from the benchmark’s returns. Staying within this limit is crucial to
ensure that the portfolio’s risk remains within acceptable bounds.
23
5. Ongoing Monitoring: Portfolio managers continuously monitor the portfolio’s
performance relative to the benchmark. Adjustments may be made to the portfolio’s
weights to capitalize on opportunities or manage risk as market conditions change.
Buy-side analysts, like sell-side analysts, form views and recommendations of which
assets are overvalued and give them sell or strong sell ratings; and they form views of
which assets are undervalued and give them buy or strong buy ratings. Lets first briefly
discuss the roles of such analysts.
Sell-Side Analysts
Sell-side analysts are typically believed to provide unbiased opinions based on propri-
etary research of a company’s securities. Their responsibilities include:
24
• Assigning ratings such as Buy, Sell, or Hold when initiating coverage on a company.
• Convincing institutional clients to direct their trading through their firm’s trading
desk.
• Providing valuable information and being the first to share new insights with clients.
Buy-Side Analysts
In contrast, buy-side analysts are more focused on achieving high-alpha ideas and
avoiding major mistakes. Their responsibilities include:
• Identifying potential risks and considering what can go wrong with investment ideas.
Both types of analysts are essential, but their roles, compensation structures, and
responsibilities differ significantly. Sell-side analysts focus on information flow and access
to management, while buy-side analysts prioritize the quality of their recommendations
and the overall success of their funds.
Key Differences
There are several key differences between buy-side and sell-side analysts, including:
25
• Working Conditions: Sell-side analysts may work longer hours and frequently travel,
making buy-side analysis arguably less stressful.
• Role: Accuracy is crucial for buy-side analysts, whereas sell-side analysts are more
focused on information flow.
Understanding the roles and differences between buy-side and sell-side analysts is
essential for investors. Ratings provided by analysts can influence stock prices, but they
should be considered alongside other factors. Buy-side analysts aim to deliver high-alpha
ideas, while sell-side analysts often provide valuable information for trading decisions.
The choice between buy-side and sell-side careers involves differences in compensation,
responsibilities, and regulations.
The recommendations of Wall Street analysts are often relied on by investors when
deciding whether to buy, sell, or hold a stock. Media reports about these brokerage-firm-
employed (or sell-side) analysts changing their ratings often affect a stock’s price. But do
these ratings truly matter?
26
Figure 1: Analyst Ratings Scale
ABR is calculated based on recommendations (Buy, Hold, Sell, etc.) made by 10 brokerage
firms. An ABR of 2.00 indicates a "Buy" recommendation.
Of the 10 recommendations contributing to the ABR, six are "Strong Buy," represent-
ing 60% of all recommendations.
Use a dividend discount model or similar methods to directly forecast the expected
return for each security. Calculate the expected return of the benchmark index. Compute
the relative expected return (alpha) of each stock by subtracting the expected return of
the benchmark index from the expected return of each stock.
In the context of forecasting stock alpha, analysts often play a crucial role in providing
27
Figure 2: Rio Tinto Ratings - September 2023
ratings for stocks. These ratings, typically ranging from 1 to 5, are essential for investors in
making buy, sell, or hold decisions. However, to use these ratings effectively in forecasting
alpha, we follow a specific process.
• Initially, we gather analyst ratings for various stocks, where ratings range from 1
(indicating a strong buy) to 5 (indicating a strong sell).
• Once the analyst ratings are standardized, we use them as the basis for calculating
the Score parameter. The Score parameter represents the degree to which a stock
is favored or disfavored based on analyst consensus.
28
Figure 3: Ratings and Expected Alpha Distributions
29
• This calculation involves statistical methods that transform the standardized ratings
into a Score that quantifies the analyst sentiment towards each stock.
Rating − M ean(Rating)
Score =
StandardDev(Rating)
Alpha Forecasting:
• With the Score parameter in hand, we integrate it into the alpha forecasting process.
• Alpha, in this context, represents the expected relative return of each stock con-
cerning a benchmark or market index.
• The formula used to estimate alpha takes into account the Score, along with other
factors, such as the information coefficient (IC) and the expected volatility.
• The information coefficient (IC) measures the correlation between analyst forecasts
and subsequent returns. We will discuss how this is calculated next week.
• Score, derived from the standardized analyst ratings, reflects the market sentiment
towards a stock.
• E[Volatility] represents the expected volatility or risk associated with a stock’s future
returns.
Understanding E[Volatility]:
30
• E[Volatility] plays a crucial role in the alpha forecasting equation. It represents the
expected variability or dispersion in returns compared to the consensus expected
returns of all investors.
• This multiplication accounts for how much variability we expect in returns compared
to the consensus expected returns that produce the benchmark weights. Stocks that
analysts believe are likely to perform better are assigned higher values along the
distribution of future alphas. Conversely, stocks that analysts believe will perform
worse are assigned lower values along the expected distribution of future alphas. We
will discuss this in more detail in Week 4.
31