Question

Part 1:

Use the data below to construct the advance/decline line and Arms ratio for the market. Volume is in thousands of shares.(Input all amounts as positive values. Do not round intermediate calculations. Round your "Arms Ratio" answers to 3 decimal places.)

	Stocks Advancing	Advancing Volume	Stocks Declining	Declining Volume
Monday	1,925	844,111	763	16,203
Tuesday	2,855	859,531	669	211,567
Wednesday	1,639	517,382	1,389	498,403
Thursday	2,201	928,442	826	313,404
Friday	1,865	593,067	1,191	383,703

	Adv./Dec.	Cumulative	Arms Ratio
Monday
Tuesday
Wednesday
Thursday
Friday

A stock had the following trades during a particular period. What was the money flow for the stock? (Leave no cells blank - be certain to enter "0" wherever required. Input all amounts as positive values. Do not round intermediate calculations. Round your answers to the nearest whole dollar.)

Part 2:

Week	Day	Price				Volume
1	Monday	$	91.42
	Tuesday		91.38			2,700
	Wednesday		91.39			3,100
	Thursday		91.42			3,000
	Friday		91.41			3,150
2	Monday		91.44			1,100
	Tuesday		91.45			1,600
	Wednesday		91.49			600
	Thursday		91.48			1,500
	Friday		91.50			3,300

Price	Up/Down	Price Times Volume	Positive Money Flow	Negative Money Flow	Net Money Flow
$91.42
91.38
91.39
91.42
91.41
91.44
91.45
91.49
91.48
91.50
			Money flow at the end of the day

Answer 1

Part 1

Please see the table below. Please see the third row to understand the mathematics.

	Stocks	Advancing	Stocks	Declining	Advance/Decline	Arms
	Advancing	Volume	Declining	Volume	Line	Ratio
	A	B	C	D	A - C	(D/C) / (B/A)
Monday	1,925	844,111	763	16,203	1,162	0.048
Tuesday	2,855	859,531	669	211,567	2,186	1.050
Wednesday	1,639	517,382	1,389	498,403	250	1.137
Thursday	2,201	928,442	826	313,404	1,375	0.899
Friday	1,865	593,067	1,191	383,703	674	1.013

Part - 2

Week	Day	Price	Volume	Up / Down	Price x Volume	Positive Money Flow	Negative Money Flow	Net Money Flow
		P	V		A = P x V	B	C	|B - C|
1	Monday	91.42
	Tuesday	91.38	2,700	Down	246,726	-	246,726	246,726
	Wednesday	91.39	3,100	Up	283,309	283,309	-	283,309
	Thursday	91.42	3,000	Up	274,260	274,260	-	274,260
	Friday	91.41	3,150	Down	287,942	-	287,942	287,942
2	Monday	91.44	1,100	Up	100,584	100,584	-	100,584
	Tuesday	91.45	1,600	Up	146,320	146,320	-	146,320
	Wednesday	91.49	600	Up	54,894	54,894	-	54,894
	Thursday	91.48	1,500	Down	137,220	-	137,220	137,220
	Friday	91.5	3,300	Up	301,950	301,950	-	301,950
	Total					1,161,317	671,888

  the money flow for the stock = Total positive money flow - total negative money flow =  1,161,317 - 671,888 = 489,430