please answer as detailed as possible and show me the steps

Hedging Assignment for Chapter 3 Download the daily prices of 4 stocks and a stock index which has a futures contract. Compute the daily returns, the individual beta and portfolio beta (i.e., the optimal hedge ratio) of the equally-weighted 4-stock portfolio using Excel. Suppose you have invested 1 million unit of local currency each in the 4 stocks, compute number of stock index futures contract of that market you need to use in order to hedge your stock portfolio. Due date: submit the Excel file to Ummoodle by 21 March 2022. You can also monitor the performance of the hedged stock portfolio on a weekly basis. If the hedge works, the portfolio value should be very stable. Losses (gains) in the stock portfolio will be offset by gains (losses) in the stock index futures. Hedging Assignment for Chapter 3 Download the daily prices of 4 stocks and a stock index which has a futures contract. Compute the daily returns, the individual beta and portfolio beta (i.e., the optimal hedge ratio) of the equally-weighted 4-stock portfolio using Excel. Suppose you have invested 1 million unit of local currency each in the 4 stocks, compute number of stock index futures contract of that market you need to use in order to hedge your stock portfolio. Due date: submit the Excel file to Ummoodle by 21 March 2022. You can also monitor the performance of the hedged stock portfolio on a weekly basis. If the hedge works, the portfolio value should be very stable. Losses (gains) in the stock portfolio will be offset by gains (losses) in the stock index futures