polycarpvenant
New member
Hi all,
I am using the NSE definition here: https://www.nseindia.com/products-services/indices-tracking-error (stdev of fund less TRI daily return annualized via sqrt250)
I have taken Nifty 50 TRI data from here: https://www1.nseindia.com/products/content/equities/indices/historical_total_return.htm
and UTI - NIFTY Index Fund-Growth Option- Direct NAV data from AMFI.
I have replicated the calc in this Google Sheet but unable to reconcile the result (Annualised 1yr Tracking error value of 0.0382) from UTI AMC website for YE 31-Mar-2021:
It is driving me nuts. Please help.
Link to spreadsheet: https://docs.google.com/spreadsheet...9oEv8Pt9Xf8ag1vaEae9sNuo3kUOl/pub?output=xlsx
Disclosure: This calculation will eventually go into my blog so in case that is relevant (the post will deal with choosing index funds)
Any help is highly appreciated and thanks in advance.
Edit: Solved by @gunderson500 below. This was because 14Nov2020 has trading data for Muhurat trading but no MF NAVs.
I am using the NSE definition here: https://www.nseindia.com/products-services/indices-tracking-error (stdev of fund less TRI daily return annualized via sqrt250)
I have taken Nifty 50 TRI data from here: https://www1.nseindia.com/products/content/equities/indices/historical_total_return.htm
and UTI - NIFTY Index Fund-Growth Option- Direct NAV data from AMFI.
I have replicated the calc in this Google Sheet but unable to reconcile the result (Annualised 1yr Tracking error value of 0.0382) from UTI AMC website for YE 31-Mar-2021:
It is driving me nuts. Please help.
Link to spreadsheet: https://docs.google.com/spreadsheet...9oEv8Pt9Xf8ag1vaEae9sNuo3kUOl/pub?output=xlsx
Disclosure: This calculation will eventually go into my blog so in case that is relevant (the post will deal with choosing index funds)
Any help is highly appreciated and thanks in advance.
Edit: Solved by @gunderson500 below. This was because 14Nov2020 has trading data for Muhurat trading but no MF NAVs.