here is my problem
I am trying to make this in excel, but not sure is achievable.
5(or more)stocks with historical price in ten years and I have index also in that range.
I want to have the regression analysis between index and a stock price.
The point is I can run regression for one, but how to run it for 1000 companies.
1
the data range is the date 180 before to 10 days after.
so total 191 days data.
2
I want run regression and have the result showing in Er(ibm)=a+b(index)
have a and b value showing
I will attach the raw data and a example result for one firm.(the yellow portion is what i need)
Bookmarks