please do as quick as possible

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