Answered step by step
Verified Expert Solution
Link Copied!

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

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Students also viewed these Finance questions