Question: 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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I need help from a Financial expert who is very familiar with exchange rate exposure & payout policy.I will adjust the price as you suggest. For some reason I am not able to do it here. Please be...

First Edition Actuarial Excel Data Analytics and Applications Guangwei Fan Guodong Li Jinfeng Wei Preface This iBook was written based on lecture notes from courses on actuarial technology and from...

there is a note and please solve it based on that note thanks Please note: I) Answers must be motivated and all the steps in the calculations are shown. II) Write your full name. III) You are...

Need help with my final project Part 2 ASAP It has a part A and Part B Part A is an Excel Sheet and Part B is a word document. Will provide extra information. The directions will be found in the...

Need help with part 3 only Part 3 Minimum Variance and Tangent Portfolios Instruction: You have two customers that have different tastes of risk. The first customer is a risk averter who find the way...

Please make sure that you can do it, someone already cancelled this question one me before. Thank you for your help. FIN 5550 - Investments Project 1: Beta and Return. This project is worth 15% of...

He want us to identify the 18 vulnerabilities. template is attach. Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE...

Can you please help me with this case problem? AICPA Case Development Program. Case No. 2000-02: Recreation, Inc Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC....

Risk Assestment Project - Identify 18 Vulnerabilit AICPA Case Development Program Case No. 2000-02: Recreation, Inc. ? 1 RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE STUDY OF...

I need help with how to do a DCF analysis for this Spotify case. Please can you show the explanation of the steps Thank you A. Using the information provided, what should SPs shares be trading at on...

Consider the irreversible process in Problem 8.128. Assume that the process could be done reversibly by adding heat engines/pumps between tanks A and B and the cylinder. The total system is...

Document for Analysis: Poorly Written Procedure E-Mail Your Task. Analyze the following poorly written e-mail message, and list its specific weaknesses. If your instructor directs, revise it. To:...

Fraudsters can target investors who are trying to coupon losses, and derivative markets could be fertile ground in some respects because participants tend to be ?

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Compare levels of resolution in conflict outcomes?

What kinds of behaviors provoke you the most? Are there times when you provoke conflict with others, perhaps even on purpose?

Strategies for Managing Conflict Conflict Outcomes?