Last Updated on December 29, 2021 at 5:49 pm
In this article, we show how the NAV of an index fund or the price of an ETF is affected by a market crash and discuss a simple, effective way to measure tracking error. That is how well the fund or ETF was able to track the underlying total returns index.
Textbooks define tracking error as the standard deviation of “difference between the returns of an investment and its benchmark”. This is always a positive number and higher the value, more the deviation. What many investors fail to appreciate is, the tracking error depends on the time window chosen. That is tracking error over the last one year is different from that over the last two years.
This definition does not distinguish between underperformance (index fund return less than benchmark return say over a month) and outperformance (index fund return higher than the benchmark). As pointed by Siva from Facebook group, Asan Ideas for Wealth (privately), expenses do not result in tracking error!
That is if you remove say, 1% annual fee from the Nifty TRI data (distributed daily), the return difference bet the bare data and the processed data is 1%, but the tracking error is zero. This is because there is no variation in return between the index data and our imaginary index fund.
Join over 32,000 readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email! 🔥Enjoy massive discounts on our robo-advisory tool & courses! 🔥
This is because the tracking error is measured as a standard deviation. If you invest in a fixed deposit, the monthly return is the same each month. So the standard deviation is zero. The reason here is the same if the daily expense ratio is the same and there are no other factors that affect the fund management.
Thus the main reason for tracking error in an index fund is fund in and outflows and the difficulty in trying to copy changes to the index. These, in turn, depend on how easy or difficult it is to buy or sell stocks. Siva also showed that it is possible to construct an index fund NAV that has the same return as that of the index but with significant tracking error. The tracking error is non-intuitive and unsuitable for use by retail investors.
A fund with a low expense ratio can have a high tracking error: This has been established in multiple articles:
- Selecting index funds: Lowest expenses does not mean lowest tracking error!
- ICICI Nifty Next 50 Index Fund vs Reliance ETF Junior BeEs
- ETFs vs Index Funds: Stop assuming lower expenses equals higher returns!
- Which Nifty, Nifty Next 50, Sensex index funds have the lowest tracking error?
- Which Nifty Index Fund has the lowest tracking error?
To make things worse, the return and tracking error of an ETF are measuring using its NAV data, while investors buy and sell at market price. This price movement can deviate significantly from the NAV movement especially during a market crash when there is a sudden drop in demand.
We plot below the rolling monthly return difference between Nifty 50 TRI and Nippon India Nifty Bees price (blue) and NAV (red). The price data is so huge that we had to multiply the NAV data by ten and it is still small! Stay away from ETFs unless you want to trade in real-time!
How a market crash affects index funds
![Monthly return of Nifty TRI minus the monthly return of Nippon India Nifty Bees ETF NAV and Price (multiplied by 10 for clarity)](https://freefincal.com/wp-content/uploads/2020/11/Monthly-return-of-Nifty-TRI-minus-monthly-return-of-Nippon-India-Nifty-Bees-ETF-and-Price-multiplied-by-10-for-clarity.jpg)
Notice how much the tracking error measured with the NAV data misrepresents reality even far away from the crash! Every return that is mentioned online is based on NAV and not on the price! The huge upward and downward spike correspond to the March 2020 crash.
Ideally Nifty 50 TRI monthly return – Nippon India Nifty Bees ETF NAV monthly return should be positive. That is over a month, the index will always have a higher return primarily because of the expenses associated with the ETF (or any index fund). Out of the 469 monthly return differences studied, the ETF NAV return was higher than that of the index 196 times! This is clear evidence that difficulty in aligning the portfolio with that of the index is the main reason for this return difference – so much that it negates the loss due to expenses!
In our opinion, studying this return difference is a simpler and superior way than computing tracking error as a standard deviation. The ETF price return is expected to oscillate above and below that of the index return due to demand and supply fluctuations. This is welcome as long as the swings are small and bi-directional (both ways).
Let us now consider one of the worst index fund performers: Tata Nifty Index fund. Currently, this has the same expense ratio as that of Nippon Nifty Bees. The negative blue dots represent monthly returns of fund which were higher than the index.
![Monthly return of Nifty TRI minus the monthly return of Nippon India Nifty Bees ETF NAV and Tata Nifty Index Fund NAV](https://freefincal.com/wp-content/uploads/2020/11/Monthly-return-of-Nifty-TRI-minus-the-monthly-return-of-Nippon-India-Nifty-Bees-ETF-NAV-and-Tata-Nifty-Index-Fund-NAV.jpg)
During a market crash, the negative deviation is sharp, but such deviations can occur on any given day. As many as 148 such negative return differences were seen for the Tata fund and 196 for Nifty Bees ETF (with NAV).
A better way to measure tracking error
Instead of reporting a single always positive number as tracking error, we can quantify deviations from the index in the following ways:
- no of times fund return or etf return (with price) was higher than then index for a month. This means the index – fund monthly return difference is negative.
- The gap between the max return difference and min return difference
- These along with few other quantities are tabulated below.
Quantity | Nippon India Nifty Bees Price | Nippon India Nifty Bees NAV | Tata Index Fund-Nifty Plan(G)-Direct Plan | Franklin India Index Fund-NSE Nifty(G)-Direct Plan |
No of negative monthly return difference | 244 | 196 | 148 | 87 |
Total monthly returns | 474 | 469 | 469 | 469 |
median monthly return difference | -0.01% | 0.00% | 0.03% | 0.05% |
stdev of monthly return differnces | 0.72% | 0.03% | 0.25% | 0.17% |
avg monthly return difference | -0.13% | 0.00% | -0.02% | 0.10% |
max monthly return difference | 7.63% | 0.24% | 2.13% | 1.22% |
min monthly return difference | -4.86% | -0.04% | -1.17% | -0.66% |
If someone were to study the ETF NAV alone, they would be impressed with the gap between the max and min monthly return differences: 0.24% – (-0.04%) = 0.28%. Only if they bother to look at this difference based on the price they would appreciate it is as high as 12.49%.
Compared to this, the Franklin fund has fared reasonably well with a spread of 1.89% and only 87/469 instances of fund outperformance (negative return difference). These quantities are intuitive and easier to understand than the tracking error. As one can see from the above table, the median and average of the return differences are quite different. This makes the standard deviation (conventional tracking error) an incorrect measure unrepresentative of the actual spread.
A monthly tracking error data sheet with this data will soon be made available. The top 2-3 funds in this list are not names you would see commonly in DIY forums 🙂
🔥Enjoy massive discounts on our courses, robo-advisory tool and exclusive investor circle! 🔥& join our community of 5000+ users!
Use our Robo-advisory Tool for a start-to-finish financial plan! ⇐ More than 1,000 investors and advisors use this!
New Tool! => Track your mutual funds and stock investments with this Google Sheet!
We also publish monthly equity mutual funds, debt and hybrid mutual funds, index funds and ETF screeners and momentum, low-volatility stock screeners.
![Follow Freefincal on Google News Follow Freefincal on Google News](https://freefincal.com/wp-content/uploads/2023/07/Follow-Freefincal-on-Google-News.jpg)
![Subscribe to the freefincal Youtube Channel Subscribe to the freefincal Youtube Channel. Subscribe button courtesy: Vecteezy.](https://freefincal.com/wp-content/uploads/2023/07/Subscribe-to-the-freefincal-Youtube-Channel.jpg)
![Follow freefincal on WhatsApp Channel Follow freefincal on WhatsApp Channel](https://freefincal.com/wp-content/uploads/2023/09/Follow-freefincal-on-WhatsApp-Channel-300x83.jpg)
![Listen to the Lets Get Rich with Pattu Podcast Listen to the Lets Get Rich with Pattu Podcast](https://freefincal.com/wp-content/uploads/2023/07/Listen-to-the-Lets-Get-Rich-with-Pattu-Podcast.jpg)
![Lets Get RICH With PATTU podcast on YouTube Lets Get RICH With PATTU podcast on YouTube](https://freefincal.com/wp-content/uploads/2023/08/Lets-Get-RICH-With-PATTU-podcast-on-YouTube-644x362.jpg)
- Do you have a comment about the above article? Reach out to us on Twitter: @freefincal or @pattufreefincal
- Have a question? Subscribe to our newsletter using the form below.
- Hit 'reply' to any email from us! We do not offer personalized investment advice. We can write a detailed article without mentioning your name if you have a generic question.
Join over 32,000 readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email!
About The Author
![Pattabiraman editor freefincal](https://freefincal.com/wp-content/uploads/2019/11/Pattabiraman-author-freefincal-article-bottom.jpg)
Our flagship course! Learn to manage your portfolio like a pro to achieve your goals regardless of market conditions! ⇐ More than 3,000 investors and advisors are part of our exclusive community! Get clarity on how to plan for your goals and achieve the necessary corpus no matter the market condition is!! Watch the first lecture for free! One-time payment! No recurring fees! Life-long access to videos! Reduce fear, uncertainty and doubt while investing! Learn how to plan for your goals before and after retirement with confidence.
Our new course! Increase your income by getting people to pay for your skills! ⇐ More than 700 salaried employees, entrepreneurs and financial advisors are part of our exclusive community! Learn how to get people to pay for your skills! Whether you are a professional or small business owner who wants more clients via online visibility or a salaried person wanting a side income or passive income, we will show you how to achieve this by showcasing your skills and building a community that trusts and pays you! (watch 1st lecture for free). One-time payment! No recurring fees! Life-long access to videos!
Our new book for kids: “Chinchu Gets a Superpower!” is now available!
![Both boy and girl version covers of Chinchu gets a superpower](https://freefincal.com/wp-content/uploads/2021/02/Article-bottom-Chinchu-gets-a-superpower-front-cover-for-girls-and-boys.jpg)
![Feedback from a young reader after reading Chinchu gets a Superpower (small version)](https://freefincal.com/wp-content/uploads/2021/02/For-bottom-Feedback-from-a-young-reader-after-reading-Chinchu-gets-a-superpower.jpg)
Must-read book even for adults! This is something that every parent should teach their kids right from their young age. The importance of money management and decision making based on their wants and needs. Very nicely written in simple terms. - Arun.Buy the book: Chinchu gets a superpower for your child!
How to profit from content writing: Our new ebook is for those interested in getting side income via content writing. It is available at a 50% discount for Rs. 500 only!
Do you want to check if the market is overvalued or undervalued? Use our market valuation tool (it will work with any index!), or get the Tactical Buy/Sell timing tool!
We publish monthly mutual fund screeners and momentum, low-volatility stock screeners.
About freefincal & its content policy. Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on mutual funds, stocks, investing, retirement and personal finance developments. We do so without conflict of interest and bias. Follow us on Google News. Freefincal serves more than three million readers a year (5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified with credible and knowledgeable sources before publication. Freefincal does not publish paid articles, promotions, PR, satire or opinions without data. All opinions will be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
- Twitter @freefincal
- Subscribe to our YouTube Videos
- Posts feed via Feedburner.
Our publications
You Can Be Rich Too with Goal-Based Investing
![You can be rich too with goal based investing](https://freefincal.com/wp-content/uploads/2016/11/You-can-be-rich-243x300.jpg)
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want
![Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you want](https://freefincal.com/wp-content/uploads/2017/05/2-mini-Cover-pink.jpg)
Your Ultimate Guide to Travel
![Travel-Training-Kit-Cover-new](https://freefincal.com/wp-content/uploads/2019/11/Travel-Training-Kit-Cover-new.jpg)