Using finance.yahoo.com, in the section named Quote lookup download the historical data on weekly basis for the last two years (Dec. 30, 2017- Dec. 6, 2019) of any three of the following companies (of your choice): IBM, GM, GE, TSLA, XOM, GIS, DUK, FCAU, CRC, and PEP. The data should appear on an excel file

What is the average highest and lowest price during the above period for each of the selected stocks?

b- Select the adjusted stock price of each of the three stocks and put them in one file (in three adjacent columns with the heading of each one being the name of the company) and then save this file using your name as a file name. Derive the weekly HPR for each companies by inserting three additional columns and then compute using the Excel built-in functions the average HPR, geometric HPR mean, variance, and standard deviation.

c- What is the difference between the arithmetic mean and geometric mean? Which one is always the lowest and when do they get close to each other?

d- Create a 3x3 grid on that excel file where in each cell of it you calculate the correlation coefficients between every possible pair of stocks. What is your explanations for those coefficients? How do they affect your investment choices?

e- Convert the weekly HPR and standard deviation into yearly figures.

f- If you aim to create a complete portfolio, why is it necessary to add a certain percentage (such as 10%) of money market instruments into that portfolio? What are the different types of US money market instruments and which one(s) will you select for your portfolio.

g- Based on the results you get what will be your complete portfolio return and standard deviation assuming that the 90% to be invested in the three stocks shall be divided as 40%, 30% and 20% from the highest Sharpe ratio to the lowest respectively.