hi,

the necessary data and the instruction are in the attachment.

Thank you,

ACE 427 Spring 2016 Homework 2 Due date: Beginning of class Friday, February 19, 2016 Your first assignment is to analyze the likely path of June 2016 crude oil futures prices using the charting patterns discussed in lecture. To begin, download the file June_2016_Crude Oil.xls from the ACE 427 Compass website. It contains the high, low and settlement (closing) price ($/barrel) for the June 2016 crude oil futures contract from January 2, 2015 through February 12, 2016. 1. Generate a bar chart for all of the available June 2016 contract price data using the stock chart option in Excel. This is easy to do in Excel 2007 and 2010. Just insert a high-lowclose stock price chart. In Excel 2003 it is a bit harder. In order to just plot business days on the horizontal axis, do the following: i) Click the chart to select it, ii) On the Chart menu, click Chart Options, iii) Click the Axes tab and iv) Click Category under Category (X) axes and click OK. 2. On your bar chart, identify major chart patterns. Focus on major patterns rather than minor ones. I realize this is fairly subjective but that is the nature of the beast. 3. Based on your chart analysis, make a forecast for the direction of crude oil prices going forward. Make clear how reach your conclusion based on the chart patterns you identify. Your second assignment is to compute a 14-day Relative Strength Index (RSI) in predicting price movements. Using the same data file as before, compute the 14 day RSI for all of the available data. Note that the RSI values only have to be computed for settlement (closing) prices. Your RSI values should start on the 15th day of the sample and end on the last day of the sample, February 12, 2016. 1. Generate a line chart of the RSI. Please note these do not need to be on the same bar chart produced above. I don't think there is an easy way to do this in Excel. 2. Next, determine buy and sell signals based on the RSI values as explained in lecture That is, when the RSI rises above 70 a sell signal is given and maintained until the RSI reaches 30, which signals a reversal of the position to the buy side. You can use the chart as an aid in determining the buy and sell points, but this will not be very precise. Exact determination of the signals requires direct comparison of the magnitude of the RSI to the 30 and 70 cutoff points. 3. Based on your analysis, discuss the strengths and weaknesses of the RSI to forecast price direction. Finally, your report must by typed and all charts computer-generated. Symbol CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 Date Open High Low 1/2/2015 62.68 62.88 1/5/2015 61.54 61.55 1/6/2015 60.12 60.15 1/7/2015 57.9 58.77 1/8/2015 57.9 58.26 1/9/2015 58.32 58.89 1/12/2015 57.92 57.92 1/13/2015 56.5 57.24 1/14/2015 56.5 58.15 1/15/2015 57.53 59.38 1/16/2015 56.53 57.88 1/20/2015 57.66 57.66 1/21/2015 56.43 57.12 1/22/2015 56.7 57.99 1/23/2015 57.26 57.47 1/26/2015 56.55 57.4 1/27/2015 56.32 57.6 1/28/2015 56.79 57.25 1/29/2015 56.41 57.11 1/30/2015 56.99 60.11 2/2/2015 58.96 61.32 2/3/2015 61.12 64.43 2/4/2015 62.82 63.13 2/5/2015 60.74 63.14 2/6/2015 62.09 63.58 2/9/2015 62.65 63.92 2/10/2015 62.88 63.4 2/11/2015 62.01 62.01 2/12/2015 61.51 63.1 2/13/2015 62.92 63.96 2/17/2015 63.32 63.83 2/18/2015 62.88 63.27 2/19/2015 61.42 61.93 2/20/2015 61.48 61.76 2/23/2015 61.49 61.94 2/24/2015 60.9 62.09 2/25/2015 61.28 62.88 2/26/2015 62.2 62.94 2/27/2015 61.68 62.73 3/2/2015 62.3 62.71 3/3/2015 62.18 62.88 3/4/2015 62.43 62.48 3/5/2015 61.87 62.22 3/6/2015 61.57 61.83 3/9/2015 60.59 61.11 3/10/2015 60.19 60.19 3/11/2015 59.34 59.58 3/12/2015 59.52 60.22 3/13/2015 59.37 59.38 3/16/2015 56.36 57.62 3/17/2015 57 57 3/18/2015 55.8 58.24 3/19/2015 57.28 57.28 3/20/2015 56.37 57.56 3/23/2015 56.65 57.79 3/24/2015 57.17 58.48 3/25/2015 57.1 58.72 3/26/2015 58.14 60.89 3/27/2015 59.02 59.65 3/30/2015 57.45 58.5 3/31/2015 57.61 58.29 4/1/2015 57.67 59.42 4/2/2015 58.42 59.21 4/6/2015 58.5 59.99 4/7/2015 59.54 60.5 4/8/2015 59.64 59.67 4/9/2015 58.61 59.67 4/10/2015 58.95 59.8 4/13/2015 59.53 60.42 4/14/2015 60.2 60.71 4/15/2015 60.41 62.34 4/16/2015 61.93 63.25 4/17/2015 61.88 62.85 4/20/2015 62.75 63.02 4/21/2015 62.72 63.02 4/22/2015 62.08 62.93 4/23/2015 62.45 63.86 4/24/2015 63.32 63.66 4/27/2015 63.4 63.78 4/28/2015 63.19 63.6 Last 61.06 60.14 57.91 57.38 57.22 57.07 56.77 55.57 56.17 56.2 56.53 54.86 56.21 56.12 56.53 56.22 56.27 56.5 56.2 56.62 58.96 61.07 60.5 60.06 62.09 62.26 61.61 60.35 61.51 62.81 61.91 61.47 60.2 60.94 60.43 60.76 60.93 61.31 61.68 61.59 62.04 61.48 61.34 60.58 60.1 58.91 58.66 58.73 57.33 55.82 55.61 55.22 55.98 55.81 56.39 57 57.1 58.05 57.44 57.26 57.05 57.23 57.34 58.5 59.23 58.03 58.61 58.4 59.46 59.99 60.37 61.42 61.79 61.34 61.89 61.54 62.15 63 62.95 62.67 Volume 62.13 60.42 58.26 58.15 58.26 58.45 56.94 56.87 58.15 56.31 57.82 55.9 56.83 56.43 56.65 56.52 57.47 56.72 57.03 60.1 61.14 63.88 60.92 62.08 62.54 63.34 61.89 61.36 63.03 63.37 63.6 62.36 61.32 61.36 61.43 61.34 62.8 61.37 62.7 61.7 62.75 62.12 61.42 60.82 60.38 59.13 59.48 59.13 57.55 56.84 55.83 57.94 56.46 57.41 57.76 57.39 58.4 59.85 57.97 58.36 57.68 59.31 58.1 59.94 60.34 58.07 59.04 59.79 59.86 60.38 62.31 62.76 62.08 62.94 62.26 62.55 63.52 63.57 63.38 63.11 Open Interest CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 4/29/2015 4/30/2015 5/1/2015 5/4/2015 5/5/2015 5/6/2015 5/7/2015 5/8/2015 5/11/2015 5/12/2015 5/13/2015 5/14/2015 5/15/2015 5/18/2015 5/19/2015 5/20/2015 5/21/2015 5/22/2015 5/26/2015 5/27/2015 5/28/2015 5/29/2015 6/1/2015 6/2/2015 6/3/2015 6/4/2015 6/5/2015 6/8/2015 6/9/2015 6/10/2015 6/11/2015 6/12/2015 6/15/2015 6/16/2015 6/17/2015 6/18/2015 6/19/2015 6/22/2015 6/23/2015 6/24/2015 6/25/2015 6/26/2015 6/29/2015 6/30/2015 7/1/2015 7/2/2015 7/6/2015 7/7/2015 7/8/2015 7/9/2015 7/10/2015 7/13/2015 7/14/2015 7/15/2015 7/16/2015 7/17/2015 7/20/2015 7/21/2015 7/22/2015 7/23/2015 7/24/2015 7/27/2015 7/28/2015 7/29/2015 7/30/2015 7/31/2015 8/3/2015 8/4/2015 8/5/2015 8/6/2015 8/7/2015 8/10/2015 8/11/2015 8/12/2015 8/13/2015 8/14/2015 8/17/2015 8/18/2015 8/19/2015 8/20/2015 8/21/2015 63.1 63.27 64.22 64.02 63.9 64.96 64.51 63.22 63.32 63.69 65.1 64.19 63.89 63.68 63.21 61.76 62.19 63.02 62.44 61.45 60.38 60.75 62.16 62.01 62.77 61.98 61.07 61.67 61.73 62.95 63.41 63.04 62.13 62.7 62.8 62.42 63.22 62.4 62.7 63.43 62.54 62.12 61.2 60.67 61.34 60.04 58.02 56.12 55.7 56.2 57 56.38 56.3 57.29 55.76 55.23 54.89 54.5 54.77 54.06 53.37 52.78 52.2 52.57 53.14 53.09 52.14 50.61 50.9 50.38 50.34 49.11 50.59 49.36 50.12 49.1 49.47 48.71 48.79 47.13 46.09 64.14 64.17 64.22 64.33 65.25 65.93 65.28 63.91 63.65 65 65.24 64.64 63.99 64.51 63.21 62.32 63.45 63.12 62.86 61.65 60.55 62.66 62.61 63.16 63.1 62.35 62.36 62 63.18 64 63.84 63.09 62.47 62.93 63.81 63.62 63.22 63.01 63.64 63.72 62.69 62.3 61.76 62.08 61.42 60.92 59.98 56.7 56.38 57.15 57.62 57.49 57.4 57.3 56.13 55.26 55.16 55.57 55.14 54.28 53.44 52.85 53.31 53.93 53.75 53.35 52.31 51.21 51.5 50.43 50.55 50.94 51.31 50.33 50.46 50.11 49.83 49.31 49.02 47.4 46.39 62.71 63.16 63.55 63.59 63.9 64.49 62.99 62.41 63.03 63.66 64.03 63.49 62.88 62.84 61.48 61.63 62.19 62.12 60.76 60.11 59.63 60.38 61.57 62.01 61.79 60.73 60.16 61.21 61.51 62.95 62.93 62.37 61.44 62.15 61.92 62.36 61.79 61.78 62.33 62.22 61.79 61.32 60.78 60.67 59.98 59.65 55.74 54.11 54.89 55.84 56 55.6 55.61 55.38 55 54.31 54.32 54.4 53.79 53.09 52.48 52.01 51.87 52.23 53.03 52.05 50.4 50.48 49.89 49.65 49.38 49.08 49.36 49.15 49.4 49.01 48.89 48.59 46.85 45.77 45.09 63.68 64.14 64.12 64.14 64.7 64.92 63.17 63.52 63.57 64.66 64.33 63.99 63.69 63.15 61.57 62.29 63.21 62.37 61.05 60.18 60.41 62.6 62.15 63.06 62.08 60.96 62.34 61.5 63.04 63.92 63.49 62.46 62.32 62.73 62.84 63.21 62.44 62.99 63.35 62.67 62.1 62.08 60.98 61.91 60.16 60.09 55.88 55.87 55.61 56.62 57.01 56.81 57.2 55.5 55.01 54.98 54.66 55.22 53.95 53.17 52.84 52.53 52.87 53.22 53.23 52.48 50.48 50.78 50.27 50.2 49.45 50.9 49.56 50.05 49.72 49.79 49.07 49.17 47.31 46.76 45.51 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 8/24/2015 8/25/2015 8/26/2015 8/27/2015 8/28/2015 8/31/2015 9/1/2015 9/2/2015 9/3/2015 9/4/2015 9/8/2015 9/9/2015 9/10/2015 9/11/2015 9/14/2015 9/15/2015 9/16/2015 9/17/2015 9/18/2015 9/21/2015 9/22/2015 9/23/2015 9/24/2015 9/25/2015 9/28/2015 9/29/2015 9/30/2015 10/1/2015 10/2/2015 10/5/2015 10/6/2015 10/7/2015 10/8/2015 10/9/2015 10/12/2015 10/13/2015 10/14/2015 10/15/2015 10/16/2015 10/19/2015 10/20/2015 10/21/2015 10/22/2015 10/23/2015 10/26/2015 10/27/2015 10/28/2015 10/29/2015 10/30/2015 11/2/2015 11/3/2015 11/4/2015 11/5/2015 11/6/2015 11/9/2015 11/10/2015 11/11/2015 11/12/2015 11/13/2015 11/16/2015 11/17/2015 11/18/2015 11/19/2015 11/20/2015 11/23/2015 11/24/2015 11/25/2015 11/27/2015 11/30/2015 12/1/2015 12/2/2015 12/3/2015 12/4/2015 12/7/2015 12/8/2015 12/9/2015 12/10/2015 12/11/2015 12/14/2015 12/15/2015 12/16/2015 45.5 43.28 44.17 44.64 48.43 49.86 52.66 48.73 50.47 50.84 49.73 50.06 48.9 50 49.54 48.39 48.99 50.79 50.11 48.55 49.92 50.08 48.63 49.1 49.28 48.01 48.24 49.19 48.6 48.81 50.05 52.02 51.82 52.81 52.84 50.93 50.33 50.4 50.51 50.89 49.77 49.57 49.1 49.27 48.57 47.97 47.28 49.8 49.6 50.18 50.06 51.4 50.16 49.5 48.66 48.57 48.34 47.62 46.33 45.65 46.42 45.63 46.13 45.91 46.01 46.65 47.59 47.67 46.36 45.99 45.99 44.91 46.03 44.83 42.8 42.81 42.45 42.02 40.96 40.81 41.23 45.59 44.84 44.79 48.62 51.36 54.23 53.41 51.21 52.35 51.2 50.65 50.73 50.43 50.3 49.58 49.33 51.14 51.08 50.46 50.29 50.25 50.84 49.23 49.99 49.28 49.03 49.26 50.33 49.11 50.35 52.27 52.91 53.14 53.77 53.2 51.72 50.66 50.69 51.17 51.01 50.15 49.68 49.67 49.71 48.92 47.99 49.92 50.31 50.69 50.45 52.03 52.04 50.31 49.73 49.45 49.02 48.75 47.72 46.96 46.68 46.67 46.3 46.32 46.85 47.04 47.93 48.02 47.83 47.03 46.4 46.35 46.54 46.49 44.83 43.3 43.51 42.73 42.27 41.48 42.3 41.77 42.82 43.27 43.9 44.55 47.66 49.05 48.75 48.12 50.18 49.79 48.39 48.78 48.18 48.63 48.09 48.16 48.99 49.85 48.16 48.51 49.03 48.48 48.01 48.93 47.94 47.97 48.19 48.17 47.47 48.77 49.5 51.39 51.33 52.11 50.55 49.96 49.78 49.24 50.05 49.55 49.37 48.62 48.8 48.38 47.81 46.81 47.11 49.04 49.23 49.46 49.8 49.94 49.2 48.42 48.14 48.07 47.32 46.23 45.28 44.84 45.35 45.19 45.39 45.52 44.98 46.45 46.63 46.3 45.9 45.46 44.66 44.91 44.6 42.62 41.9 41.74 41.94 40.78 39.73 40.73 40.17 43.36 44.33 44.19 48.47 50.52 54.16 49.84 50.82 50.93 50.15 50.44 48.95 50.36 49.32 48.17 48.84 50.79 50.33 48.53 50.27 50.03 48.56 49.04 49.55 48.08 48.64 48.74 48.25 48.91 49.92 52 51.48 52.66 52.82 50.6 50.34 50.44 50.19 51 49.62 49.79 48.9 49.17 48.56 48.1 47.23 49.78 49.76 50.37 50.02 51.74 50.01 49.26 48.64 48.42 48.67 47.39 46.42 45.63 46.35 45.43 45.87 45.79 46.16 46.37 47.69 47.65 46.36 46.05 46.11 44.81 45.78 44.81 42.8 42.45 42.29 42.38 41.15 41.03 41.72 40.36 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 12/17/2015 12/18/2015 12/21/2015 12/22/2015 12/23/2015 12/24/2015 12/28/2015 12/29/2015 12/30/2015 12/31/2015 1/4/2016 1/5/2016 1/6/2016 1/7/2016 1/8/2016 1/11/2016 1/12/2016 1/13/2016 1/14/2016 1/15/2016 1/19/2016 1/20/2016 1/21/2016 1/22/2016 1/25/2016 1/26/2016 1/27/2016 1/28/2016 1/29/2016 2/1/2016 2/2/2016 2/3/2016 2/4/2016 2/5/2016 2/8/2016 2/9/2016 2/10/2016 2/11/2016 2/12/2016 40.63 39.75 39.6 39.15 39.41 40.68 41.11 39.9 40.46 40.12 41.15 40.85 40.25 38.38 37.62 37.36 35.65 34.79 34.3 35.05 32.94 32.55 31.94 33.25 35.61 33.9 34.42 35.96 37.39 38.08 36.07 34.44 37 36.38 35.99 35.09 33.14 32.97 33.35 40.8 40.55 39.7 39.55 40.78 41.31 41.11 41.07 40.55 41.25 42.07 40.92 40.25 38.49 38.59 37.37 36.47 35.42 35.28 35.05 34.09 32.55 33.53 35.74 36.24 36.15 36.63 38.52 38.37 38.46 36.13 37.04 37.65 37.19 36.52 35.59 34.32 33.5 34.06 39.72 39.44 38.89 38.97 39.26 40.23 39.79 39.8 39.72 39.62 40.15 39.72 38.07 36.37 36.85 35.3 34.14 33.84 33.82 32.87 32.01 30.79 31.26 32.8 33.7 33.18 34.13 35.65 36.88 35.9 34.25 34.18 35.94 35.71 34.82 32.65 32.7 32.1 33.14 40.02 39.7 39.19 39.14 40.38 41.25 40.04 41.01 39.92 40.71 40.55 39.94 38.16 37.58 37.49 35.75 34.63 34.12 34.96 33.15 32.57 31.77 32.86 35.65 34.21 35.27 36.12 37.09 38 36.23 34.63 36.67 36.3 35.94 34.92 32.74 32.96 32.21 33.41 Symbol CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 Date Open High Low 1/2/2015 62.68 62.88 1/5/2015 61.54 61.55 1/6/2015 60.12 60.15 1/7/2015 57.9 58.77 1/8/2015 57.9 58.26 1/9/2015 58.32 58.89 1/12/2015 57.92 57.92 1/13/2015 56.5 57.24 1/14/2015 56.5 58.15 1/15/2015 57.53 59.38 1/16/2015 56.53 57.88 1/20/2015 57.66 57.66 1/21/2015 56.43 57.12 1/22/2015 56.7 57.99 1/23/2015 57.26 57.47 1/26/2015 56.55 57.4 1/27/2015 56.32 57.6 1/28/2015 56.79 57.25 1/29/2015 56.41 57.11 1/30/2015 56.99 60.11 2/2/2015 58.96 61.32 2/3/2015 61.12 64.43 2/4/2015 62.82 63.13 2/5/2015 60.74 63.14 2/6/2015 62.09 63.58 2/9/2015 62.65 63.92 2/10/2015 62.88 63.4 2/11/2015 62.01 62.01 2/12/2015 61.51 63.1 2/13/2015 62.92 63.96 2/17/2015 63.32 63.83 2/18/2015 62.88 63.27 2/19/2015 61.42 61.93 2/20/2015 61.48 61.76 2/23/2015 61.49 61.94 2/24/2015 60.9 62.09 2/25/2015 61.28 62.88 2/26/2015 62.2 62.94 2/27/2015 61.68 62.73 3/2/2015 62.3 62.71 3/3/2015 62.18 62.88 3/4/2015 62.43 62.48 3/5/2015 61.87 62.22 3/6/2015 61.57 61.83 3/9/2015 60.59 61.11 3/10/2015 60.19 60.19 3/11/2015 59.34 59.58 3/12/2015 59.52 60.22 3/13/2015 59.37 59.38 3/16/2015 56.36 57.62 3/17/2015 57 57 3/18/2015 55.8 58.24 3/19/2015 57.28 57.28 3/20/2015 56.37 57.56 3/23/2015 56.65 57.79 3/24/2015 57.17 58.48 3/25/2015 57.1 58.72 3/26/2015 58.14 60.89 3/27/2015 59.02 59.65 3/30/2015 57.45 58.5 3/31/2015 57.61 58.29 4/1/2015 57.67 59.42 4/2/2015 58.42 59.21 4/6/2015 58.5 59.99 4/7/2015 59.54 60.5 4/8/2015 59.64 59.67 4/9/2015 58.61 59.67 4/10/2015 58.95 59.8 4/13/2015 59.53 60.42 4/14/2015 60.2 60.71 4/15/2015 60.41 62.34 4/16/2015 61.93 63.25 4/17/2015 61.88 62.85 4/20/2015 62.75 63.02 4/21/2015 62.72 63.02 4/22/2015 62.08 62.93 4/23/2015 62.45 63.86 4/24/2015 63.32 63.66 4/27/2015 63.4 63.78 4/28/2015 63.19 63.6 Last 61.06 60.14 57.91 57.38 57.22 57.07 56.77 55.57 56.17 56.2 56.53 54.86 56.21 56.12 56.53 56.22 56.27 56.5 56.2 56.62 58.96 61.07 60.5 60.06 62.09 62.26 61.61 60.35 61.51 62.81 61.91 61.47 60.2 60.94 60.43 60.76 60.93 61.31 61.68 61.59 62.04 61.48 61.34 60.58 60.1 58.91 58.66 58.73 57.33 55.82 55.61 55.22 55.98 55.81 56.39 57 57.1 58.05 57.44 57.26 57.05 57.23 57.34 58.5 59.23 58.03 58.61 58.4 59.46 59.99 60.37 61.42 61.79 61.34 61.89 61.54 62.15 63 62.95 62.67 Volume 62.13 60.42 58.26 58.15 58.26 58.45 56.94 56.87 58.15 56.31 57.82 55.9 56.83 56.43 56.65 56.52 57.47 56.72 57.03 60.1 61.14 63.88 60.92 62.08 62.54 63.34 61.89 61.36 63.03 63.37 63.6 62.36 61.32 61.36 61.43 61.34 62.8 61.37 62.7 61.7 62.75 62.12 61.42 60.82 60.38 59.13 59.48 59.13 57.55 56.84 55.83 57.94 56.46 57.41 57.76 57.39 58.4 59.85 57.97 58.36 57.68 59.31 58.1 59.94 60.34 58.07 59.04 59.79 59.86 60.38 62.31 62.76 62.08 62.94 62.26 62.55 63.52 63.57 63.38 63.11 Open Interest Upward movement Downward movement Average Upward Movement Average downward movement Relative Strength RSI 14 0.00000 Err:518 Err:518 0.11000 0.19000 Err:518 Err:518 1.28000 Err:518 1.51000 Err:518 0.93000 Err:518 0.22000 Err:518 0.95000 Err:518 0.31000 3.07000 1.04000 2.74000 Err:518 1.16000 0.46000 0.80000 Err:518 Err:518 1.67000 0.34000 0.23000 Err:518 Err:518 0.04000 0.07000 Err:518 1.46000 Err:518 1.33000 Err:518 1.05000 Err:518 Err:518 Err:518 Err:518 Err:518 0.35000 Err:518 Err:518 Err:518 Err:518 2.11000 Err:518 0.95000 0.35000 Err:518 1.01000 1.45000 Err:518 0.39000 Err:518 1.63000 Err:518 1.84000 0.40000 Err:518 0.97000 0.75000 0.07000 0.52000 1.93000 0.45000 Err:518 0.86000 Err:518 0.29000 0.97000 0.05000 Err:518 Err:518 1.71000 2.16000 0.11000 Err:518 Err:518 1.51000 0.07000 Err:518 1.84000 Err:518 1.92000 Err:518 0.40000 Err:518 0.13000 Err:518 0.75000 Err:518 Err:518 Err:518 Err:518 2.96000 Err:518 Err:518 Err:518 1.45000 0.53000 Err:518 Err:518 Err:518 1.24000 1.04000 Err:518 Err:518 0.09000 Err:518 1.43000 Err:518 1.00000 Err:518 0.63000 0.70000 0.60000 0.44000 1.25000 Err:518 0.35000 1.58000 0.71000 1.01000 Err:518 1.48000 Err:518 Err:518 0.37000 Err:518 Err:518 1.88000 Err:518 0.68000 Err:518 1.21000 Err:518 Err:518 2.27000 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 0.68000 Err:518 0.68000 Err:518 Err:518 Err:518 0.19000 0.27000 14 0.30286 0.28122 0.32899 Err:518 Err:518 Err:518 0.69429 0.65398 Err:518 Err:518 Err:518 Err:518 0.4362139918 30.37249 0.430020284 30.07092 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 0.60571 0.56745 Err:518 Err:518 Err:518 Err:518 0.51571 0.47888 0.45110 Err:518 Err:518 Err:518 1.1745152355 54.01274 1.1849563179 54.23249 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 4/29/2015 4/30/2015 5/1/2015 5/4/2015 5/5/2015 5/6/2015 5/7/2015 5/8/2015 5/11/2015 5/12/2015 5/13/2015 5/14/2015 5/15/2015 5/18/2015 5/19/2015 5/20/2015 5/21/2015 5/22/2015 5/26/2015 5/27/2015 5/28/2015 5/29/2015 6/1/2015 6/2/2015 6/3/2015 6/4/2015 6/5/2015 6/8/2015 6/9/2015 6/10/2015 6/11/2015 6/12/2015 6/15/2015 6/16/2015 6/17/2015 6/18/2015 6/19/2015 6/22/2015 6/23/2015 6/24/2015 6/25/2015 6/26/2015 6/29/2015 6/30/2015 7/1/2015 7/2/2015 7/6/2015 7/7/2015 7/8/2015 7/9/2015 7/10/2015 7/13/2015 7/14/2015 7/15/2015 7/16/2015 7/17/2015 7/20/2015 7/21/2015 7/22/2015 7/23/2015 7/24/2015 7/27/2015 7/28/2015 7/29/2015 7/30/2015 7/31/2015 8/3/2015 8/4/2015 8/5/2015 8/6/2015 8/7/2015 8/10/2015 8/11/2015 8/12/2015 8/13/2015 8/14/2015 8/17/2015 8/18/2015 8/19/2015 8/20/2015 8/21/2015 63.1 63.27 64.22 64.02 63.9 64.96 64.51 63.22 63.32 63.69 65.1 64.19 63.89 63.68 63.21 61.76 62.19 63.02 62.44 61.45 60.38 60.75 62.16 62.01 62.77 61.98 61.07 61.67 61.73 62.95 63.41 63.04 62.13 62.7 62.8 62.42 63.22 62.4 62.7 63.43 62.54 62.12 61.2 60.67 61.34 60.04 58.02 56.12 55.7 56.2 57 56.38 56.3 57.29 55.76 55.23 54.89 54.5 54.77 54.06 53.37 52.78 52.2 52.57 53.14 53.09 52.14 50.61 50.9 50.38 50.34 49.11 50.59 49.36 50.12 49.1 49.47 48.71 48.79 47.13 46.09 64.14 64.17 64.22 64.33 65.25 65.93 65.28 63.91 63.65 65 65.24 64.64 63.99 64.51 63.21 62.32 63.45 63.12 62.86 61.65 60.55 62.66 62.61 63.16 63.1 62.35 62.36 62 63.18 64 63.84 63.09 62.47 62.93 63.81 63.62 63.22 63.01 63.64 63.72 62.69 62.3 61.76 62.08 61.42 60.92 59.98 56.7 56.38 57.15 57.62 57.49 57.4 57.3 56.13 55.26 55.16 55.57 55.14 54.28 53.44 52.85 53.31 53.93 53.75 53.35 52.31 51.21 51.5 50.43 50.55 50.94 51.31 50.33 50.46 50.11 49.83 49.31 49.02 47.4 46.39 62.71 63.16 63.55 63.59 63.9 64.49 62.99 62.41 63.03 63.66 64.03 63.49 62.88 62.84 61.48 61.63 62.19 62.12 60.76 60.11 59.63 60.38 61.57 62.01 61.79 60.73 60.16 61.21 61.51 62.95 62.93 62.37 61.44 62.15 61.92 62.36 61.79 61.78 62.33 62.22 61.79 61.32 60.78 60.67 59.98 59.65 55.74 54.11 54.89 55.84 56 55.6 55.61 55.38 55 54.31 54.32 54.4 53.79 53.09 52.48 52.01 51.87 52.23 53.03 52.05 50.4 50.48 49.89 49.65 49.38 49.08 49.36 49.15 49.4 49.01 48.89 48.59 46.85 45.77 45.09 63.68 64.14 64.12 64.14 64.7 64.92 63.17 63.52 63.57 64.66 64.33 63.99 63.69 63.15 61.57 62.29 63.21 62.37 61.05 60.18 60.41 62.6 62.15 63.06 62.08 60.96 62.34 61.5 63.04 63.92 63.49 62.46 62.32 62.73 62.84 63.21 62.44 62.99 63.35 62.67 62.1 62.08 60.98 61.91 60.16 60.09 55.88 55.87 55.61 56.62 57.01 56.81 57.2 55.5 55.01 54.98 54.66 55.22 53.95 53.17 52.84 52.53 52.87 53.22 53.23 52.48 50.48 50.78 50.27 50.2 49.45 50.9 49.56 50.05 49.72 49.79 49.07 49.17 47.31 46.76 45.51 0.57000 0.46000 Err:518 0.02000 0.56000 0.22000 Err:518 0.35000 0.05000 1.09000 Err:518 Err:518 Err:518 Err:518 Err:518 0.72000 0.92000 Err:518 Err:518 Err:518 0.23000 2.19000 Err:518 0.91000 Err:518 Err:518 1.38000 Err:518 1.54000 0.88000 Err:518 Err:518 Err:518 0.41000 0.11000 0.37000 Err:518 0.55000 0.36000 Err:518 Err:518 Err:518 Err:518 0.93000 Err:518 Err:518 Err:518 Err:518 Err:518 1.01000 0.39000 Err:518 0.39000 Err:518 Err:518 Err:518 Err:518 0.56000 Err:518 Err:518 Err:518 Err:518 0.34000 0.35000 0.01000 Err:518 Err:518 0.30000 Err:518 Err:518 Err:518 1.45000 Err:518 0.49000 Err:518 0.07000 Err:518 0.10000 Err:518 Err:518 Err:518 Err:518 Err:518 0.02000 Err:518 Err:518 Err:518 1.75000 Err:518 Err:518 Err:518 0.33000 0.34000 0.30000 0.54000 1.58000 Err:518 Err:518 0.84000 1.32000 0.87000 Err:518 Err:518 0.45000 Err:518 0.98000 1.12000 Err:518 0.84000 Err:518 Err:518 0.43000 1.03000 0.14000 Err:518 Err:518 Err:518 0.77000 Err:518 Err:518 0.68000 0.57000 0.02000 1.10000 Err:518 1.75000 0.07000 4.21000 0.01000 0.26000 Err:518 Err:518 0.20000 Err:518 1.70000 0.49000 0.03000 0.32000 Err:518 1.27000 0.78000 0.33000 0.31000 Err:518 Err:518 Err:518 0.75000 2.00000 Err:518 0.51000 0.07000 0.75000 Err:518 1.34000 Err:518 0.33000 Err:518 0.72000 Err:518 1.86000 0.55000 1.25000 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 8/24/2015 8/25/2015 8/26/2015 8/27/2015 8/28/2015 8/31/2015 9/1/2015 9/2/2015 9/3/2015 9/4/2015 9/8/2015 9/9/2015 9/10/2015 9/11/2015 9/14/2015 9/15/2015 9/16/2015 9/17/2015 9/18/2015 9/21/2015 9/22/2015 9/23/2015 9/24/2015 9/25/2015 9/28/2015 9/29/2015 9/30/2015 10/1/2015 10/2/2015 10/5/2015 10/6/2015 10/7/2015 10/8/2015 10/9/2015 10/12/2015 10/13/2015 10/14/2015 10/15/2015 10/16/2015 10/19/2015 10/20/2015 10/21/2015 10/22/2015 10/23/2015 10/26/2015 10/27/2015 10/28/2015 10/29/2015 10/30/2015 11/2/2015 11/3/2015 11/4/2015 11/5/2015 11/6/2015 11/9/2015 11/10/2015 11/11/2015 11/12/2015 11/13/2015 11/16/2015 11/17/2015 11/18/2015 11/19/2015 11/20/2015 11/23/2015 11/24/2015 11/25/2015 11/27/2015 11/30/2015 12/1/2015 12/2/2015 12/3/2015 12/4/2015 12/7/2015 12/8/2015 12/9/2015 12/10/2015 12/11/2015 12/14/2015 12/15/2015 12/16/2015 45.5 43.28 44.17 44.64 48.43 49.86 52.66 48.73 50.47 50.84 49.73 50.06 48.9 50 49.54 48.39 48.99 50.79 50.11 48.55 49.92 50.08 48.63 49.1 49.28 48.01 48.24 49.19 48.6 48.81 50.05 52.02 51.82 52.81 52.84 50.93 50.33 50.4 50.51 50.89 49.77 49.57 49.1 49.27 48.57 47.97 47.28 49.8 49.6 50.18 50.06 51.4 50.16 49.5 48.66 48.57 48.34 47.62 46.33 45.65 46.42 45.63 46.13 45.91 46.01 46.65 47.59 47.67 46.36 45.99 45.99 44.91 46.03 44.83 42.8 42.81 42.45 42.02 40.96 40.81 41.23 45.59 44.84 44.79 48.62 51.36 54.23 53.41 51.21 52.35 51.2 50.65 50.73 50.43 50.3 49.58 49.33 51.14 51.08 50.46 50.29 50.25 50.84 49.23 49.99 49.28 49.03 49.26 50.33 49.11 50.35 52.27 52.91 53.14 53.77 53.2 51.72 50.66 50.69 51.17 51.01 50.15 49.68 49.67 49.71 48.92 47.99 49.92 50.31 50.69 50.45 52.03 52.04 50.31 49.73 49.45 49.02 48.75 47.72 46.96 46.68 46.67 46.3 46.32 46.85 47.04 47.93 48.02 47.83 47.03 46.4 46.35 46.54 46.49 44.83 43.3 43.51 42.73 42.27 41.48 42.3 41.77 42.82 43.27 43.9 44.55 47.66 49.05 48.75 48.12 50.18 49.79 48.39 48.78 48.18 48.63 48.09 48.16 48.99 49.85 48.16 48.51 49.03 48.48 48.01 48.93 47.94 47.97 48.19 48.17 47.47 48.77 49.5 51.39 51.33 52.11 50.55 49.96 49.78 49.24 50.05 49.55 49.37 48.62 48.8 48.38 47.81 46.81 47.11 49.04 49.23 49.46 49.8 49.94 49.2 48.42 48.14 48.07 47.32 46.23 45.28 44.84 45.35 45.19 45.39 45.52 44.98 46.45 46.63 46.3 45.9 45.46 44.66 44.91 44.6 42.62 41.9 41.74 41.94 40.78 39.73 40.73 40.17 43.36 44.33 44.19 48.47 50.52 54.16 49.84 50.82 50.93 50.15 50.44 48.95 50.36 49.32 48.17 48.84 50.79 50.33 48.53 50.27 50.03 48.56 49.04 49.55 48.08 48.64 48.74 48.25 48.91 49.92 52 51.48 52.66 52.82 50.6 50.34 50.44 50.19 51 49.62 49.79 48.9 49.17 48.56 48.1 47.23 49.78 49.76 50.37 50.02 51.74 50.01 49.26 48.64 48.42 48.67 47.39 46.42 45.63 46.35 45.43 45.87 45.79 46.16 46.37 47.69 47.65 46.36 46.05 46.11 44.81 45.78 44.81 42.8 42.45 42.29 42.38 41.15 41.03 41.72 40.36 Err:518 0.97000 Err:518 4.28000 2.05000 3.64000 Err:518 0.98000 0.11000 Err:518 0.29000 Err:518 1.41000 Err:518 Err:518 0.67000 1.95000 Err:518 Err:518 1.74000 Err:518 Err:518 0.48000 0.51000 Err:518 0.56000 0.10000 Err:518 0.66000 1.01000 2.08000 Err:518 1.18000 0.16000 Err:518 Err:518 0.10000 Err:518 0.81000 Err:518 0.17000 Err:518 0.27000 Err:518 Err:518 Err:518 2.55000 Err:518 0.61000 Err:518 1.72000 Err:518 Err:518 Err:518 Err:518 0.25000 Err:518 Err:518 Err:518 0.72000 Err:518 0.44000 Err:518 0.37000 0.21000 1.32000 Err:518 Err:518 Err:518 0.06000 Err:518 0.97000 Err:518 Err:518 Err:518 Err:518 0.09000 Err:518 Err:518 0.69000 Err:518 2.15000 Err:518 0.14000 Err:518 Err:518 Err:518 4.32000 Err:518 Err:518 0.78000 Err:518 1.49000 Err:518 1.04000 1.15000 Err:518 Err:518 0.46000 1.80000 Err:518 0.24000 1.47000 Err:518 Err:518 1.47000 Err:518 Err:518 0.49000 Err:518 Err:518 Err:518 0.52000 Err:518 Err:518 2.22000 0.26000 Err:518 0.25000 Err:518 1.38000 Err:518 0.89000 Err:518 0.61000 0.46000 0.87000 Err:518 0.02000 Err:518 0.35000 Err:518 1.73000 0.75000 0.62000 0.22000 Err:518 1.28000 0.97000 0.79000 Err:518 0.92000 Err:518 0.08000 Err:518 Err:518 Err:518 0.04000 1.29000 0.31000 Err:518 1.30000 Err:518 0.97000 2.01000 0.35000 0.16000 Err:518 1.23000 0.12000 Err:518 1.36000 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 CLM16 12/17/2015 12/18/2015 12/21/2015 12/22/2015 12/23/2015 12/24/2015 12/28/2015 12/29/2015 12/30/2015 12/31/2015 1/4/2016 1/5/2016 1/6/2016 1/7/2016 1/8/2016 1/11/2016 1/12/2016 1/13/2016 1/14/2016 1/15/2016 1/19/2016 1/20/2016 1/21/2016 1/22/2016 1/25/2016 1/26/2016 1/27/2016 1/28/2016 1/29/2016 2/1/2016 2/2/2016 2/3/2016 2/4/2016 2/5/2016 2/8/2016 2/9/2016 2/10/2016 2/11/2016 2/12/2016 2/13/2016 2/14/2016 2/15/2016 2/16/2016 2/17/2016 2/18/2016 2/19/2016 2/20/2016 2/21/2016 2/22/2016 2/23/2016 2/24/2016 2/25/2016 2/26/2016 2/27/2016 2/28/2016 2/29/2016 3/1/2016 3/2/2016 3/3/2016 3/4/2016 3/5/2016 3/6/2016 3/7/2016 3/8/2016 3/9/2016 3/10/2016 3/11/2016 3/12/2016 3/13/2016 3/14/2016 3/15/2016 3/16/2016 3/17/2016 3/18/2016 3/19/2016 3/20/2016 3/21/2016 3/22/2016 3/23/2016 3/24/2016 3/25/2016 40.63 39.75 39.6 39.15 39.41 40.68 41.11 39.9 40.46 40.12 41.15 40.85 40.25 38.38 37.62 37.36 35.65 34.79 34.3 35.05 32.94 32.55 31.94 33.25 35.61 33.9 34.42 35.96 37.39 38.08 36.07 34.44 37 36.38 35.99 35.09 33.14 32.97 33.35 39.3615 39.29556 39.22961 39.16367 39.09773 39.03178 38.96584 38.89989 38.83395 38.76801 38.70206 38.63612 38.57017 38.50423 38.43829 38.37234 38.3064 38.24046 38.17451 38.10857 38.04262 37.97668 37.91074 37.84479 37.77885 37.7129 37.64696 37.58102 37.51507 37.44913 37.38318 37.31724 37.2513 37.18535 37.11941 37.05347 36.98752 36.92158 36.85563 36.78969 36.72375 36.6578 40.8 40.55 39.7 39.55 40.78 41.31 41.11 41.07 40.55 41.25 42.07 40.92 40.25 38.49 38.59 37.37 36.47 35.42 35.28 35.05 34.09 32.55 33.53 35.74 36.24 36.15 36.63 38.52 38.37 38.46 36.13 37.04 37.65 37.19 36.52 35.59 34.32 33.5 34.06 40.11031 39.91949 39.71856 39.50531 39.27853 39.0454 38.81487 38.57443 38.32533 38.07876 37.83986 37.58679 37.32897 37.06337 36.80025 36.53092 36.25792 35.98292 35.7004 35.41262 35.14609 34.88688 34.65031 34.40121 34.14989 33.90141 33.65358 33.39866 33.12983 32.86886 32.61415 32.35586 32.08959 31.80958 31.52525 31.24166 30.95657 30.67406 30.38979 30.10188 29.81232 29.52029 39.72 39.44 38.89 38.97 39.26 40.23 39.79 39.8 39.72 39.62 40.15 39.72 38.07 36.37 36.85 35.3 34.14 33.84 33.82 32.87 32.01 30.79 31.26 32.8 33.7 33.18 34.13 35.65 36.88 35.9 34.25 34.18 35.94 35.71 34.82 32.65 32.7 32.1 33.14 38.41847 38.22463 38.02269 37.80297 37.57514 37.3435 37.10919 36.86977 36.61834 36.36673 36.11241 35.85876 35.58873 35.32532 35.05676 34.78899 34.51633 34.24058 33.96212 33.67666 33.39137 33.12285 32.86872 32.60613 32.33759 32.08489 31.83194 31.57073 31.29574 31.02954 30.77321 30.50644 30.23304 29.94562 29.66276 29.37366 29.08506 28.79403 28.50304 28.21438 27.92305 27.63261 40.02 39.7 39.19 39.14 40.38 41.25 40.04 41.01 39.92 40.71 40.55 39.94 38.16 37.58 37.49 35.75 34.63 34.12 34.96 33.15 32.57 31.77 32.86 35.65 34.21 35.27 36.12 37.09 38 36.23 34.63 36.67 36.3 35.94 34.92 32.74 32.96 32.21 33.41 39.09761 38.90382 38.69596 38.47025 38.23982 38.00812 37.77532 37.529 37.27851 37.03303 36.77229 36.51917 36.24912 35.98173 35.70697 35.43222 35.15227 34.87699 34.59058 34.30263 34.0367 33.77657 33.53686 33.26981 33.01029 32.7538 32.50077 32.23387 31.95945 31.69872 31.43881 31.17808 30.9045 30.61941 30.33221 30.04387 29.75173 29.46918 29.17066 28.88298 28.58401 28.28963 Err:518 Err:518 Err:518 Err:518 1.24000 0.87000 Err:518 0.97000 Err:518 0.79000 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 0.84000 Err:518 Err:518 Err:518 1.09000 2.79000 Err:518 1.06000 0.85000 0.97000 0.91000 Err:518 Err:518 2.04000 Err:518 Err:518 Err:518 Err:518 0.22000 Err:518 1.20000 5.68761 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 0.34000 0.32000 0.51000 0.05000 Err:518 Err:518 1.21000 Err:518 1.09000 Err:518 0.16000 0.61000 1.78000 0.58000 0.09000 1.74000 1.12000 0.51000 Err:518 1.81000 0.58000 0.80000 Err:518 Err:518 1.44000 Err:518 Err:518 Err:518 Err:518 1.77000 1.60000 Err:518 0.37000 0.36000 1.02000 2.18000 Err:518 0.75000 Err:518 Err:518 0.19379 0.20786 0.22572 0.23043 0.23170 0.23280 0.24632 0.25049 0.24547 0.26074 0.25312 0.27005 0.26740 0.27475 0.27476 0.27995 0.27527 0.28641 0.28795 0.26593 0.26013 0.23971 0.26705 0.25952 0.25649 0.25303 0.26690 0.27442 0.26072 0.25991 0.26073 0.27358 0.28510 0.28720 0.28834 0.29214 0.28254 0.29852 0.28768 0.29898 0.29438 52.7 52.6 52.5 52.4 52.3 Values 52.2 52.1 Column O 52 51.9 51.8 51.7 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Days of t he mont h 0.76230 0.70785 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 0.68698 0.65276 0.62226 0.59427 0.56837 0.54440 0.52311 0.50364 0.48520 0.46916 0.45373 0.44061 0.42824 0.41728 0.40710 0.39801 1.1096363945 52.59847 1.084397903 52.02452 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 3/26/2016 3/27/2016 3/28/2016 3/29/2016 3/30/2016 3/31/2016 4/1/2016 4/2/2016 4/3/2016 4/4/2016 4/5/2016 4/6/2016 4/7/2016 4/8/2016 4/9/2016 4/10/2016 4/11/2016 4/12/2016 4/13/2016 4/14/2016 4/15/2016 4/16/2016 4/17/2016 4/18/2016 4/19/2016 4/20/2016 4/21/2016 4/22/2016 4/23/2016 4/24/2016 4/25/2016 4/26/2016 4/27/2016 4/28/2016 4/29/2016 4/30/2016 5/1/2016 5/2/2016 5/3/2016 5/4/2016 5/5/2016 5/6/2016 5/7/2016 5/8/2016 5/9/2016 5/10/2016 5/11/2016 5/12/2016 5/13/2016 5/14/2016 5/15/2016 5/16/2016 5/17/2016 5/18/2016 5/19/2016 5/20/2016 5/21/2016 5/22/2016 5/23/2016 5/24/2016 5/25/2016 5/26/2016 5/27/2016 5/28/2016 5/29/2016 5/30/2016 5/31/2016 6/1/2016 6/2/2016 6/3/2016 6/4/2016 6/5/2016 6/6/2016 6/7/2016 6/8/2016 6/9/2016 6/10/2016 6/11/2016 6/12/2016 6/13/2016 6/14/2016 36.59186 36.52591 36.45997 36.39403 36.32808 36.26214 36.19619 36.13025 36.06431 35.99836 35.93242 35.86647 35.80053 35.73459 35.66864 35.6027 35.53676 35.47081 35.40487 35.33892 35.27298 35.20704 35.14109 35.07515 35.0092 34.94326 34.87732 34.81137 34.74543 34.67948 34.61354 34.5476 34.48165 34.41571 34.34977 34.28382 34.21788 34.15193 34.08599 34.02005 33.9541 33.88816 33.82221 33.75627 33.69033 33.62438 33.55844 33.49249 33.42655 33.36061 33.29466 33.22872 33.16278 33.09683 33.03089 32.96494 32.899 32.83306 32.76711 32.70117 32.63522 32.56928 32.50334 32.43739 32.37145 32.3055 32.23956 32.17362 32.10767 32.04173 31.97578 31.90984 31.8439 31.77795 31.71201 31.64607 31.58012 31.51418 31.44823 31.38229 31.31635 29.22057 28.91552 28.6051 28.28573 27.95388 27.61077 27.27025 26.91914 26.54715 26.16359 25.78677 25.39518 25.00188 24.60599 24.21107 23.81269 23.43285 23.03692 22.624 22.20286 21.7887 21.36748 20.9508 20.53483 20.10392 19.66697 19.22684 18.78926 18.34932 17.92199 17.49895 17.06887 16.63748 16.20138 15.75963 15.32258 14.88063 14.4363 13.98534 13.53639 13.082 12.62543 12.16665 11.71451 11.26608 10.80521 10.32596 9.840022 9.365018 8.888275 8.399635 7.899833 7.401962 6.883327 6.348016 5.820876 5.286011 4.742212 4.177593 3.592737 3.027513 2.456081 1.885162 1.307822 0.714853 0.115482 -0.494036 -1.09405 -1.689994 -2.296084 -2.916845 -3.551304 -4.186225 -4.81668 -5.457089 -6.107467 -6.766822 -7.425147 -8.0888 -8.774443 -9.471778 27.33291 27.02896 26.7161 26.39665 26.06226 25.72029 25.37507 25.01359 24.63376 24.24632 23.84915 23.45355 23.05181 22.65146 22.25072 21.84532 21.44528 21.03463 20.61787 20.19296 19.76403 19.33147 18.90753 18.48684 18.04701 17.60691 17.16041 16.72124 16.28262 15.84228 15.40752 14.9741 14.53295 14.09266 13.6437 13.19572 12.75421 12.30984 11.85699 11.40023 10.94332 10.48784 10.03089 9.572723 9.116678 8.638379 8.150872 7.667434 7.18634 6.704477 6.211295 5.708167 5.200893 4.671223 4.137258 3.604865 3.068225 2.509188 1.935319 1.348908 0.765139 0.191272 -0.383666 -0.967807 -1.570997 -2.188444 -2.797759 -3.409148 -4.009268 -4.6173 -5.237237 -5.873911 -6.508023 -7.153124 -7.799245 -8.457671 -9.122215 -9.786981 -10.46068 -11.14725 -11.84658 27.98779 27.67502 27.35549 27.02936 26.68626 26.34293 25.99131 25.62231 25.24191 24.84565 24.4654 24.06437 23.66852 23.27163 22.86408 22.46233 22.07082 21.65591 21.23997 20.81147 20.39484 19.96054 19.54262 19.12297 18.67392 18.22839 17.78689 17.3416 16.89642 16.46723 16.03728 15.59769 15.16369 14.71794 14.27016 13.82719 13.38361 12.93306 12.47541 12.0196 11.56336 11.10513 10.6433 10.18422 9.722293 9.235575 8.751267 8.26239 7.782041 7.292606 6.794338 6.290107 5.773886 5.233316 4.695181 4.163389 3.617682 3.048594 2.462881 1.873037 1.303969 0.724291 0.148583 -0.444303 -1.058318 -1.660596 -2.279668 -2.884714 -3.485483 -4.099369 -4.730852 -5.370378 -6.010731 -6.657642 -7.305937 -7.9691 -8.632441 -9.297684 -9.978981 -10.6754 -11.37911 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 0.30184 0.31278 0.31953 0.32613 0.34309 0.34333 0.35163 0.36900 0.38040 0.39627 0.38025 0.40103 0.39584 0.39690 0.40754 0.40175 0.39151 0.41491 0.41594 0.42849 0.41663 0.43430 0.41792 0.41964 0.44905 0.44553 0.44150 0.44529 0.44518 0.42919 0.42995 0.43958 0.43400 0.44575 0.44778 0.44297 0.44358 0.45055 0.45765 0.45581 0.45624 0.45823 0.46183 0.45909 0.46192 0.48672 0.48431 0.48888 0.48035 0.48944 0.49827 0.50423 0.51622 0.54057 0.53813 0.53179 0.54571 0.56909 0.58571 0.58984 0.56907 0.57968 0.57571 0.59289 0.61401 0.60228 0.61907 0.60505 0.60077 0.61389 0.63148 0.63953 0.64035 0.64691 0.64830 0.66316 0.66334 0.66524 0.68130 0.69642 0.70371 6/15/2016 6/16/2016 6/17/2016 6/18/2016 6/19/2016 6/20/2016 6/21/2016 6/22/2016 6/23/2016 6/24/2016 6/25/2016 6/26/2016 6/27/2016 6/28/2016 6/29/2016 6/30/2016 7/1/2016 7/2/2016 7/3/2016 7/4/2016 7/5/2016 7/6/2016 7/7/2016 7/8/2016 7/9/2016 7/10/2016 7/11/2016 7/12/2016 7/13/2016 7/14/2016 7/15/2016 7/16/2016 7/17/2016 7/18/2016 7/19/2016 7/20/2016 7/21/2016 7/22/2016 7/23/2016 7/24/2016 7/25/2016 7/26/2016 7/27/2016 7/28/2016 7/29/2016 7/30/2016 7/31/2016 8/1/2016 8/2/2016 8/3/2016 8/4/2016 8/5/2016 8/6/2016 8/7/2016 8/8/2016 8/9/2016 8/10/2016 8/11/2016 8/12/2016 8/13/2016 8/14/2016 8/15/2016 8/16/2016 8/17/2016 8/18/2016 8/19/2016 8/20/2016 8/21/2016 8/22/2016 8/23/2016 8/24/2016 8/25/2016 8/26/2016 8/27/2016 8/28/2016 8/29/2016 8/30/2016 8/31/2016 9/1/2016 9/2/2016 9/3/2016 31.2504 31.18446 31.11851 31.05257 30.98663 30.92068 30.85474 30.78879 30.72285 30.65691 30.59096 30.52502 30.45908 30.39313 30.32719 30.26124 30.1953 30.12936 30.06341 29.99747 29.93152 29.86558 29.79964 29.73369 29.66775 29.6018 29.53586 29.46992 29.40397 29.33803 29.27208 29.20614 29.1402 29.07425 29.00831 28.94237 28.87642 28.81048 28.74453 28.67859 28.61265 28.5467 28.48076 28.41481 28.34887 28.28293 28.21698 28.15104 28.08509 28.01915 27.95321 27.88726 27.82132 27.75538 27.68943 27.62349 27.55754 27.4916 27.42566 27.35971 27.29377 27.22782 27.16188 27.09594 27.02999 26.96405 26.8981 26.83216 26.76622 26.70027 26.63433 26.56839 26.50244 26.4365 26.37055 26.30461 26.23867 26.17272 26.10678 26.04083 25.97489 -10.18355 -10.89913 -11.63164 -12.38133 -13.15175 -13.97676 -14.8181 -15.65965 -16.50727 -17.36733 -18.23948 -19.12469 -20.03974 -20.98142 -21.93703 -22.89898 -23.88111 -24.89202 -25.93098 -26.993 -28.06383 -29.14245 -30.24161 -31.36422 -32.51792 -33.70656 -34.91051 -36.15108 -37.41023 -38.68291 -39.97089 -41.2958 -42.6421 -44.01662 -45.41671 -46.84825 -48.31088 -49.82445 -51.37975 -52.97414 -54.60904 -56.27649 -57.91358 -59.53437 -61.13607 -62.77772 -64.48362 -66.20065 -67.96438 -69.76756 -71.6004 -73.47178 -75.37754 -77.32774 -79.31664 -81.31201 -83.34392 -85.42254 -87.53998 -89.69617 -91.88159 -94.1356 -96.41686 -98.75007 -101.1303 -103.5514 -106 -108.5129 -111.0495 -113.5993 -116.1854 -118.8159 -121.4814 -124.2034 -127.0021 -129.8726 -132.7972 -135.7661 -138.7922 -141.8915 -145.0589 -12.5598 -13.28313 -14.02485 -14.78037 -15.59797 -16.44829 -17.30015 -18.15077 -19.01175 -19.88838 -20.77562 -21.67917 -22.60111 -23.54724 -24.50465 -25.47341 -26.46605 -27.48455 -28.52798 -29.59131 -30.67319 -31.76721 -32.86719 -33.99899 -35.17063 -36.35966 -37.57791 -38.82019 -40.08652 -41.37652 -42.68371 -44.01634 -45.36904 -46.7496 -48.15336 -49.58521 -51.07051 -52.5994 -54.16391 -55.79116 -57.44149 -59.11312 -60.80581 -62.47682 -64.15409 -65.86658 -67.6192 -69.37014 -71.15559 -72.99422 -74.85988 -76.76844 -78.70351 -80.67995 -82.69035 -84.72411 -86.77983 -88.90028 -91.05169 -93.23338 -95.46434 -97.74563 -100.051 -102.4137 -104.8198 -107.2666 -109.7602 -112.3098 -114.883 -117.4913 -120.1149 -122.7892 -125.496 -128.2776 -131.1221 -134.024 -136.9903 -139.9955 -143.0644 -146.1951 -149.3997 -12.1047 -12.82589 -13.58027 -14.34457 -15.17576 -16.01812 -16.87543 -17.73136 -18.59353 -19.46863 -20.35018 -21.26671 -22.20626 -23.15836 -24.12783 -25.10235 -26.10991 -27.14579 -28.20136 -29.27569 -30.36223 -31.46069 -32.57712 -33.72104 -34.91128 -36.11689 -37.35089 -38.60549 -39.89176 -41.17646 -42.50218 -43.84482 -45.21443 -46.60578 -48.02985 -49.4772 -50.98002 -52.51741 -54.1002 -55.74424 -57.40389 -59.09733 -60.75288 -62.40309 -64.02286 -65.74059 -67.47111 -69.23085 -71.03114 -72.85851 -74.74304 -76.63704 -78.58111 -80.57731 -82.59873 -84.62514 -86.69416 -88.83005 -90.9744 -93.16125 -95.41323 -97.6994 -100.0162 -102.3996 -104.818 -107.2795 -109.7957 -112.3442 -114.9227 -117.5117 -120.1586 -122.8333 -125.551 -128.3568 -131.2207 -134.1369 -137.1115 -140.125 -143.2201 -146.3706 -149.5981 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 0.72559 0.72118 0.75438 0.76430 0.83119 0.84236 0.85731 0.85593 0.86217 0.87510 0.88155 0.91653 0.93955 0.95210 0.96947 0.97452 1.00756 1.03588 1.05557 1.07433 1.08655 1.09846 1.11642 1.14392 1.19024 1.20561 1.23400 1.25460 1.28628 1.28470 1.32572 1.34263 1.36961 1.39135 1.42407 1.44735 1.50282 1.53739 1.58279 1.64404 1.65965 1.69344 1.65555 1.65021 1.61977 1.71773 1.73052 1.75973 1.80029 1.82737 1.88453 1.89400 1.94406 1.99620 2.02141 2.02642 2.06902 2.13589 2.14435 2.18685 2.25198 2.28617 2.31679 2.38338 2.41843 2.46153 2.51620 2.54851 2.57850 2.58899 2.64685 2.67474 2.71764 2.80587 2.86386 2.91623 2.97460 3.01349 3.09507 3.15054 3.22745 9/4/2016 9/5/2016 9/6/2016 9/7/2016 9/8/2016 9/9/2016 9/10/2016 9/11/2016 9/12/2016 9/13/2016 9/14/2016 9/15/2016 9/16/2016 9/17/2016 9/18/2016 9/19/2016 9/20/2016 9/21/2016 9/22/2016 9/23/2016 9/24/2016 9/25/2016 9/26/2016 9/27/2016 9/28/2016 9/29/2016 25.90895 25.843 25.77706 25.71111 25.64517 25.57923 25.51328 25.44734 25.38139 25.31545 25.24951 25.18356 25.11762 25.05168 24.98573 24.91979 24.85384 24.7879 24.72196 24.65601 24.59007 24.52412 24.45818 24.39224 24.32629 24.26035 -148.2877 -151.575 -154.939 -158.3864 -161.8653 -165.4048 -169.0034 -172.6765 -176.3917 -180.1783 -184.0709 -188.0489 -192.1105 -196.2604 -200.4978 -204.8398 -209.2816 -213.8185 -218.4481 -223.1801 -228.0058 -232.9183 -237.9277 -243.0232 -248.2221 -253.529 -152.6625 -155.9924 -159.3957 -162.8841 -166.4355 -170.0201 -173.6682 -177.383 -181.164 -185.0159 -188.956 -192.9855 -197.1006 -201.2982 -205.5932 -209.9941 -214.4998 -219.1054 -223.7951 -228.5842 -233.4641 -238.4395 -243.5273 -248.6921 -253.9593 -259.3382 -152.8813 -156.236 -159.6647 -163.1759 -166.7087 -170.3093 -173.9665 -177.702 -181.4777 -185.3579 -189.3273 -193.3849 -197.5274 -201.7472 -206.0739 -210.5051 -215.0406 -219.6533 -224.3784 -229.1907 -234.0999 -239.102 -244.2021 -249.3826 -254.6685 -260.0855 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 Err:518 3.28324 3.35470 3.42872 3.51118 3.53282 3.60060 3.65714 3.73554 3.77575 3.88015 3.96940 4.05764 4.14245 4.21979 4.32673 4.43122 4.53548 4.61264 4.72515 4.81229 4.90924 5.00208 5.10004 5.18057 5.28584 5.41709 70 f(x) = - 0.0672279772x + 2890.437812062 R = 0.7708273146 60 50 40 Prices 30 20 10 0 1/4/2015 1/8/2015 1/12/2015 1/16/2015 1/20/2015 1/24/2015 1/28/2015 2/1/2015 2/5/2015 2/9/2015 2/13/2015 2/17/2015 2/21/2015 2/25/2015 3/1/2015 3/5/2015 3/9/2015 3/13/2015 3/17/2015 3/21/2015 3/25 1/2/2015 1/6/2015 1/10/2015 1/14/2015 1/18/2015 1/22/2015 1/26/2015 1/30/2015 2/3/2015 2/7/2015 2/11/2015 2/15/2015 2/19/2015 2/23/2015 2/27/2015 3/3/2015 3/7/2015 3/11/2015 3/15/2015 3/19/2015 3/23/2015 3/25/2015 3/29/2015 4/2/2015 4/6/2015 4/10/2015 4/14/2015 4/18/2015 4/22/2015 4/26/2015 4/30/2015 5/4/2015 5/8/2015 5/12/2015 5/16/2015 5/20/2015 5/24/2015 5/28/2015 6/1/2015 6/5/2015 6/9/2015 6/13/2015 6/17/2015 6/21/2015 6/25/2015 6/29/20 015 3/27/2015 3/31/2015 4/4/2015 4/8/2015 4/12/2015 4/16/2015 4/20/2015 4/24/2015 4/28/2015 5/2/2015 5/6/2015 5/10/2015 5/14/2015 5/18/2015 5/22/2015 5/26/2015 5/30/2015 6/3/2015 6/7/2015 6/11/2015 6/15/2015 6/19/2015 6/23/2015 6/27/2015 29/2015 7/3/2015 7/7/2015 7/11/2015 7/15/2015 7/19/2015 7/23/2015 7/27/2015 7/31/2015 8/4/2015 8/8/2015 8/12/2015 8/16/2015 8/20/2015 8/24/2015 8/28/2015 9/1/2015 9/5/2015 9/9/2015 9/13/2015 9/17/2015 9/21/2015 9/25/2015 9/29/2015 10/3/201 5 7/1/2015 7/5/2015 7/9/2015 7/13/2015 7/17/2015 7/21/2015 7/25/2015 7/29/2015 8/2/2015 8/6/2015 8/10/2015 8/14/2015 8/18/2015 8/22/2015 8/26/2015 8/30/2015 9/3/2015 9/7/2015 9/11/2015 9/15/2015 9/19/2015 9/23/2015 9/27/2015 10/1/2015 10 Mont hs /2015 10/7/2015 10/11/2015 10/15/2015 10/19/2015 10/23/2015 10/27/2015 10/31/2015 11/4/2015 11/8/2015 11/12/2015 11/16/2015 11/20/2015 11/24/2015 11/28/2015 12/2/2015 12/6/2015 12/10/2015 12/14/2015 12/18/2015 12/22/2015 12/26/2015 12/30/2015 1/3/2016 1/7/2016 10/5/2015 10/9/2015 10/13/2015 10/17/2015 10/21/2015 10/25/2015 10/29/2015 11/2/2015 11/6/2015 11/10/2015 11/14/2015 11/18/2015 11/22/2015 11/26/2015 11/30/2015 12/4/2015 12/8/2015 12/12/2015 12/16/2015 12/20/2015 12/24/2015 12/28/2015 1/1/2016 1/5/2016 1/9 16 1/11/2016 1/15/2016 1/19/2016 1/23/2016 1/27/2016 1/31/2016 2/4/2016 2/8/2016 2/12/2016 1/9/2016 1/13/2016 1/17/2016 1/21/2016 1/25/2016 1/29/2016 2/2/2016 2/6/2016 2/10/2016 Open Linear (Open) High Linear (High) Low Linear (Low) Last Linear (Last) 52.7 52.6 52.5 52.4 52.3 Values 52.2 52.1 Column O 52 51.9 51.8 51.7 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Days of the mont h 1 No signal to sell or buy has been indicated by the data Analysis 2 From the evaluation it is easy to draw clear information on how stock should be sold and bought using the RSI It is difficult to calculate the RSI which makes it hard to implement in a business setting