Get Help With Your Essay
"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."
Download the Excel Spreadsheet for Project 3. You’ll see a data sheet and then sheets for Relative Strength Index (RSI), Moving Average Convergence/Divergence (MACD), Bollinger Bands (BOLL), Stochastics (TAS), and Graphs. Each sheet has seven local stocks: Bank of America (BAC), Lowe’s (LOW), Duke Energy (DUK), Sonic Automotive (SAH), Nucor Steel (NUE), Domtar Corp (UFS), and 3D Systems (DDD).
You need to create:
1. A 14-day RSI for each of the seven stocks with graphs of each. Identify periods of overbought/oversold. (10 points)
2. MACD for each of the seven stocks using a 12-day EMA, 26-day EMA and 9-day EMA signal line with graphs for each. Identify buy and sell signals. (10 points)
3. BOLL for each of the seven stocks using a 20-day moving average and UBB of +2 standard deviations with LBB of -2 standard deviations. Show graph and buy/sell signals. (15 points)
4. TAS for each of the seven stocks using a 20-day K line, 5-day D line, 5-day DS line, and 3-day DSS line. Show graph and buy/sell signals. (15 points)