Need to fill Excel file.Simple finance work.

profileigecunil
stocks.xlsx
Home>Business & Finance homework help>Financial markets homework help>Need to fill Excel file.Simple finance work.

Sheet1

Company Name JD.com, Inc. Alibaba Group Holding Limited Alphabet Inc. Amazon.com, Inc. Tencent Holdings Limited Advanced Micro Devices, Inc. Tesla, Inc. Apple Inc. NVIDIA Corporation Facebook
Ticker Symbol JD BABA GOOG AMZN TCTZF AMD TSLA AAPL NVDA FB
Market Cap 63.509B 463.209B 736.878B 669.802B 504.294B 11.163B 56.255B 796.074B 129.502B 526.707B
Closing Price (daily)
1/8/18 46.10 190.33 1106.94 1246.87 56.60 12.28 336.41 174.35 222.00 188.28
1/9/18 46.13 190.80 1106.26 1252.70 57.17 11.82 333.69 174.33 221.94 187.87
1/10/18 46.45 189.79 1102.61 1254.33 56.20 11.96 334.80 174.29 223.68 187.84
1/11/18 46.61 188.75 1105.52 1276.68 55.51 12.14 337.95 175.28 224.08 187.77
1/12/18 46.40 187.79 1122.26 1305.20 57.00 12.02 336.22 177.09 222.98 179.37
1/16/18 46.46 182.40 1121.76 1304.86 56.50 11.91 340.06 176.19 220.11 178.39
1/17/18 46.61 183.83 1131.98 1295.00 57.94 12.18 347.16 179.10 224.72 177.60
1/18/18 45.90 184.40 1129.79 1293.32 57.31 12.47 344.57 179.26 224.44 179.80
1/19/18 46.02 184.05 1137.51 1294.58 58.30 12.59 350.02 178.46 230.11 181.29
1/22/18 45.26 184.02 1155.81 1327.31 59.30 12.65 351.56 177.00 233.69 185.37
1/23/18 45.18 192.28 1169.97 1362.54 60.89 12.94 352.79 177.04 238.91 189.35
1/24/18 46.74 195.53 1164.24 1357.51 60.20 12.71 345.89 174.22 235.80 186.55
1/25/18 47.38 198.33 1170.37 1377.95 59.20 12.41 337.64 171.11 236.35 187.48
1/26/18 50.50 205.22 1175.84 1402.05 61.00 12.95 342.85 171.51 243.33 190.00
1/29/18 49.94 203.01 1175.58 1417.68 59.91 13.32 349.53 167.96 246.85 185.95
1/30/18 49.26 199.66 1163.69 1437.82 58.50 12.87 345.82 166.97 242.72 187.12
1/31/18 49.23 204.29 1169.94 1450.89 59.21 13.74 345.31 167.43 245.80 186.89
2/1/18 47.55 192.22 1167.70 1390.00 58.00 13.25 333.13 167.78 240.50 193.09
2/2/18 46.03 187.31 1111.90 1429.95 55.90 12.45 343.75 160.50 233.52 190.28
2/5/18 44.60 180.53 1055.80 1390.00 53.90 11.57 333.13 156.49 213.70 181.26
2/6/18 45.05 185.17 1080.60 1442.84 55.50 11.65 333.97 163.03 225.58 185.31
2/7/18 44.39 180.30 1048.58 1416.78 53.56 11.60 345.00 159.54 228.80 180.18
2/8/18 42.25 173.70 1001.52 1350.50 51.70 11.22 315.23 155.15 217.52 171.58
2/9/18 42.93 176.67 1037.78 1339.60 52.70 11.31 310.42 156.41 232.08 176.11
2/12/18 43.72 177.44 1051.94 1386.23 53.97 11.68 315.73 162.71 228.03 176.41
2/13/18 44.55 179.25 1052.10 1414.51 54.72 11.78 323.66 164.34 232.63 173.15
2/14/18 46.86 186.76 1069.70 1451.05 56.91 12.20 322.31 167.37 241.42 179.52
2/15/18 47.11 187.45 1089.52 1461.76 58.55 12.19 334.07 172.99 246.50 179.96
2/16/18 46.42 183.68 1094.80 1448.69 58.34 11.82 335.49 172.43 243.84 177.36
2/20/18 46.93 187.19 1102.46 1468.35 57.63 12.02 334.77 171.85 249.08 176.01
2/21/18 47.16 188.82 1111.34 1482.92 58.14 11.72 333.30 171.07 241.51 177.91
2/22/18 47.81 188.75 1106.63 1485.34 57.69 11.84 346.17 172.50 242.15 178.99
2/23/18 48.35 193.29 1126.79 1500.00 58.74 12.07 352.05 175.50 245.93 183.29
2/26/18 18.80 194.19 1143.75 1521.95 58.76 12.42 357.42 178.97 246.58 184.93
2/27/18 47.04 188.26 1118.29 1511.98 56.46 12.53 350.99 178.39 246.06 181.46
2/28/18 47.15 186.14 1104.73 1512.45 54.94 12.11 343.06 178.12 242.00 178.32
3/1/18 46.21 181.99 1069.52 1493.45 55.60 11.90 330.93 175.00 232.21 175.94
3/2/18 43.80 179.76 1078.92 1500.25 55.91 11.81 335.12 176.21 236.54 176.62
3/5/18 42.99 181.60 1090.93 1523.61 55.11 11.91 333.35 176.82 235.65 180.40
3/6/18 43.14 187.37 1095.06 1537.64 56.33 11.76 328.20 176.67 242.16 179.78
3/7/18 44.41 189.05 1109.64 1545.00 56.50 12.24 332.30 175.03 241.84 183.71
3/8/18 45.39 187.18 1126.00 1551.86 56.84 11.97 329.10 176.94 241.18 182.34
3/9/18 45.71 190.55 1160.04 1578.89 58.25 11.70 327.17 179.98 245.33 185.23
3/12/18 46.01 192.74 1164.50 1598.39 58.70 11.52 345.51 181.72 249.76 184.76
3/13/18 44.32 188.41 1138.17 1588.18 57.75 11.64 341.84 179.97 247.71 181.88
3/14/18 44.09 192.56 1149.49 1591.00 58.53 11.36 326.63 178.44 248.74 184.19
3/15/18 44.94 199.06 1149.58 1582.32 59.81 11.46 325.60 178.65 249.34 183.86
3/16/18 44.97 200.28 1135.73 1571.68 59.36 11.47 321.35 178.02 250.48 185.09
3/19/18 44.15 194.53 1099.82 1544.93 58.38 11.43 313.56 175.30 241.00 172.56
3/20/18 44.00 198.95 1097.71 1586.51 59.75 11.11 310.55 175.24 249.58 168.15
3/21/18 43.51 195.30 1090.88 1581.86 58.29 11.26 316.53 171.27 248.56 169.39
3/22/18 52.51 184.65 1049.08 1544.92 52.00 10.91 309.10 168.85 241.85 164.89
3/23/18 40.87 181.20 1021.57 1495.56 52.50 10.63 301.54 164.94 232.97 159.39
3/26/18 41.85 190.50 1053.21 1555.86 55.30 10.44 304.18 172.77 244.48 160.06
3/27/18 40.71 181.89 1005.10 1497.05 53.33 10.00 279.18 168.34 225.52 152.22
3/28/18 40.01 178.91 1004.56 1431.42 52.47 9.81 257.78 166.48 221.35 153.03
3/29/18 40.49 183.54 1031.79 1447.34 53.48 10.05 266.13 167.78 231.59 159.79
4/2/18 39.08 177.61 1006.47 1371.99 51.40 9.53 252.48 166.68 221.05 155.39
4/3/18 38.98 174.67 1013.41 1392.05 52.39 9.55 267.53 168.39 225.35 156.11
4/4/18 39.44 172.07 1025.14 1410.57 52.61 9.77 286.94 171.61 226.24 155.10
4/5/18 40.19 172.57 1027.81 1451.75 52.86 10.02 305.72 172.80 221.38 159.34
4/6/18 39.23 167.52 1007.04 1405.23 50.85 9.61 299.30 168.38 214.25 157.20
4/9/18 40.07 169.87 1015.45 1406.08 52.12 9.53 289.66 170.05 215.41 157.93
4/10/18 40.70 177.10 1031.64 1436.22 53.72 9.98 304.70 173.25 227.91 165.04
4/11/18 40.46 175.36 1019.97 1427.05 53.05 9.82 300.93 172.44 226.24 166.32
4/12/18 40.60 175.92 1032.51 1448.50 53.27 10.08 294.08 174.14 234.60 163.87
4/13/18 39.38 172.04 1029.27 1430.79 51.50 9.93 300.34 174.73 231.50 164.52
4/16/18 39.93 174.70 1037.98 1441.50 51.26 10.09 291.21 175.82 231.49 164.83
4/17/18 40.27 178.70 1074.16 1503.83 51.95 10.52 287.69 178.24 237.54 168.66
4/18/18 40.18 182.68 1072.08 1527.84 51.54 10.36 293.35 177.84 236.37 166.36
4/19/18 38.90 181.39 1087.70 1556.91 51.53 10.11 300.08 172.80 229.04 168.10
4/20/18 37.44 179.11 1072.96 1527.49 50.48 9.99 290.24 165.72 228.71 166.28
4/23/18 37.00 175.57 1067.45 1517.86 50.59 10.04 283.37 165.24 223.88 165.84
4/24/18 35.87 173.09 1019.98 1460.09 49.85 10.09 283.46 162.94 221.20 159.69
4/25/18 35.88 170.22 1021.18 1460.17 49.30 9.71 280.69 163.65 216.66 159.69
4/26/18 36.50 173.90 1040.04 1517.96 49.40 11.04 285.48 164.22 225.22 174.16
4/27/18 36.76 177.16 1030.05 1572.62 49.45 11.11 294.08 162.32 226.33 173.59
4/30/18 36.51 178.54 1017.33 1566.13 49.16 10.88 293.90 165.26 224.90 172.00

Sheet2

Sheet3