Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started