Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please choose real life companies to complete this question. No data was provided by the professor. Collect 30-day closing values of two companies of your

Please choose real life companies to complete this question. No data was provided by the professor.

Collect 30-day closing values of two companies of your choice, which operate in the same industry.

Collect 30-day closing values of S&P500 (same days as the days of the companies of your choice).

Calculate daily returns for the companies and S&P500, all in one file. (Make sure to sort your data in descending date (earlier dates to later dates i.e. the oldest date on top and newest date at the bottom of the columns).

Graph the returns (of the companies and the S&P500) together in one chart (days on horizontal axis and returns on vertical axis).

Make a 3-line comment about the shapes of the graphs.

Wal-Mart (WMT)
Date Open High Low Close Adj Close Volume
8/23/18 95.5 95.860001 95.059998 95.18 95.18 6096400
8/24/18 95.089996 95.660004 94.349998 94.949997 94.949997 8594300
8/27/18 95.260002 95.610001 94.290001 94.540001 94.540001 7040300
8/28/18 94.769997 96.349998 94.529999 96.07 96.07 9983000
8/29/18 96.279999 96.830002 95.529999 95.639999 95.639999 7862800
8/30/18 95.5 96.5 95.449997 96.099998 96.099998 7058700
8/31/18 96.190002 96.440002 95.110001 95.860001 95.860001 6324700
9/4/18 95.800003 96.269997 95.239998 95.360001 95.360001 8280700
9/5/18 95.669998 96.830002 95.360001 96.620003 96.620003 9474600
9/6/18 96.529999 96.720001 96.010002 96.449997 96.449997 6150800
9/7/18 95.800003 96.480003 95.639999 95.830002 95.830002 6672400
9/10/18 96.110001 97.190002 96.089996 96.900002 96.900002 8332600
9/11/18 97.269997 97.660004 96.489998 96.639999 96.639999 6463500
9/12/18 96.260002 96.739998 95.93 95.970001 95.970001 5900000
9/13/18 95.32 95.620003 94.910004 95.120003 95.120003 7652900
9/14/18 94.529999 94.839996 94.349998 94.589996 94.589996 6319400
9/17/18 94.75 95.480003 94.370003 94.82 94.82 5329800
9/18/18 94.459999 95.589996 94.150002 95.43 95.43 6759800
9/19/18 95.57 95.889999 94.879997 95.239998 95.239998 5675100
9/20/18 95.349998 95.790001 94.949997 95.75 95.75 5256800
9/21/18 95.919998 96.290001 95.629997 95.900002 95.900002 9530133

Kroger (KR)
Date Open High Low Close Adj Close Volume
8/22/18 31.450001 31.99 31.35 31.74 31.74 13288800
8/23/18 31.6 32.400002 31.51 32.310001 32.310001 11686900
8/24/18 32.279999 32.299999 31.190001 31.200001 31.200001 8486100
8/27/18 31.299999 31.389999 30.91 31.190001 31.190001 6684100
8/28/18 31.219999 31.34 30.82 31.110001 31.110001 5749600
8/29/18 31.15 31.360001 30.66 30.68 30.68 6886600
8/30/18 30.76 31.690001 30.73 31.040001 31.040001 6507900
8/31/18 31.01 31.51 30.93 31.5 31.5 7356500
9/4/18 31.540001 31.940001 31.530001 31.9 31.9 8774500
9/5/18 31.790001 32.09 31.6 31.959999 31.959999 6881000
9/6/18 32.07 32.740002 32.049999 32.560001 32.560001 8404900
9/7/18 32.549999 32.73 32.34 32.369999 32.369999 6488100
9/10/18 32.119999 32.150002 31.629999 31.75 31.75 10614100
9/11/18 31.83 32.080002 31.370001 31.389999 31.389999 14372000
9/12/18 31.5 31.83 31.09 31.73 31.73 11846000
9/13/18 28.610001 29.18 28.299999 28.58 28.58 32474400
9/14/18 28.6 28.610001 27.76 27.799999 27.799999 18729600
9/17/18 27.75 28.98 27.540001 28.84 28.84 16749800
9/18/18 28.950001 29.43 28.82 29.290001 29.290001 10436600
9/19/18 29.360001 29.629999 28.370001 28.879999 28.879999 10168400
9/20/18 28.98 29.219999 28.549999 29.18 29.18 9022200
9/21/18 29.43 29.995001 29.299999 29.950001 29.950001 16765367

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Handbook Of Mortgage Backed Securities

Authors: Frank Fabozzi

6th Edition

0071460748, 978-0071460743

More Books

Students also viewed these Finance questions