Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the 10 & 20 day moving averages for each. Graph the two moving averages for each in the same line graph, put the date
Calculate the 10 & 20 day moving averages for each. Graph the two moving averages for each in the same line graph, put the date on x-axis. (Note: should have two graphs, one for each asset). 1A) Determine the date for each asset where there was a crossover point in the moving averages. 1B) How many crossover points were there for Apple? Were there buy or sell signals?
Date | SP 500 | AAPL |
9/3/2019 | 2906.27 | 205.7 |
9/4/2019 | 2937.78 | 209.19 |
9/5/2019 | 2976 | 213.28 |
9/6/2019 | 2978.71 | 213.26 |
9/9/2019 | 2978.43 | 214.17 |
9/10/2019 | 2979.39 | 216.7 |
9/11/2019 | 3000.93 | 223.59 |
9/12/2019 | 3009.57 | 223.09 |
9/13/2019 | 3007.39 | 218.75 |
9/16/2019 | 2997.96 | 219.9 |
9/17/2019 | 3005.7 | 220.7 |
9/18/2019 | 3006.73 | 222.77 |
9/19/2019 | 3006.79 | 220.96 |
9/20/2019 | 2992.07 | 217.73 |
9/23/2019 | 2991.78 | 218.72 |
9/24/2019 | 2966.6 | 217.68 |
9/25/2019 | 2984.87 | 221.03 |
9/26/2019 | 2977.62 | 219.89 |
9/27/2019 | 2961.79 | 218.82 |
9/30/2019 | 2976.74 | 223.97 |
10/1/2019 | 2940.25 | 224.59 |
10/2/2019 | 2887.61 | 218.96 |
10/3/2019 | 2910.63 | 220.82 |
10/4/2019 | 2952.01 | 227.01 |
10/7/2019 | 2938.79 | 227.06 |
10/8/2019 | 2893.06 | 224.4 |
10/9/2019 | 2919.4 | 227.03 |
10/10/2019 | 2938.13 | 230.09 |
10/11/2019 | 2970.27 | 236.21 |
10/14/2019 | 2966.15 | 235.87 |
10/15/2019 | 2995.68 | 235.32 |
10/16/2019 | 2989.69 | 234.37 |
10/17/2019 | 2997.95 | 235.28 |
10/18/2019 | 2986.2 | 236.41 |
10/21/2019 | 3006.72 | 240.51 |
10/22/2019 | 2995.99 | 239.96 |
10/23/2019 | 3004.52 | 243.18 |
10/24/2019 | 3010.29 | 243.58 |
10/25/2019 | 3022.55 | 246.58 |
10/28/2019 | 3039.42 | 249.05 |
10/29/2019 | 3036.89 | 243.29 |
10/30/2019 | 3046.77 | 243.26 |
10/31/2019 | 3037.56 | 248.76 |
11/1/2019 | 3066.91 | 255.82 |
11/4/2019 | 3078.27 | 257.5 |
11/5/2019 | 3074.62 | 257.13 |
11/6/2019 | 3076.78 | 257.24 |
11/7/2019 | 3085.18 | 259.43 |
11/8/2019 | 3093.08 | 260.14 |
11/11/2019 | 3087.01 | 262.2 |
11/12/2019 | 3091.84 | 261.96 |
11/13/2019 | 3094.04 | 264.47 |
11/14/2019 | 3096.63 | 262.64 |
11/15/2019 | 3120.46 | 265.76 |
11/18/2019 | 3122.03 | 267.1 |
11/19/2019 | 3120.18 | 266.29 |
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