# Using rolling returns in a multivariate linear regression?

I am trying to use fundamental factors such as PE, BV, & CFO in a multivariate linear regression with the response variable being the rolling 1 month returns. But this approach seems flawed as the autocorrelation of the residuals is to high and the Durbin Watson test points also to such flaws. What is the best what to use long time horizon rolling returns in a linear regression?

• Incidentally, you have stumbled upon one of the skeletons in the closet for the Fama-French type multiple regression techniques. Many academic papers suffer from exactly the issue you describe (autocorrelated residuals) but it's simply not discussed. Commented Aug 9, 2012 at 19:36
• I can't seem to find any deterministic solutions and I am not conducting such a study for academic purposes so I can't afford to be lazy with assumptions. I will post back once I have some results of interest Commented Aug 28, 2012 at 9:26
• why not ARMA(n,m)-GARCH(p,q)? several users below actually suggested just an arma model.. Commented Nov 16, 2012 at 3:58
• Have a look at the several serial correlation robust bootstrap estimators.
– Jase
Commented Dec 7, 2012 at 2:03

Why not fit an ARMA model to the rolling returns first, and then model the residuals in your regression equation? That way you should be removing most of the effects of auto-correlation.

• where can I read more about this approach of using an ARMA model? ARMA model will help to deal the smoothing for rolling returns but I dont quite understand what you mean by model the residuals? Commented Jul 11, 2012 at 8:10
• Are you looking for practical examples of ARMA models in a language like R or more a theoretical explanation? By modelling the residuals I meant you first fit an ARMA model, then run predictions from this model and the residuals are the actual returns minus the predicted returns. You use the residuals (which if you choose your ARMA model correctly, should be free from autocorrelation) instead of the rolling returns in your model. Note: You will likely want to fit the ARMA model on a rolling window like you would a rolling mean. Commented Jul 11, 2012 at 9:50
• Alternatively you could look at including your predictors as exogenous variables in your ARMA process. Commented Jul 11, 2012 at 9:50
• I am using matlab. if there are any practical examples for using an ARMA model approach that would be great. I still don't quite grasp how the ARMA model is supposed to work.. Commented Jul 12, 2012 at 6:56
• I dont know any examples in matlab unfortunately, but I found plenty using R (my language of choice). You may find the series of blog posts at theaverageinvestor.wordpress.com/2011/04/14/… useful, and a number of trading strategies with code discussed at systematicinvestor.wordpress.com/?s=garch (for example, his use of rolling regression for factor analysis seems similar in principle to what you want to do.) Since you seem to be at the prototyping stage, might make sense to play around with some of these examples in R first. Hope this helps. Commented Jul 12, 2012 at 19:34

It simply points to the fact that your model as stands does not have much explanatory power of monthly returns. One reason could be of a observation period mismatch. I am not a fundamental type of guy, but I imagine that the monthly returns are measured over too short a period (1 month) while most fundamental factors are updated on a quarterly basis (sometimes semi-annually or annually depending on local market regulations). Thus, changes or absolute levels in cash flows on a quarterly basis may not be able to explain changes in monthly returns. Can you run the same model again but use quarterly returns (or match the periodicity of the independent variables periodicity) and report back?

• once I difference (once) the rolling returns and the factors it seems to handle any issues that may violate the requirements of the OLS.. I still think I am missing something? Commented Jul 10, 2012 at 13:32

Try fitting a model with ARMA errors?

However, if by "rolling returns" you imply a moving average of returns or some QoQ or YoY return series, which has much persistence, I am not so sure what the right way to proceed really is (with the exception that you can apply some corrections suggested in econometrics literature).