## 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 the app to see the outputs

Press the run button in the top right corner

Read csv document, convert the first column to a proper datetime format, and set the converted datetime as the index of the dataframe.

Run the app to see the outputs

Press the run button in the top right corner

Create the maximum Sharpe portfolio's daily return dataframe.

Run the app to see the outputs

Press the run button in the top right corner

Merge the maximum Sharpe portfolio's daily return dataframe with Fama French's five return factors.

Run the app to see the outputs

Press the run button in the top right corner

2. Examine visually the correlation between portfolio and factor returns.

Calculate the correlation Matrix for Fama-French factors.

Run the app to see the outputs

Press the run button in the top right corner

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 the app to see the outputs

Press the run button in the top right corner

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.

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 the app to see the outputs

Press the run button in the top right corner

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 the app to see the outputs

Press the run button in the top right corner

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 the app to see the outputs

Press the run button in the top right corner

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 the app to see the outputs

Press the run button in the top right corner

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 the app to see the outputs

Press the run button in the top right corner

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 the app to see the outputs

Press the run button in the top right corner