small P R O JECT

profileahabuloshi
excelpart.xlsx
Home>Business & Finance homework help>small P R O JECT

AAPL

Date Open High Low Close Adj Close Volume Stock Daily Return Daily Return (AAPL) Daily Return (MSFT) Index Daily Return
4/8/20 65.684998 66.842499 65.307503 66.517502 65.795349 168895200 ERROR:#VALUE! -0.832504 0.539993 ERROR:#VALUE!
4/9/20 67.175003 67.517502 66.175003 66.997498 66.270126 161834800 0.0072160858 0.177505 1.220002 -1.2132181947
4/13/20 67.077499 68.425003 66.457497 68.3125 67.570862 131022800 0.0196276285 -1.235001 -1.159989 -7.9575561252
4/14/20 70 72.0625 69.512497 71.762497 70.983391 194994800 0.0505031583 -1.762497 -4.699997 0.4271219214
4/15/20 70.599998 71.582497 70.157501 71.107498 70.33551 131154400 -0.0091273162 -0.5075 -0.680008 -0.7120562475
4/16/20 71.845001 72.050003 70.587502 71.672501 70.894386 157125200 0.0079457584 0.1725 -2.73999 -1.3399014778
4/17/20 71.172501 71.737503 69.214996 70.699997 69.932442 215250000 -0.0135687186 0.472504 0.899994 1.7391536232
4/20/20 69.487503 70.419998 69.212502 69.232498 68.480873 130015200 -0.0207567053 0.255005 1.570007 -0.4603114471
4/21/20 69.07 69.3125 66.357498 67.092499 66.364113 180991600 -0.0309103248 1.977501 5.679993 6.7547538284
4/22/20 68.402496 69.474998 68.050003 69.025002 68.275627 116862400 0.0288035627 -0.622506 -2.130005 -1.3147942782
4/23/20 68.967499 70.4375 68.717499 68.7575 68.011032 124814400 -0.0038754363 0.209999 2.690003 -1.3373445397
4/24/20 69.300003 70.752502 69.25 70.7425 69.974472 126161200 0.0288695779 -1.442497 -2.490005 -7.8690660432
4/27/20 70.449997 71.135002 69.987503 70.792503 70.023941 117087600 0.0007068311 -0.342506 2.539993 -0.7625603381
4/28/20 71.269997 71.457497 69.550003 69.644997 68.888901 112004800 -0.0162094283 1.625 5.779998 -5.7444424331
4/29/20 71.182503 72.417503 70.972504 71.932503 71.151558 137280800 0.0328452308 -0.75 -4.209992 -1.4615384615
4/30/20 72.489998 73.6325 72.087502 73.449997 72.65258 183064000 0.0210960823 -0.959999 0.789993 0.2799986667
5/1/20 71.5625 74.75 71.462502 72.267502 71.482933 240616800 -0.0160993199 -0.705002 1.229996 -0.2656221517
5/4/20 72.292503 73.422501 71.580002 73.290001 72.494324 133568000 0.0141488079 -0.997498 -4.349991 0.4148867663
5/5/20 73.764999 75.25 73.614998 74.389999 73.582382 147751200 0.0150088414 -0.625 -0.14 -0.3734323277
5/6/20 75.114998 75.809998 74.717499 75.157501 74.341537 142333600 0.010317274 -0.042503 -0.459991 -0.9319952
5/7/20 75.805 76.292503 75.4925 75.934998 75.110603 115215200 0.0103449022 -0.129998 0.569992 2.0585605722
5/8/20 76.410004 77.587502 76.072502 77.532501 76.898361 133838400 0.0210377697 -1.122497 0.300003 7.6347251496
5/11/20 77.025002 79.262497 76.809998 78.752502 78.108383 145946400 0.0157353495 -1.7275 -3.590011 0.5389796142
5/12/20 79.457497 79.922501 77.727501 77.852501 77.215744 162301200 -0.011428221 1.604996 4.290008 -1.9290859624
5/13/20 78.037498 78.987503 75.802498 76.912498 76.283424 200622400 -0.0120741529 1.125 2.800003 -0.2990636737
5/14/20 76.127502 77.447502 75.3825 77.385002 76.752075 158929200 0.0061433969 -1.2575 -2.990006 -2.1177777778
5/15/20 75.087502 76.974998 75.052498 76.927498 76.298309 166348400 -0.00591205 -1.839996 -4.100006 0.463217495
5/18/20 78.292503 79.125 77.580002 78.739998 78.095993 135178400 0.0235611458 -0.447495 0.839996 -0.7567956669
5/19/20 78.7575 79.629997 78.252502 78.285004 77.644714 101729600 -0.0057784355 0.472496 1.399994 -2.0558687807
5/20/20 79.169998 79.879997 79.129997 79.807503 79.154762 111504800 0.0194481564 -0.637505 -0.850006 -2.3492283533
5/21/20 79.665001 80.222504 78.967499 79.212502 78.564621 102688800 -0.0074554519 0.452499 1.970001 -1.7097967859
5/22/20 78.942497 79.807503 78.837502 79.722504 79.070457 81803200 0.0064384029 -0.780007 -0.319993 -2.7237761851
5/26/20 80.875 81.059998 79.125 79.182503 78.534874 125522000 -0.0067735078 1.692497 4.769989 -3.1698484757
5/27/20 79.035004 79.677498 78.272499 79.527496 78.877037 112945200 0.0043569348 -0.492492 -1.610001 -1.2909854493
5/28/20 79.192497 80.860001 78.907501 79.5625 78.911751 133560800 0.0004401497 -0.370003 -0.659989 -0.2487126694
5/29/20 79.8125 80.287498 79.1175 79.485001 78.8349 153532400 -0.0009740644 0.327499 -0.520004 -1.8851252557
6/1/20 79.4375 80.587502 79.302498 80.462502 79.804398 80791200 0.0122979303 -1.025002 -0.290009 -4.1297866558
6/2/20 80.1875 80.860001 79.732498 80.834999 80.173843 87642800 0.0046294484 -0.647499 -0.660004 -0.3682948911
6/3/20 81.165001 81.550003 80.574997 81.279999 80.615211 104491200 0.0055050412 -0.114998 -0.539994 -0.8223966369
6/4/20 81.097504 81.404999 80.195 80.580002 79.920944 87560400 -0.0086121679 0.517502 1.380005 -5.5000956538
6/5/20 80.837502 82.9375 80.807503 82.875 82.197174 137250400 0.0284809871 -2.037498 -4.580002 -4.9371789867
6/8/20 82.5625 83.400002 81.830002 83.364998 82.683151 95654400 0.0059124947 -0.802498 -2.419999 -0.6061355643
6/9/20 83.035004 86.402496 83.002502 85.997498 85.294128 147712400 0.0315780011 -2.962494 -1.800003 2.6915905086
6/10/20 86.974998 88.692497 86.522499 88.209999 87.488533 166651600 0.0257275043 -1.235001 -5.709991 -0.583121181
6/11/20 87.327499 87.764999 83.870003 83.974998 83.28817 201662400 -0.0480104415 3.352501 6.860001 -3.7145735105
6/12/20 86.18 86.949997 83.555 84.699997 84.007233 200146000 0.0086335102 1.480003 2.799988 -0.558537641
6/15/20 83.3125 86.419998 83.144997 85.747498 85.046173 138808800 0.0123671905 -2.434998 -4.36 -2.6452655839
6/16/20 87.864998 88.300003 86.18 88.019997 87.300087 165428800 0.0265022193 -0.154999 -0.680008 -0.9363453276
6/17/20 88.787498 88.849998 87.772499 87.897499 87.178589 114406400 -0.0013917065 0.889999 0.789994 -6.7419660772
6/18/20 87.852501 88.362503 87.305 87.932503 87.213303 96820400 0.0003982366 -0.080002 -2.320007 -1.0898899886
6/19/20 88.660004 89.139999 86.287498 87.43 86.714905 264476000 -0.0057146446 1.230004 3.440002 -16.3746656334
6/22/20 87.834999 89.864998 87.787498 89.717499 88.983704 135445200 0.0261637767 -1.8825 -4.780014 -2.5304828277
6/23/20 91 93.095001 90.567497 91.6325 90.883034 212155600 0.021344788 -0.6325 0.179992 -0.6640106242
6/24/20 91.25 92.197502 89.629997 90.014999 89.27877 192623200 -0.0176520449 1.235001 3.76001 -2.952570751
6/25/20 90.175003 91.25 89.392502 91.209999 90.463997 137522400 0.0132755653 -1.034996 -2.539993 -1.8380527627
6/26/20 91.102501 91.330002 88.254997 88.407501 87.684418 205256800 -0.030725776 2.695 3.399994 -3.6038747976
6/29/20 88.3125 90.542503 87.82 90.445 89.705254 130646000 0.0230466756 -2.1325 -2.660003 -1.7912801484
6/30/20 90.019997 91.495003 90 91.199997 90.454079 140223200 0.0083475814 -1.18 -5.62999 -0.4466588511
7/1/20 91.279999 91.839996 90.977501 91.027496 90.282982 110737200 -0.0018914584 0.252503 -1.559998 -1.2139855932
7/2/20 91.962502 92.6175 90.910004 91.027496 90.282982 114041600 0 0.935006 -0.580002 2.702950064
7/6/20 92.5 93.945 92.467499 93.462502 92.698074 118655600 0.026750225 -0.962502 -1.869995 -2.0294072979
7/7/20 93.852501 94.654999 93.057503 93.172501 92.410439 112424400 -0.0031028594 0.68 2.199997 -1.7064920385
7/8/20 94.18 95.375 94.089996 95.342499 94.562691 117092000 0.0232901122 -1.162499 -2.759995 -2.7095573529
7/9/20 96.262497 96.317497 94.672501 95.752502 94.969345 125642800 0.0043003173 0.509995 2.009995 -1.4387057537
7/10/20 95.334999 95.980003 94.705002 95.919998 95.135475 90257200 0.0017492598 -0.584999 -0.050003 -2.1470681085
7/13/20 97.264999 99.955002 95.2575 95.477501 94.696594 191649200 -0.0046131882 1.787498 7.409989 -4.0555573599
7/14/20 94.839996 97.254997 93.877502 97.057503 96.263672 170989200 0.0165484222 -2.217507 -2.220001 -2.2405647447
7/15/20 98.989998 99.247498 96.489998 97.724998 96.925705 153198000 0.0068773148 1.265 1.520005 -1.5704604315
7/16/20 96.5625 97.404999 95.904999 96.522499 95.73304 110577600 -0.0123049273 0.040001 1.479996 -0.9683786561
7/17/20 96.987503 97.147499 95.839996 96.327499 95.539635 92186800 -0.0020202544 0.660004 1.589996 15.4996875078
7/20/20 96.417503 98.5 96.0625 98.357498 97.553032 90318000 0.0210739303 -1.939995 -6.600006 -3.9393685493
7/21/20 99.172501 99.25 96.7425 97 96.206642 103433200 -0.0138016728 2.172501 4.910004 -2.1198487625
7/22/20 96.692497 97.974998 96.602501 97.272499 96.476906 89001600 0.002809268 -0.580002 -2.550003 -1.2669743305
7/23/20 96.997498 97.077499 92.010002 92.845001 92.085625 197004400 -0.0455164414 4.152497 4.650009 -8.1594528984
7/24/20 90.987503 92.970001 89.144997 92.614998 91.857506 185438800 -0.0024772793 -1.627495 -0.880005 -1.3919316498
7/27/20 93.709999 94.904999 93.480003 94.809998 94.034538 121214000 0.023700265 -1.099999 -2.380005 -0.3241152815
7/28/20 94.3675 94.550003 93.247498 93.252502 92.489784 103625600 -0.0164275502 1.114998 1.589997 -2.0136354669
7/29/20 93.75 95.230003 93.712502 95.040001 94.262657 90329200 0.0191683758 -1.290001 -1.559998 -2.1569536448
7/30/20 94.1875 96.297501 93.767502 96.190002 95.403267 158130000 0.0121001787 -2.002502 -2.899994 0.5523259284
7/31/20 102.885002 106.415001 100.824997 106.260002 105.390907 374336800 0.1046886349 -3.375 -0.610001 0.6853915751
8/3/20 108.199997 111.637497 107.892502 108.9375 108.046509 308151200 0.0251976092 -0.737503 -5.019989 -0.7814805926
8/4/20 109.1325 110.790001 108.387497 109.665001 108.768059 173071600 0.0066781503 -0.532501 0.880005 -0.2779676828
8/5/20 109.377502 110.392502 108.897499 110.0625 109.162292 121776800 0.003624666 -0.684998 1.959992 0.2863788049
8/6/20 110.404999 114.412498 109.797501 113.902496 112.970894 202428800 0.0348892311 -3.497497 -4.01001 4.1058499441
8/7/20 113.205002 113.675003 110.292503 111.112503 110.40242 198045600 -0.024494573 2.092499 2.37001 -1.5982847162
8/10/20 112.599998 113.775002 110 112.727501 112.007095 212403600 0.0145347999 -0.127503 3.419998 -1.0609333625
8/11/20 111.970001 112.482498 109.107498 109.375 108.67601 187902400 -0.029739868 2.595001 3.779999 -21.352470138
8/12/20 110.497498 113.275002 110.297501 113.010002 112.287788 165598000 0.033234304 -2.512504 -3.900009 -1.9682092608
8/13/20 114.43 116.042503 113.927498 115.010002 114.275002 210082000 0.0176975486 -0.580002 0.740005 -0.7691538004
8/14/20 114.830002 115 113.044998 114.907501 114.173164 165565200 -0.0008912355 -0.077499 -0.139999 -0.8663814952
8/17/20 116.0625 116.087502 113.962502 114.607498 113.875069 119561600 -0.0026108217 1.455002 -0.679993 -19.774461606
8/18/20 114.352501 116 114.0075 115.5625 114.823975 105633600 0.0083328056 -1.209999 -0.960006 -1.8316132899
8/19/20 115.982498 117.162498 115.610001 115.707497 114.968048 145538000 0.0012547063 0.275001 1.790008 -1.2272737415
8/20/20 115.75 118.392502 115.732498 118.275002 117.519142 126907200 0.0221896166 -2.525002 -5.040009 -10.1817920662
8/21/20 119.262497 124.8675 119.25 124.370003 123.575188 338054800 0.0515324532 -5.107506 0.839997 1.0227730513
8/24/20 128.697495 128.785004 123.9375 125.857498 125.053177 345937600 0.0119602393 2.839997 1.099991 -1.5560437912
8/25/20 124.697502 125.18 123.052498 124.824997 124.027283 211495600 -0.0082037305 -0.127495 -3.369995 -1.0448926531
8/26/20 126.18 126.9925 125.082497 126.522499 125.713928 163022400 0.013599055 -0.342499 -3.269989 1.6863720146
8/27/20 127.142502 127.485001 123.832497 125.010002 124.211098 155552400 -0.0119543718 2.1325 -3.690003 -7.2262955512
8/28/20 126.012497 126.442497 124.577499 124.807503 124.009895 187630000 -0.0016198624 1.204994 -0.730011 -0.4349383353
8/31/20 127.580002 131 126 129.039993 128.215347 225702700 0.0339121439 -1.459991 1.470001 -2.2116168213
9/1/20 132.759995 134.800003 130.529999 134.179993 133.322495 151948100 0.0398326122 -1.419998 -1.760009 -0.0273926346
9/2/20 137.589996 137.979996 127 131.399994 130.560257 200119000 -0.0207184315 6.190002 -3.679993 -5.3591624777
9/3/20 126.910004 128.839996 120.5 120.879997 120.107483 257599600 -0.0800608636 6.030007 11.970001 -0.0258473261
9/4/20 120.07 123.699997 110.889999 120.959999 120.186981 332607200 0.0006618299 -0.889999 0.850006 -1.1475950194
9/8/20 113.949997 118.989998 112.68 112.82 112.098999 231366600 -0.0672949658 1.129997 3.839996 -2.2696609771
9/9/20 117.260002 119.139999 115.260002 117.32 116.570236 176940500 0.0398865449 -0.059998 -3.689987 -1.0530957162
9/10/20 120.360001 120.5 112.5 113.489998 112.764717 182274400 -0.0326457722 6.870003 8.029999 -115.5038667956
9/11/20 114.57 115.230003 110 112 111.284241 180860300 -0.0131288926 2.57 3.169998 -0.6259099159
9/14/20 114.720001 115.93 112.800003 115.360001 114.622765 140150100 0.0300000089 -0.64 -1.169999 -1.2490272374
9/15/20 118.330002 118.830002 113.610001 115.540001 114.80162 184642000 0.0015603329 2.790001 -0.360001 -5.3593765625
9/16/20 115.230003 116 112.040001 112.129997 111.413406 154679000 -0.0295136227 3.100006 5.569992 0.1111128634
9/17/20 109.720001 112.199997 108.709999 110.339996 109.63485 178011000 -0.015963623 -0.619995 -2.860001 -1.199998
9/18/20 110.400002 110.879997 106.089996 106.839996 106.157211 287104900 -0.0317201389 3.560006 2.410004 -6.7419914677
9/21/20 104.540001 110.190002 103.099998 110.080002 109.376511 195713800 0.030325778 -5.540001 -5.349991 -2.5561774334
9/22/20 112.68 112.860001 109.160004 111.809998 111.095444 183055400 0.0157158064 0.870002 -2.36 -1.1570400439
9/23/20 111.620003 112.110001 106.769997 107.120003 106.435432 150718700 -0.0419461147 4.5 7.309998 4.1724019025
9/24/20 105.169998 110.25 105 108.220001 107.528404 167743300 0.0102688384 -3.050003 -3.339996 -1.6777784444
9/25/20 108.43 112.440002 107.669998 112.279999 111.562439 149981400 0.0375161519 -3.849999 -4.270004 0.2622935125
9/28/20 115.010002 115.32 112.779999 114.959999 114.225311 137672400 0.0238688994 0.050003 1.440003 -1.0129877956
9/29/20 114.550003 115.309998 113.57 114.089996 113.360878 99382200 -0.0075678758 0.460007 2.090011 8.1995880247
9/30/20 113.790001 117.260002 113.620003 115.809998 115.069893 142675200 0.0150758354 -2.019997 -2.600006 -5.391231003
10/1/20 117.639999 117.720001 115.830002 116.790001 116.043625 116120400 0.0084621623 0.849998 1.029998 -1.420791714
10/2/20 112.889999 115.370003 112.220001 113.019997 112.297722 144712000 -0.0322801949 -0.129998 1.809998 -1.1529391834
10/5/20 113.910004 116.650002 113.550003 116.5 115.755478 106243800 0.0307910378 -2.589996 -3.160004 18.923352667
10/6/20 115.699997 116.120003 112.25 113.160004 112.436829 161498200 -0.0286694936 2.539993 2.910003 -1.9806937926
10/7/20 114.620003 115.550003 114.129997 115.080002 114.344559 96849000 0.0169671079 -0.459999 -2.770004 -1.1811024676
10/8/20 116.25 116.400002 114.589996 114.970001 114.23526 83477200 -0.0009558655 1.279999 -0.070007 -3.7826125709
10/9/20 115.279999 117 114.919998 116.970001 116.222473 100506900 0.0173958422 -1.690002 -4.580002 -2.320315094
10/12/20 120.059998 125.18 119.279999 124.400002 123.604996 240226800 0.0635205688 -4.340004 -2.610001 1.568046665
10/13/20 125.269997 125.389999 119.650002 121.099998 120.326073 262330500 -0.0265273629 4.169999 -0.14 -1.9608283771
10/14/20 121 123.029999 119.620003 121.190002 120.415512 150712000 0.0007432205 -0.190002 2.139999 -1.0455640397
10/15/20 118.720001 121.199997 118.150002 120.709999 119.938568 112559200 -0.0039607475 -1.989998 -2.559998 9.4735634362
10/16/20 121.279999 121.550003 118.809998 119.019997 118.259369 115393800 -0.0140005137 2.260002 0.48999 -2.1356805384
10/19/20 119.959999 120.419998 115.660004 115.980003 115.2388 120639300 -0.025541876 3.979996 6.199997 0.7610586185
10/20/20 116.199997 118.980003 115.629997 117.510002 116.759033 124423700 0.0131919207 -1.310005 1.150009 -1.3291473157
10/21/20 116.669998 118.709999 116.449997 116.870003 116.123123 89946000 -0.0054463364 -0.200005 -1.680008 -0.8473250102
10/22/20 117.449997 118.040001 114.589996 115.75 115.010269 101988000 -0.0095833231 1.699997 -0.960006 -9.4997725057
10/23/20 116.389999 116.550003 114.279999 115.040001 114.304817 82572600 -0.0061339006 1.349998 -1.199997 -0.205882128
10/26/20 114.010002 116.550003 112.879997 115.050003 114.314751 111850700 0.0000869437 -1.040001 3.770004 -1.7703722524
10/27/20 115.489998 117.279999 114.540001 116.599998 115.854843 92276800 0.0134723595 -1.11 -1.660004 0.0673066661
10/28/20 115.050003 115.43 111.099998 111.199997 110.489349 143937800 -0.0463121878 3.850006 4.990005 -4.4684738739
10/29/20 112.370003 116.93 112.199997 115.32 114.583023 146129200 0.0370503877 -2.949997 -0.649994 -1.7662317929
10/30/20 111.059998 111.989998 107.720001 108.860001 108.164307 190272600 -0.0560180281 2.199997 1.029999 -1.7457624533
11/2/20 109.110001 110.68 107.32 108.769997 108.074883 122866900 -0.0008267867 0.340004 1.959991 -0.8454525165
11/3/20 109.660004 111.489998 108.730003 110.440002 109.734207 107624400 0.0153535446 -0.779998 -2.539994 -3.2940847755
11/4/20 114.139999 115.589996 112.349998 114.949997 114.215385 138235500 0.0408366074 -0.809998 -2.369995 0.0384616371
11/5/20 117.949997 119.620003 116.870003 119.029999 118.26931 126387100 0.0354937112 -1.080002 -1.25 0.3333390947
11/6/20 118.32 119.199997 116.129997 118.690002 118.134956 114457900 -0.0028563976 -0.370002 -1.460006 -0.65740619
11/9/20 120.5 121.989998 116.050003 116.32 115.776031 154515300 -0.0199680003 4.18 6.050003 -12.2972362312
11/10/20 115.550003 117.589996 114.129997 115.970001 115.427666 138023400 -0.0030089323 -0.419998 3.490005 -1.1004779904
11/11/20 117.190002 119.629997 116.440002 119.489998 118.931198 112295000 0.0303526513 -2.299996 -4.160004 4.4762070296
11/12/20 119.620003 120.529999 118.57 119.209999 118.652512 103162300 -0.002343284 0.410004 1.770005 -1.1782629187
11/13/20 119.440002 119.669998 117.870003 119.260002 118.702278 81581900 0.0004194531 0.18 -0.149994 -0.5609798929
11/16/20 118.919998 120.989998 118.150002 120.300003 119.737419 91183000 0.008720451 -1.380005 -2.360001 -8.6666944444
11/17/20 119.550003 120.669998 118.959999 119.389999 118.831673 74271000 -0.0075644553 0.160004 1.639999 -1.1159445074
11/18/20 118.610001 119.82 118 118.029999 117.478035 76322100 -0.0113912389 0.580002 2.569992 2.624921877
11/19/20 117.589996 119.059998 116.809998 118.639999 118.085182 74113000 0.0051681776 -1.050003 -1.039993 -2.8103437574
11/20/20 118.639999 118.769997 117.290001 117.339996 116.79126 73604300 -0.0109575439 1.300003 1.809998 -2.2380945578
11/23/20 117.18 117.620003 113.75 113.849998 113.317581 127959300 -0.0297426122 3.330002 0.839996 1.5615340888
11/24/20 113.910004 115.849998 112.589996 115.169998 114.631409 113874200 0.0115942031 -1.259994 -4.270005 -1.3783763493
11/25/20 115.550003 116.75 115.169998 116.029999 115.487389 76499200 0.0074672312 -0.479996 1.240006 -0.6190489796
11/27/20 116.57 117.489998 116.220001 116.589996 116.044762 46691300 0.0048263122 -0.019996 -0.37999 -0.9583413195
11/30/20 116.970001 120.970001 116.809998 119.050003 118.493263 169410200 0.0210996405 -2.080002 0.029999 103.0209041808
12/1/20 121.010002 123.470001 120.010002 122.720001 122.146103 127728200 0.0308273659 -1.709999 -1.700012 -0.1778858866
12/2/20 122.019997 123.370003 120.889999 123.080002 122.504417 89004200 0.0029335153 -1.060005 -0.48999 -0.3801136726
12/3/20 123.519997 123.779999 122.209999 122.940002 122.365074 78967600 -0.0011374715 0.579995 0.369996 -1.5471625134
12/4/20 122.599998 122.860001 121.519997 122.25 121.678307 78260400 -0.0056125101 0.349998 -0.14 -0.3965499703
12/7/20 122.309998 124.57 122.25 123.75 123.171288 86712000 0.0122699387 -1.440002 0.080002 -5.1143149389
12/8/20 124.370003 124.980003 123.089996 124.379997 123.79834 82225500 0.0050908848 -0.009994 -2.039994 -0.9930597319
12/9/20 124.529999 125.949997 121 121.779999 121.210495 115089200 -0.0209036667 2.75 3.360001 -276.1650990593
12/10/20 120.5 123.870003 120.150002 123.239998 122.663666 81312200 0.0119888242 -2.739998 1.25 -1.9963629091
12/11/20 122.43 122.760002 120.550003 122.410004 121.837555 86939800 -0.0067347778 0.019996 -3.209992 -1.0072978155
12/14/20 122.599998 123.349998 121.540001 121.779999 121.210495 79184500 -0.005146679 0.819999 -1.099991 40.0081516303
12/15/20 124.339996 127.900002 124.129997 127.879997 127.28196 157243700 0.0500903108 -3.540001 1.039993 -5.317079655
12/16/20 127.410004 128.369995 126.559998 127.809998 127.212296 98208600 -0.0005473804 -0.399994 -4.529999 -0.8870073766
12/17/20 128.899994 129.580002 128.039993 128.699997 128.098129 94359800 0.0069634537 0.199997 0.449997 -1.5
12/18/20 128.960007 129.100006 126.120003 126.660004 126.06768 192541500 -0.0158507618 2.300003 0 10.5001875028
12/21/20 125.019997 128.309998 123.449997 128.229996 127.630325 121251600 0.0123953257 -3.209999 -5.039993 -2.3956499187
12/22/20 131.610001 134.410004 129.649994 131.880005 131.26326 168904800 0.028464549 -0.270004 -1.25 -0.9158865782
12/23/20 132.160004 132.429993 130.779999 130.960007 130.347565 88223700 -0.0069760234 1.199997 2.089997 -5.4443674909
12/24/20 131.320007 133.460007 131.100006 131.970001 131.352829 54930100 0.0077122323 -0.649994 -1.330002 -1.5416630208
12/28/20 133.990005 137.339996 133.509995 136.690002 136.050766 124486200 0.0357657116 -2.699997 -0.51001 3.153879882
12/29/20 138.050003 138.789993 134.339996 134.869995 134.239273 121047300 -0.0133148509 3.180008 2.160004 -2.1777820494
12/30/20 135.580002 135.990005 133.399994 133.720001 133.09465 96452100 -0.0085266853 1.860001 3.550003 -0.4150954966
12/31/20 134.080002 134.740005 131.720001 132.690002 132.069473 99116600 -0.0077026547 1.39 -0.720001 -0.2526885738
1/4/21 133.520004 133.610001 126.760002 129.410004 128.804825 143301900 -0.024719255 4.11 4.839997 1.9568345324
1/5/21 128.889999 131.740005 128.429993 131.009995 130.397324 97664900 0.012363735 -2.119996 -0.639999 -1.5158141119
1/6/21 127.720001 131.050003 126.379997 126.599998 126.007957 155088000 -0.0336615309 1.120003 -0.080002 -1.5283042987
1/7/21 128.360001 131.630005 127.860001 130.919998 130.307755 109578200 0.0341232233 -2.559997 -4.25 -3.2857054847
1/8/21 132.429993 132.630005 130.229996 132.050003 131.432465 105158200 0.0086312635 0.37999 -0.940002 -1.1484337677
1/11/21 129.190002 130.169998 128.5 128.979996 128.376831 100384500 -0.0232488219 0.210006 0.979996 -0.4473380878
1/12/21 128.5 129.690002 126.860001 128.800003 128.197662 91951100 -0.001395511 -0.300003 1.570007 -2.4285448987
1/13/21 128.759995 131.449997 128.490005 130.889999 130.277893 88636800 0.0162266766 -2.130004 -2.319992 6.0999423339
1/14/21 130.800003 131 128.759995 128.910004 128.307175 90221800 -0.015127168 1.889999 2.89 -1.8873218078
1/15/21 128.779999 130.220001 127 127.139999 126.545425 111598500 -0.013730548 1.64 0.87001 -0.1322746732
1/19/21 127.779999 128.710007 126.940002 127.830002 127.232201 90757300 0.0054271119 -0.050003 -2.690002 -1.0304896341
1/20/21 128.660004 132.490005 128.550003 132.029999 131.412567 104319500 0.0328561131 -3.369995 -6.639999 66.3958562486
1/21/21 133.800003 139.669998 133.589996 136.869995 136.229919 120150900 0.0366583052 -3.069992 -0.270004 -0.0890217938
1/22/21 136.279999 139.850006 135.020004 139.070007 138.419647 114459400 0.0160737348 -2.790008 1.130005 -0.0912002377
1/25/21 143.070007 145.089996 136.539993 142.919998 142.251633 157611700 0.0276838341 0.150009 -0.410004 -1.0537665125
1/26/21 143.600006 144.300003 141.369995 143.160004 142.490524 98390600 0.0016793031 0.440002 -0.470001 1.9331706764
1/27/21 143.429993 144.300003 140.410004 142.059998 141.39566 140843800 -0.0076837522 1.369995 5.100006 2.1136108472
1/28/21 139.520004 141.990005 136.699997 137.089996 136.448898 142621100 -0.0349852321 2.430008 -3.319992 0.7737349406
1/29/21 135.830002 136.740005 130.210007 131.960007 131.34288 177523800 -0.0374205934 3.869995 4.029998 0.5925852919
2/1/21 133.75 135.380005 130.929993 134.139999 133.51268 106239800 0.0165200961 -0.389999 -4.589996 -1.1007750656
2/2/21 135.729996 136.309998 134.610001 134.990005 134.358719 83305400 0.006336708 0.739991 1.790008 -2.8974176857
2/3/21 135.759995 135.770004 133.610001 133.940002 133.313644 89880900 -0.0077783759 1.819993 -3.429993 1.4594799126
2/4/21 136.300003 137.399994 134.589996 137.389999 136.747498 84183100 0.0257577792 -1.089996 0.650009 -1.5989012046
2/5/21 137.350006 137.419998 135.860001 136.759995 136.323837 75693800 -0.0045855157 0.590011 0.029999 -1.5412964818
2/8/21 136.029999 136.960007 134.919998 136.910004 136.473373 71297200 0.0010968778 -0.880005 0.679993 -2.4915060906
2/9/21 136.619995 137.880005 135.850006 136.009995 135.576233 76774200 -0.0065737271 0.61 -1.900009 -1.6931778797
2/10/21 136.479996 136.990005 134.399994 135.389999 134.958206 73046600 -0.0045584591 1.089997 2.179993 0.7868803279
2/11/21 135.899994 136.389999 133.770004 135.130005 134.699051 64280000 -0.0019203339 0.769989 0.289994 -0.2935861291
2/12/21 134.350006 135.529999 133.690002 135.369995 134.938263 60145100 0.0017759934 -1.019989 -1.060012 -2.324679963
2/16/21 135.490005 136.009995 132.789993 133.190002 132.765244 80576300 -0.0161039601 2.300003 1.330002 -3.2549292198
2/17/21 131.25 132.220001 129.470001 130.839996 130.422729 97918500 -0.017644012 0.410004 -2.87999 -0.8217376238
2/18/21 129.199997 130 127.410004 129.710007 129.296326 96856700 -0.0086364188 -0.51001 -1.98999 -2.2439146935
2/19/21 130.240005 130.710007 128.800003 129.869995 129.455826 87668800 0.0012334284 0.37001 2.779999 -1.7254955785
2/22/21 128.009995 129.720001 125.599998 126 125.598167 103916400 -0.0297989924 2.009995 2.910003 4.4322721008
2/23/21 123.760002 126.709999 118.389999 125.860001 125.458611 158273000 -0.0011111032 -2.099999 -2.940002 -2.0447782208
2/24/21 124.940002 125.559998 122.230003 125.349998 124.950233 111039900 -0.0040521452 -0.409996 -4.540008 -0.8047637166
2/25/21 124.68 126.459999 120.540001 120.989998 120.604141 148199500 -0.0347826093 3.690002 3.089997 -10.0000926838
2/26/21 122.589996 124.849998 121.199997 121.260002 120.873283 164560400 0.0022316225 1.329994 -0.850006 -0.639568217
3/1/21 123.75 127.93 122.790001 127.790001 127.382462 116307900 0.0538512196 -4.040001 -1.040008 -4.0376084403
3/2/21 128.410004 128.720001 125.010002 125.120003 124.72097 102260900 -0.0208936378 3.290001 3.14 -1.8143564816
3/3/21 124.809998 125.709999 121.839996 122.059998 121.670723 112966300 -0.0244565611 2.75 4.600006 -0.1641339927
3/4/21 121.75 123.599998 118.620003 120.129997 119.74688 178155000 -0.0158119042 1.620003 0.010009 -0.410908
3/5/21 120.980003 121.940002 117.57 121.419998 121.032768 153766600 0.0107383754 -0.439995 -2.080002 -1.2716013489
3/8/21 120.93 121 116.209999 116.360001 115.988907 154376600 -0.0416735059 4.569999 3.979996 -11.3864793918
3/9/21 119.029999 122.059998 118.790001 121.089996 120.703819 129525800 0.0406496645 -2.059997 -0.899994 -1.4507653065
3/10/21 121.690002 122.169998 119.449997 119.980003 119.597374 111943300 -0.009166678 1.709999 4.580002 -1.8300978108
3/11/21 122.540001 123.209999 121.260002 121.959999 121.571045 103026500 0.0165027167 0.580002 -2.169998 -0.6608173455
3/12/21 120.400002 121.169998 119.160004 121.029999 120.644012 88105100 -0.007625451 -0.629997 -1.740005 -2.0861979786
3/15/21 121.410004 124 120.419998 123.989998 123.594574 92403800 0.0244567382 -2.579994 0.150009 3.0952480726
3/16/21 125.699997 127.220001 124.720001 125.57 125.169533 115227900 0.0127429795 0.129997 -1.430008 -1.0503865513
3/17/21 124.050003 125.860001 122.339996 124.760002 124.362122 111932600 -0.0064505694 -0.709999 -0.889999 -6.4616568075
3/18/21 122.879997 123.18 120.32 120.529999 120.145607 121229700 -0.0339051213 2.349998 1.839997 -4.3098609998
3/19/21 119.900002 121.43 119.68 119.989998 119.60733 185549500 -0.0044802207 -0.089996 0.669998 -1.0382962028
3/22/21 120.330002 123.870003 120.260002 123.389999 122.99649 111912300 0.0283357034 -3.059997 -5.720001 33.0014778435
3/23/21 123.330002 124.239998 122.139999 122.540001 122.1492 95467100 -0.0068887106 0.790001 -0.089997 -1.2581705145
3/24/21 122.82 122.900002 120.07 120.089996 119.707008 88530500 -0.0199935122 2.730004 2.389999 2.4556968915
3/25/21 119.540001 121.660004 119 120.589996 120.205414 98844700 0.0041635441 -1.049995 2.960007 -1.3846129896
3/26/21 120.349998 121.480003 118.919998 121.209999 120.823441 94071200 0.0051414132 -0.860001 -4.929993 -0.1809475283
3/29/21 121.650002 122.580002 120.730003 121.389999 121.002861 80819200 0.001485026 0.260003 1.349991 -1.3023287182
3/30/21 120.110001 120.400002 118.860001 119.900002 119.517616 85671900 -0.0122744626 0.209999 1.679993 -0.1923208578
3/31/21 121.650002 123.519997 121.150002 122.150002 121.760445 118323800 0.0187656377 -0.5 -2.86 -3.3809637189
4/1/21 123.660004 124.18 122.489998 123 122.607727 75089100 0.0069586409 0.660004 -3.880005 -2.320008
4/5/21 123.870003 126.160004 123.07 125.900002 125.498489 88651200 0.023577252 -2.029999 -6.310012 -4.0757374198
4/6/21 126.5 127.129997 125.650002 126.209999 125.807495 80171300 0.0024622478 0.290001 -0.25 -1.1428577058
4/7/21 125.830002 127.919998 125.139999 127.900002 127.492104 83466700 0.013390405 -2.07 -2.089996 -8.137906421
4/8/21 128.949997 130.389999 128.520004 130.360001 129.94426 88844600 0.0192337683 -1.410004 -0.479996 -0.3188386473
4/9/21 129.800003 133.039993 129.470001 133 132.575836 106686700 0.0202516031 -3.199997 -2.980011 1.2694949802
4/12/21 132.520004 132.850006 130.630005 131.240005 130.821457 91420000 -0.0132330451 1.279999 -1.199997 -1.4000000625
4/13/21 132.440002 134.660004 131.929993 134.429993 134.001266 91266500 0.0243065215 -1.989991 -1.22998 -2.5546816833
4/14/21 134.940002 135 131.660004 132.029999 131.608932 87222800 -0.0178531141 2.910003 1.890015 -2.4623196788
4/15/21 133.820007 135 133.639999 134.5 134.07106 89347100 0.0187078771 -0.679993 -1.570007 -1.2336743295
4/16/21 134.300003 134.669998 133.279999 134.160004 133.732147 84922400 -0.0025278513 0.139999 -1.269989 -1.2058830017
4/19/21 133.509995 135.470001 133.339996 134.839996 134.409958 94264200 0.0050685151 -1.330001 1.450012 -10.5000750005
4/20/21 135.020004 135.529999 131.809998 133.110001 132.685501 94812300 -0.0128299841 1.910003 -0.440003 -2.4360914014
4/21/21 132.360001 133.75 131.300003 133.5 133.074234 68847100 0.0029299001 -1.139999 -1.639985 -1.5968571777
4/22/21 133.039993 134.149994 131.410004 131.940002 131.519226 84566500 -0.0116853783 1.099991 3.039978 -1.9649052324
4/23/21 132.160004 135.119995 132.160004 134.320007 133.891632 78657500 0.01803854 -2.160003 -3.269989 -2.9636551572
4/26/21 134.830002 135.059998 133.559998 134.720001 134.290359 66905100 0.0029779182 0.110001 0.110016 -1.0509263182
4/27/21 135.009995 135.410004 134.110001 134.389999 133.961395 66015800 -0.0024495398 0.619996 -0.390014 4.6362760339
4/28/21 134.309998 135.020004 133.080002 133.580002 133.153992 107760100 -0.0060272119 0.729996 1.519989 0.1774204995
4/29/21 136.470001 137.070007 132.449997 133.479996 133.054306 151101000 -0.00074866 2.990005 2.950012 3.0959197037
4/30/21 131.779999 133.559998 131.070007 131.460007 131.040756 109839500 -0.0151332714 0.319992 -2.439988 -0.8929794432
5/3/21 132.039993 134.070007 131.830002 132.539993 132.117294 75135100 0.0082153198 -0.5 1.539993 -2.5625390635
5/4/21 131.190002 131.490005 126.699997 127.849998 127.442261 137564700 -0.0353855081 3.340004 3.180008 -7.680008
5/5/21 129.199997 130.449997 127.970001 128.100006 127.691475 84000900 0.0019554791 1.099991 2.589997 -0.6706617717
5/6/21 127.889999 129.75 127.129997 129.740005 129.326233 78128300 0.0128024896 -1.850006 -3.279999 -2.6818373969
5/7/21 130.850006 131.259995 129.479996 130.210007 130.015213 78973300 0.0036226452 0.639999 -0.310013 -1.3459442834
5/10/21 129.410004 129.539993 126.809998 126.849998 126.660225 88071200 -0.0258045374 2.560006 3.690002 3.000015625
5/11/21 123.5 126.269997 122.769997 125.910004 125.721642 126142800 -0.00741028 -2.410004 -1.679993 -1.9414056061
5/12/21 123.400002 124.639999 122.25 122.769997 122.586334 112172300 -0.0249385029 0.630005 3.169998 -1.2614124292
5/13/21 124.580002 126.150002 124.260002 124.970001 124.783043 105861300 0.0179197202 -0.389999 -1.229996 -1.6190411187
5/14/21 126.25 127.889999 125.849998 127.449997 127.259331 81918000 0.0198447306 -1.199997 -2.569992 2.0769232742
5/17/21 126.82 126.93 125.169998 126.269997 126.081093 74244600 -0.009258533 0.550003 1.37001 -1.4583369792
5/18/21 126.559998 126.989998 124.779999 124.849998 124.663223 63342900 -0.0112457356 1.71 3.190002 2.1090739505
5/19/21 123.160004 124.919998 122.860001 124.690002 124.503464 92612000 -0.0012815058 -1.529998 -3.809997 -1.8947356725
5/20/21 125.230003 127.720001 125.099998 127.309998 127.119537 76857100 0.0210120776 -2.079995 -2.519989 0.3594756333
5/21/21 127.82 128 125.209999 125.43 125.242355 79295400 -0.0147670884 2.39 2.400009 -2.1490412237
5/24/21 126.010002 127.940002 125.940002 127.099998 126.909851 63092900 0.0133141832 -1.089996 -2.990006 -1.456065272
5/25/21 127.82 128.320007 126.32 126.900002 126.710159 72009500 -0.0015735327 0.919998 0.050003 -1.8440379598
5/26/21 126.959999 127.389999 126.419998 126.849998 126.660225 56575900 -0.0003940425 0.110001 -0.060012 -0.8804334357
5/27/21 126.440002 127.639999 125.080002 125.279999 125.092575 94625600 -0.0123768153 1.160003 1.86 9.545385951
5/28/21 125.57 125.800003 124.550003 124.610001 124.423584 71311100 -0.0053480045 0.959999 1.320007 -0.1724167955
6/1/21 125.080002 125.349998 123.940002 124.279999 124.09407 67637100 -0.0026482786 0.800003 3.830002 -0.1666626736
6/2/21 124.279999 125.239998 124.050003 125.059998 124.872902 59278900 0.0062761426 -0.779999 0.830002 -1.9749950938
6/3/21 124.68 124.849998 123.129997 123.540001 123.355186 76229200 -0.0121541422 1.139999 -0.490006 -2.4615390533
6/4/21 124.07 126.160004 123.849998 125.889999 125.701668 75169300 0.0190221627 -1.819999 -3.029998 -2.5964917513
6/7/21 126.169998 126.32 124.830002 125.900002 125.711655 71057600 0.0000794583 0.269996 -3.830002 -1.1483495321
6/8/21 126.599998 128.460007 126.209999 126.739998 126.550392 74403800 0.00667193 -0.14 2.589997 -1.5185262004
6/9/21 127.209999 127.75 126.519997 127.129997 126.939812 56877900 0.003077158 0.080002 0.220002 -1.5714428571
6/10/21 127.019997 128.190002 125.940002 126.110001 125.921341 71186400 -0.008023252 0.909996 -2.949997 10.3746656334
6/11/21 126.529999 127.440002 126.099998 127.349998 127.159477 53522400 0.0098326619 -0.819999 0.099975 -1.9011017631
6/14/21 127.82 130.539993 127.07 130.479996 130.28479 96906500 0.0245779195 -2.659996 -1.990021 2.243901517
6/15/21 129.940002 130.600006 129.389999 129.639999 129.44606 62746300 -0.0064377454 0.300003 1.410004 -1.1127832523
6/16/21 130.369995 130.889999 128.460007 130.149994 129.955292 91815000 0.0039339325 0.220001 2.019989 -0.2666706666
6/17/21 129.800003 132.550003 129.649994 131.789993 131.592834 96721700 0.0126008381 -1.98999 -4.829987 -10.0453679756
6/18/21 130.710007 131.509995 130.240005 130.460007 130.264832 108953300 -0.010091707 0.25 0.200012 -1.125628772
6/21/21 130.300003 132.410004 129.210007 132.300003 132.102081 79663300 0.0141039085 -2 -2.809998 -9
6/22/21 132.130005 134.080002 131.619995 133.979996 133.779556 74783600 0.0126983595 -1.849991 -2.790009 -0.0750045
6/23/21 133.770004 134.320007 133.229996 133.699997 133.499985 60214200 -0.0020898568 0.070007 0.720001 -1.0378418057
6/24/21 134.449997 134.639999 132.929993 133.410004 133.210419 68711000 -0.0021689828 1.039993 -0.529998 13.8555573014
6/25/21 133.460007 133.889999 132.809998 133.110001 132.910873 70783700 -0.0022487294 0.350006 1.210022 -0.663453504
6/28/21 133.410004 135.25 133.350006 134.779999 134.578369 62111300 0.0125459995 -1.369995 -2.529999 -4.9142043279
6/29/21 134.800003 136.490005 134.350006 136.330002 136.126053 64556100 0.0115002449 -1.529999 -2.529999 0.1167916671
6/30/21 136.169998 137.410004 135.869995 136.960007 136.755112 63261400 0.0046211765 -0.790009 -0.209992 -0.4836539109
7/1/21 136.600006 137.330002 135.759995 137.270004 137.064651 52485800 0.0022634126 -0.669998 -1.990021 -0.1519109276
7/2/21 137.899994 140 137.75 139.960007 139.750626 78852600 0.0195964371 -2.060013 -4.829987 2.0746554467
7/6/21 140.070007 143.149994 140.070007 142.020004 141.807541 108181800 0.0147184688 -1.949997 0.369995 -0.0534054882
7/7/21 143.539993 144.889999 142.660004 144.570007 144.353729 104911600 0.0179552382 -1.030014 -0.529999 -0.4717868797
7/8/21 141.580002 144.059998 140.669998 143.240005 143.025711 105575500 -0.009199709 -1.660003 -0.520019 0.6116314924
7/9/21 142.75 145.649994 142.649994 145.110001 144.892914 99788400 0.0130549842 -2.360001 -2.220001 0.4216847801
7/12/21 146.210007 146.320007 144 144.5 144.283829 76299700 -0.0042037144 1.710007 1.839997 -1.7245789303
7/13/21 144.029999 147.460007 143.630005 145.639999 145.422119 100827100 0.0078892664 -1.61 -3.460022 -1.9415166137
7/14/21 148.100006 149.570007 147.679993 149.149994 148.926865 127050800 0.0241004877 -1.049988 -0.160004 -0.3478335404
7/15/21 149.240005 150 147.089996 148.479996 148.257874 106820300 -0.0044921088 0.760009 0.970001 -1.7238263675
7/16/21 148.460007 149.759995 145.880005 146.389999 146.17099 93100300 -0.01407595 2.070008 1.320007 1.7236624829
7/19/21 143.75 144.070007 141.669998 142.449997 142.236893 121434600 -0.0269144206 1.300003 1.919983 -0.3719816542
7/20/21 143.460007 147.100006 142.960007 146.149994 145.931351 96350000 0.0259740055 -2.689987 -1.290008 -3.0692159941
7/21/21 145.529999 146.130005 144.630005 145.399994 145.18248 74993500 -0.0051317142 0.130005 -2.5 -1.0483292298
7/22/21 145.940002 148.199997 145.809998 146.800003 146.580383 77338200 0.009628673 -0.860001 -2.300019 -7.6151378793
7/23/21 147.550003 148.720001 146.919998 148.559998 148.337753 71447400 0.0119890665 -1.009995 -2.300018 0.1744114251
7/26/21 148.270004 149.830002 147.699997 148.990005 148.76712 72434100 0.0028945006 -0.720001 -0.049988 -0.2871241937
7/27/21 149.119995 149.210007 145.550003 146.770004 146.55043 104818600 -0.0149003351 2.349991 2.889984 -4.2638718557
7/28/21 144.809998 146.970001 142.539993 144.979996 144.763107 118931200 -0.012196007 -0.169998 2.769989 -1.0723398515
7/29/21 144.690002 146.550003 144.580002 145.639999 145.422119 56699500 0.0045523729 -0.949997 -0.26001 4.5882833916
7/30/21 144.380005 146.330002 144.110001 145.860001 145.641785 70382000 0.0015105878 -1.479996 0.260009 0.557895446
8/2/21 146.360001 146.949997 145.25 145.520004 145.302307 62880000 -0.0023309817 0.839997 1.539978 -1.5675670745
8/3/21 145.809998 148.039993 145.179993 147.360001 147.139542 64660800 0.0126442891 -1.550003 -1.699982 -2.8452482568
8/4/21 147.270004 147.789993 146.279999 146.949997 146.730164 56368300 -0.002782329 0.320007 -0.290009 -1.2064557294
8/5/21 146.979996 147.839996 146.169998 147.059998 146.839996 46397700 0.0007485608 -0.080002 -2.639984 -1.2500007812
8/6/21 146.350006 147.110001 145.630005 146.139999 146.139999 54067400 -0.0062559432 0.210007 -0.949981 -3.6250218745
Average 0.002562118 -0.028518753 -0.1815776042 -1.70000414
Standard Deviation 0.0205381733 18.2542558986
correlation coefficient between the two stocks 0.650933542

MSFT

Date Open High Low Close Adj Close Volume Stock Daily Return Daily Return Index Daily Return
4/8/20 165.669998 166.669998 163.5 165.130005 163.092239 48318200 ERROR:#VALUE! 0.539993 ERROR:#VALUE!
4/9/20 166.360001 167.369995 163.330002 165.139999 163.102097 51385100 0.000060522 1.220002 1.2592922501
4/13/20 164.350006 165.570007 162.300003 165.509995 163.467514 41905300 0.002240499 -1.159989 -1.950809097
4/14/20 169 173.75 168 173.699997 171.556458 52874300 0.0494834285 -4.699997 3.0517599736
4/15/20 171.199997 173.570007 169.240005 171.880005 169.758926 40940800 -0.0104777895 -0.680008 -0.8553173545
4/16/20 174.300003 177.279999 172.899994 177.039993 174.85524 50479600 0.0300208742 -2.73999 3.0293496547
4/17/20 179.5 180 175.869995 178.600006 176.395996 52765600 0.0088116418 0.899994 -1.3284661623
4/20/20 176.630005 178.75 174.990005 175.059998 172.899673 36669600 -0.0198208728 1.570007 0.744463852
4/21/20 173.5 173.669998 166.110001 167.820007 165.749039 56203700 -0.041357198 5.679993 2.6178138059
4/22/20 171.389999 174 170.820007 173.520004 171.378693 34620200 0.0339649432 -2.130005 -1.3750013424
4/23/20 174.110001 175.059998 170.910004 171.419998 169.304611 32790800 -0.0121023856 2.690003 -2.262909242
4/24/20 172.059998 174.559998 170.710007 174.550003 172.395981 34277600 0.0182592757 -2.490005 -1.925651384
4/27/20 176.589996 176.899994 173.300003 174.050003 171.902145 33194400 -0.0028645087 2.539993 -2.0200754617
4/28/20 175.589996 175.669998 169.389999 169.809998 167.714462 34392700 -0.0243608442 5.779998 1.2755960351
4/29/20 173.220001 177.679993 171.880005 177.429993 175.240417 51286600 0.0448736534 -4.209992 -1.7283725704
4/30/20 180 180.399994 176.229996 179.210007 176.998489 53875900 0.0100322046 0.789993 -1.1876471499
5/1/20 175.800003 178.639999 174.009995 174.570007 172.415741 39370500 -0.0258914113 1.229996 0.556970758
5/4/20 174.490005 179 173.800003 178.839996 176.633041 30372900 0.024460038 -4.349991 -4.5365895499
5/5/20 180.619995 183.649994 179.899994 180.759995 178.529343 36839200 0.0107358479 -0.14 -0.9678160254
5/6/20 182.080002 184.199997 181.630005 182.539993 180.287384 32139300 0.0098473006 -0.459991 2.28565
5/7/20 184.169998 184.550003 182.580002 183.600006 181.334305 28316000 0.0058070179 0.569992 -2.2391372875
5/8/20 184.979996 185 183.360001 184.679993 182.40097 30877800 0.0058822819 0.300003 -0.4736715603
5/11/20 183.149994 187.509995 182.850006 186.740005 184.435562 30892700 0.0111544947 -3.590011 -12.9665836675
5/12/20 186.800003 187.039993 182.300003 182.509995 180.257736 32038200 -0.0226518683 4.290008 -2.1949846393
5/13/20 182.550003 184.050003 176.539993 179.75 177.531815 44711500 -0.0151224321 2.800003 -0.3473198651
5/14/20 177.539993 180.690002 175.679993 180.529999 178.302185 41873900 0.0043393547 -2.990006 -2.0678581416
5/15/20 179.059998 187.059998 177 183.160004 180.89975 46610400 0.0145682436 -4.100006 0.3712367132
5/18/20 185.75 186.199997 183.960007 184.910004 182.628143 35264500 0.0095544877 0.839996 -1.2048767734
5/19/20 185.029999 186.600006 183.490005 183.630005 181.363937 26799100 -0.006922281 1.399994 0.6666674603
5/20/20 184.809998 185.850006 183.940002 185.660004 183.879578 31261300 0.0110548328 -0.850006 -1.6071497449
5/21/20 185.399994 186.669998 183.289993 183.429993 181.670944 29119500 -0.0120112623 1.970001 -3.3176318755
5/22/20 183.190002 184.460007 182.539993 183.509995 181.750183 20826900 0.0004361446 -0.319993 -1.1624329125
5/26/20 186.339996 186.5 181.100006 181.570007 179.828796 36073600 -0.0105715659 4.769989 -15.9065417056
5/27/20 180.199997 181.990005 176.600006 181.809998 180.066498 39517100 0.0013217546 -1.610001 -1.3375271935
5/28/20 180.740005 184.149994 180.380005 181.399994 179.660416 33810200 -0.0022551235 -0.659989 -0.5900691987
5/29/20 182.729996 184.270004 180.410004 183.25 181.492691 42130400 0.0101984899 -0.520004 -0.2121020199
6/1/20 182.539993 183 181.460007 182.830002 181.076721 22622400 -0.00229194 -0.290009 -0.4422946747
6/2/20 184.25 185 181.350006 184.910004 183.136765 30794600 0.0113766995 -0.660004 1.2758052336
6/3/20 184.820007 185.940002 183.580002 185.360001 183.582458 27311000 0.0024336001 -0.539994 -0.1818322313
6/4/20 184.300003 185.839996 182.300003 182.919998 181.165863 28761800 -0.0131635897 1.380005 -3.5555932103
6/5/20 182.619995 187.729996 182.009995 187.199997 185.4048 39893600 0.0233982017 -4.580002 -4.3188300042
6/8/20 185.940002 188.550003 184.440002 188.360001 186.55368 33211600 0.0061966027 -2.419999 -0.4716161696
6/9/20 188 190.699997 187.259995 189.800003 187.979889 29783900 0.0076449458 -1.800003 -0.2561968001
6/10/20 191.130005 198.520004 191.009995 196.839996 194.952362 43872300 0.037091638 -5.709991 2.1722119352
6/11/20 193.130005 195.759995 186.070007 186.270004 184.483734 52854700 -0.0536983957 6.860001 -2.2014031195
6/12/20 190.539993 191.720001 185.179993 187.740005 185.939621 43373600 0.0078917752 2.799988 -0.5918385435
6/15/20 184.580002 190.820007 184.009995 188.940002 187.128113 32770200 0.0063918023 -4.36 -2.5571495306
6/16/20 192.889999 195.580002 191.460007 193.570007 191.713745 42556700 0.0245051601 -0.680008 -0.8440348624
6/17/20 195.029999 196.320007 193.690002 194.240005 192.377289 25687800 0.0034612697 0.789994 -2.1617422148
6/18/20 194 196.490005 194 196.320007 194.437363 23061600 0.010708412 -2.320007 -3.9367400259
6/19/20 198.589996 199.289993 194.369995 195.149994 193.278564 44441100 -0.0059597237 3.440002 -2.4827550089
6/22/20 195.789993 200.759995 195.229996 200.570007 198.646606 32818900 0.027773575 -4.780014 -2.3895381456
6/23/20 202.089996 203.949997 201.429993 201.910004 199.97374 30917400 0.0066809441 0.179992 -1.0376551198
6/24/20 201.600006 203.25 196.559998 197.839996 195.94278 36740600 -0.0201575351 3.76001 19.8898728832
6/25/20 197.800003 200.610001 195.470001 200.339996 198.418793 27803900 0.0126364742 -2.539993 -1.6755282566
6/26/20 199.729996 199.889999 194.880005 196.330002 194.447235 54675800 -0.0200159433 3.399994 -2.338584004
6/29/20 195.779999 198.529999 193.550003 198.440002 196.537018 26701600 0.0107472112 -2.660003 -1.7823552042
6/30/20 197.880005 204.399994 197.740005 203.509995 201.558395 34310300 0.0255492489 -5.62999 1.1165352069
7/1/20 203.139999 206.350006 201.770004 204.699997 202.736984 32061200 0.0058473885 -1.559998 -0.7229128293
7/2/20 205.679993 208.020004 205 206.259995 204.282013 29315800 0.007620899 -0.580002 -0.6282033695
7/6/20 208.830002 211.130005 208.089996 210.699997 208.679443 31897600 0.0215262392 -1.869995 2.2241181927
7/7/20 210.449997 214.669998 207.990005 208.25 206.25293 33600700 -0.0116278929 2.199997 -2.1764721296
7/8/20 210.070007 213.259995 208.690002 212.830002 210.789032 33600000 0.0219928067 -2.759995 -2.2545448926
7/9/20 216.330002 216.380005 211.470001 214.320007 212.26474 33121700 0.0070009162 2.009995 -1.7282603773
7/10/20 213.619995 214.080002 211.080002 213.669998 211.620972 26177600 -0.00303289 -0.050003 -1.0248771763
7/13/20 214.479996 215.800003 206.5 207.070007 205.084259 38135600 -0.0308887119 7.409989 -149.1908885467
7/14/20 206.130005 208.850006 202.029999 208.350006 206.351974 37591800 0.0061814795 -2.220001 -1.2995957214
7/15/20 209.559998 211.330002 205.029999 208.039993 206.044937 32179400 -0.0014879433 1.520005 -1.6846866285
7/16/20 205.399994 205.699997 202.309998 203.919998 201.964462 29940700 -0.0198038605 1.479996 -0.0263216239
7/17/20 204.470001 205.039993 201.389999 202.880005 200.934448 31635300 -0.005100005 1.589996 0.0743245252
7/20/20 205 212.300003 203.009995 211.600006 209.570831 36884800 0.0429810764 -6.600006 -5.1509576125
7/21/20 213.660004 213.940002 208.029999 208.75 206.748154 37990400 -0.013468837 4.910004 -1.7439393237
7/22/20 209.199997 212.300003 208.389999 211.75 209.71936 49605700 0.0143712575 -2.550003 -1.5193484567
7/23/20 207.190002 210.919998 202.149994 202.539993 200.597687 67457000 -0.0434947202 4.650009 -2.8235307958
7/24/20 200.419998 202.860001 197.509995 201.300003 199.369598 39827000 -0.0061221983 -0.880005 -1.1892480208
7/27/20 201.470001 203.970001 200.860001 203.850006 201.895142 30160900 0.0126676749 -2.380005 1.7045357697
7/28/20 203.610001 204.699997 201.740005 202.020004 200.082703 23251400 -0.0089771987 1.589997 -1.6680645629
7/29/20 202.5 204.649994 202.009995 204.059998 202.103119 19632600 0.0100979802 -1.559998 -1.9811326688
7/30/20 201 204.460007 199.570007 203.899994 201.944656 25079600 -0.0007841027 -2.899994 0.8589728961
7/31/20 204.399994 205.100006 199.009995 205.009995 203.044006 51044000 0.0054438501 -0.610001 -0.7896543924
8/3/20 211.520004 217.639999 210.440002 216.539993 214.46344 78983000 0.0562411506 -5.019989 7.229476673
8/4/20 214.169998 214.770004 210.309998 213.289993 211.244598 49280100 -0.0150087748 0.880005 -1.1753001849
8/5/20 214.899994 215 211.570007 212.940002 210.897964 28806400 -0.0016409162 1.959992 1.2272509815
8/6/20 212.339996 216.369995 211.550003 216.350006 214.275269 32656800 0.0160139193 -4.01001 -3.0459318201
8/7/20 214.850006 215.699997 210.929993 212.479996 210.442368 27820400 -0.0178877277 2.37001 -1.5910234638
8/10/20 211.669998 211.880005 206.350006 208.25 206.25293 36716500 -0.0199077376 3.419998 0.4430310421
8/11/20 207.160004 207.649994 203.139999 203.380005 201.429657 36446500 -0.0233853301 3.779999 0.1052635119
8/12/20 205.289993 210.279999 204.75 209.190002 207.183945 28013100 0.0285671986 -3.900009 -2.0317486856
8/13/20 209.440002 211.350006 208.149994 208.699997 206.698624 22588900 -0.0023423921 0.740005 -1.1897444339
8/14/20 208.759995 209.589996 207.509995 208.899994 206.896698 17958900 0.000958299 -0.139999 -1.1891865596
8/17/20 209.600006 211.190002 208.919998 210.279999 208.263489 20184800 0.0066060557 -0.679993 3.8571275509
8/18/20 210.529999 212.360001 209.210007 211.490005 209.461884 21336200 0.005754261 -0.960006 0.4117880625
8/19/20 211.490005 212.100006 209.25 209.699997 208.191086 27627600 -0.0084637948 1.790008 -2.864580013
8/20/20 209.539993 215 208.910004 214.580002 213.035965 26981500 0.0232713642 -5.040009 -3.8156349022
8/21/20 213.860001 216.25 212.850006 213.020004 211.487198 36249300 -0.0072700065 0.839997 -1.1666657738
8/24/20 214.789993 215.520004 212.429993 213.690002 212.152374 25460100 0.0031452351 1.099991 0.3095177721
8/25/20 213.100006 216.610001 213.100006 216.470001 214.912384 23043700 0.0130094949 -3.369995 -4.0636568845
8/26/20 217.880005 222.089996 217.360001 221.149994 219.558701 39600800 0.0216195915 -3.269989 -0.0296754149
8/27/20 222.889999 231.149994 219.399994 226.580002 224.949631 57602200 0.0245535073 -3.690003 0.1284450804
8/28/20 228.179993 230.639999 226.580002 228.910004 227.262863 26292900 0.0102833524 -0.730011 -0.8021652015
8/31/20 227 228.699997 224.309998 225.529999 223.907166 28774200 -0.01476565 1.470001 -3.013669657
9/1/20 225.509995 227.449997 224.429993 227.270004 225.634674 25725500 0.007715182 -1.760009 -2.1972842195
9/2/20 227.970001 232.860001 227.350006 231.649994 229.983139 34080800 0.0192721869 -3.679993 1.0908944216
9/3/20 229.270004 229.309998 214.960007 217.300003 215.73642 58400300 -0.0619468654 11.970001 -4.2527238503
9/4/20 215.100006 218.360001 205.190002 214.25 212.708359 59664100 -0.0140359087 0.850006 -0.9289886442
9/8/20 206.5 210.029999 202.199997 202.660004 201.201736 52924300 -0.0540956639 3.839996 3.5176104639
9/9/20 207.600006 214.839996 206.699997 211.289993 209.769638 45679000 0.0425835825 -3.689987 -1.9609351156
9/10/20 213.399994 214.740005 204.110001 205.369995 203.892227 35461500 -0.0280183548 8.029999 -3.1761591572
9/11/20 207.199997 208.630005 201.240005 204.029999 202.56189 33620100 -0.0065247896 3.169998 -0.605230586
9/14/20 204.240005 209.199997 204.029999 205.410004 203.931946 30375800 0.0067637358 -1.169999 -1.3690850909
9/15/20 208.419998 209.779999 206.929993 208.779999 207.27771 21823900 0.0164061873 -0.360001 -0.6923065746
9/16/20 210.619995 210.649994 204.639999 205.050003 203.574539 26328100 -0.0178656769 5.569992 -16.4721570218
9/17/20 200.050003 204.330002 199.960007 202.910004 201.449951 34011300 -0.0104364739 -2.860001 -1.513465908
9/18/20 202.800003 203.649994 196.25 200.389999 198.948074 55225300 -0.0124193236 2.410004 -1.8426584466
9/21/20 197.190002 202.710007 196.380005 202.539993 201.082596 39839700 0.0107290484 -5.349991 -3.2199095935
9/22/20 205.059998 208.100006 202.080002 207.419998 205.927475 33517100 0.0240940316 -2.36 -0.5588777626
9/23/20 207.899994 208.100006 200.029999 200.589996 199.146637 30803800 -0.0329283679 7.309998 -4.0974567797
9/24/20 199.850006 205.570007 199.199997 203.190002 201.727921 31202500 0.012961793 -3.339996 -1.4569079225
9/25/20 203.550003 209.039993 202.539993 207.820007 206.324615 29437300 0.0227865788 -4.270004 0.2784458425
9/28/20 210.880005 212.570007 208.059998 209.440002 207.932953 32004900 0.0077951831 1.440003 -1.3372369206
9/29/20 209.350006 210.070007 206.809998 207.259995 205.768631 24221900 -0.0104087423 2.090011 0.451393504
9/30/20 207.729996 211.979996 206.539993 210.330002 208.816544 33829100 0.0148123472 -2.600006 -2.2440154621
10/1/20 213.490005 213.990005 211.320007 212.460007 210.931229 27158400 0.0101269671 1.029998 -1.3961521627
10/2/20 208 210.990005 205.539993 206.190002 204.70636 33154800 -0.02951146 1.809998 0.7572830239
10/5/20 207.220001 210.410004 206.979996 210.380005 208.866211 21331600 0.0203210774 -3.160004 -2.7458604927
10/6/20 208.820007 210.179993 204.820007 205.910004 204.42836 28554300 -0.0212472711 2.910003 -1.9208858596
10/7/20 207.059998 210.110001 206.720001 209.830002 208.320145 25681100 0.0190374335 -2.770004 -1.9518904276
10/8/20 210.509995 211.190002 208.320007 210.580002 209.064774 19925800 0.003574322 -0.070007 -0.9747267513
10/9/20 211.229996 215.860001 211.229996 215.809998 214.257126 26458000 0.0248361475 -4.580002 64.4220577942
10/12/20 218.789993 223.860001 216.809998 221.399994 219.806885 40461400 0.0259023959 -2.610001 -0.4301310349
10/13/20 222.720001 225.210007 220.429993 222.860001 221.256378 28950800 0.0065944311 -0.14 -0.9463601738
10/14/20 223 224.220001 219.130005 220.860001 219.270782 23421700 -0.0089742439 2.139999 -16.2857071429
10/15/20 217.100006 220.360001 216.009995 219.660004 218.079422 22733100 -0.0054332926 -2.559998 -2.1962613067
10/16/20 220.149994 222.289993 219.320007 219.660004 218.079422 26057900 0 0.48999 -1.1914024933
10/19/20 220.419998 222.300003 213.720001 214.220001 212.678558 27625800 -0.02476556 6.199997 11.6533133329
10/20/20 215.800003 217.369995 213.089996 214.649994 213.105469 22753500 0.0020072495 1.150009 -0.8145145877
10/21/20 213.119995 216.919998 213.119995 214.800003 213.254395 22724900 0.000698854 -1.680008 -2.4608650889
10/22/20 213.929993 216.059998 211.699997 214.889999 213.34375 22351500 0.0004189758 -0.960006 -0.4285705782
10/23/20 215.029999 216.279999 213.160004 216.229996 214.674103 18879600 0.0062357346 -1.199997 0.2499890626
10/26/20 213.850006 216.339996 208.100006 210.080002 208.568359 37111600 -0.0284419096 3.770004 -4.1416778542
10/27/20 211.589996 214.669998 210.330002 213.25 211.715546 36700300 0.0150894801 -1.660004 -1.4403188962
10/28/20 207.669998 208.839996 202.100006 202.679993 201.221588 51195600 -0.0495662696 4.990005 -4.006019865
10/29/20 204.070007 207.360001 203.369995 204.720001 203.246918 31432600 0.0100651671 -0.649994 -1.1302591881
10/30/20 203.5 204.289993 199.619995 202.470001 201.013123 36953700 -0.0109906213 1.029999 -2.5846284735
11/2/20 204.289993 205.279999 200.119995 202.330002 200.874115 30842200 -0.0006914555 1.959991 0.902905731
11/3/20 203.889999 208.119995 203.119995 206.429993 204.944611 27512000 0.0202638806 -2.539994 -2.2959212568
11/4/20 214.020004 218.320007 212.419998 216.389999 214.832947 42311800 0.0482488317 -2.369995 -0.0669288983
11/5/20 222.039993 224.119995 221.149994 223.289993 221.683304 36080100 0.0318868433 -1.25 -0.4725727269
11/6/20 222.259995 224.360001 218.029999 223.720001 222.110214 25231900 0.0019257827 -1.460006 0.1680048
11/9/20 224.440002 228.119995 217.880005 218.389999 216.818542 44395000 -0.0238244322 6.050003 -5.1438206418
11/10/20 214.5 216.5 209.720001 211.009995 209.491653 44045100 -0.0337927745 3.490005 -0.4231399555
11/11/20 212.389999 218.039993 212.199997 216.550003 214.991806 29440800 0.0262547184 -4.160004 -2.1919765158
11/12/20 217.210007 219.110001 214.460007 215.440002 213.889786 21593900 -0.0051258415 1.770005 -1.425481562
11/13/20 216.360001 217.419998 214.160004 216.509995 214.952087 18621100 0.0049665475 -0.149994 -1.0847421335
11/16/20 214.869995 217.740005 214.520004 217.229996 215.666901 24953300 0.0033254862 -2.360001 14.7339693588
11/17/20 216.100006 217.679993 214.080002 214.460007 212.91684 24154100 -0.0127514112 1.639999 -1.6949145361
11/18/20 213.649994 215.169998 210.929993 211.080002 210.109802 28372800 -0.0157605376 2.569992 0.5670692482
11/19/20 211.380005 213.029999 209.929993 212.419998 211.443649 24792700 0.006348285 -1.039993 -1.4046677966
11/20/20 212.199997 213.289993 210 210.389999 209.422974 22843100 -0.0095565343 1.809998 -2.7403944065
11/23/20 210.949997 212.289993 208.160004 210.110001 209.144257 25683500 -0.0013308522 0.839996 -0.5359132994
11/24/20 209.589996 214.25 208.860001 213.860001 212.877014 33979700 0.0178477939 -4.270005 -6.0833634922
11/25/20 215.110001 215.289993 212.460007 213.869995 212.886978 21012900 0.0000467315 1.240006 -1.2903991916
11/27/20 214.850006 216.270004 214.039993 215.229996 214.240707 14512200 0.006359008 -0.37999 -1.3064420656
11/30/20 214.100006 214.759995 210.839996 214.070007 213.086075 33064800 -0.0053895322 0.029999 -1.0789468144
12/1/20 214.509995 217.320007 213.350006 216.210007 215.216232 30904500 0.0099967297 -1.700012 -57.6689556318
12/2/20 214.880005 215.470001 212.800003 215.369995 214.380066 23724500 -0.0038851671 -0.48999 -0.7117726228
12/3/20 214.610001 216.380005 213.649994 214.240005 213.25528 25120900 -0.0052467383 0.369996 -1.7551092879
12/4/20 214.220001 215.380005 213.179993 214.360001 213.374725 24666000 0.0005601008 -0.14 -1.378382469
12/7/20 214.369995 215.539993 212.990005 214.289993 213.305038 24620000 -0.0003265908 0.080002 -1.5714428571
12/8/20 213.970001 216.949997 212.889999 216.009995 215.017136 23284100 0.0080265157 -2.039994 -26.4992875178
12/9/20 215.160004 215.229996 211.210007 211.800003 210.826492 32440600 -0.0194898018 3.360001 -2.647064158
12/10/20 211.770004 213.080002 210.360001 210.520004 209.552383 26733300 -0.0060434324 1.25 -0.6279763012
12/11/20 210.050003 213.320007 209.110001 213.259995 212.27977 30979400 0.0130153475 -3.209992 -3.5679936
12/14/20 213.100006 216.210007 212.880005 214.199997 213.215454 28798400 0.0044077747 -1.099991 -0.657322822
12/15/20 215.169998 215.419998 212.240005 214.130005 213.145798 27000600 -0.00032676 1.039993 -1.9454559174
12/16/20 214.75 220.110001 214.720001 219.279999 218.27211 35023300 0.0240507817 -4.529999 -5.3557975871
12/17/20 219.869995 220.889999 217.919998 219.419998 218.411469 32515800 0.0006384486 0.449997 -1.099337108
12/18/20 218.589996 219.690002 216.020004 218.589996 217.585281 63354900 -0.003782709 0 -1
12/21/20 217.550003 224 217.279999 222.589996 221.566895 37181900 0.0182990991 -5.039993 ERROR:#DIV/0!
12/22/20 222.690002 225.630005 221.850006 223.940002 222.91069 22612200 0.0060649896 -1.25 -0.7519837825
12/23/20 223.110001 223.559998 220.800003 221.020004 220.004105 18699600 -0.0130391979 2.089997 -2.6719976
12/24/20 221.419998 223.610001 221.199997 222.75 221.726166 10550600 0.0078273277 -1.330002 -1.6363655067
12/28/20 224.449997 226.029999 223.020004 224.960007 223.925995 17933500 0.009921468 -0.51001 -0.6165344112
12/29/20 226.309998 227.179993 223.580002 224.149994 223.11972 17403200 -0.0036006978 2.160004 -5.2352189173
12/30/20 225.229996 225.630005 221.470001 221.679993 220.661072 20272300 -0.0110194114 3.550003 0.6435168639
12/31/20 221.699997 223 219.679993 222.419998 221.397675 20942100 0.0033381677 -0.720001 -1.2028170117
1/4/21 222.529999 223 214.809998 217.690002 216.689423 37130100 -0.0212660554 4.839997 -7.7222087192
1/5/21 217.259995 218.520004 215.699997 217.899994 216.898438 23823000 0.0009646378 -0.639999 -1.1322312803
1/6/21 212.169998 216.490005 211.940002 212.25 211.274414 35930700 -0.0259292986 -0.080002 -0.8749966797
1/7/21 214.039993 219.339996 213.710007 218.289993 217.286652 27694500 0.0284569753 -4.25 52.1236719082
1/8/21 218.679993 220.580002 217.029999 219.619995 218.61055 22956200 0.0060928217 -0.940002 -0.7788230588
1/11/21 218.470001 218.910004 216.729996 217.490005 216.490341 23031300 -0.0096985249 0.979996 -2.042546718
1/12/21 216.5 217.100006 213.320007 214.929993 213.942093 23249300 -0.011770711 1.570007 0.6020544982
1/13/21 214.020004 216.759995 213.929993 216.339996 215.345627 20087100 0.0065602896 -2.319992 -2.4776953224
1/14/21 215.910004 217.460007 212.740005 213.020004 212.040878 29480800 -0.0153461776 2.89 -2.2456939507
1/15/21 213.520004 214.509995 212.029999 212.649994 211.672577 31746500 -0.001736973 0.87001 -0.6989584775
1/19/21 213.75 216.979996 212.630005 216.440002 215.445175 30480900 0.0178227515 -2.690002 -4.0919207825
1/20/21 217.699997 225.789993 217.289993 224.339996 223.308853 37777300 0.0364996947 -6.639999 1.46839928
1/21/21 224.699997 226.300003 222.419998 224.970001 223.935959 30709400 0.0028082598 -0.270004 -0.9593367409
1/22/21 227.080002 230.070007 225.800003 225.949997 224.911453 30172700 0.0043561186 1.130005 -5.1851417016
1/25/21 229.119995 229.779999 224.220001 229.529999 228.474991 33152100 0.0158442224 -0.410004 -1.3628337928
1/26/21 231.860001 234.179993 230.080002 232.330002 231.262131 49169600 0.0121988542 -0.470001 0.1463327187
1/27/21 238 240.440002 230.139999 232.899994 231.829514 69870600 0.0024533723 5.100006 -11.8510535084
1/28/21 235.610001 242.639999 235.089996 238.929993 237.831787 49111200 0.0258909367 -3.319992 -1.6509780577
1/29/21 235.990005 238.020004 231.350006 231.960007 230.893845 42503100 -0.0291716662 4.029998 -2.2138577442
2/1/21 235.059998 242.5 232.429993 239.649994 238.548477 33314200 0.0331522106 -4.589996 -2.1389573891
2/2/21 241.300003 242.309998 238.690002 239.509995 238.409119 25916300 -0.0005841811 1.790008 -1.3899802963
2/3/21 239.570007 245.089996 239.259995 243 241.883087 27158100 0.0145714378 -3.429993 -2.9161886427
2/4/21 242.660004 243.240005 240.369995 242.009995 240.897629 25296100 -0.0040740947 0.650009 -1.1895073838
2/5/21 242.229996 243.279999 240.419998 242.199997 241.086761 18054800 0.0007850998 0.029999 -0.9538483313
2/8/21 243.149994 243.679993 240.809998 242.470001 241.35553 22211900 0.0011147977 0.679993 21.6671889063
2/9/21 241.869995 244.759995 241.380005 243.770004 242.649536 23565000 0.0053615004 -1.900009 -3.7941596458
2/10/21 245 245.919998 240.889999 242.820007 241.703918 22186700 -0.0038971038 2.179993 -2.147359302
2/11/21 244.779999 245.149994 242.149994 244.490005 243.366241 15751100 0.006877514 0.289994 -0.8669748022
2/12/21 243.929993 245.300003 242.729996 244.990005 243.863937 16561100 0.0020450734 -1.060012 -4.6552894198
2/16/21 245.029999 246.130005 242.919998 243.699997 242.579865 26728500 -0.0052655536 1.330002 -2.2547046637
2/17/21 241.320007 244.309998 240.940002 244.199997 243.637421 21653500 0.0020517029 -2.87999 -3.1654027588
2/18/21 241.800003 243.929993 240.860001 243.789993 243.228348 16925600 -0.0016789681 -1.98999 -0.3090288508
2/19/21 243.75 243.860001 240.179993 240.970001 240.414856 25262600 -0.0115673001 2.779999 -2.3969914422
2/22/21 237.419998 237.929993 232.399994 234.509995 233.969742 36446900 -0.0268083412 2.910003 0.0467640456
2/23/21 230.330002 234.830002 228.729996 233.270004 232.732605 30228700 -0.0052875827 -2.940002 -2.0103089241
2/24/21 230.009995 235.199997 229 234.550003 234.009659 26339700 0.0054871993 -4.540008 0.5442193577
2/25/21 232.080002 234.589996 227.880005 228.990005 228.462463 39542200 -0.0237049581 3.089997 -1.68061488
2/26/21 231.529999 235.369995 229.539993 232.380005 231.84465 37819200 0.0148041396 -0.850006 -1.275083115
3/1/21 235.899994 237.470001 233.149994 236.940002 236.39415 25324000 0.0196230179 -1.040008 0.2235301868
3/2/21 237.009995 237.300003 233.449997 233.869995 233.331207 22812500 -0.0129568962 3.14 -4.0192075446
3/3/21 232.160004 233.580002 227.259995 227.559998 227.035751 34029500 -0.026980789 4.600006 0.4649700637
3/4/21 226.740005 232.490005 224.259995 226.729996 226.207657 44727800 -0.0036473985 0.010009 -0.9978241333
3/5/21 229.520004 233.270004 226.460007 231.600006 231.066452 41872800 0.021479337 -2.080002 -208.8131681487
3/8/21 231.369995 233.369995 227.130005 227.389999 226.86615 35267400 -0.0181779227 3.979996 -2.9134577755
3/9/21 232.880005 235.380005 231.669998 233.779999 233.241425 33080500 0.0281014997 -0.899994 -1.226129373
3/10/21 237 237 232.039993 232.419998 231.884552 29746800 -0.0058174395 4.580002 -6.0889250373
3/11/21 234.960007 239.169998 234.309998 237.130005 236.58371 29907600 0.0202650677 -2.169998 -1.4737984831
3/12/21 234.009995 235.820007 233.229996 235.75 235.206879 22653700 -0.0058196136 -1.740005 -0.1981536389
3/15/21 234.960007 235.190002 231.809998 234.809998 234.269043 26034900 -0.0039872831 0.150009 -1.0862118212
3/16/21 236.279999 240.059998 235.940002 237.710007 237.162369 28092200 0.0123504494 -1.430008 -10.5328146978
3/17/21 236.149994 238.550003 233.229996 237.039993 236.493912 29562100 -0.0028186192 -0.889999 -0.3776265587
3/18/21 232.559998 234.190002 230.330002 230.720001 230.188477 34833000 -0.0266621338 1.839997 -3.0674146825
3/19/21 231.020004 232.470001 229.350006 230.350006 229.819336 46430700 -0.0016036538 0.669998 -0.6358700585
3/22/21 230.270004 236.899994 230.139999 235.990005 235.446335 30127000 0.0244844752 -5.720001 -9.53734041
3/23/21 237.490005 241.050003 237.070007 237.580002 237.032669 31638400 0.0067375608 -0.089997 -0.9842662615
3/24/21 237.850006 238 235.320007 235.460007 234.917557 25620100 -0.0089232889 2.389999 -27.5564296588
3/25/21 235.300003 236.940002 231.570007 232.339996 231.804733 34061900 -0.0132507046 2.960007 0.2384971709
3/26/21 231.550003 236.710007 231.550003 236.479996 235.935196 25479900 0.0178187143 -4.929993 -2.6655342369
3/29/21 236.589996 236.800003 231.880005 235.240005 234.698059 25227500 -0.0052435344 1.349991 -1.2738322347
3/30/21 233.529999 233.850006 231.100006 231.850006 231.315872 24792000 -0.0144108099 1.679993 0.2444475556
3/31/21 232.910004 239.100006 232.389999 235.770004 235.226837 43623500 0.0169074742 -2.86 -2.7023880457
4/1/21 238.470001 242.839996 238.050003 242.350006 241.791687 30338000 0.027908563 -3.880005 0.3566451049
4/5/21 242.759995 249.960007 242.699997 249.070007 248.496201 36910600 0.0277284953 -6.310012 0.6262896568
4/6/21 247.610001 249.399994 246.880005 247.860001 247.288986 22931900 -0.004858096 -0.25 -0.960380424
4/7/21 247.809998 250.929993 247.190002 249.899994 249.32428 22719800 0.0082304244 -2.089996 7.359984
4/8/21 252.770004 254.139999 252 253.25 252.666565 23625200 0.0134053865 -0.479996 -0.7703364026
4/9/21 252.869995 255.990005 252.440002 255.850006 255.26059 24326800 0.0102665587 -2.980011 5.2084079867
4/12/21 254.710007 257.670013 254.619995 255.910004 255.32045 27148700 0.0002345046 -1.199997 -0.5973179294
4/13/21 257.26001 259.190002 256.829987 258.48999 257.894501 23837500 0.0100816145 -1.22998 0.0249858958
4/14/21 257.480011 258.829987 255.160004 255.589996 255.001175 23070900 -0.0112189799 1.890015 -2.5366225467
4/15/21 257.929993 259.929993 257.730011 259.5 258.902161 25627500 0.015297954 -1.570007 -1.8306849417
4/16/21 259.470001 261 257.600006 260.73999 260.139313 24878600 0.0047783815 -1.269989 -0.1910934155
4/19/21 260.190002 261.480011 257.820007 258.73999 258.143921 23209300 -0.0076704766 1.450012 -2.1417516215
4/20/21 257.820007 260.200012 256.839996 258.26001 257.665039 19722900 -0.0018550669 -0.440003 -1.3034478335
4/21/21 258.940002 260.679993 257.25 260.579987 259.979675 24030400 0.0089831058 -1.639985 2.7272132235
4/22/21 260.209991 261.779999 255.639999 257.170013 256.577545 25606200 -0.0130860932 3.039978 -2.8536620762
4/23/21 257.880005 261.51001 257.269989 261.149994 260.54837 21462600 0.0154760695 -3.269989 -2.0756620607
4/26/21 261.660004 262.440002 260.170013 261.549988 260.947449 19763300 0.0015316638 0.110016 -1.0336441499
4/27/21 261.579987 263.190002 260.119995 261.970001 261.366486 31014200 0.0016058613 -0.390014 -4.5450661722
4/28/21 256.079987 256.540009 252.949997 254.559998 253.973541 46903100 -0.0282856929 1.519989 -4.8972677904
4/29/21 255.460007 256.100006 249 252.509995 251.928268 40589000 -0.0080531231 2.950012 0.9408114138
4/30/21 249.740005 253.080002 249.600006 252.179993 251.59903 30945100 -0.0013068869 -2.439988 -1.8271112118
5/3/21 253.399994 254.350006 251.119995 251.860001 251.27977 19626600 -0.0012689032 1.539993 -1.6311477761
5/4/21 250.970001 251.210007 245.759995 247.789993 247.219147 32756100 -0.016159803 3.180008 1.0649496459
5/5/21 249.059998 249.5 245.820007 246.470001 245.902191 21901300 -0.0053270594 2.589997 -0.1855375836
5/6/21 246.449997 249.860001 244.690002 249.729996 249.154678 26491100 0.0132267415 -3.279999 -2.2664103472
5/7/21 252.149994 254.300003 251.169998 252.460007 251.878387 27032900 0.0109318506 -0.310013 -0.9054838126
5/10/21 250.869995 251.729996 247.119995 247.179993 246.61055 29299900 -0.0209142591 3.690002 -12.9027331112
5/11/21 244.550003 246.600006 242.570007 246.229996 245.662735 33641600 -0.003843341 -1.679993 -1.4552824091
5/12/21 242.169998 244.380005 238.070007 239 238.449402 36684400 -0.0293627751 3.169998 -2.8869114336
5/13/21 241.800003 245.600006 241.419998 243.029999 242.470108 29624300 0.0168619205 -1.229996 -1.3880116013
5/14/21 245.580002 249.179993 245.490005 248.149994 247.578308 23901100 0.0210673375 -2.569992 1.0894311851
5/17/21 246.550003 246.589996 243.520004 245.179993 244.615158 24970200 -0.0119685717 1.37001 -1.5330794804
5/18/21 246.270004 246.410004 242.899994 243.080002 242.520004 20168000 -0.0085650994 3.190002 1.3284516171
5/19/21 239.309998 243.229996 238.600006 243.119995 243.119995 25739800 0.0001645261 -3.809997 -2.1943556775
5/20/21 243.960007 247.949997 243.860001 246.479996 246.479996 21800700 0.01382034 -2.519989 -0.3385850435
5/21/21 247.570007 248.330002 244.740005 245.169998 245.169998 21863100 -0.0053148248 2.400009 -1.9523886811
5/24/21 247.789993 251.160004 247.509995 250.779999 250.779999 21411500 0.0228820861 -2.990006 -2.2458311615
5/25/21 251.770004 252.75 250.820007 251.720001 251.720001 17704300 0.0037483133 0.050003 -1.0167233778
5/26/21 251.429993 252.940002 250.75 251.490005 251.490005 17771600 -0.0009136978 -0.060012 -2.2001679899
5/27/21 251.169998 251.479996 249.25 249.309998 249.309998 24426200 -0.0086683644 1.86 -31.9938012398
5/28/21 251 252.080002 249.559998 249.679993 249.679993 18270200 0.0014840761 1.320007 -0.2903188172
6/1/21 251.229996 251.289993 246.960007 247.399994 247.399994 23213300 -0.0091316848 3.830002 1.9015012799
6/2/21 248.130005 249.270004 245.839996 247.300003 247.300003 19406700 -0.0004041674 0.830002 -0.7832894082
6/3/21 245.220001 246.339996 243 245.710007 245.710007 25307700 -0.0064294217 -0.490006 -1.5903672521
6/4/21 247.759995 251.649994 247.509995 250.789993 250.789993 25281100 0.0206747216 -3.029998 5.1835936703
6/7/21 249.979996 254.089996 249.809998 253.809998 253.809998 23079200 0.0120419677 -3.830002 0.264027897
6/8/21 255.160004 256.01001 252.509995 252.570007 252.570007 22455000 -0.0048855089 2.589997 -1.6762390725
6/9/21 253.809998 255.529999 253.210007 253.589996 253.589996 17937600 0.0040384407 0.220002 -0.9150570445
6/10/21 254.289993 257.459991 253.669998 257.23999 257.23999 24563600 0.0143932886 -2.949997 -14.4089553731
6/11/21 257.98999 258.48999 256.609985 257.890015 257.890015 18999700 0.0025269205 0.099975 -1.033889865
6/14/21 257.899994 259.950012 256.799988 259.890015 259.890015 19150500 0.007755244 -1.990021 -20.9051862966
6/15/21 259.769989 259.98999 257.679993 258.359985 258.359985 18038900 -0.0058872212 1.410004 -1.7085372466
6/16/21 259.399994 260.579987 254.419998 257.380005 257.380005 27220000 -0.0037930796 2.019989 0.4326122479
6/17/21 256.070007 261.75 256.01001 260.899994 260.899994 27565500 0.0136762333 -4.829987 -3.3910956941
6/18/21 259.630005 262.299988 258.75 259.429993 259.429993 37202200 -0.0056343466 0.200012 -1.0414104634
6/21/21 259.820007 263.519989 257.920013 262.630005 262.630005 26696100 0.0123347804 -2.809998 -15.0491470512
6/22/21 262.720001 265.790009 262.399994 265.51001 265.51001 24694100 0.0109660166 -2.790009 -0.0071135282
6/23/21 265.98999 266.829987 264.429993 265.269989 265.269989 19518700 -0.0009039998 0.720001 -1.2580640421
6/24/21 266.160004 267.850006 265.470001 266.690002 266.690002 21446900 0.0053530858 -0.529998 -1.736107311
6/25/21 266.230011 267.25 264.76001 265.019989 265.019989 25611100 -0.0062620008 1.210022 -3.2830689927
6/28/21 266.190002 268.899994 265.910004 268.720001 268.720001 19590000 0.0139612563 -2.529999 -3.0908702486
6/29/21 268.869995 271.649994 267.980011 271.399994 271.399994 19937800 0.0099731802 -2.529999 -0
6/30/21 270.690002 271.359985 269.600006 270.899994 270.899994 21656500 -0.0018422992 -0.209992 -0.9169991767
7/1/21 269.609985 271.839996 269.600006 271.600006 271.600006 16725300 0.0025840237 -1.990021 8.4766514915
7/2/21 272.820007 278 272.5 277.649994 277.649994 26458000 0.0222753603 -4.829987 1.4271035331
7/6/21 278.029999 279.369995 274.299988 277.660004 277.660004 31565600 0.0000360526 0.369995 -1.0766037258
7/7/21 279.399994 280.690002 277.149994 279.929993 279.929993 23260000 0.0081754267 -0.529999 -2.4324490872
7/8/21 276.899994 278.730011 274.869995 277.420013 277.420013 24618600 -0.0089664561 -0.520019 -0.0188302242
7/9/21 275.720001 278.049988 275.320007 277.940002 277.940002 23905500 0.0018743745 -2.220001 3.2690767068
7/12/21 279.160004 279.769989 276.579987 277.320007 277.320007 18931700 -0.0022306793 1.839997 -1.8288271041
7/13/21 277.519989 282.850006 277.390015 280.980011 280.980011 26120100 0.013197764 -3.460022 -2.8804498051
7/14/21 282.350006 283.660004 280.549988 282.51001 282.51001 23113700 0.0054452236 -0.160004 -0.9537563634
7/15/21 282 282.51001 279.829987 281.029999 281.029999 22604200 -0.0052387914 0.970001 -7.0623546911
7/16/21 282.070007 284.100006 279.459991 280.75 280.75 26176100 -0.0009963314 1.320007 0.3608305558
7/19/21 278.929993 280.369995 274.450012 277.01001 277.01001 32935600 -0.0133214248 1.919983 0.4545248624
7/20/21 278.029999 280.970001 276.26001 279.320007 279.320007 26259700 0.008339038 -1.290008 -1.6718851156
7/21/21 278.899994 281.519989 277.290009 281.399994 281.399994 24364300 0.0074466094 -2.5 0.9379724777
7/22/21 283.839996 286.420013 283.420013 286.140015 286.140015 23384100 0.0168444247 -2.300019 -0.0799924
7/23/21 287.369995 289.98999 286.5 289.670013 289.670013 22768100 0.0123366108 -2.300018 -0.0000004348
7/26/21 289 289.690002 286.640015 289.049988 289.049988 23176100 -0.0021404528 -0.049988 -0.978266257
7/27/21 289.429993 289.579987 282.950012 286.540009 286.540009 33604100 -0.0086835465 2.889984 -58.8135552533
7/28/21 288.98999 290.149994 283.829987 286.220001 286.220001 33566900 -0.0011168004 2.769989 -0.0415209911
7/29/21 286.23999 288.619995 286.079987 286.5 286.5 18168300 0.000978265 -0.26001 -1.0938667987
7/30/21 285.170013 286.660004 283.910004 284.910004 284.910004 20940900 -0.0055497243 0.260009 -1.999996154
8/2/21 286.359985 286.769989 283.73999 284.820007 284.820007 16267400 -0.0003158787 1.539978 4.9227872881
8/3/21 285.420013 287.230011 284 287.119995 287.119995 17863200 0.0080752333 -1.699982 -2.1039001856
8/4/21 286.220001 287.589996 284.649994 286.51001 286.51001 16191300 -0.002124495 -0.290009 -0.8294046643
8/5/21 286.880005 289.630005 286.100006 289.519989 289.519989 13900200 0.0105056678 -2.639984 8.1031105931
8/6/21 288.51001 289.5 287.619995 289.459991 289.459991 16585200 -0.0002072327 -0.949981 -0.6401565313
Average -0.1815776042
Standard Deviation 0.0167607054

Portfolio Risk and Return

Company Average Daily return Standard Deviation(S.D) Free Cash Flow Current Stock Value No of Shares Current Market Value Total Market Value Weight of Stocks square of Weight Square of S.D correlation coefficient portfolio risk daily return return
AAPL -0.028518753 0.0205381733 94,768,000 146.139999 500 73069.9995 0.229824408 0.0528192585 0.0004218166 0.00002228 0.0000399735 0.0001045687 -0.028518753
MSFT -0.1815776042 0.0167607054 56,118,000 289.459991 500 144729.9955 0.3881107577 0.1506299602 0.0002809212 0.0000423152 -0.1815776042
217799.995 0.650933542 0.0102258854 -0.0770265271
PORTFOLIO RISK AND RETURN ANALYSIS
Portfolio risk 0.0102258854
Return -0.0770265271

Risk Diversification Analysis

Portfolio compositiom
AAPL 50%
MSFT 50%
AAPL MSFT Portfolio returns Percentage Invested in MSFT Portfolio Standard Deviation Portfolio Expected Return
7/26/21 56.80% 33.42% 0.4511 25% 4.69% 34.33%
7/27/21 48.90% 54.76% 0.5183 50% 5.23% 45.25%
7/28/21 39.98% 47.82% 0.439 30% 4.75% 36.52%
7/29/21 42.78% 38.98% 0.4088 45% 5.08% 43.07%
7/30/21 36.54% 43.56% 0.4005 60% 5.59% 49.62%
8/2/21 65.78% 44.45% 0.55115 55% 5.40% 47.43%
8/3/21 54.86% 37.86% 0.4636 30% 4.75% 36.52%
8/4/21 37.65% 51.98% 0.44815 33% 4.80% 37.83%
8/5/21 44.89% 48.24% 0.46565 48% 5.17% 44.38%
8/6/21 40.10% 35.65% 0.37875 52% 5.30% 46.12%
Expected Return 46.83% 43.67% 45.25%
Standard Deviation 0.0960212453 0.0711732753 0.0522956127
correlation coefficient -0.2448286856

The effect of stock weight (Frontier Portfolio)

4.6939570785804921E-2 5.2295612732916524E-2 4.7528607338691839E-2 5.077276040249265E-2 5.5899297510991375E-2 5.4010343443537501E-2 4.7528607338691839E-2 4.8005345179700731E-2 5.1662448307794664E-2 5.2959476632190576E-2 0.34331999999999996 0.45249999999999996 0.36515599999999998 0.43066399999999999 0.49617199999999989 0.47433600000000009 0.36515599999999998 0.37825760000000003 0.44376559999999998 0.46123440000000004

Standard Deviation

Expected Return