I want to calculate excess return for AAPL plus the S&P 500. I have computed monthly and daily logarithmic returns for every stock and for the market, I now need to calculate the risk free interest rate in order to be able to compute the excess return for every stock and the market.
Interest rates on three months T-Bills are a good proxy for the risk-free rate of return, but I have a lot of doubts on how to use data provided by Yahoo! Finance in order to compute the daily risk-free. I use the 13 week treasury bill (ticker: ^IRX) historical quotes provided by Yahoo! Finance. I divided t-bill rate by 100 and calculate the daily excess returns.
             t-bill         AAPL           Excess
2017-01-31    0.500     -0.00230205    -0.00730020
2017-01-30    0.495     -0.00262402    -0.00762402
However, I realized that monthly t-bill rate units are the same as daily rates.
              t-bill      AAPL          
Jan 2017      0.500      0.0477  
Dec 2016      0.480      0.0479 
I am making a mistake while computing daily and monthly t-bill rate units. The Federal Reserve (https://fred.stlouisfed.org/series/DTB3) also provide the same t-bill rates for daily and monthly frequency as in Yahoo Finance. How can I correctly calculate the excess returns? Thanks for any answer.
No comments:
Post a Comment