I have a series of prices from Jan 2012 to Jul 2017 for the iShares Short Treasury Bond ETF.
I calculated monthly returns using (Month 2 Price / Month 1 Price)-1.
Then, I used PRODUCT(1+RANGE)^(MIN(1,12/COUNT(RANGE)))-1 to calculate the 1 year and 5 years annualized return.
Are the above steps right? The output does not match what is reflected on the ETF's website.
For example, I am getting a 5-year annualized returns of 0.02% as of 30 June 2017, when the website states 0.12% for the same period. Help please!
I calculated monthly returns using (Month 2 Price / Month 1 Price)-1.
Then, I used PRODUCT(1+RANGE)^(MIN(1,12/COUNT(RANGE)))-1 to calculate the 1 year and 5 years annualized return.
Are the above steps right? The output does not match what is reflected on the ETF's website.
For example, I am getting a 5-year annualized returns of 0.02% as of 30 June 2017, when the website states 0.12% for the same period. Help please!