Tracking error formula in 1.b.5

[Gary2584]

Hi David,

In the practice bag spreadsheet for the tracking error calculation, i am confused on the logic behind the formula used for calculation. TE = Voltality(R(portfolio) - R(benchmark portfolio)) but am not able to correlate the above mentioned formula to the one used in the spreadsheet.

Please advise.

Thanks,
Gary

 

[David Harper CFA FRM]

Hi Gary,

can i ask you to leave open (not post in) David's Notebook? I am moving this to Foundations

this is the only way to get an ex ante Tracking error: as the variance(A - B) = variance(A) + variance (B) - 2*covariance, the standardDeviation(P - M) = SQRT[Variance(P - M)] = sqrt[volatility(P)^2 + volatility(M)^2 - 2*vol(P)*vol(M)*correlation(P,M)]; i.e., elegant application of variance property

Now that you ask me about this, I noticed that I need to revise this XLS to make a note that this TE is an ex ante tracking error based on active return/active risk rather than residual return/residual risk.

Thanks, David

 

[Gary2584]

Hi David,
Thanks for letting me know, as i was kinda confused where to put my query relating to the Focus review.

Gary