Question

Use the data for ATT to calculate the latest values of the: Bollinger Bands
and Stochastic Oscillator. ∑ (x-mean)^2 is 614.712. 
Hint: Bollinger Bands use 20 days of data, Stochastic Oscillator uses 14 days.

Date	Copmany XYZ
09/08/2017	331.5
12/08/2017	330
13/08/2017	332.3
14/08/2017	327.2
15/08/2017	326.6
16/08/2017	326.8
19/08/2017	323.2
20/08/2017	329.2
21/08/2017	328.4
22/08/2017	331.5
23/08/2017	333.3
26/08/2017	333.3
27/08/2017	327.2
28/08/2017	324
29/08/2017	331.8
30/08/2017	326.3
02/09/2017	339.2
03/09/2017	338.9
04/09/2017	341.4
05/09/2017	343.5

must show all work step by step

Answer 1

Middle Bollinger Band = 20-day simple moving average (SMA) => Using AVERAGE function in Excel = 331.28
Upper Bollinger Band = 20-day SMA + (20-day standard deviation of price x 2) => Using STDEVPA function in excel = 331.28 + (5.54397*2) = 342.368
Lower Bollinger Band = 20-day SMA - (20-day standard deviation of price x 2) => Using STDEVPA function in excel = 331.28 - (5.54397*2) = 320.192

Stochastic Oscillator (%K) Is calculated as:

%K = (C - L14) / (H14 - L14) *100

where

C = The most recent closing price => 343.5

L14 = The lowest price traded of the 14 previous days => using excel MIN = 323.2

H14 = The highest price traded of the same 14-day period => using excel MAX = 343.5

%K = 100%

Let me know in case of any issues. Enjoy learning. Good luck!