Calculating Tracking Error Of Portfolio
Contents |
the benchmark or index it was meant to mimic or beat. Tracking error is sometimes called active risk. There are two ways to measure tracking error. The first is to how to measure tracking error subtract the benchmark's cumulative returns from the portfolio's returns, as follows: Returnp - tracking risk formula Returni = Tracking Error Where: p = portfolio i = index or benchmark However, the second way is calculating tracking error in excel more common, which is to calculate the standard deviation of the difference in the the portfolio and benchmark returns over time. The formula is as follows: How it works (Example): Let's tracking error example assume you invest in the XYZ Company mutual fund, which exists to replicate the Russell 2000 index, both in composition and in returns. If the XYZ Company mutual fund returns 5.5% in a year but the Russell 2000 (the benchmark) returns 5.0%, then using the first formula above, we would say that the XYZ Company mutual fund had a 0.5% tracking error. As
Ex Ante Tracking Error Formula
time goes by, there will be more periods during which we can compare returns. This is where the second formula becomes more useful. The consistency (or inconsistency) of the "spreads" between the portfolio's returns and the benchmark's returns is what allows analysts to try to predict the portfolio's future performance. If, for example, we knew that the portfolio's annual returns were 0.4% higher than the benchmark 67% of the time during the last five years, we would know that this would probably be the case going forward (assuming the portfolio manager made no major changes). The predictive value of these calculations gets even better when there are more data points and when the analyst accounts for how the portfolio's securities move relative to one another (this is called co-variance). Several factors generally determine a portfolio's tracking error: 1. The degree to which the portfolio and the benchmark have securities in common 2. Differences in market capitalization, timing, investment style, and other fundamental characteristics of the portfolio and the benchmark 3. Differences in the weighting of assets between the portfolio and the benchmark 4. The managemen
Finance Trading Q4 Special Report Small Business Back to School Reference Dictionary Term Of The Day Martingale System A money management system of investing in which the dollar values of investments ... Read More » Latest Videos
Calculating Information Ratio
Why Create a Financial Plan? John McAfee on the IoT & Secure Smartphones calculating sharpe ratio Guides Stock Basics Economics Basics Options Basics Exam Prep Series 7 Exam CFA Level 1 Series 65 Exam Simulator calculating alpha Stock Simulator Trade with a starting balance of $100,000 and zero risk! FX Trader Trade the Forex market risk free using our free Forex trading simulator. Advisor Insights Newsletters http://www.investinganswers.com/financial-dictionary/mutual-funds-etfs/tracking-error-4970 Site Log In Advisor Insights Log In Tracking Error Loading the player... What is a 'Tracking Error' Tracking error is the divergence between the price behavior of a position or a portfolio and the price behavior of a benchmark. This is often in the context of a hedge or mutual fund that did not work as effectively as intended, creating an unexpected profit or loss instead.Tracking error is reported as a standard deviation percentage difference, which reports the http://www.investopedia.com/terms/t/trackingerror.asp difference between the return an investor receives and that of the benchmark he was attempting to imitate. BREAKING DOWN 'Tracking Error' Since portfolio risk is often measured against a benchmark, tracking error is a commonly used metric to gauge how well an investment is performing. Tracking error shows an investment's consistency versus a benchmark over a given period of time. Even portfolios that are perfectly indexed against a benchmark behave differently than the benchmark, even though this difference on a day-to-day, quarter-to-quarter or year-to-year basis may be ever so slight. Tracking error is used to quantify this difference.Calculation of Tracking ErrorTracking error is the standard deviation of the difference between the returns of an investment and its benchmark. Given a sequence of returns for an investment or portfolio and its benchmark, tracking error is calculated as follows:Tracking Error = Standard Deviation of (P - B).For example, assume that there is a large cap mutual fund that is benchmarked to the Standard and Poor's (S&P) 500 index. Next, assume that the mutual fund and the index realized the follow returns over a given five-year period:Mutual Fund: 11%, 3%, 12%, 14% and 8%.S&P 500 index: 12%, 5%, 13%, 9% and 7%.Given this data, the series of differences is then (11% - 12%), (3% - 5%), (12% - 13%), (14% - 9%) and (8% - 7%). These differences equal -1%, -2%, -1%, 5%, an
CFA Program CFA Forums CFA General Discussion CFA Level I Forum CFA Level II Forum CFA Level III http://www.analystforum.com/forums/cfa-forums/cfa-general-discussion/9939876 Forum CFA Hook Up CAIA More in CAIA CAIA Test Prep CAIA Events CAIA Links About the CAIA Program FRM More in FRM FRM Test Prep FRM Events FRM Links About the FRM Program Careers Investments Water Cooler Test Prep Test Prep Sections CFA Test Prep CAIA Test Prep FRM Test Prep Calendar AF Deals CFA Test Prep CFA Events CFA tracking error Links About the CFA Program Home Forums CFA Forums CFA General Discussion Tracking Error Calculation Tweet Widget Google Plus One Linkedin Share Button Facebook Like Last post whystudy Apr 20th, 2009 6:42pm CFA Charterholder 641 AF Points I have quarterly returns for a fund up to 5 years and also the benchmark mark. meaning I calculation the excess return. How can calculating tracking error I calculate the Annualized Tracking Error and why? How does the formula change for monthly returns. Thanks 5 Reasons to Use Wiley in 2016 Reason #2: No Expiration Date. You get free updates until you pass. learn more Share this Facebook Like Google Plus One Linkedin Share Button Tweet Widget kblade Apr 20th, 2009 7:00pm CFA Charterholder 714 AF Points For annualized tracking error I think you need to take your quarterly returns and multiply them to get annual return annual = (1+q1)(1+q2)(1+q3)(1+q4) do the same for benchmark unless it is already in annual terms then tracking error is standard deviation of (portfolio return - benchmark return) for monthly returns it’s same formula, standard deviation of (portfolio return - benchmark return), just that they are monthly returns not annual to get monthly return take 4th root of your quarterly returns i.e. (1+q)^(1/4) unless you have monthly return for portfolio and benchmark already if you don’t then your tracking error will be same for first 3 months, for the next 3 months, etc. whystudy Apr 20th, 2009 7:07pm CFA Charterholder 641 AF
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 01:30:07 GMT by s_hv1002 (squid/3.5.20)