I am studying share price log returns and AR(1) model. I downloaded data from $FTSE100$ and I used the Adj.close column to find the Ln returns:

enter image description here

enter image description here

Now I am trying to understand how can I estimate an AR(1) model using this information.

I understand the AR(1) model. I did a couple of example in excel, but I do not understand how the ln returns are related to that.

AR(1) is given by:


I assume that I need to find values for $\phi$ and $\alpha$ to try to fit the AR(1) model but I am confused.

Can anyone help me on this?



You're on the right track. The time series you're trying to fit is the one formed by the returns $X_t = \ln (P_{t}/P_{t-1})$, where $P_t$ the tabulated price.

Once you calculate the returns just use a linear fit to estimate $\alpha$, $\phi$ and you're set. Probably you want to check $|\alpha|$ as well, it tells you something about the stationarity of the series

  • $\begingroup$ In column H you have the returns, create a new column I with the previous day's return (for example in I4 have the formula =H3). Then do a linear regression with these two columns (H: dependent, I: independent variable). $\endgroup$
    – Alex C
    Nov 16 '17 at 23:37
  • $\begingroup$ are you suggesting to do a regression using excel of the returns and lagged returns? and then find the intercept and slope values? $\endgroup$
    – user290335
    Nov 24 '17 at 13:39
  • $\begingroup$ @user290335 Yes $\endgroup$
    – caverac
    Nov 24 '17 at 13:42
  • $\begingroup$ when I do the regression I should only include in the X values the log returns starting from: H4 until the end and to Y values the lagged returns from I4 to the end right? $\endgroup$
    – user290335
    Nov 24 '17 at 13:46
  • $\begingroup$ @user290335 correct $\endgroup$
    – caverac
    Nov 24 '17 at 14:03

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