Data Lab 4
1. Revisit the all-weather portfolio you crafted. Create the maximum Sharpe portfolio's daily return dataframe and then merge it with Fama French's five return factors.
Run to view results
Read csv document, convert the first column to a proper datetime format, and set the converted datetime as the index of the dataframe.
Run to view results
Create the maximum Sharpe portfolio's daily return dataframe.
Run to view results
Merge the maximum Sharpe portfolio's daily return dataframe with Fama French's five return factors.
Run to view results
2. Examine visually the correlation between portfolio and factor returns.
Run to view results
Calculate the correlation Matrix for Fama-French factors.
Run to view results
3. Regress the portfolio return on each factor and assess the portfolio's sensitivity to each factor. For the curious, optional challenge, how do you test whether the intercept (i.e., alpha) is significantly different from the risk-free rate for a single-factor regression?
Run to view results
To facilitate the comparison of whether the intercept is significantly different from the risk-free rate, I set the dependent variable in the regression to be the daily returns minus the risk-free rate, which is the excess returns. This way, I only need to test if the intercept is significantly different from zero.
Run to view results
The regression coefficient for the 'Mkt-RF' factor is 0.0040, indicating that the portfolio is relatively sensitive to this factor. The p-value of intercept is 0.000, indicating that the intercept is significantly different from the risk-free rate.
Run to view results
The regression coefficient for the 'SMB' factor is -3.18e-06, indicating that the portfolio is not sensitive to this factor. However, the p-value of 'SMB' factor is 0.994, indicating that the coefficient is not significant. The p-value of intercept is 0.000, indicating that the intercept is significantly different from the risk-free rate.
Run to view results
The regression coefficient for the 'HML' factor is -0.0022, indicating that the portfolio is relatively sensitive to this factor. The p-value of intercept is 0.000, indicating that the intercept is significantly different from the risk-free rate.
Run to view results
The regression coefficient for the 'RMW' factor is -0.0019, indicating that the portfolio is relatively sensitive to this factor. The p-value of intercept is 0.000, indicating that the intercept is significantly different from the risk-free rate.
Run to view results
The regression coefficient for the 'CMA' factor is -0.0029, indicating that the portfolio is relatively sensitive to this factor. The p-value of intercept is 0.000, indicating that the intercept is significantly different from the risk-free rate.
Run to view results
4. Regress the portfolio return on all factors and assess the portfolio's sensitivity to factors. For the curious, optional challenge, how do you test whether the intercept (i.e., alpha) is significantly different from the risk-free rate for a multi-factor regression?
From the regression results, it can be observed that ‘SMB’ and ‘RMW’ are not statistically significant and thus should be excluded. The portfolio shows the highest sensitivity to 'CMA' and 'Mkt-RF'. Additionally, the p-value of the intercept is 0.000, indicating that the intercept is significantly different from the risk-free rate.
Run to view results