Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
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. – Ram Ahluwalia Aug 9 '12 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 – user1129988 Aug 28 '12 at 9:26
why not ARMA(n,m)-GARCH(p,q)? several users below actually suggested just an arma model.. – pyCthon Nov 16 '12 at 3:58
Have a look at the several serial correlation robust bootstrap estimators. – Jase Dec 7 '12 at 2:03

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?

share|improve this answer
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? – user1129988 Jul 10 '12 at 13:32

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.

share|improve this answer
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? – user1129988 Jul 11 '12 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. – psandersen Jul 11 '12 at 9:50
Alternatively you could look at including your predictors as exogenous variables in your ARMA process. – psandersen Jul 11 '12 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.. – user1129988 Jul 12 '12 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. – psandersen Jul 12 '12 at 19:34

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).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.