Hi Can someone please explain me how the cross sectional calculation can be done.

For an example, I'm having a vector like this.

enter image description here

Vector 1: This is the vector where all the excess returns for n portfolios and to n time series are written.

Vector 2: Fama French 3 factor vector (nx3)

Vector 3: Calculated Betas for the portfolio. (3xn). So can someone please show me how the betas for each time can be calculated. (Cross sectional regression) this should be a [4xTn] times matrics including the the intercept as well. I need to implement this in excel. But have no idea

Even a small example is highly appreciated. I couldn't find any resources for this calculation.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.