please answer as quick as possible, and show all the steps

didn't state which 4 stock and index, you just randomly choose 4 stocks is ok

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. 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