MSFT y Gráficos Rentabilidades Con AAPL

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 12

MSFT

Date Close Rentabilidades Rentabilidades


1 5/9/2023 307 MSFT AAPL
2 5/10/2023 312.309998 1.715% 1.037%
3 5/11/2023 310.109985 -0.707% 0.109%
4 5/12/2023 308.970001 -0.368% -0.681%
5 5/15/2023 309.459991 0.158% -0.290%
6 5/16/2023 311.73999 0.734% 0.000%
7 5/17/2023 314 0.722% 0.360%
8 5/18/2023 318.519989 1.429% 1.357%
9 5/19/2023 318.339996 -0.057% 0.063%
10 5/22/2023 321.179993 0.888% -0.550%
11 5/23/2023 315.26001 -1.860% -1.527%
12 5/24/2023 313.850006 -0.448% 0.163%
13 5/25/2023 325.920013 3.774% 0.667%
14 5/26/2023 332.890015 2.116% 1.401%
15 5/30/2023 331.209991 -0.506% 1.060%
16 5/31/2023 328.390015 -0.855% -0.028%
17 6/1/2023 332.579987 1.268% 1.590%
18 6/2/2023 335.399994 0.844% 0.476%
19 6/5/2023 335.940002 0.161% -0.760%
20 6/6/2023 333.679993 -0.675% -0.206%
21 6/7/2023 323.380005 -3.135% -0.779%
22 6/8/2023 325.26001 0.580% 1.535%
23 6/9/2023 326.790009 0.469% 0.216%
24 6/12/2023 331.850006 1.537% 1.552%
25 6/13/2023 334.290009 0.733% -0.262%
26 6/14/2023 337.339996 0.908% 0.349%
27 6/15/2023 348.100006 3.140% 1.114%
28 6/16/2023 342.329987 -1.671% -0.588%
29 6/20/2023 338.049988 -1.258% 0.049%
30 6/21/2023 333.559998 -1.337% -0.569%
31 6/22/2023 339.709991 1.827% 1.639%
32 6/23/2023 335.019989 -1.390% -0.171%
33 6/26/2023 328.600006 -1.935% -0.758%
34 6/27/2023 334.570007 1.800% 1.495%
35 6/28/2023 335.850006 0.382% 0.631%
36 6/29/2023 335.049988 -0.238% 0.179%
37 6/30/2023 340.540009 1.625% 2.284%
38 7/3/2023 337.98999 -0.752% -0.782%
39 7/5/2023 338.149994 0.047% -0.589%
40 7/6/2023 341.269989 0.918% 0.251%
41 7/7/2023 337.220001 -1.194% -0.591%
42 7/10/2023 331.829987 -1.611% -1.092%
43 7/11/2023 332.470001 0.193% -0.281%
44 7/12/2023 337.200012 1.413% 0.895%
45 7/13/2023 342.660004 1.606% 0.405%
46 7/14/2023 345.23999 0.750% 0.079%
47 7/17/2023 345.730011 0.142% 1.716%
48 7/18/2023 359.48999 3.903% -0.134%
49 7/19/2023 355.079987 -1.234% 0.705%
50 7/20/2023 346.869995 -2.339% -1.015%
51 7/21/2023 343.769989 -0.898% -0.618%
52 7/24/2023 345.109985 0.389% 0.421%
53 7/25/2023 350.980011 1.687% 0.450%
54 7/26/2023 337.769989 -3.836% 0.453%
55 7/27/2023 330.720001 -2.109% -0.660%
56 7/28/2023 338.369995 2.287% 1.342%
57 7/31/2023 335.920013 -0.727% 0.316%
58 8/1/2023 336.339996 0.125% -0.429%
59 8/2/2023 327.5 -2.663% -1.561%
60 8/3/2023 326.660004 -0.257% -0.735%
61 8/4/2023 327.779999 0.342% -4.921%
62 8/7/2023 330.109985 0.708% -1.740%
63 8/8/2023 326.049988 -1.238% 0.530%
64 8/9/2023 322.230011 -1.179% -0.899%
65 8/10/2023 322.929993 0.217% -0.124%
66 8/11/2023 321.01001 -0.596% -0.101%
67 8/14/2023 324.040009 0.939% 0.935%
68 8/15/2023 321.859985 -0.675% -1.126%
69 8/16/2023 320.399994 -0.455% -0.497%
70 8/17/2023 316.880005 -1.105% -1.466%
71 8/18/2023 316.480011 -0.126% 0.281%
72 8/21/2023 321.880005 1.692% 0.771%
73 8/22/2023 322.459991 0.180% 0.787%
74 8/23/2023 327 1.398% 2.171%
75 8/24/2023 319.970001 -2.173% -2.652%
76 8/25/2023 322.980011 0.936% 1.256%
77 8/28/2023 323.700012 0.223% 0.881%
78 8/29/2023 328.410004 1.445% 2.158%
79 8/30/2023 328.790009 0.116% 1.899%
80 8/31/2023 327.76001 -0.314% 0.117%
81 9/1/2023 328.660004 0.274% 0.843%
82 9/5/2023 333.549988 1.477% 0.127%
83 9/6/2023 332.880005 -0.201% -3.645%
84 9/7/2023 329.910004 -0.896% -2.969%
85 9/8/2023 334.269989 1.313% 0.349%
86 9/11/2023 337.940002 1.092% 0.660%
87 9/12/2023 331.769989 -1.843% -1.721%
88 9/13/2023 336.059998 1.285% -1.193%
89 9/14/2023 338.700012 0.783% 0.874%
90 9/15/2023 330.220001 -2.536% -0.416%
91 9/18/2023 329.059998 -0.352% 1.677%
92 9/19/2023 328.649994 -0.125% 0.616%
93 9/20/2023 320.769989 -2.427% -2.019%
94 9/21/2023 319.529999 -0.387% -0.893%
95 9/22/2023 317.01001 -0.792% 0.493%
96 9/25/2023 317.540009 0.167% 0.735%
97 9/26/2023 312.140015 -1.715% -2.368%
98 9/27/2023 312.790009 0.208% -0.894%
99 9/28/2023 313.640015 0.271% 0.152%
100 9/29/2023 315.75 0.670% 0.304%
101 10/2/2023 321.799988 1.898% 1.473%
102 10/3/2023 313.390015 -2.648% -0.780%
103 10/4/2023 318.959991 1.762% 0.728%
104 10/5/2023 319.359985 0.125% 0.717%
105 10/6/2023 327.26001 2.444% 1.464%
106 10/9/2023 329.820007 0.779% 0.842%
107 10/10/2023 328.390015 -0.435% -0.336%
108 10/11/2023 332.420013 1.220% 0.787%
109 10/12/2023 331.160004 -0.380% 0.505%
110 10/13/2023 327.730011 -1.041% -1.035%
111 10/16/2023 332.640015 1.487% -0.073%
112 10/17/2023 332.059998 -0.175% -0.882%
113 10/18/2023 330.109985 -0.589% -0.742%
114 10/19/2023 331.320007 0.366% -0.216%
115 10/20/2023 326.670013 -1.413% -1.481%
116 10/23/2023 329.320007 0.808% 0.069%
117 10/24/2023 330.529999 0.367% 0.254%
118 10/25/2023 340.670013 3.022% -1.358%
119 10/26/2023 327.890015 -3.824% -2.491%
120 10/27/2023 329.809998 0.584% 0.794%
121 10/30/2023 337.309998 2.249% 1.223%
122 10/31/2023 338.109985 0.237% 0.281%
123 11/1/2023 346.070007 2.327% 1.857%
124 11/2/2023 348.320007 0.648% 2.048%
125 11/3/2023 352.799988 1.278% -0.519%
126 11/6/2023 356.529999 1.052% 1.450%
127 11/7/2023 360.529999 1.116% 1.435%
128 11/8/2023 363.200012 0.738% 0.587%
129 11/9/2023 360.690002 -0.693% -0.263%
130 11/10/2023 369.670013 2.459% 2.164%
131 11/13/2023 366.679993 -0.812% -0.862%
132 11/14/2023 370.269989 0.974% 1.418%
133 11/15/2023 369.670013 -0.162% 0.304%
134 11/16/2023 376.170013 1.743% 0.900%
135 11/17/2023 369.850006 -1.694% -0.011%
136 11/20/2023 377.440002 2.031% 0.924%
137 11/21/2023 373.070007 -1.165% -0.424%
138 11/22/2023 377.850006 1.273% 0.351%
139 11/24/2023 377.429993 -0.111% -0.703%
140 11/27/2023 378.609985 0.312% -0.095%
141 11/28/2023 382.700012 1.074% 0.321%
142 11/29/2023 378.850006 -1.011% -0.542%
143 11/30/2023 378.910004 0.016% 0.306%
144 12/1/2023 374.51001 -1.168% 0.677%
145 12/4/2023 369.140015 -1.444% -0.951%
146 12/5/2023 372.519989 0.911% 2.084%
147 12/6/2023 368.799988 -1.004% -0.570%
148 12/7/2023 370.950012 0.581% 1.009%
149 12/8/2023 374.230011 0.880% 0.739%
150 12/11/2023 371.299988 -0.786% -1.301%
151 12/12/2023 374.380005 0.826% 0.789%
152 12/13/2023 374.369995 -0.003% 1.655%
153 12/14/2023 365.929993 -2.280% 0.076%
154 12/15/2023 370.730011 1.303% -0.273%
155 12/18/2023 372.649994 0.517% -0.854%
156 12/19/2023 373.26001 0.164% 0.535%
157 12/20/2023 370.619995 -0.710% -1.077%
158 12/21/2023 373.540009 0.785% -0.077%
159 12/22/2023 374.579987 0.278% -0.556%
160 12/26/2023 374.660004 0.021% -0.284%
161 12/27/2023 374.070007 -0.158% 0.052%
162 12/28/2023 375.279999 0.323% 0.222%
163 12/29/2023 376.040009 0.202% -0.544%
164 1/2/2024 370.869995 -1.384% -3.644%
165 1/3/2024 370.600006 -0.073% -0.752%
166 1/4/2024 367.940002 -0.720% -1.278%
167 1/5/2024 367.75 -0.052% -0.402%
168 1/8/2024 374.690002 1.870% 2.389%
169 1/9/2024 375.790009 0.293% -0.227%
170 1/10/2024 382.769989 1.840% 0.566%
171 1/11/2024 384.630005 0.485% -0.323%
172 1/12/2024 388.470001 0.993% 0.178%
173 1/16/2024 390.269989 0.462% -1.239%
174 1/17/2024 389.470001 -0.205% -0.519%
175 1/18/2024 393.869995 1.123% 3.205%
176 1/19/2024 398.670013 1.211% 1.541%
177 1/22/2024 396.51001 -0.543% 1.209%
178 1/23/2024 398.899994 0.601% 0.663%
179 1/24/2024 402.559998 0.913% -0.349%
180 1/25/2024 404.869995 0.572% -0.170%
181 1/26/2024 403.929993 -0.232% -0.905%
182 1/29/2024 409.720001 1.423% -0.359%
183 1/30/2024 408.589996 -0.276% -1.943%
184 1/31/2024 397.579987 -2.732% -1.955%
185 2/1/2024 403.779999 1.547% 1.325%
186 2/2/2024 411.220001 1.826% -0.542%
187 2/5/2024 405.649994 -1.364% 0.980%
188 2/6/2024 405.48999 -0.039% 0.859%
189 2/7/2024 414.049988 2.089% 0.058%
190 2/8/2024 414.109985 0.014% -0.577%
191 2/9/2024 420.549988 1.543% 0.281%
192 2/12/2024 415.26001 -1.266% -0.904%
193 2/13/2024 406.320007 -2.176% -1.134%
194 2/14/2024 409.48999 0.777% -0.482%
195 2/15/2024 406.559998 -0.718% -0.158%
196 2/16/2024 404.059998 -0.617% -0.847%
197 2/20/2024 402.790009 -0.315% -0.412%
198 2/21/2024 402.179993 -0.152% 0.418%
199 2/22/2024 411.649994 2.327% 1.118%
200 2/23/2024 410.339996 -0.319% -1.008%
201 2/26/2024 407.540009 -0.685% -0.748%
202 2/27/2024 407.480011 -0.015% 0.808%
203 2/28/2024 407.720001 0.059% -0.665%
204 2/29/2024 413.640015 1.442% -0.370%
205 3/1/2024 415.5 0.449% -0.605%
206 3/4/2024 414.920013 -0.140% -2.571%
207 3/5/2024 402.649994 -3.002% -2.885%
208 3/6/2024 402.089996 -0.139% -0.590%
209 3/7/2024 409.140015 1.738% -0.071%
210 3/8/2024 406.220001 -0.716% 1.018%
211 3/11/2024 404.519989 -0.419% 1.176%
212 3/12/2024 415.279999 2.625% 0.277%
213 3/13/2024 415.100006 -0.043% -1.220%
214 3/14/2024 425.220001 2.409% 1.087%
215 3/15/2024 416.420013 -2.091% -0.220%
216 3/18/2024 417.320007 0.216% 0.635%
217 3/19/2024 421.410004 0.975% 1.349%
218 3/20/2024 425.230011 0.902% 1.460%
219 3/21/2024 429.369995 0.969% -4.172%
220 3/22/2024 428.73999 -0.147% 0.530%
221 3/25/2024 422.859985 -1.381% -0.834%
222 3/26/2024 421.649994 -0.287% -0.669%
223 3/27/2024 421.429993 -0.052% 2.099%
224 3/28/2024 420.720001 -0.169% -1.062%
225 4/1/2024 424.570007 0.911% -0.849%
226 4/2/2024 421.440002 -0.740% -0.702%
227 4/3/2024 420.450012 -0.235% 0.479%
228 4/4/2024 417.880005 -0.613% -0.490%
229 4/5/2024 425.519989 1.812% 0.449%
230 4/8/2024 424.589996 -0.219% -0.669%
231 4/9/2024 426.279999 0.397% 0.722%
232 4/10/2024 423.26001 -0.711% -1.120%
233 4/11/2024 427.929993 1.097% 4.236%
234 4/12/2024 421.899994 -1.419% 0.859%
235 4/15/2024 413.640015 -1.977% -2.211%
236 4/16/2024 414.579987 0.227% -1.935%
237 4/17/2024 411.839996 -0.663% -0.818%
238 4/18/2024 404.269989 -1.855% -0.573%
239 4/19/2024 399.119995 -1.282% -1.229%
240 4/22/2024 400.959991 0.460% 0.508%
241 4/23/2024 407.570007 1.635% 0.637%
242 4/24/2024 409.059998 0.365% 1.262%
243 4/25/2024 399.040009 -2.480% 0.513%
244 4/26/2024 406.320007 1.808% -0.348%
245 4/29/2024 402.25 -1.007% 2.451%
246 4/30/2024 389.329987 -3.265% -1.844%
247 5/1/2024 394.940002 1.431% -0.607%
248 5/2/2024 397.839996 0.732% 2.179%
249 5/3/2024 406.660004 2.193% 5.810%
250 5/6/2024 413.540009 1.678% -0.915%
251 5/7/2024 409.339996 -1.021% 0.379%
252 5/8/2024 410.540009 0.293% 0.186%
253 5/9/2024 412.320007 0.433% 0.996%
29.495% 7.187%
MSFT AAPL
Rentabilidad 29.495% 7.187%
1.3281% SD 1.3281% 1.265%
Varianza 0.000176374376 0.0001599675
Covarianza 0.000080
Correlación 0.475563113
Matriz de varianzas y covarianzas
MSFT AAPL
MSFT 0.000176374 0.000080
AAPL 0.000080 0.000159967
Matriz de correlaciones
MSFT AAPL
MSFT 1 0.4755631133
AAPL 0.475563113332 1

Rentab

8.000%

6.000%

4.000%

2.000%

0.000%
1 7 13 19 25 31 37 43 49 55 61 67 73 79 85 91 97

-2.000%
2.000%

0.000%
1 7 13 19 25 31 37 43 49 55 61 67 73 79 85 91 97

-2.000%

-4.000%

-6.000%
Rentabilidades MSFT - AAPL
MSFT AAPL

61 67 73 79 85 91 97 103 109 115 121 127 133 139 145 151 157 163 169 175 181 187 193 199 205 211 217 223 229 235 241 24
61 67 73 79 85 91 97 103 109 115 121 127 133 139 145 151 157 163 169 175 181 187 193 199 205 211 217 223 229 235 241 24
3 199 205 211 217 223 229 235 241 247
3 199 205 211 217 223 229 235 241 247

You might also like