1. Introduction This analysis evaluates weekly adjusted closing stock prices for Apple Inc. (AAPL) and Microsoft Corp. (MSFT) over a five-year historical period across 263 complete, non-null observations. To analyze the underlying trend structure, two distinct window function techniques were applied in dplyr: a rolling window using a 6-period moving average to smooth short-term price volatility and localized fluctuations, and an expanding window partitioned by calendar year to compute cumulative Year-To-Date (YTD) running averages. While the 6-period moving average closely tracks recent price momentum with a minimal time lag, the YTD running average resets annually each January and progressively stabilizes as trading data accumulates throughout the year, establishing a reliable performance benchmark for long-term equity trends.
2. Conceptual Breakdown of the Window Functions Dataset structure
6-Period Moving Average (Rolling Window):
Window Framing: ROWS BETWEEN 5 PRECEDING AND CURRENT ROW.
Purpose: Acts as a short-term trend filter by averaging the current row and the 5 preceding observations. It smooths out weekly price spikes and localized volatility without losing momentum trajectory.
Edge Case Handling: The first 5 periods do not have enough historical data. In dplyr, using pure lag math or zoo::rollmean fills these initial slots with NA (or partial averages if using slider::slide_dbl).
Year-To-Date (YTD) Average (Expanding Window):
Window Framing: PARTITION BY Symbol, Year ORDER BY Date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW.
Purpose: Tracks cumulative yearly performance. It restarts at index \(1\) on the first trading date of each calendar year (e.g., Jan 1st) and expands row-by-row until Dec 31st.
Implementation: Handled via dplyr::cummean() after grouping by both stock symbol and calendar year.
3. Complete R Structure
Attaching package: 'dplyr'
The following objects are masked from 'package:stats':
filter, lag
The following objects are masked from 'package:base':
intersect, setdiff, setequal, union
library (readxl)library (lubridate)
Attaching package: 'lubridate'
The following objects are masked from 'package:base':
date, intersect, setdiff, union
<- "https://github.com/Muhammad-Imran91/607/raw/main/Data_shares.xlsx" <- tempfile (fileext = ".xlsx" )download.file (github_url, destfile = temp_file, mode = "wb" )<- read_excel (temp_file, sheet = "AAPL Shares" ) %>% mutate (Symbol = "AAPL" )<- read_excel (temp_file, sheet = "MSFT shares" ) %>% mutate (Symbol = "MSFT" )# Combine & calculate calculations <- bind_rows (aapl_df, msft_df) %>% rename (Price = ` Adjusted closing price ` ) %>% mutate (Date = as.Date (Date),Year = as.numeric (format (Date, "%Y" ))%>% arrange (Symbol, Date) %>% group_by (Symbol) %>% mutate (Six_Period_MA = (Price + lag (Price,1 ) + lag (Price,2 ) + lag (Price,3 ) + lag (Price,4 ) + lag (Price,5 )) / 6 %>% group_by (Symbol, Year) %>% mutate (YTD_Average = cummean (Price)%>% ungroup () %>% select (Symbol, Date, Price, Year, YTD_Average, Six_Period_MA)# View complete dataframe print (df_full_table, n = Inf )
# A tibble: 526 × 6
Symbol Date Price Year YTD_Average Six_Period_MA
<chr> <date> <dbl> <dbl> <dbl> <dbl>
1 AAPL 2019-05-20 43.2 2019 43.2 NA
2 AAPL 2019-05-27 42.2 2019 42.7 NA
3 AAPL 2019-06-03 45.9 2019 43.8 NA
4 AAPL 2019-06-10 46.5 2019 44.5 NA
5 AAPL 2019-06-17 48.0 2019 45.2 NA
6 AAPL 2019-06-24 47.8 2019 45.6 45.6
7 AAPL 2019-07-01 49.3 2019 46.1 46.6
8 AAPL 2019-07-08 49.1 2019 46.5 47.7
9 AAPL 2019-07-15 48.9 2019 46.7 48.2
10 AAPL 2019-07-22 50.1 2019 47.1 48.8
11 AAPL 2019-07-29 49.2 2019 47.3 49.1
12 AAPL 2019-08-05 48.5 2019 47.4 49.2
13 AAPL 2019-08-12 50.0 2019 47.6 49.3
14 AAPL 2019-08-19 49.1 2019 47.7 49.3
15 AAPL 2019-08-26 50.6 2019 47.9 49.6
16 AAPL 2019-09-02 51.6 2019 48.1 49.8
17 AAPL 2019-09-09 53.0 2019 48.4 50.5
18 AAPL 2019-09-16 52.7 2019 48.6 51.2
19 AAPL 2019-09-23 53.0 2019 48.9 51.7
20 AAPL 2019-09-30 55.0 2019 49.2 52.6
21 AAPL 2019-10-07 57.2 2019 49.6 53.8
22 AAPL 2019-10-14 57.3 2019 49.9 54.7
23 AAPL 2019-10-21 59.7 2019 50.3 55.8
24 AAPL 2019-10-28 62.0 2019 50.8 57.4
25 AAPL 2019-11-04 63.0 2019 51.3 59.0
26 AAPL 2019-11-11 64.6 2019 51.8 60.6
27 AAPL 2019-11-18 63.6 2019 52.3 61.7
28 AAPL 2019-11-25 64.9 2019 52.7 63.0
29 AAPL 2019-12-02 65.8 2019 53.2 64.0
30 AAPL 2019-12-09 66.8 2019 53.6 64.8
31 AAPL 2019-12-16 67.9 2019 54.1 65.6
32 AAPL 2019-12-23 70.4 2019 54.6 66.6
33 AAPL 2019-12-30 72.3 2019 55.1 68.0
34 AAPL 2020-01-06 75.4 2020 75.4 69.8
35 AAPL 2020-01-13 77.4 2020 76.4 71.7
36 AAPL 2020-01-20 77.3 2020 76.7 73.4
37 AAPL 2020-01-27 75.2 2020 76.3 74.7
38 AAPL 2020-02-03 77.7 2020 76.6 75.9
39 AAPL 2020-02-10 79.1 2020 77.0 77.0
40 AAPL 2020-02-17 76.2 2020 76.9 77.2
41 AAPL 2020-02-24 66.6 2020 75.6 75.4
42 AAPL 2020-03-02 70.4 2020 75.0 74.2
43 AAPL 2020-03-09 67.7 2020 74.3 73.0
44 AAPL 2020-03-16 55.8 2020 72.6 69.3
45 AAPL 2020-03-23 60.3 2020 71.6 66.2
46 AAPL 2020-03-30 58.8 2020 70.6 63.3
47 AAPL 2020-04-06 65.3 2020 70.2 63.0
48 AAPL 2020-04-13 68.9 2020 70.1 62.8
49 AAPL 2020-04-20 68.9 2020 70.1 63.0
50 AAPL 2020-04-27 70.4 2020 70.1 65.4
51 AAPL 2020-05-04 75.5 2020 70.4 68.0
52 AAPL 2020-05-11 75.1 2020 70.6 70.7
53 AAPL 2020-05-18 77.9 2020 71.0 72.8
54 AAPL 2020-05-25 77.6 2020 71.3 74.2
55 AAPL 2020-06-01 80.9 2020 71.7 76.2
56 AAPL 2020-06-08 82.7 2020 72.2 78.3
57 AAPL 2020-06-15 85.4 2020 72.8 79.9
58 AAPL 2020-06-22 86.3 2020 73.3 81.8
59 AAPL 2020-06-29 88.9 2020 73.9 83.7
60 AAPL 2020-07-06 93.7 2020 74.6 86.3
61 AAPL 2020-07-13 94.1 2020 75.3 88.5
62 AAPL 2020-07-20 90.4 2020 75.9 89.8
63 AAPL 2020-07-27 104. 2020 76.8 92.9
64 AAPL 2020-08-03 109. 2020 77.8 96.6
65 AAPL 2020-08-10 112. 2020 78.9 100.
66 AAPL 2020-08-17 122. 2020 80.2 105.
67 AAPL 2020-08-24 122. 2020 81.4 110.
68 AAPL 2020-08-31 118. 2020 82.5 114.
69 AAPL 2020-09-07 110. 2020 83.2 115.
70 AAPL 2020-09-14 105. 2020 83.8 115.
71 AAPL 2020-09-21 110. 2020 84.5 114.
72 AAPL 2020-09-28 111. 2020 85.2 112.
73 AAPL 2020-10-05 114. 2020 85.9 111.
74 AAPL 2020-10-12 116. 2020 86.6 111.
75 AAPL 2020-10-19 113. 2020 87.3 111.
76 AAPL 2020-10-26 107. 2020 87.7 112.
77 AAPL 2020-11-02 116. 2020 88.4 113.
78 AAPL 2020-11-09 117. 2020 89.0 114.
79 AAPL 2020-11-16 115. 2020 89.6 114.
80 AAPL 2020-11-23 114. 2020 90.1 114.
81 AAPL 2020-11-30 120. 2020 90.7 115.
82 AAPL 2020-12-07 120. 2020 91.3 117.
83 AAPL 2020-12-14 124. 2020 91.9 118.
84 AAPL 2020-12-21 129. 2020 92.7 120.
85 AAPL 2020-12-28 130. 2020 93.4 123.
86 AAPL 2021-01-04 129. 2021 129. 125.
87 AAPL 2021-01-11 125. 2021 127. 126.
88 AAPL 2021-01-18 136. 2021 130. 129.
89 AAPL 2021-01-25 129. 2021 130. 130.
90 AAPL 2021-02-01 134. 2021 131. 131.
91 AAPL 2021-02-08 133. 2021 131. 131.
92 AAPL 2021-02-15 127. 2021 131. 131.
93 AAPL 2021-02-22 119. 2021 129. 130.
94 AAPL 2021-03-01 119. 2021 128. 127.
95 AAPL 2021-03-08 119. 2021 127. 125.
96 AAPL 2021-03-15 118. 2021 126. 123.
97 AAPL 2021-03-22 119. 2021 126. 120.
98 AAPL 2021-03-29 121. 2021 125. 119.
99 AAPL 2021-04-05 131. 2021 126. 121.
100 AAPL 2021-04-12 132. 2021 126. 123.
101 AAPL 2021-04-19 132. 2021 126. 125.
102 AAPL 2021-04-26 129. 2021 127. 127.
103 AAPL 2021-05-03 128. 2021 127. 129.
104 AAPL 2021-05-10 125. 2021 127. 129.
105 AAPL 2021-05-17 123. 2021 126. 128.
106 AAPL 2021-05-24 123. 2021 126. 127.
107 AAPL 2021-05-31 124. 2021 126. 125.
108 AAPL 2021-06-07 125. 2021 126. 125.
109 AAPL 2021-06-14 128. 2021 126. 125.
110 AAPL 2021-06-21 131. 2021 126. 126.
111 AAPL 2021-06-28 138. 2021 127. 128.
112 AAPL 2021-07-05 143. 2021 127. 131.
113 AAPL 2021-07-12 144. 2021 128. 135.
114 AAPL 2021-07-19 146. 2021 129. 138.
115 AAPL 2021-07-26 143. 2021 129. 141.
116 AAPL 2021-08-02 144. 2021 130. 143.
117 AAPL 2021-08-09 147. 2021 130. 144.
118 AAPL 2021-08-16 146. 2021 131. 145.
119 AAPL 2021-08-23 146. 2021 131. 145.
120 AAPL 2021-08-30 152. 2021 132. 146.
121 AAPL 2021-09-06 147. 2021 132. 147.
122 AAPL 2021-09-13 144. 2021 132. 147.
123 AAPL 2021-09-20 145. 2021 133. 147.
124 AAPL 2021-09-27 140. 2021 133. 146.
125 AAPL 2021-10-04 141. 2021 133. 145.
126 AAPL 2021-10-11 143. 2021 133. 143.
127 AAPL 2021-10-18 146. 2021 134. 143.
128 AAPL 2021-10-25 148. 2021 134. 144.
129 AAPL 2021-11-01 149. 2021 134. 144.
130 AAPL 2021-11-08 148. 2021 135. 146.
131 AAPL 2021-11-15 158. 2021 135. 149.
132 AAPL 2021-11-22 155. 2021 136. 151.
133 AAPL 2021-11-29 160. 2021 136. 153.
134 AAPL 2021-12-06 177. 2021 137. 158.
135 AAPL 2021-12-13 169. 2021 138. 161.
136 AAPL 2021-12-20 174. 2021 138. 165.
137 AAPL 2021-12-27 175. 2021 139. 168.
138 AAPL 2022-01-03 170. 2022 170. 171.
139 AAPL 2022-01-10 171. 2022 170. 173.
140 AAPL 2022-01-17 160. 2022 167. 170.
141 AAPL 2022-01-24 168. 2022 167. 170.
142 AAPL 2022-01-31 170. 2022 168. 169.
143 AAPL 2022-02-07 167. 2022 168. 168.
144 AAPL 2022-02-14 165. 2022 167. 167.
145 AAPL 2022-02-21 163. 2022 167. 165.
146 AAPL 2022-02-28 161. 2022 166. 166.
147 AAPL 2022-03-07 153. 2022 165. 163.
148 AAPL 2022-03-14 162. 2022 164. 162.
149 AAPL 2022-03-21 173. 2022 165. 163.
150 AAPL 2022-03-28 172. 2022 166. 164.
151 AAPL 2022-04-04 168. 2022 166. 165.
152 AAPL 2022-04-11 163. 2022 166. 165.
153 AAPL 2022-04-18 160. 2022 165. 166.
154 AAPL 2022-04-25 156. 2022 165. 165.
155 AAPL 2022-05-02 155. 2022 164. 162.
156 AAPL 2022-05-09 145. 2022 163. 158.
157 AAPL 2022-05-16 136. 2022 162. 153.
158 AAPL 2022-05-23 148. 2022 161. 150.
159 AAPL 2022-05-30 144. 2022 160. 147.
160 AAPL 2022-06-06 136. 2022 159. 144.
161 AAPL 2022-06-13 130. 2022 158. 140.
162 AAPL 2022-06-20 140. 2022 157. 139.
163 AAPL 2022-06-27 137. 2022 157. 139.
164 AAPL 2022-07-04 145. 2022 156. 139.
165 AAPL 2022-07-11 148. 2022 156. 140.
166 AAPL 2022-07-18 152. 2022 156. 142.
167 AAPL 2022-07-25 161. 2022 156. 147.
168 AAPL 2022-08-01 164. 2022 156. 151.
169 AAPL 2022-08-08 170. 2022 157. 157.
170 AAPL 2022-08-15 170. 2022 157. 161.
171 AAPL 2022-08-22 162. 2022 157. 163.
172 AAPL 2022-08-29 154. 2022 157. 163.
173 AAPL 2022-09-05 156. 2022 157. 163.
174 AAPL 2022-09-12 149. 2022 157. 160.
175 AAPL 2022-09-19 149. 2022 157. 157.
176 AAPL 2022-09-26 137. 2022 156. 151.
177 AAPL 2022-10-03 139. 2022 156. 147.
178 AAPL 2022-10-10 137. 2022 155. 144.
179 AAPL 2022-10-17 146. 2022 155. 143.
180 AAPL 2022-10-24 154. 2022 155. 144.
181 AAPL 2022-10-31 137. 2022 155. 142.
182 AAPL 2022-11-07 148. 2022 154. 144.
183 AAPL 2022-11-14 150. 2022 154. 145.
184 AAPL 2022-11-21 147. 2022 154. 147.
185 AAPL 2022-11-28 147. 2022 154. 147.
186 AAPL 2022-12-05 141. 2022 154. 145.
187 AAPL 2022-12-12 133. 2022 153. 144.
188 AAPL 2022-12-19 131. 2022 153. 141.
189 AAPL 2022-12-26 129. 2022 152. 138.
190 AAPL 2023-01-02 129. 2023 129. 135.
191 AAPL 2023-01-09 134. 2023 131. 133.
192 AAPL 2023-01-16 137. 2023 133. 132.
193 AAPL 2023-01-23 145. 2023 136. 134.
194 AAPL 2023-01-30 153. 2023 139. 138.
195 AAPL 2023-02-06 150. 2023 141. 141.
196 AAPL 2023-02-13 152. 2023 143. 145.
197 AAPL 2023-02-20 146. 2023 143. 147.
198 AAPL 2023-02-27 150. 2023 144. 149.
199 AAPL 2023-03-06 148. 2023 144. 150.
200 AAPL 2023-03-13 154. 2023 145. 150.
201 AAPL 2023-03-20 159. 2023 146. 151.
202 AAPL 2023-03-27 164. 2023 148. 153.
203 AAPL 2023-04-03 164. 2023 149. 156.
204 AAPL 2023-04-10 164. 2023 150. 159.
205 AAPL 2023-04-17 164. 2023 151. 161.
206 AAPL 2023-04-24 169. 2023 152. 164.
207 AAPL 2023-05-01 172. 2023 153. 166.
208 AAPL 2023-05-08 171. 2023 154. 167.
209 AAPL 2023-05-15 174. 2023 155. 169.
210 AAPL 2023-05-22 175. 2023 156. 171.
211 AAPL 2023-05-29 180. 2023 157. 174.
212 AAPL 2023-06-05 180. 2023 158. 175.
213 AAPL 2023-06-12 184. 2023 159. 177.
214 AAPL 2023-06-19 186. 2023 160. 180.
215 AAPL 2023-06-26 193. 2023 161. 183.
216 AAPL 2023-07-03 190. 2023 162. 185.
217 AAPL 2023-07-10 190. 2023 163. 187.
218 AAPL 2023-07-17 191. 2023 164. 189.
219 AAPL 2023-07-24 195. 2023 165. 191.
220 AAPL 2023-07-31 181. 2023 166. 190.
221 AAPL 2023-08-07 177. 2023 166. 187.
222 AAPL 2023-08-14 174. 2023 166. 185.
223 AAPL 2023-08-21 178. 2023 167. 183.
224 AAPL 2023-08-28 189. 2023 167. 182.
225 AAPL 2023-09-04 177. 2023 168. 179.
226 AAPL 2023-09-11 174. 2023 168. 178.
227 AAPL 2023-09-18 174. 2023 168. 178.
228 AAPL 2023-09-25 171. 2023 168. 177.
229 AAPL 2023-10-02 177. 2023 168. 177.
230 AAPL 2023-10-09 178. 2023 169. 175.
231 AAPL 2023-10-16 172. 2023 169. 174.
232 AAPL 2023-10-23 168. 2023 169. 173.
233 AAPL 2023-10-30 176. 2023 169. 174.
234 AAPL 2023-11-06 186. 2023 169. 176.
235 AAPL 2023-11-13 189. 2023 170. 178.
236 AAPL 2023-11-20 189. 2023 170. 180.
237 AAPL 2023-11-27 191. 2023 170. 183.
238 AAPL 2023-12-04 195. 2023 171. 188.
239 AAPL 2023-12-11 197. 2023 171. 191.
240 AAPL 2023-12-18 193. 2023 172. 192.
241 AAPL 2023-12-25 192. 2023 172. 193.
242 AAPL 2024-01-01 181. 2024 181. 191.
243 AAPL 2024-01-08 185. 2024 183. 191.
244 AAPL 2024-01-15 191. 2024 186. 190.
245 AAPL 2024-01-22 192. 2024 187. 189.
246 AAPL 2024-01-29 185. 2024 187. 188.
247 AAPL 2024-02-05 188. 2024 187. 187.
248 AAPL 2024-02-12 182. 2024 186. 187.
249 AAPL 2024-02-19 182. 2024 186. 187.
250 AAPL 2024-02-26 179. 2024 185. 185.
251 AAPL 2024-03-04 170. 2024 184. 181.
252 AAPL 2024-03-11 172. 2024 183. 179.
253 AAPL 2024-03-18 172. 2024 182. 176.
254 AAPL 2024-03-25 171. 2024 181. 175.
255 AAPL 2024-04-01 169. 2024 180. 172.
256 AAPL 2024-04-08 176. 2024 180. 172.
257 AAPL 2024-04-15 165. 2024 179. 171.
258 AAPL 2024-04-22 169. 2024 178. 170.
259 AAPL 2024-04-29 183. 2024 179. 172.
260 AAPL 2024-05-06 183. 2024 179. 174.
261 AAPL 2024-05-13 190. 2024 179. 178.
262 AAPL 2024-05-20 187. 2024 180. 179.
263 AAPL 2024-05-23 187. 2024 180. 183.
264 MSFT 2019-05-13 122. 2019 122. NA
265 MSFT 2019-05-20 120. 2019 121. NA
266 MSFT 2019-05-27 118. 2019 120. NA
267 MSFT 2019-06-03 125. 2019 121. NA
268 MSFT 2019-06-10 126. 2019 122. NA
269 MSFT 2019-06-17 131. 2019 124. 124.
270 MSFT 2019-06-24 128. 2019 124. 125.
271 MSFT 2019-07-01 131. 2019 125. 126.
272 MSFT 2019-07-08 132. 2019 126. 129.
273 MSFT 2019-07-15 130. 2019 126. 130.
274 MSFT 2019-07-22 135. 2019 127. 131.
275 MSFT 2019-07-29 131. 2019 127. 131.
276 MSFT 2019-08-05 131. 2019 128. 132.
277 MSFT 2019-08-12 130. 2019 128. 132.
278 MSFT 2019-08-19 128. 2019 128. 131.
279 MSFT 2019-08-26 132. 2019 128. 131.
280 MSFT 2019-09-02 133. 2019 128. 131.
281 MSFT 2019-09-09 131. 2019 129. 131.
282 MSFT 2019-09-16 133. 2019 129. 131.
283 MSFT 2019-09-23 132. 2019 129. 132.
284 MSFT 2019-09-30 132. 2019 129. 132.
285 MSFT 2019-10-07 134. 2019 129. 133.
286 MSFT 2019-10-14 131. 2019 129. 132.
287 MSFT 2019-10-21 135. 2019 130. 133.
288 MSFT 2019-10-28 138. 2019 130. 134.
289 MSFT 2019-11-04 140. 2019 130. 135.
290 MSFT 2019-11-11 144. 2019 131. 137.
291 MSFT 2019-11-18 143. 2019 131. 138.
292 MSFT 2019-11-25 145. 2019 132. 141.
293 MSFT 2019-12-02 146. 2019 132. 142.
294 MSFT 2019-12-09 148. 2019 133. 144.
295 MSFT 2019-12-16 151. 2019 133. 146.
296 MSFT 2019-12-23 153. 2019 134. 148.
297 MSFT 2019-12-30 152. 2019 134. 149.
298 MSFT 2020-01-06 155. 2020 155. 151.
299 MSFT 2020-01-13 160. 2020 158. 153.
300 MSFT 2020-01-20 158. 2020 158. 155.
301 MSFT 2020-01-27 163. 2020 159. 157.
302 MSFT 2020-02-03 177. 2020 163. 161.
303 MSFT 2020-02-10 178. 2020 165. 165.
304 MSFT 2020-02-17 171. 2020 166. 168.
305 MSFT 2020-02-24 156. 2020 165. 167.
306 MSFT 2020-03-02 156. 2020 164. 167.
307 MSFT 2020-03-09 153. 2020 163. 165.
308 MSFT 2020-03-16 132. 2020 160. 158.
309 MSFT 2020-03-23 144. 2020 159. 152.
310 MSFT 2020-03-30 148. 2020 158. 148.
311 MSFT 2020-04-06 159. 2020 158. 149.
312 MSFT 2020-04-13 172. 2020 159. 151.
313 MSFT 2020-04-20 168. 2020 159. 154.
314 MSFT 2020-04-27 168. 2020 160. 160.
315 MSFT 2020-05-04 178. 2020 161. 165.
316 MSFT 2020-05-11 176. 2020 162. 170.
317 MSFT 2020-05-18 177. 2020 162. 173.
318 MSFT 2020-05-25 177. 2020 163. 174.
319 MSFT 2020-06-01 181. 2020 164. 176.
320 MSFT 2020-06-08 181. 2020 165. 178.
321 MSFT 2020-06-15 188. 2020 166. 180.
322 MSFT 2020-06-22 190. 2020 167. 182.
323 MSFT 2020-06-29 199. 2020 168. 186.
324 MSFT 2020-07-06 206. 2020 169. 191.
325 MSFT 2020-07-13 196. 2020 170. 193.
326 MSFT 2020-07-20 194. 2020 171. 196.
327 MSFT 2020-07-27 198. 2020 172. 197.
328 MSFT 2020-08-03 205. 2020 173. 200.
329 MSFT 2020-08-10 202. 2020 174. 200.
330 MSFT 2020-08-17 206. 2020 175. 200.
331 MSFT 2020-08-24 222. 2020 176. 204.
332 MSFT 2020-08-31 207. 2020 177. 207.
333 MSFT 2020-09-07 197. 2020 178. 206.
334 MSFT 2020-09-14 194. 2020 178. 205.
335 MSFT 2020-09-21 201. 2020 179. 205.
336 MSFT 2020-09-28 200. 2020 179. 203.
337 MSFT 2020-10-05 209. 2020 180. 201.
338 MSFT 2020-10-12 213. 2020 181. 202.
339 MSFT 2020-10-19 209. 2020 182. 204.
340 MSFT 2020-10-26 196. 2020 182. 205.
341 MSFT 2020-11-02 217. 2020 183. 207.
342 MSFT 2020-11-09 210. 2020 183. 209.
343 MSFT 2020-11-16 204. 2020 184. 208.
344 MSFT 2020-11-23 209. 2020 184. 207.
345 MSFT 2020-11-30 208. 2020 185. 207.
346 MSFT 2020-12-07 207. 2020 185. 209.
347 MSFT 2020-12-14 212. 2020 186. 208.
348 MSFT 2020-12-21 216. 2020 186. 209.
349 MSFT 2020-12-28 216. 2020 187. 211.
350 MSFT 2021-01-04 213. 2021 213. 212.
351 MSFT 2021-01-11 206. 2021 210. 212.
352 MSFT 2021-01-18 219. 2021 213. 214.
353 MSFT 2021-01-25 225. 2021 216. 216.
354 MSFT 2021-02-01 235. 2021 220. 219.
355 MSFT 2021-02-08 238. 2021 223. 223.
356 MSFT 2021-02-15 234. 2021 224. 226.
357 MSFT 2021-02-22 226. 2021 225. 229.
358 MSFT 2021-03-01 225. 2021 225. 230.
359 MSFT 2021-03-08 229. 2021 225. 231.
360 MSFT 2021-03-15 224. 2021 225. 229.
361 MSFT 2021-03-22 230. 2021 225. 228.
362 MSFT 2021-03-29 236. 2021 226. 228.
363 MSFT 2021-04-05 249. 2021 228. 232.
364 MSFT 2021-04-12 254. 2021 230. 237.
365 MSFT 2021-04-19 254. 2021 231. 241.
366 MSFT 2021-04-26 245. 2021 232. 245.
367 MSFT 2021-05-03 246. 2021 233. 247.
368 MSFT 2021-05-10 241. 2021 233. 248.
369 MSFT 2021-05-17 238. 2021 233. 246.
370 MSFT 2021-05-24 243. 2021 234. 245.
371 MSFT 2021-05-31 244. 2021 234. 243.
372 MSFT 2021-06-07 251. 2021 235. 244.
373 MSFT 2021-06-14 253. 2021 236. 245.
374 MSFT 2021-06-21 258. 2021 237. 248.
375 MSFT 2021-06-28 271. 2021 238. 254.
376 MSFT 2021-07-05 271. 2021 239. 258.
377 MSFT 2021-07-12 274. 2021 240. 263.
378 MSFT 2021-07-19 282. 2021 242. 268.
379 MSFT 2021-07-26 278. 2021 243. 272.
380 MSFT 2021-08-02 282. 2021 244. 276.
381 MSFT 2021-08-09 285. 2021 246. 279.
382 MSFT 2021-08-16 297. 2021 247. 283.
383 MSFT 2021-08-23 293. 2021 249. 286.
384 MSFT 2021-08-30 294. 2021 250. 288.
385 MSFT 2021-09-06 289. 2021 251. 290.
386 MSFT 2021-09-13 293. 2021 252. 292.
387 MSFT 2021-09-20 292. 2021 253. 293.
388 MSFT 2021-09-27 282. 2021 254. 291.
389 MSFT 2021-10-04 288. 2021 255. 290.
390 MSFT 2021-10-11 297. 2021 256. 290.
391 MSFT 2021-10-18 302. 2021 257. 292.
392 MSFT 2021-10-25 324. 2021 258. 298.
393 MSFT 2021-11-01 328. 2021 260. 304.
394 MSFT 2021-11-08 329. 2021 262. 311.
395 MSFT 2021-11-15 335. 2021 263. 319.
396 MSFT 2021-11-22 323. 2021 264. 323.
397 MSFT 2021-11-29 316. 2021 265. 326.
398 MSFT 2021-12-06 335. 2021 267. 328.
399 MSFT 2021-12-13 317. 2021 268. 326.
400 MSFT 2021-12-20 327. 2021 269. 326.
401 MSFT 2021-12-27 329. 2021 270. 325.
402 MSFT 2022-01-03 307. 2022 307. 322.
403 MSFT 2022-01-10 304. 2022 305. 320.
404 MSFT 2022-01-17 290. 2022 300. 312.
405 MSFT 2022-01-24 302. 2022 301. 310.
406 MSFT 2022-01-31 299. 2022 300. 305.
407 MSFT 2022-02-07 289. 2022 298. 298.
408 MSFT 2022-02-14 282. 2022 296. 294.
409 MSFT 2022-02-21 291. 2022 295. 292.
410 MSFT 2022-02-28 284. 2022 294. 291.
411 MSFT 2022-03-07 275. 2022 292. 287.
412 MSFT 2022-03-14 295. 2022 292. 286.
413 MSFT 2022-03-21 298. 2022 293. 287.
414 MSFT 2022-03-28 303. 2022 294. 291.
415 MSFT 2022-04-04 291. 2022 293. 291.
416 MSFT 2022-04-11 274. 2022 292. 289.
417 MSFT 2022-04-18 269. 2022 291. 288.
418 MSFT 2022-04-25 272. 2022 290. 285.
419 MSFT 2022-05-02 269. 2022 289. 280.
420 MSFT 2022-05-09 256. 2022 287. 272.
421 MSFT 2022-05-16 248. 2022 285. 265.
422 MSFT 2022-05-23 269. 2022 284. 264.
423 MSFT 2022-05-30 265. 2022 283. 263.
424 MSFT 2022-06-06 249. 2022 282. 259.
425 MSFT 2022-06-13 243. 2022 280. 255.
426 MSFT 2022-06-20 263. 2022 279. 256.
427 MSFT 2022-06-27 255. 2022 279. 257.
428 MSFT 2022-07-04 263. 2022 278. 256.
429 MSFT 2022-07-11 252. 2022 277. 254.
430 MSFT 2022-07-18 256. 2022 276. 255.
431 MSFT 2022-07-25 276. 2022 276. 261.
432 MSFT 2022-08-01 278. 2022 276. 263.
433 MSFT 2022-08-08 287. 2022 277. 269.
434 MSFT 2022-08-15 281. 2022 277. 272.
435 MSFT 2022-08-22 264. 2022 276. 274.
436 MSFT 2022-08-29 252. 2022 276. 273.
437 MSFT 2022-09-05 260. 2022 275. 270.
438 MSFT 2022-09-12 241. 2022 274. 264.
439 MSFT 2022-09-19 234. 2022 273. 256.
440 MSFT 2022-09-26 229. 2022 272. 247.
441 MSFT 2022-10-03 231. 2022 271. 241.
442 MSFT 2022-10-10 225. 2022 270. 237.
443 MSFT 2022-10-17 238. 2022 269. 233.
444 MSFT 2022-10-24 232. 2022 268. 232.
445 MSFT 2022-10-31 218. 2022 267. 229.
446 MSFT 2022-11-07 243. 2022 267. 231.
447 MSFT 2022-11-14 238. 2022 266. 232.
448 MSFT 2022-11-21 244. 2022 266. 236.
449 MSFT 2022-11-28 252. 2022 265. 238.
450 MSFT 2022-12-05 242. 2022 265. 240.
451 MSFT 2022-12-12 242. 2022 264. 244.
452 MSFT 2022-12-19 236. 2022 264. 242.
453 MSFT 2022-12-26 237. 2022 263. 242.
454 MSFT 2023-01-02 222. 2023 222. 238.
455 MSFT 2023-01-09 236. 2023 229. 236.
456 MSFT 2023-01-16 237. 2023 232. 235.
457 MSFT 2023-01-23 245. 2023 235. 236.
458 MSFT 2023-01-30 255. 2023 239. 239.
459 MSFT 2023-02-06 260. 2023 243. 243.
460 MSFT 2023-02-13 255. 2023 244. 248.
461 MSFT 2023-02-20 247. 2023 245. 250.
462 MSFT 2023-02-27 253. 2023 246. 252.
463 MSFT 2023-03-06 246. 2023 246. 253.
464 MSFT 2023-03-13 277. 2023 248. 256.
465 MSFT 2023-03-20 278. 2023 251. 259.
466 MSFT 2023-03-27 285. 2023 254. 264.
467 MSFT 2023-04-03 289. 2023 256. 271.
468 MSFT 2023-04-10 283. 2023 258. 276.
469 MSFT 2023-04-17 283. 2023 259. 282.
470 MSFT 2023-04-24 304. 2023 262. 287.
471 MSFT 2023-05-01 308. 2023 265. 292.
472 MSFT 2023-05-08 306. 2023 267. 295.
473 MSFT 2023-05-15 315. 2023 269. 300.
474 MSFT 2023-05-22 330. 2023 272. 308.
475 MSFT 2023-05-29 333. 2023 275. 316.
476 MSFT 2023-06-05 324. 2023 277. 319.
477 MSFT 2023-06-12 340. 2023 280. 325.
478 MSFT 2023-06-19 332. 2023 282. 329.
479 MSFT 2023-06-26 338. 2023 284. 333.
480 MSFT 2023-07-03 335. 2023 286. 334.
481 MSFT 2023-07-10 343. 2023 288. 335.
482 MSFT 2023-07-17 341. 2023 290. 338.
483 MSFT 2023-07-24 336. 2023 291. 337.
484 MSFT 2023-07-31 325. 2023 292. 336.
485 MSFT 2023-08-07 319. 2023 293. 333.
486 MSFT 2023-08-14 314. 2023 294. 330.
487 MSFT 2023-08-21 321. 2023 295. 326.
488 MSFT 2023-08-28 327. 2023 295. 324.
489 MSFT 2023-09-04 332. 2023 296. 323.
490 MSFT 2023-09-11 328. 2023 297. 324.
491 MSFT 2023-09-18 315. 2023 298. 323.
492 MSFT 2023-09-25 314. 2023 298. 323.
493 MSFT 2023-10-02 325. 2023 299. 324.
494 MSFT 2023-10-09 326. 2023 300. 324.
495 MSFT 2023-10-16 325. 2023 300. 322.
496 MSFT 2023-10-23 328. 2023 301. 322.
497 MSFT 2023-10-30 351. 2023 302. 328.
498 MSFT 2023-11-06 368. 2023 303. 337.
499 MSFT 2023-11-13 368. 2023 305. 344.
500 MSFT 2023-11-20 376. 2023 306. 352.
501 MSFT 2023-11-27 373. 2023 308. 361.
502 MSFT 2023-12-04 373. 2023 309. 368.
503 MSFT 2023-12-11 369. 2023 310. 371.
504 MSFT 2023-12-18 373. 2023 311. 372.
505 MSFT 2023-12-25 375. 2023 313. 373.
506 MSFT 2024-01-01 366. 2024 366. 372.
507 MSFT 2024-01-08 387. 2024 377. 374.
508 MSFT 2024-01-15 397. 2024 384. 378.
509 MSFT 2024-01-22 402. 2024 388. 384.
510 MSFT 2024-01-29 410. 2024 393. 390.
511 MSFT 2024-02-05 419. 2024 397. 397.
512 MSFT 2024-02-12 403. 2024 398. 403.
513 MSFT 2024-02-19 410. 2024 399. 407.
514 MSFT 2024-02-26 415. 2024 401. 410.
515 MSFT 2024-03-04 405. 2024 401. 410.
516 MSFT 2024-03-11 416. 2024 403. 411.
517 MSFT 2024-03-18 428. 2024 405. 413.
518 MSFT 2024-03-25 420. 2024 406. 416.
519 MSFT 2024-04-01 425. 2024 407. 418.
520 MSFT 2024-04-08 421. 2024 408. 419.
521 MSFT 2024-04-15 398. 2024 408. 418.
522 MSFT 2024-04-22 406. 2024 408. 416.
523 MSFT 2024-04-29 406. 2024 407. 413.
524 MSFT 2024-05-06 414. 2024 408. 412.
525 MSFT 2024-05-13 419. 2024 408. 411.
526 MSFT 2024-05-20 429. 2024 409. 412.