Please solve A, B, and C. Please use excel. Please show work. Thank you.

A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file.

B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute the price changes using the current week prices minus the previous week's prices. Create a new column for each stock which takes the value of one if the price changes are positive, zero otherwise.

C. Use another sheet to stack up all info of price changes (1/0), ticker, and industry. This table should include three columns (stocks ticker, price changes, industry). Create pivot table to get the price change information across stocks and industry.