Hi guys,
I hope someone can help me here. I am in a dire situation. I have to use LINEST to regress stock returns with 3 factors (x variables). It seems simple enough as I just select Y array and the X arrays and then boom, 3 coefficients and the alpha. However, that is only for one stock. I need to do this 252 times (252 stocks)!!!! moreover, using a mac doesnt make things any easier and I have to do a rolling regression, meaning 72 times!!
Regressing 252 stocks X 72 regressions = way too much work!
What can I do? I am hopeless at VBA and I have a couple weeks left!!
BobF
Bookmarks