Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the 5-day and 50-day simple MA for the stock price from 28 Oct 2016 to 14 June 2017. Plot the MA5 and MA50. How
Calculate the 5-day and 50-day simple MA for the stock price from 28 Oct 2016 to 14 June 2017. Plot the MA5 and MA50. How many golden crosses (if any) are there?
Date | Time | Closing Price | 5-day MA | 50-day MA |
2016/10/28 | 1 | 204 | ||
2016/10/31 | 2 | 205.399994 | ||
2016/11/1 | 3 | 206 | ||
2016/11/2 | 4 | 203 | ||
2016/11/3 | 5 | 200.199997 | ||
2016/11/4 | 6 | 199.699997 | ||
2016/11/7 | 7 | 202.600006 | ||
2016/11/8 | 8 | 203.600006 | ||
2016/11/9 | 9 | 202.399994 | ||
2016/11/10 | 10 | 204.800003 | ||
2016/11/11 | 11 | 206.199997 | ||
2016/11/14 | 12 | 204.199997 | ||
2016/11/15 | 13 | 203.399994 | ||
2016/11/16 | 14 | 203.399994 | ||
2016/11/17 | 15 | 204 | ||
2016/11/18 | 16 | 203 | ||
2016/11/21 | 17 | 202.399994 | ||
2016/11/22 | 18 | 203.800003 | ||
2016/11/23 | 19 | 203.600006 | ||
2016/11/24 | 20 | 203.800003 | ||
2016/11/25 | 21 | 205 | ||
2016/11/28 | 22 | 204.800003 | ||
2016/11/29 | 23 | 203.600006 | ||
2016/11/30 | 24 | 204 | ||
2016/12/1 | 25 | 204.199997 | ||
2016/12/2 | 26 | 202.800003 | ||
2016/12/5 | 27 | 197.399994 | ||
2016/12/6 | 28 | 196.399994 | ||
2016/12/7 | 29 | 193.600006 | ||
2016/12/8 | 30 | 195 | ||
2016/12/9 | 31 | 192.699997 | ||
2016/12/12 | 32 | 189.600006 | ||
2016/12/13 | 33 | 189.600006 | ||
2016/12/14 | 34 | 190 | ||
2016/12/15 | 35 | 186.899994 | ||
2016/12/16 | 36 | 185.100006 | ||
2016/12/19 | 37 | 182.600006 | ||
2016/12/20 | 38 | 182.100006 | ||
2016/12/21 | 39 | 182.100006 | ||
2016/12/22 | 40 | 181 | ||
2016/12/23 | 41 | 179.899994 | ||
2016/12/28 | 42 | 180.699997 | ||
2016/12/29 | 43 | 180.899994 | ||
2016/12/30 | 44 | 183.199997 | ||
2017/1/3 | 45 | 184.300003 | ||
2017/1/4 | 46 | 182.600006 | ||
2017/1/5 | 47 | 185.300003 | ||
2017/1/6 | 48 | 185.399994 | ||
2017/1/9 | 49 | 185.600006 | ||
2017/1/10 | 50 | 187.5 | ||
2017/1/11 | 51 | 188.300003 | ||
2017/1/12 | 52 | 186.600006 | ||
2017/1/13 | 53 | 186.5 | ||
2017/1/16 | 54 | 185 | ||
2017/1/17 | 55 | 185.899994 | ||
2017/1/18 | 56 | 187.899994 | ||
2017/1/19 | 57 | 187.199997 | ||
2017/1/20 | 58 | 185.5 | ||
2017/1/23 | 59 | 185.199997 | ||
2017/1/24 | 60 | 185.199997 | ||
2017/1/25 | 61 | 185.800003 | ||
2017/1/26 | 62 | 187.800003 | ||
2017/1/27 | 63 | 188.699997 | ||
2017/2/1 | 64 | 188.5 | ||
2017/2/2 | 65 | 187.300003 | ||
2017/2/3 | 66 | 186.399994 | ||
2017/2/6 | 67 | 187.199997 | ||
2017/2/7 | 68 | 186.699997 | ||
2017/2/8 | 69 | 195.5 | ||
2017/2/9 | 70 | 195.5 | ||
2017/2/10 | 71 | 195.800003 | ||
2017/2/13 | 72 | 198.699997 | ||
2017/2/14 | 73 | 197.800003 | ||
2017/2/15 | 74 | 202 | ||
2017/2/16 | 75 | 202.399994 | ||
2017/2/17 | 76 | 200.199997 | ||
2017/2/20 | 77 | 200.800003 | ||
2017/2/21 | 78 | 199 | ||
2017/2/22 | 79 | 200 | ||
2017/2/23 | 80 | 200.399994 | ||
2017/2/24 | 81 | 198 | ||
2017/2/27 | 82 | 195.399994 | ||
2017/2/28 | 83 | 192.699997 | ||
2017/3/1 | 84 | 193.5 | ||
2017/3/2 | 85 | 192 | ||
2017/3/3 | 86 | 191.399994 | ||
2017/3/6 | 87 | 191.699997 | ||
2017/3/7 | 88 | 192.199997 | ||
2017/3/8 | 89 | 191.800003 | ||
2017/3/9 | 90 | 190.399994 | ||
2017/3/10 | 91 | 190.100006 | ||
2017/3/13 | 92 | 191.800003 | ||
2017/3/14 | 93 | 192 | ||
2017/3/15 | 94 | 194.699997 | ||
2017/3/16 | 95 | 197.399994 | ||
2017/3/17 | 96 | 196.5 | ||
2017/3/20 | 97 | 200.399994 | ||
2017/3/21 | 98 | 199.699997 | ||
2017/3/22 | 99 | 196.399994 | ||
2017/3/23 | 100 | 196.399994 | ||
2017/3/24 | 101 | 196.399994 | ||
2017/3/27 | 102 | 195 | ||
2017/3/28 | 103 | 195.399994 | ||
2017/3/29 | 104 | 194.600006 | ||
2017/3/30 | 105 | 194.399994 | ||
2017/3/31 | 106 | 195.600006 | ||
2017/4/3 | 107 | 196.100006 | ||
2017/4/5 | 108 | 197.399994 | ||
2017/4/6 | 109 | 196 | ||
2017/4/7 | 110 | 195.899994 | ||
2017/4/10 | 111 | 195.5 | ||
2017/4/11 | 112 | 193.800003 | ||
2017/4/12 | 113 | 195.199997 | ||
2017/4/13 | 114 | 194.199997 | ||
2017/4/18 | 115 | 191.699997 | ||
2017/4/19 | 116 | 190.800003 | ||
2017/4/20 | 117 | 191.5 | ||
2017/4/21 | 118 | 190.800003 | ||
2017/4/24 | 119 | 190.800003 | ||
2017/4/25 | 120 | 192 | ||
2017/4/26 | 121 | 193.699997 | ||
2017/4/27 | 122 | 194.100006 | ||
2017/4/28 | 123 | 191.600006 | ||
2017/5/2 | 124 | 191.600006 | ||
2017/5/4 | 125 | 190.600006 | ||
2017/5/5 | 126 | 189.300003 | ||
2017/5/8 | 127 | 189.600006 | ||
2017/5/9 | 128 | 194.399994 | ||
2017/5/10 | 129 | 194.199997 | ||
2017/5/11 | 130 | 195.699997 | ||
2017/5/12 | 131 | 195.5 | ||
2017/5/15 | 132 | 197.100006 | ||
2017/5/16 | 133 | 196.699997 | ||
2017/5/17 | 134 | 197.699997 | ||
2017/5/18 | 135 | 195.300003 | ||
2017/5/19 | 136 | 195.699997 | ||
2017/5/22 | 137 | 196.399994 | ||
2017/5/23 | 138 | 195.199997 | ||
2017/5/24 | 139 | 194.899994 | ||
2017/5/25 | 140 | 196.300003 | ||
2017/5/26 | 141 | 196 | ||
2017/5/29 | 142 | 197.199997 | ||
2017/5/31 | 143 | 196.699997 | ||
2017/6/1 | 144 | 196.800003 | ||
2017/6/2 | 145 | 205 | ||
2017/6/5 | 146 | 203.800003 | ||
2017/6/6 | 147 | 205 | ||
2017/6/7 | 148 | 204.199997 | ||
2017/6/8 | 149 | 205.600006 | ||
2017/6/9 | 150 | 205.399994 | ||
2017/6/12 | 151 | 199.699997 | ||
2017/6/13 | 152 | 201 | ||
2017/6/14 | 153 | 200.600006 |
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