Tracking error and information ratio explained (Excel)
HTML-код
- Опубликовано: 28 июл 2021
- How one might evaluate the performance of an investment strategy with respect to its deviation from the market index? Today we are addressing this question and investigating two very popular portfolio and fund performance metrics - the tracking error and the information ratio, learning how to apply these in Excel, and discussing their advantages and limitations.
Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Investment!
Please consider supporting NEDL on Patreon: / nedleducation
You can find the spreadsheets for this video and some additional materials here: drive.google.com/drive/folders/1sP40IW0p0w5IETCgo464uhDFfdyR6rh7
Please consider supporting NEDL on Patreon: www.patreon.com/NEDLeducation
Another great video. Really appreciate your content and efforts to make the calculations understandable. Also appreciate the context and qualitative considerations that are discussed after doing all the math. Thanks for all you do.
Great video, very informative!
thanks such a great explanation!
Great video and very easy explained! Thank you for these videos they are very helpful.
I was thinking if it is still possible to attain Jensens alpha or the tracking error by only using annum return for both the mutual fund and the s&p500 or does it have to be monthly data?
Thank you for you answer!
Hey,
I've done my calculations on 3 funds. The fund with the highest return and alpha has given me the highest tracking error but lowest Information Ratio from the 3 funds. The opposite is true for the fund with the lowest return and alpha.
Would you be able to offer an interpretation on this?
Thank you!
just have one doubt, if the outperformance is more in this case, the tracking error is decreasing and when it is closer to "zero" it is increasing, it should be the opposite right?
Would a larger lookback period provide a more accurate/useful Information Ratio? Or is it better to have a more "relevant" IR of only a few years back? Thanks
Great video! If I have monthly returns, I just change the formulas from e.g. SQRT(252) to SQRT(12) right?
Hi, and glad you liked the video! Yes, exactly, to annualise monthly standard deviation you can simply multiply by SQRT(12).
QQQ = NASDAQ 100 index fund
INZ = Stock of Invesco, investment management company (and manager of QQQ)
BLK = Stock of Blackrock, investment management company
SCHW = Stock of Charles Schwab, brokerage/wealth management/investment management company
you have 1 year's data so not sure why multiplying by SQRT 252 necessary? One multiplies by SQRT(time) if less than 1 year's data. So one month date = *(SQRT) 12
Hi Paul, and thanks for the question! I have got five years worth of daily data, so to determine annualised standard deviation, multiplying by SQRT(252) is needed as the original data is daily and we would like to have it on an annual basis.
Hi @@NEDLeducation , could you please let me why you took 252 instead 365 or 366?
Hi, that's because there are only 252 trading days, or 252 observations per year if you prefer. Week-end does not count. @@EduLife_Chronicles
from where come 252 ?
Hi, and thanks for the question! 252 is a typical number of trading days (when markets are open) in a year.
@@NEDLeducation where can i contact you in private please ?