Asset Management Tutorial
- Portfolio Management
- Portfolio Management Career
- How to Get Into Asset Management?
- Asset Classes
- Institutional Investors
- Accredited Investor
- Diversified Investments
- Cash Investment
- Modern Portfolio Theory
- Portfolio Optimization
- M2 Measure
- Modified Dietz
- Risk Adjusted Return | Top 6 Risk Ratios You must Know!
- Sharpe Ratio | Comprehensive Guide with Excel Examples
- Sharpe Ratio Formula
- Expected Return Formula
- Treynor Ratio | Formula | Calculation | vs Sharpe Ratio
- Portfolio Standard Deviation
- Portfolio Return Formula
- ETF vs Index Funds
- 401k vs Roth IRA
- Tax Deferred Annuity
- 457 vs 403b
- Annuity vs 401k
- IRA vs 401k
- Sortino Ratio
- Stop-Loss Order
- Nominal Rate of Return
- Financial Planning Apps Softwares
- Information Ratio Formula
- Tracking Error Formula
- Portfolio Variance Formula
- Top 10 Best Wealth Management Books
- Top 10 Best Portfolio Management Books
Formula of Tracking Error (Table of Contents)
What is Tracking Error Formula?
Tracking error is simply a measure to gauge how much the return of portfolio or a mutual fund deviates from the return of an index it is trying to replicate in terms of the components of an index and also in the term of the return of that index. There are several mutual funds where the fund managers of that fund aim to construct the fund by closely replicating the stocks of a particular index, by trying to add stocks in his fund with the same proportion. There are two formulas to calculate the tracking error for a portfolio.
The first method is to simply take the difference between the portfolio return and the return from the index it is trying to replicate
- Rp= Return from the portfolio
- Ri= Return from the index
There is another method to calculate the tracking error of a portfolio in respect to the return from the index the portfolio is tracking.
The second method takes the standard deviation of the return of the portfolio and the benchmark.
The only difference is in this method it is like calculating the standard deviation of return of the portfolio and that of the index, the portfolio is trying to replicate. The second method is the more popular one and is used when the time series of data is has a long history, in other words when the historical data for the return of two variables are available for a longer period of time.
Explanation of Formula
Tracking error is a measure to find out how much the return of portfolio or a mutual fund deviates from the return of an index it is trying to replicate in terms of the components of an index and also in the term of the return of that index. But most of the time it doesn’t get replicated exactly in terms of the return, due to various factors like the timing of buying the stocks, personal judgment of the fund manager to alter the proportion depending on his style of investment.
Other than these the volatilities of the stocks in the portfolio and the various charges that are attached for an investor when they invest in a mutual fund also results in deviation of the returns of a portfolio and the index the portfolio tracks.
4.9 (1,067 ratings)
Examples of Tracking Error Formula (with Excel Template)
Let’s see some simple to advanced examples of tracking error calculation formula to understand it better.
Tracking Error Formula – Example #1
Let us try to do the calculation of the tracking error with the help of an arbitrary example say for mutual fund A which is tracking the oil and gas index. It is calculated by the difference of the return of the two variables.
Tracking Error calculation = Ra – Ro&G
- Ra= Return from the portfolio
- Ro&g= Return from the oil and gas index
Suppose the return from the portfolio is 7% and the return from the benchmark is 6%. The calculation will be as follows,
In this case, the tracking errors for the portfolio will be 1%.
Tracking Error Formula – Example #2
There is a mutual managed by a fund manager in SBI. The name of the fund in question is SBI- ETF Nifty Bank. This particular fund is constructed by taking the components of bank nifty closely in the proportion by which the banking stocks are in the bank nifty index.
Tracking Error formula = Rp-Ri
One year return from the portfolio is 8.9% and the one year return from the benchmark Nifty index is 8.6%.
In this case, the tracking errors for the portfolio will be 0.3%.
Tracking Error Formula – Example #3
There is a mutual managed by a fund manager in Axis Bank. The name of the fund in question is Axis Nifty ETF. This particular fund is constructed by taking the components of the nifty 50 closely in the proportion by which the index stocks are in the Nifty index.
One year return from the portfolio is 5.4% and the one year return from the benchmark Nifty index is 3.9%.
In this case, the tracking errors for the portfolio will be 1.5%.
Relevance and Use of Tracking Error Formula
Tracking error formula helps the investors of a fund to understand whether the fund is closely tracking and replicating the components of the index it is putting up as a benchmark. It showcases whether the fund manager is trying to actively track the benchmark or he is putting his style in order to modify it. It also helps the investors to find out whether the charges are high enough for the fund to impact the return of the fund.
You can download this Tracking Error Formula Excel Template from here – Tracking Error Formula Excel Template
This has been a guide to Tracking Error Formula. Here we discuss how to calculate tracking error for the portfolio along with examples and downloadable excel sheet. You can learn more about financing from the following articles-
- What is the Portfolio Return Formula?
- Standard Deviation Formula in Excel | Examples
- What is the Sample Standard Deviation Formula?
- What is Relative Standard Deviation Formula?
- Margin Error Formula
- Sortino Ratio Calculation
- Risk-Adjusted Return Calculation
- Sharpe Ratio Calculation
- Treynor Ratio Calculation