$2.$ Select a stock traded on the NYSE and construct a daily high, low, and close bar chart for it that includes its volume of trading for $10$ consecutive trading days.

a$.$ Compute the relative$-$strength ratio for the stock relative to the S&P $500$ Index. Prepare a table that includes all the data and indicates the computations.

b$.$ Plot the RSI computed in part $($a$)$ on your bar chart. Note that the assignment in Canvas provides a template for computing RSI.

c$.$ Discuss whether the stock's relative strength is bullish or bearish. Do it in excel. Here is an excel file you can use. Date QQQQ Close Change Gain Loss Avg Gain Avg Loss RS $14-$day RSI

$114-$Dec$-0944\mathrm{.}34$

$215-$Dec$-0944\mathrm{.}09-0\mathrm{.}250\mathrm{.}25$

$316-$Dec$-0944\mathrm{.}150\mathrm{.}060\mathrm{.}06$

$417-$Dec$-0943\mathrm{.}61-0\mathrm{.}540\mathrm{.}54$

$518-$Dec$-0944\mathrm{.}330\mathrm{.}720\mathrm{.}72$

$621-$Dec$-0944\mathrm{.}830\mathrm{.}500\mathrm{.}50$

$722-$Dec$-0945\mathrm{.}100\mathrm{.}270\mathrm{.}27$

$823-$Dec$-0945\mathrm{.}420\mathrm{.}330\mathrm{.}33$

$924-$Dec$-0945\mathrm{.}840\mathrm{.}420\mathrm{.}42$

$1028-$Dec$-0946\mathrm{.}080\mathrm{.}240\mathrm{.}24$

$1129-$Dec$-0945\mathrm{.}89-0\mathrm{.}190\mathrm{.}19$

$1230-$Dec$-0946\mathrm{.}030\mathrm{.}140\mathrm{.}14$

$1331-$Dec$-0945\mathrm{.}61-0\mathrm{.}420\mathrm{.}42$

$144-$Jan$-1046\mathrm{.}280\mathrm{.}670\mathrm{.}67$ RS RSI

$155-$Jan$-1046\mathrm{.}280\mathrm{.}240\mathrm{.}102\mathrm{.}3970\mathrm{.}53$

$166-$Jan$-1046\mathrm{.}00-0\mathrm{.}280\mathrm{.}280\mathrm{.}220\mathrm{.}111\mathrm{.}9766\mathrm{.}32$

$177-$Jan$-1046\mathrm{.}030\mathrm{.}030\mathrm{.}030\mathrm{.}210\mathrm{.}101\mathrm{.}9966\mathrm{.}55$

$188-$Jan$-1046\mathrm{.}410\mathrm{.}380\mathrm{.}380\mathrm{.}220\mathrm{.}102\mathrm{.}2769\mathrm{.}41$

$1911-$Jan$-1046\mathrm{.}22-0\mathrm{.}190\mathrm{.}190\mathrm{.}200\mathrm{.}101\mathrm{.}9766\mathrm{.}36$

$2012-$Jan$-1045\mathrm{.}64-0\mathrm{.}580\mathrm{.}580\mathrm{.}190\mathrm{.}141\mathrm{.}3857\mathrm{.}97$

$2113-$Jan$-1046\mathrm{.}210\mathrm{.}570\mathrm{.}570\mathrm{.}220\mathrm{.}131\mathrm{.}7062\mathrm{.}93$

$2214-$Jan$-1046\mathrm{.}250\mathrm{.}040\mathrm{.}040\mathrm{.}200\mathrm{.}121\mathrm{.}7263\mathrm{.}26$

$2315-$Jan$-1045\mathrm{.}71-0\mathrm{.}540\mathrm{.}540\mathrm{.}190\mathrm{.}151\mathrm{.}2856\mathrm{.}06$

$2419-$Jan$-1046\mathrm{.}450\mathrm{.}740\mathrm{.}740\mathrm{.}230\mathrm{.}141\mathrm{.}6662\mathrm{.}38$

$2520-$Jan$-1045\mathrm{.}78-0\mathrm{.}670\mathrm{.}670\mathrm{.}210\mathrm{.}181\mathrm{.}2154\mathrm{.}71$

$2621-$Jan$-1045\mathrm{.}35-0\mathrm{.}430\mathrm{.}430\mathrm{.}200\mathrm{.}191\mathrm{.}0250\mathrm{.}42$

$2722-$Jan$-1044\mathrm{.}03-1\mathrm{.}331\mathrm{.}330\mathrm{.}180\mathrm{.}270\mathrm{.}6739\mathrm{.}99$

$2825-$Jan$-1044\mathrm{.}180\mathrm{.}150\mathrm{.}150\mathrm{.}180\mathrm{.}260\mathrm{.}7141\mathrm{.}46$

$2926-$Jan$-1044\mathrm{.}220\mathrm{.}040\mathrm{.}040\mathrm{.}170\mathrm{.}240\mathrm{.}7241\mathrm{.}87$

$3027-$Jan$-1044\mathrm{.}570\mathrm{.}350\mathrm{.}350\mathrm{.}180\mathrm{.}220\mathrm{.}8345\mathrm{.}46$

$3128-$Jan$-1043\mathrm{.}42-1\mathrm{.}151\mathrm{.}150\mathrm{.}170\mathrm{.}290\mathrm{.}5937\mathrm{.}30$

$3229-$Jan$-1042\mathrm{.}66-0\mathrm{.}760\mathrm{.}760\mathrm{.}160\mathrm{.}320\mathrm{.}4933\mathrm{.}08$

$331-$Feb$-1043\mathrm{.}130\mathrm{.}470\mathrm{.}470\mathrm{.}180\mathrm{.}300\mathrm{.}6137\mathrm{.}77$

Note: The smoothing process affects RSI values. RS values are smoothed after the first calculation. Average Loss equals the sum of the losses divided by $14$ for the first calculation. Subsequent calculations multiply the prior value by $13,$ add the most recent value and then divide the total by $14.$ This creates a smoothing affect. The same applies to Average Gain. Because of this smoothing, RSI values may differ based on the total calculation period. $250$ periods will allow for smoothing than $30$ periods and this will slightly affect RSI values. Stockcharts.com goes back $250-$days when possible. If Average Loss equals zero, a "divide by zero" situation occurs for RS and RSI is set to $100$ by definition. Similarly, RSI equals $0$ when Average Gain equals zero.