0
$\begingroup$

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:

$X_t=\phi+\alpha*X_{t-1}+\epsilon$

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?

Thanks.

$\endgroup$

closed as off-topic by LocalVolatility, Helin, Neeraj, lehalle, Bob Jansen Dec 3 '17 at 11:48

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Basic financial questions are off-topic as they are assumed to be common knowledge for those studying or working in the field of quantitative finance." – LocalVolatility, Helin, Neeraj, lehalle, Bob Jansen
If this question can be reworded to fit the rules in the help center, please edit the question.

3
$\begingroup$

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

$\endgroup$
  • $\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.