CIS107 Homework 2

profileCollegeman
stock.xlsx
Home>Computer Science homework help>CIS107 Homework 2

Documentation

Plaid Solar Manufacturing
Author
Date
Purpose To document and chart stock price trends for Plaid Solar Manufacturing

Stock Values

Plaid Solar Manufacturing Monthly Stock Price (2007 - 2016)
Date Open High Low Close Volume
12/3/16 36.65 36.65 33.79 34.00 235,500
11/1/16 35.61 37.50 34.47 36.44 253,400
10/2/16 35.66 37.77 35.10 35.81 361,400
9/3/16 35.88 37.83 33.96 35.90 458,900
8/2/16 35.71 36.19 34.14 35.69 354,200
7/2/16 35.66 37.01 34.45 35.60 352,800
6/4/16 33.82 36.65 32.77 35.68 311,500
5/7/16 36.73 36.94 33.73 33.76 238,800
4/3/16 32.64 37.10 32.64 36.62 380,700
3/5/16 32.19 34.14 31.63 32.42 325,800
2/1/16 33.20 34.08 31.95 32.17 409,800
1/2/16 35.49 38.47 31.93 33.21 945,200
12/4/15 35.44 37.00 34.92 35.34 324,100
11/1/15 34.83 35.55 31.40 35.31 535,800
10/2/15 31.11 36.00 30.83 34.67 615,600
9/1/15 31.15 32.01 29.02 30.69 637,900
8/2/15 29.45 32.78 28.66 31.39 512,500
7/3/15 26.31 32.04 24.75 29.66 1,339,400
6/5/15 23.77 28.07 23.48 27.02 968,400
5/5/15 27.14 28.38 23.94 24.09 730,000
4/3/15 25.57 28.17 22.54 27.19 1,308,500
3/6/15 34.90 36.57 23.51 26.67 1,100,300
2/2/15 37.51 39.39 30.21 34.90 1,190,800
1/4/15 44.25 46.96 37.18 38.00 802,600
12/3/14 44.24 45.84 42.93 44.01 366,000
11/2/14 42.30 45.07 39.50 43.86 819,700
10/4/14 45.00 49.34 42.78 42.82 1,050,500
9/2/14 40.76 45.65 40.45 45.00 582,300
8/3/14 39.00 41.80 38.55 40.87 451,400
7/5/14 41.75 42.83 33.81 38.76 1,304,700
6/4/14 41.03 42.78 38.02 41.66 557,000
5/5/14 42.46 42.91 37.75 40.88 723,900
4/5/14 37.70 43.27 36.73 42.55 581,700
3/4/14 38.17 38.44 33.44 37.36 418,800
2/1/14 34.40 38.58 33.59 38.38 630,700
1/5/14 29.37 34.77 28.59 34.39 363,000
12/2/13 28.11 30.67 27.90 29.34 354,400
11/2/13 30.86 31.31 28.11 28.14 358,500
10/2/13 31.23 31.42 28.52 30.59 707,100
9/1/13 28.94 31.33 28.79 31.19 298,500
8/3/13 28.00 29.48 27.42 28.98 553,300
7/2/13 29.23 29.83 27.36 28.01 674,600
6/4/13 29.46 30.45 28.95 29.45 326,900
5/6/13 30.30 31.42 28.99 29.44 326,500
4/3/13 30.21 30.92 28.59 30.00 359,800
3/4/13 29.15 30.32 28.52 30.21 315,400
2/2/13 28.07 30.39 27.41 28.93 750,200
1/2/13 28.08 29.39 27.21 28.19 356,400
12/2/12 26.51 28.20 26.31 28.07 279,000
11/3/12 24.63 27.40 23.92 26.64 413,700
10/2/12 26.19 27.00 23.51 24.56 437,500
9/1/12 27.04 27.92 24.55 27.44 363,700
8/4/12 27.44 27.72 25.94 26.85 302,700
7/2/12 25.83 27.86 25.07 27.45 378,700
6/4/12 25.06 27.21 24.70 25.84 427,900
5/6/12 23.08 25.24 22.72 25.19 471,000
4/3/12 25.25 25.80 21.14 23.06 731,100
3/4/12 23.20 25.80 22.56 25.18 567,400
2/3/12 24.06 24.31 22.30 23.36 456,300
1/2/12 24.50 24.84 22.11 23.87 504,800
12/2/11 24.34 25.50 22.00 24.69 414,900
11/1/11 23.86 25.50 23.58 24.46 272,800
10/2/11 24.95 26.21 23.74 23.82 470,400
9/2/11 21.65 25.96 21.65 24.79 437,300
8/2/11 23.51 24.15 21.00 21.68 330,000
7/2/11 23.45 25.99 23.00 23.56 426,500
6/4/11 22.87 24.23 22.22 23.30 353,200
5/6/11 27.00 27.01 22.01 22.98 390,100
4/3/11 23.52 27.33 23.36 26.32 611,700
3/4/11 18.40 23.20 18.40 21.60 563,000
2/2/11 18.96 19.48 18.14 18.58 687,100
1/3/11 21.80 22.74 17.70 18.93 1,006,400
12/4/10 22.40 23.40 20.08 21.72 555,200
11/2/10 28.00 28.11 21.10 22.25 736,300
10/3/10 24.83 27.00 23.28 26.70 1,195,300
9/4/10 18.84 26.39 17.04 24.50 1,016,000
8/3/10 22.50 22.56 18.83 18.95 557,700
7/3/10 19.70 22.06 18.86 21.73 728,300
6/5/10 17.03 19.72 14.86 19.64 576,100
5/5/10 16.66 18.50 16.22 16.85 596,200
4/3/10 12.11 16.98 11.44 16.60 830,200
3/6/10 12.54 12.96 11.77 12.00 352,600
2/1/10 10.90 13.27 10.66 12.47 553,600
1/3/10 10.10 11.16 9.95 10.86 451,800
12/2/09 9.30 10.18 8.30 10.05 497,200
11/1/09 9.50 10.00 8.96 9.38 447,000
10/3/09 8.91 10.60 8.91 9.58 724,300
9/1/09 8.36 9.28 8.17 8.98 503,900
8/2/09 7.74 8.69 7.54 8.40 610,100
7/4/09 7.80 8.10 6.99 7.68 720,800
6/6/09 10.40 10.49 7.04 7.81 1,439,300
5/5/09 11.91 12.62 10.08 10.28 527,600
4/4/09 12.09 12.74 11.06 11.84 456,500
3/4/09 10.85 12.85 10.18 12.09 479,900
2/1/09 10.86 11.49 9.76 10.67 732,200
1/4/09 13.95 14.89 8.75 10.85 1,528,000
12/2/08 13.30 14.52 11.23 14.07 732,100
11/1/08 16.24 16.53 11.73 13.30 643,200
10/4/08 16.39 17.22 15.64 16.23 617,200
9/1/08 15.48 17.80 14.33 16.43 930,600
8/2/08 17.80 19.65 14.62 15.39 1,005,000
7/2/08 17.30 18.35 15.40 17.94 1,377,300
6/7/08 23.32 24.20 16.81 17.39 958,600
5/5/08 36.55 38.03 20.80 22.60 1,356,400
4/5/08 34.60 38.74 32.62 36.37 608,200
3/4/08 29.75 36.15 29.06 34.28 844,100
2/1/08 28.29 35.50 27.78 29.35 851,800
1/5/08 24.85 28.69 21.77 28.01 648,600
12/2/07 28.45 28.85 22.30 24.63 354,000
11/2/07 29.50 30.20 25.91 28.38 390,400
10/2/07 24.69 31.00 22.30 29.25 1,072,800
9/1/07 23.09 24.94 21.45 24.00 379,800
8/3/07 20.44 24.12 19.50 22.91 336,600
7/2/07 18.75 21.94 17.55 20.49 268,400
6/4/07 18.75 20.88 17.50 18.94 134,900
5/5/07 20.48 20.75 16.25 18.81 257,000
4/3/07 17.19 22.38 17.00 21.50 313,200
3/4/07 14.94 18.38 14.45 17.00 151,300
2/3/07 13.66 15.31 12.00 15.06 163,300
1/3/07 17.22 17.25 13.88 13.88 131,000