Home > Main Forums > General Discussion > Sharpe Ratio

Sharpe Ratio

  1. Hi all,

    I want to calculate the Sharpe Ratio for my portfolio. I started out here:

    http://investexcel.net/calculating-the-sharpe-ratio-with-excel/

    What is [if one exists] the standard in the industry for "risk-free rate" and where can I find that data?

    Also, the website gives an example with annual returns. What would be the implications of using monthly or daily returns instead? If done that way then I'm guessing I would divide risk-free rate by 12 or 365?

    Thanks!
    Mark
     
  2. Hi Mark,

    I always use the T-bill rate for the risk-free rate. The other thing you can do is just use the Information Ratio which is just Sharpe not accounting for the risk-free rate. This works fine in a short back-test or live tracking where the risk-free rate is low. If you back-test back into the 80's then the risk-free rate of course becomes more important.

    Yes, you want to annualize the returns for the Sharpe/IR calculation.

    Regards, Rich
     
  3. Thanks for the link
    I was interested in the risk free rate myself for other calculations
    I was wondering if there is a way to use RTD to somehow import the number into excel