Use the data below to construct the advance/decline line for the stock market. V
ID: 2774510 • Letter: U
Question
Use the data below to construct the advance/decline line for the stock market. Volume figures are in thousands of shares and are from November 2–6, 2009. (Input all amounts as positive values.)
Stocks
Advancing
Advancing
Volume
Stocks
Declining
Declining
Volume
Monday
1,831
687,133
1,438
596,144
Tuesday
2,225
553,360
1,520
450,885
Wednesday
1,837
625,244
1,446
721,137
Thursday
2,482
1,116,422
552
174,548
Friday
1,712
512,450
1,474
496,710
Adv./Dec.
Cumulative
Monday
Tuesday
Wednesday
Thursday
Friday
Construct the Arms ratio on each of the five trading days. (Round your answer to 3 decimal places. Input all amounts as positive values.)
Stocks
Advancing
Advancing
Volume
Stocks
Declining
Declining
Volume
Monday
1,819
691,343
1,524
598,193
Tuesday
2,372
453,360
1,957
452,973
Wednesday
1,825
625,744
1,532
721,549
Thursday
2,458
1,120,446
556
174,960
Friday
1,760
513,426
1,478
496,210
Arms ratio
Monday
Tuesday
Wednesday
Thursday
Friday
The table below shows the closing monthly stock prices for Stock 1 and Stock 2 during 2009. Calculate the simple three-month moving average for each month for both companies. (Round your answers to 2 decimal places. Input all amounts as positive values. Omit the "$" sign in your response.)
Stock 1
Stock 2
January
92.20
320.65
February
99.60
355.43
March
104.31
363.99
April
114.64
387.06
May
119.83
525.97
June
115.74
447.06
July
126.95
541.95
August
128.02
518.06
September
119.02
500.67
October
134.93
547.59
November
157.38
590.59
December
167.98
622.00
Stock 1
Stock 2
March
$
$
April
May
June
July
August
September
October
November
December
Calculate the exponential three-month moving average for both stocks where two-thirds of the average weight is placed on the most recent price. (Round your answers to 2 decimal places. Input all amounts as positive values. Omit the "$" sign in your response.)
Stock 1
Stock 2
January
55.48
309.65
February
61.42
341.13
March
70.87
341.99
April
81.20
354.06
May
86.39
415.97
June
82.30
414.06
July
90.32
431.95
August
91.39
454.59
September
82.39
467.67
October
98.30
503.81
November
120.75
544.50
December
131.35
589.00
Stock 1
Stock 2
March
$
$
April
May
June
July
August
September
October
November
December
Use the data below to construct the advance/decline line for the stock market. Volume figures are in thousands of shares and are from November 2–6, 2009. (Input all amounts as positive values.)
Explanation / Answer
Stock advancing stock declining ADV/DEc cumulative Monday 1831 1438 393 393 Tuesday 2225 1520 705 2985 Wednesday 1837 1446 391 2560 Thursday 2482 552 1930 2758 Friday 1712 1474 238 2449 Stock advancing stock volume adv stock decline stock volumeDEC AD ratio AD volume ratio Arms ratio Monday 1819 691343 1524 598193 1.19357 1.155718974 1.032751 Tuesday 2372 453360 1957 452973 1.212059 1.000854356 1.211025 Wednesday 1825 625744 1532 721549 1.191253 0.867223155 1.373641 Thursday 1458 1120446 556 174960 2.622302 6.404012346 0.409478 Friday 1760 513426 1478 496210 1.190798 1.034694988 1.150869 stock 1 simple 3 months moving average stock 2 moving average january 92.2 320.65 February 99.6 355.43 March 104.31 98.70333333 363.99 346.69 April 114.64 106.1833333 387.06 368.8266667 May 119.83 112.9266667 525.97 425.6733333 June 115.74 116.7366667 447.06 453.3633333 July 126.95 120.84 54195 18389.34333 August 128.02 123.57 518.06 18386.70667 September 119.02 124.6633333 500.67 18404.57667 October 134.93 127.3233333 547.59 522.1066667 November 157.38 137.11 590.59 546.2833333 December 168 153.4366667 662 600.06 stock 1 simple 3 months moving average stock 2 moving average Exponantial 3 months moving average st1 Exponantial 3 months moving average st2 55.48 309.65 61.42 341.13 58.45 325.39 70.87 62.59 341.99 330.9233333 66.73 336.4566667 81.2 71.16333333 354.06 345.7266667 76.37666667 348.1922222 86.39 79.48666667 415.97 370.6733333 83.05222222 393.3774074 82.3 83.29666667 414.06 394.6966667 82.55074074 407.1658025 90.32 86.33666667 431.95 420.66 87.73024691 423.6886008 91.39 88.00333333 454.59 433.5333333 90.1700823 444.2895336 82.39 88.03333333 467.67 451.4033333 84.98336077 459.8765112 98.3 90.69333333 503.81 475.3566667 93.86112026 489.1655037 120.75 100.48 544.5 505.3266667 111.7870401 526.0551679 131.35 116.8 589 545.77 124.8290134 568.0183893
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.