Dear Forum members,

I am working with Compustat quarterly and will calculated quarterly market returns (over the entire compustat universe), which will be possible using the variables given by the Compustat data (stock prices etc.).

However, I want to compare the market return with a risk-free rate of return (to get the excess return). Do you have any suggestions on a) which risk-free rate to use (e.g. 10y U.S. Gov. Bonds) and b) where to get this return from (data source) and how to match with Compustat?

The final goal of my analysis is to construct a Markov regime switching model. I want to analyze bull/bear periods and company fundamentals. I am working with STATA.

Thanks for your suggestions.

Chris