Final Project Using Stock Data Collected During the Semester 1. Be sure your data is listed so that each column is a different stock and the rows contain the prices for each day of your collection. Stock 1 Stock 2 Stock 3 Stock 10 1/1/17 1/2/1

profileFin-Acc-Boss
data______stocktracke.xlsx
Home>Business & Finance homework help> Final Project Using Stock Data Collected During the Semester 1. Be sure your data is listed so that each column is a different stock and the rows contain the prices for each day of your collection. Stock 1 Stock 2 Stock 3 Stock 10 1/1/17 1/2/1

Sheet1

Company Name EBAY INC COM APPLE INC COM JD COM INC ADR MICHAEL KORS HOLDINGS COM AMERICAN AIRLINES GROUP INC COM AMAZON.COM INC COM WELLS FARGO &CO COM NORDSTROM INC COM YAHOO! INC COM NIKE INC CL B
Ticker Symbol EBAY APPLE JD MORS AAL AMAZN WFC JWN YHOO NKE
Market Cap 36B 694.75B 41.21B 6.22B 23.49B 391.79B 284.56B 7.9B 43.01B 91.51B
Closing Price Volume
1/25/17 30.23 20,148,200 121.88 32,377,600 28.59 7,459,500 42.80 1,675,700 47.91 5,075,800 836.52 3,922,600 56.62 32,252,075 45.01 1,662,600 44.94 11,082,400 53.86 6,675,000
1/26/17 31.74 32,011,600 121.94 26,337,600 28.32 6,052,100 42.06 1,899,900 49.59 10,332,800 839.15 3,554,700 57.18 23,769,752 44.32 2,705,800 44.55 9,972,700 53.65 6,202,000
1/27/17 32.51 17,406,700 121.95 20,562,900 28.36 3,107,000 41.25 1,220,500 46.95 19,411,100 835.77 2,998,700 56.59 17,186,210 42.83 3,299,400 44.42 4,942,800 53.19 7,362,000
1/28/17
1/29/17
1/30/17 32.17 11,247,700 121.63 30,377,500 28.56 3,595,000 41.79 1,242,400 44.90 16,786,100 830.38 3,747,300 56.08 15,961,389 43.70 2,223,000 43.93 6,906,100 53.08 9,770,800
1/31/17 31.83 9,469,100 121.35 49,201,000 28.40 4,381,700 42.81 2,602,200 44.25 11,719,800 823.48 3,137,200 56.33 22,409,081 44.22 2,829,800 44.07 5,153,500 52.90 12,342,900
2/1/17 32.18 9,700,200 128.75 111,985,000 28.13 4,109,200 41.34 2,425,900 44.05 7,955,500 832.35 3,850,200 55.91 21,157,698 43.82 2,353,700 43.78 5,306.40 53.02 8,810,900
2/2/17 31.97 6,028,600 128.53 33,710,400 28.17 4,403,300 40.89 2,194,500 44.01 7,607,700 839.95 7,350,500 55.75 13,044,449 43.51 3,914,600 43.69 5,064,400 52.80 7,874,200
2/3/17 32.07 5,423,500 129.08 24,507,300 28.32 3,671,500 41.02 1,724,900 44.20 6,357,900 810.2 10,868,800 57.27 19,879,774 43.90 4,678,600 43.71 6,422,400 52.36 8,850,400
2/4/17
2/5/17
2/6/17 32.03 5,339,800 130.29 26,845,900 28.54 3,919,200 41.28 2,871,300 45.30 6,496,100 807.64 3,897,300 56.55 13,940,158 42.88 3,016,000 44.42 7,308,800 52.80 7,335,200
2/7/17 32.43 8,136,000 131.53 38,193,800 28.81 4,834,600 36.82 21,509,900 45.17 6,120,000 812.5 3,466,100 56.34 14,937,421 42.78 1,972,600 44.37 4,445,800 52.81 6,446,900
2/8/17 33.25 17,081,200 132.04 23,004,100 28.98 3,769,400 38.87 9,807,600 45.06 4,329,900 819.71 2,858,000 55.63 18,592,180 44.53 5,710,300 45.07 6,531,000 53.88 9,281,100
2/9/17 33.12 10,465,600 132.42 28,349,900 29.01 6,234,700 38.27 3,734,100 46.30 7,089,900 821.36 2,484,900 56.73 15,907,818 45.55 5,420,100 45.08 3,769,000 55.31 14,345,400
2/10/17 33.63 13,352,100 132.12 19,764,500 29.38 4,491,400 38.38 3,836,100 46.45 4,033,300 827.46 2,425,800 56.86 12,268,103 45.00 3,121,500 45.03 4,157,400 56.22 14,967,700
2/11/17
2/12/17
2/13/17 33.79 10,744,500 133.29 23,035,400 29.52 6,084,500 37.6 3,587,000 47.41 6,158,600 835.53 4,172,600 57.08 15,325,300 44.36 3,018,400 45.46 7,491,300 56.09 7,679,800
2/14/17 33.63 7,615,600 135.02 33,226,200 29.43 3,330,800 38.1 3,075,700 46.57 6,271,700 836.39 2,792,400 57.98 16,382,900 45.44 2,551,500 45.02 6,676,800 56.45 8,891,400
2/15/17 34.01 7,994,500 135.51 35,623,100 30.14 8,001,200 38.05 2,624,600 47.54 8,394,800 842.7 2,968,900 58.55 25,350,400 46.12 4,031,900 45.65 22,509,200 56.64 6,652,000
2/16/17 33.54 8,891,800 135.35 22,584,600 30.23 7,706,200 38.21 2,931,600 46.97 5,681,800 844.14 2,714,700 58.12 14,694,500 44.18 3,284,500 45.16 8,972,000 56.29 8,374,200
2/17/17 33.76 7,797,300 135.72 22,198,200 29.85 7,079,600 38.3 2,465,500 46.91 4,581,600 845.07 3,112,300 58.09 15,783,200 45.69 4,296,100 45.1 9,417,200 56.75 12,638,000
2/18/17
2/19/17
2/20/17
2/21/17 33.92 7,237,500 136.7 24,507,200 30.23 5,131,400 38.31 2,722,800 46.81 4,672,200 856.44 3,507,700 58.25 16,916,800 45.87 3,307,000 45.5 8,116,000 57.36 10,955,000
2/22/17 33.82 7,068,200 137.11 20,836,900 30.47 6,599,800 37.92 1,939,400 46.32 5,799,600 855.61 2,617,000 58.36 12,344,200 45.35 2,459,500 45.98 7,730,200 58.24 10,914,100
2/23/17 33.6 6,528,400 136.53 20,788,200 30.61 9,920,800 37.28 3,655,400 46.1 5,247,000 852.19 3,462,000 58.49 13,841,400 43.94 5,365,000 45.41 7,812,100 57.39 12,316,300
2/24/17 34.06 8,098,700 136.66 21,776,600 30.27 4,641,300 37.3 2,638,000 46.28 4,489,600 845.24 3,688,000 57.81 16,379,100 46.46 12,959,600 45.55 3,714,800 57.86 9,684,500
2/25/17
2/26/17
2/27/17 34.28 7,372,800 136.93 20,257,400 30.8 5,946,300 37.6 4,222,200 46.32 4,130,500 848.64 2,713,600 58.06 10,101,000 47.61 7,315,500 45.71 4,006,700 57.69 4,375,700
2/28/17 33.9 8,105,300 136.99 23,482,900 30.57 8,639,500 36.5 3,577,900 46.36 4,935,600 845.04 2,793,700 57.88 15,558,900 46.66 4,704,500 45.66 7,202,000 57.16 7,951,300
3/1/17 34.27 5,736,100 139.79 36,414,600 30.67 7,942,600 36.9 7,014,200 47.09 8,278,900 853.08 2,760,100 59.73 25,912,700 45.6 4,672,900 46.24 7,258,500 57.95 8,558,900
3/2/17 33.91 4,697,900 138.96 26,211,000 30.93 22,176,000 37.03 3,022,600 45.72 7,590,700 848.91 2,132,100 58.71 17,578,600 46.65 4,169,400 45.94 7,017,100 57.8 6,438,400
3/3/17 33.74 6,555,700 139.78 21,108,100 30.93 9,199,300 36.41 1,729,700 46.82 7,256,900 849.88 1,941,100 58.89 14,740,000 46.35 2,254,900 45.91 6,753,300 56.7 9,181,600
3/4/17
3/5/17
3/6/17 33.64 7,728,500 139.34 21,750,000 30.41 8,109,800 36.51 2,032,700 45.31 11,336,600 846.61 2,610,400 58.61 13,225,500 45.5 3,978,600 45.64 6,694,900 56.77 6,896,800
3/7/17 33.47 6,945,500 139.52 17,446,300 30.75 7,488,300 36.02 2,150,400 44.84 4,565,300 846.02 2,247,600 58.3 13,099,900 44.03 3,751,000 45.73 5,116,800 56.55 7,124,400
3/8/17 33.32 7,871,900 139 18,707,200 31.34 8,226,600 36.4 2,521,700 44.89 5,520,400 850.5 2,286,500 58.21 14,711,300 45.15 2,671,300 45.98 3,331,700 56.51 7,604,800
3/9/17 33.18 5,545,400 138.68 22,155,900 31.2 5,546,200 36.46 3,561,800 43.33 9,330,100 853 2,048,200 58.7 15,721,500 44.45 2,788,900 45.94 3,767,600 56.36 6,165,700
3/10/17 33.13 4,977,300 139.14 19,488,000 31.06 5,970,100 36.85 2,959,000 43.9 6,842,300 852.46 2,436,400 58.85 14,863,600 44.45 2,778,400 45.98 3,823,900 56.43 8,819,900
3/11/17
3/12/17
3/13/17 32.8 10,865,400.00 139.2 17421700 31.69 6473500 36.92 2,811,300 42.37 8,882,300 854.59 1,909,700 58.700001 14063500 43.599998 2350000 46.57 4702300 56.67 7235900
3/14/17 32.86 6,829,700.00 138.99 15309100 31.37 4364700 37.21 2615700 41.21 10208500 852.53 2130600 58.759998 10885000 43.779999 1832500 46.369999 3799800 57.28 9286900
3/15/17 32.89 9,777,800.00 140.46 25691800 31.38 4368800 37.61 2220100 42.09 13986200 852.97 2562200 58.709999 17777300 44.34 1776800 46.290001 6279300 57.66 10067500
3/16/17 33.1 6,925,800.00 140.69 19232000 31.54 6367500 37.74 2648100 42.13 7058300 853.42 1842300 59.32 18468200 44.310001 2343500 46.610001 3627100 57.60 9895000
3/17/17 33.7 15,941,300.00 139.99 43885000 31.56 6464100 37.83 23739100 41.72 10185800 852.31 3384400 58.669998 20985700 43.919998 3367000 46.59 6192400 57.80 10791500
3/18/17
3/19/17
3/20/17 33.81 7,319,600.00 141.46 21542000 31.72 4270800 37.39 1596100 41.7 6229800 852.97 2282700 57.630001 17663200 42.580002 2651200 46.77 5823000 58.68 13352500
3/21/17 33.19 8,918,500.00 139.84 39529900 30.32 9364400 36.74 2449600 40.42 7938700 843.2 4382900 55.849998 31766400 41.810001 3212600 45.77 6469400 58.01 15269800
3/22/17 33.53 5,486,100.00 141.42 25860200 30.58 6790000 36.58 1482200 40.35 9943000 848.06 2658700 55.330002 27740900 41.959999 2650300 46.060001 6773400 53.92 37413400
3/23/17 33.52 4,833,900.00 140.92 20346300 31.29 8940500 37.23 1752500 41.41 9516600 847.38 1953000 55.25 19000000 41.610001 2713900 46.599998 8297800 55.37 23848300
3/24/17 33.4 4,317,800.00 140.64 22395600 31.26 5826800 37.56 1163300 41.73 6596600 845.61 2138300 55.830002 21127500 41.950001 2107900 46.400002 5607700 56.36 14438600
3/25/17
3/26/17
3/27/17 33.43 4994400 140.88 23575100 31.38 4055400 37.8 1756900 41.74 6050500 846.82 2755800 55.389999 16854800 42.459999 2645700 46.400002 6016600 55.93 8663600
3/28/17 33.53 4609700 143.8 33374800 31.46 5862300 38.25 1739600 42.6 6185800 856 3041600 55.959999 14878900 43.580002 2897100 46.57 4630800 56.62 7823900
3/29/17 33.65 7242700 144.12 29190000 31.58 3152800 38.28 1746800 41.96 5331400 874.32 4485800 55.669998 10329100 45.919998 5004300 46.779999 4403400 56.68 7456200
3/30/17 33.7 4993400 143.93 21207300 31.56 4907700 38.13 1684500 42.54 3681400 876.34 2762700 56.240002 12106500 46.450001 2180600 46.619999 3448600 56.04 7210500
3/31/17 33.57 10223000 143.66 19661700 31.11 5975200 38.11 1368900 42.3 5427700 886.54 3957600 55.66 11864600 46.57 2645200 46.41 7814100 55.73 5905600
4/1/17
4/2/17
4/3/17 33.76 9828700 143.7 19985700 31.92 7934900 38.04 1439200 42.45 5764700 891.51001 3422300 55.490002 14550700 46.48 3085900 46.43 7675400 55.56 7088800
4/4/17 34.14 8679900 144.77 19891400 31.44 4927500 36.82 2429700 40.9 7254700 906.830017 4984700 55.200001 11937400 43.919998 3867500 46.23 4758400 55.04 8843300
4/5/17 33.81 11241900 144.02 27717900 31.53 5368400 36.84 1668800 41.31 7012700 909.280029 7508400 54.98 17411700 43.439999 2378800 46.380001 4840300 54.98 7722100
4/6/17 34.16 8854900 143.66 21149000 32.23 5840700 37.01 1606400 41.72 3627600 898.280029 6344100 55.369999 10387500 44.720001 3545300 46.279999 4124600 55.14 6692200
4/7/17 33.91 6644500 143.34 16672200 32.01 5651000 37.55 1818000 41.81 4137000 894.880005 3710900 54.84 15848800 44.529999 1819500 46.439999 4629800 55.11 6078300
4/8/17
4/9/17
4/10/17 34.06 6268100 143.17 18933400 32.67 8303800 37.29 1526800 42.32 4650500 907.039978 3184300 54.540001 14607700 45.400002 1724700 47.209999 7818000 54.90 5472700
4/11/17 33.99 5165100 141.63 30379400 32.3 8054200 37.76 1139800 43.93 10269600 902.359985 3012700 54.16 28086800 46.57 2324800 46.790001 5593900 54.92 4348600
4/12/17 34.27 10457200 141.8 20350000 32.71 6818000 37.78 1151500 43.96 9991100 896.22998 2456100 53.119999 25601300 46.43 3405300 46.830002 5127300 55.57 8504100
4/13/17 34.33 7783100 141.05 17822900 32.47 3029600 37.56 1246000 43.53 5504900 884.669983 3174600 51.349998 47982000 46.57 2770000 46.900002 3762100 55.34 5282100
4/14/17
4/15/17
4/16/17
4/17/17 34.44 6952000 141.83 16582100 32.72 4383300 37.32 1127100 44.23 4563200 901.98999 2854700 52.720001 31959100 46.099998 2222000 47.389999 3857100 56.24 7688700
4/18/17 34.02 7487000 141.2 14697500 32.84 4273500 36.9 1623200 43.81 5808900 903.780029 2999200 52.450001 22257500 46.080002 1530900 47.560001 9341900 56.11 5651100
4/19/17 33.85 15164000 140.68 17328400 33.36 10268600 36.87 1879100 44.4 6573400 899.200012 2870200 52.150002 17414600 46.529999 2285300 47 12179500 55.860001 5947700
4/20/17 32.53 28093800 142.44 23319600 33.97 7963500 37.58 1917700 45.22 4956500 902.059998 2814400 53.5 31552900 47.869999 3037200 47.669998 10925100 56.400002 6867100
4/21/17 32.18 14339200 142.27 17320900 34.35 11713500 36.76 1492500 45.15 5536000 898.530029 2420500 53 26177300 47.619999 1944100 47.52 7055000 55.849998 6055600

Sheet2

Sheet3