Date dax BMW walsvagan

4/27/2017 12443.8 84.3 144.8

4/28/2017 12438.0 84.2 146.0
5/2/2017 12507.9 84.3 145.6
5/3/2017 12527.8 83.5 144.2
5/4/2017 12647.8 83.9 145.2
5/5/2017 12716.9 85.6 145.5
5/8/2017 12694.5 86.4 146.9
5/9/2017 12749.1 86.1 146.2
5/10/2017 12757.5 87.0 146.7
5/11/2017 12711.1 86.6 147.2
5/12/2017 12770.4 87.2 146.8
5/15/2017 12807.0 87.3 148.0
5/16/2017 12804.5 86.7 147.4
5/17/2017 12631.6 86.4 144.8
5/18/2017 12590.1 85.2 142.6
5/19/2017 12638.7 86.2 143.1
5/22/2017 12619.5 85.9 142.9
5/23/2017 12659.2 86.3 143.1
5/24/2017 12642.9 85.8 143.1
5/25/2017 12621.7 85.2 142.8
5/26/2017 12602.2 84.3 142.6
5/29/2017 12629.0 84.6 141.9
5/30/2017 12598.7 84.2 141.6
5/31/2017 12615.1 83.3 139.4
6/1/2017 12664.9 84.9 140.6
6/2/2017 12822.9 85.9 141.9
6/5/2017 12822.9 85.9 141.9
6/6/2017 12690.1 84.8 139.8
6/7/2017 12672.5 84.6 137.9
6/8/2017 12713.6 84.1 137.8
6/9/2017 12815.7 84.4 137.9
6/12/2017 12690.4 84.9 139.3
6/13/2017 12765.0 85.1 139.8
6/14/2017 12806.0 84.1 138.0
6/15/2017 12691.8 83.4 136.8
6/16/2017 12752.7 83.4 135.6
6/19/2017 12889.0 84.0 135.9
6/20/2017 12814.8 83.7 136.1
6/21/2017 12774.3 83.6 135.9
6/22/2017 12794.0 84.2 138.9
6/23/2017 12733.4 83.6 137.1
6/26/2017 12770.8 83.5 137.1
6/27/2017 12671.0 82.9 138.1
6/28/2017 12647.3 83.7 137.7
6/29/2017 12416.2 82.7 136.2
6/30/2017 12325.1 81.3 135.8
7/3/2017 12475.3 83.0 137.6
7/4/2017 12437.1 82.3 137.9
7/5/2017 12453.7 81.5 137.7
7/6/2017 12381.3 81.4 140.7
7/7/2017 12388.7 81.4 141.2
7/10/2017 12445.9 81.6 140.8
7/11/2017 12437.0 83.0 142.1
7/12/2017 12626.6 84.2 144.0
7/13/2017 12641.3 84.4 145.4
7/14/2017 12631.7 83.7 146.7
7/17/2017 12587.2 83.7 146.8
7/18/2017 12430.4 83.3 145.6
7/19/2017 12452.0 83.3 146.4
7/20/2017 12447.3 83.4 145.4
7/21/2017 12240.1 81.2 141.4
7/24/2017 12209.0 78.9 137.8
7/25/2017 12264.3 79.4 136.9
7/26/2017 12305.1 79.1 138.4
7/27/2017 12212.0 78.5 136.1
7/28/2017 12162.7 77.8 134.3
7/31/2017 12118.3 77.7 132.9
8/1/2017 12251.3 78.9 134.3
8/2/2017 12181.5 78.9 133.5
8/3/2017 12154.7 79.4 131.2
8/4/2017 12297.7 81.3 131.9
8/7/2017 12257.2 81.0 131.4
8/8/2017 12292.0 80.8 131.8
8/9/2017 12154.0 80.1 129.9
8/10/2017 12014.3 80.1 128.7
8/11/2017 12014.1 79.9 129.1
8/14/2017 12165.1 80.2 130.3
8/15/2017 12177.0 80.0 130.8
8/16/2017 12263.9 80.1 132.1
8/17/2017 12203.5 79.8 131.1
8/18/2017 12165.2 79.5 130.1
8/21/2017 12066.0 79.0 129.1
8/22/2017 12229.3 79.4 129.1
 8/23/2017 12174.3 79.1 129.5
8/24/2017 12180.8 79.8 130.6
8/25/2017 12167.9 79.3 131.1
8/28/2017 12123.5 79.2 131.1
8/29/2017 11945.9 78.3 129.5
8/30/2017 12002.5 78.4 129.6
8/31/2017 12055.8 78.0 129.6
9/1/2017 12142.6 79.0 131.1
9/4/2017 12102.2 79.1 131.4
9/5/2017 12123.7 80.5 133.1
9/6/2017 12214.5 81.8 135.0
9/7/2017 12296.6 82.7 135.6
9/8/2017 12304.0 82.5 136.3
9/11/2017 12475.2 82.8 137.2
9/12/2017 12524.8 83.6 139.8
9/13/2017 12553.6 84.1 139.9
9/14/2017 12540.5 84.4 139.8
9/15/2017 12518.8 84.8 140.8
9/18/2017 12559.4 84.6 141.7
9/19/2017 12561.8 84.7 141.8
9/20/2017 12569.2 84.5 141.8
9/21/2017 12600.0 85.1 142.8
9/22/2017 12592.3 85.1 143.8
9/25/2017 12594.8 84.8 143.3
9/26/2017 12605.2 84.9 145.5
9/27/2017 12657.4 85.0 144.9
9/28/2017 12704.7 84.4 143.9
9/29/2017 12828.9 85.8 143.3
10/2/2017 12902.7 86.2 143.6
10/3/2017 12902.7 86.2 143.6
10/4/2017 12970.5 88.5 146.8
10/5/2017 12968.0 88.7 147.9
10/6/2017 12955.9 89.1 148.3
10/9/2017 12976.4 88.9 147.6
10/10/2017 12949.3 88.4 147.2
10/11/2017 12970.7 88.4 148.6
10/12/2017 12982.9 87.8 149.4
10/13/2017 12991.9 87.3 149.1
10/16/2017 13003.7 87.1 149.6
10/17/2017 12995.1 87.4 148.4
10/18/2017 13043.0 88.2 149.9
10/19/2017 12990.1 87.4 148.7
10/20/2017 12991.3 86.3 148.2
10/23/2017 13003.1 86.0 148.6
10/24/2017 13013.2 86.4 150.7
10/25/2017 12953.4 85.5 149.6
10/26/2017 13133.3 86.3 150.0
10/27/2017 13217.5 87.2 154.6
10/30/2017 13229.6 87.5 159.4
10/31/2017 13229.6 87.5 159.4
11/1/2017 13465.5 89.3 167.9
11/2/2017 13440.9 89.9 166.3
11/3/2017 13478.9 89.6 165.1
11/6/2017 13468.8 90.0 165.4
11/7/2017 13379.3 87.4 164.1
11/8/2017 13382.4 87.2 162.1
11/9/2017 13182.6 86.9 161.2
11/10/2017 13127.5 86.3 159.3
11/13/2017 13074.4 86.2 158.9
11/14/2017 13033.5 86.1 158.0
11/15/2017 12976.4 85.3 156.5
11/16/2017 13047.2 85.3 160.1
11/17/2017 12993.7 84.9 161.1
11/20/2017 13058.7 85.2 166.8
11/21/2017 13167.5 86.8 170.1
11/22/2017 13015.0 86.6 167.8
11/23/2017 13008.5 86.3 168.8
11/24/2017 13059.8 86.4 169.1
11/27/2017 13000.2 85.7 168.7
11/28/2017 13059.5 84.9 168.9
11/29/2017 13061.9 84.7 171.9
11/30/2017 13024.0 84.7 173.9
12/1/2017 12861.5 83.6 169.5
12/4/2017 13058.5 85.3 170.5
12/5/2017 13048.5 85.5 169.5
12/6/2017 12998.8 85.1 165.6
12/7/2017 13045.2 84.8 166.8
12/8/2017 13153.7 85.5 170.1
12/11/2017 13123.7 85.5 170.3
12/12/2017 13183.5 86.0 170.1
12/13/2017 13125.6 85.7 169.9
12/14/2017 13068.1 86.2 170.6
12/15/2017 13103.6 85.9 169.1
12/18/2017 13312.3 87.0 172.7
12/19/2017 13215.8 87.1 172.6
12/20/2017 13069.2 86.9 169.9
12/21/2017 13109.7 87.8 170.9
12/22/2017 13072.8 87.5 170.0
12/27/2017 13070.0 87.3 169.9
12/28/2017 12979.9 87.1 170.0
12/29/2017 12917.6 86.8 168.7
1/2/2018 12871.4 86.4 168.8
1/3/2018 12978.2 86.9 170.9
1/4/2018 13167.9 87.5 174.2
1/5/2018 13319.6 88.5 178.2
1/8/2018 13367.8 89.7 180.0
1/9/2018 13385.6 90.2 180.8
1/10/2018 13281.3 89.4 179.5
1/11/2018 13202.9 88.7 178.0
1/12/2018 13245.0 89.8 181.0
1/15/2018 13200.5 89.8 181.1
1/16/2018 13246.3 92.6 186.1
1/17/2018 13184.0 92.3 182.7
1/18/2018 13281.4 93.1 184.1
1/19/2018 13434.5 94.7 185.8
1/22/2018 13463.7 96.3 188.0
1/23/2018 13559.6 95.3 185.8
1/24/2018 13414.7 94.3 184.5
1/25/2018 13298.4 93.3 182.0
1/26/2018 13340.2 93.8 183.0
1/29/2018 13324.5 93.5 183.6
1/30/2018 13197.7 92.6 179.9
1/31/2018 13189.5 92.0 178.5
2/1/2018 13003.9 91.5 178.0
2/2/2018 12785.2 90.2 174.9
2/5/2018 12687.5 89.3 169.9
2/6/2018 12392.7 88.1 166.2
2/7/2018 12590.4 89.1 172.8
2/8/2018 12260.3 87.5 167.9
2/9/2018 12107.5 86.6 166.7
2/12/2018 12282.8 87.3 169.0
2/13/2018 12196.5 86.7 169.4
2/14/2018 12339.2 88.0 169.8
2/15/2018 12346.2 87.4 170.7
2/16/2018 12452.0 88.1 171.2
2/19/2018 12385.6 87.3 170.3
2/20/2018 12487.9 86.8 168.4
2/21/2018 12470.5 86.8 166.4
2/22/2018 12461.9 87.2 167.3
2/23/2018 12483.8 87.1 166.8
2/26/2018 12527.0 87.8 168.8
2/27/2018 12490.7 87.7 166.7
2/28/2018 12435.8 86.8 164.5
3/1/2018 12190.9 85.3 161.7
3/2/2018 11913.7 84.0 157.9
3/5/2018 12090.9 83.5 157.8
3/6/2018 12113.9 84.2 160.7
3/7/2018 12245.4 84.9 159.1
3/8/2018 12355.6 85.0 160.4
3/9/2018 12346.7 85.1 160.4
3/12/2018 12418.4 85.7 161.0
3/13/2018 12221.0 84.6 157.6
3/14/2018 12237.7 84.2 159.9
3/15/2018 12345.6 85.1 163.8
3/16/2018 12389.6 85.9 164.0
3/19/2018 12217.0 85.2 160.6
3/20/2018 12307.3 86.0 162.0
3/21/2018 12309.2 86.1 161.7
3/22/2018 12100.1 85.3 159.1
3/23/2018 11886.3 84.2 155.6
3/26/2018 11787.3 85.2 157.0
3/27/2018 11970.8 85.8 159.7
3/28/2018 11940.7 85.6 157.1
3/29/2018 12096.7 88.2 162.6
4/3/2018 12002.5 88.7 164.0
4/4/2018 11957.9 87.4 162.1
4/5/2018 12305.2 88.7 166.5
4/6/2018 12241.3 89.0 165.5
4/9/2018 12261.8 88.3 164.4
4/10/2018 12397.3 90.0 169.6
4/11/2018 12294.0 89.9 171.2
4/12/2018 12415.0 89.9 173.7
4/13/2018 12442.4 91.3 173.5
4/16/2018 12391.4 90.7 170.4
4/17/2018 12585.6 91.2 172.5
4/18/2018 12590.8 90.8 173.0
4/19/2018 12567.4 90.9 171.1
4/20/2018 12540.5 91.0 169.7
4/23/2018 12572.4 91.2 168.2
4/24/2018 12550.8 91.1 168.7
4/25/2018 12422.3 89.3 165.7
4/26/2018 12500.5 90.4 169.7
 dax BMW walsvagan

Mean 12663.4811121 Mean 85.640120843 Mean

Standard Error 25.1174262376 Standard Error 0.2222112614 Standard Error
Median 12626.580078 Median 85.709999 Median
Mode 12822.94043 Mode 83.599998 Mode
Standard Deviation 401.093132208 Standard Deviation 3.5484292854 Standard Deviation
Sample Variance 160875.700705 Sample Variance 12.591350394 Sample Variance
Kurtosis -0.8953187878 Kurtosis 0.247331631 Kurtosis
Skewness 0.1477212971 Skewness 0.059963314 Skewness
Range 1772.339843 Range 18.550003 Range
Minimum 11787.259766 Minimum 77.709999 Minimum
Maximum 13559.599609 Maximum 96.260002 Maximum
Sum 3229187.6836 Sum 21838.230815 Sum
Count 255 Count 255 Count
154.14540274
0.9954978126
149.949997
131.149994
15.896825255
252.70905319
-1.21040816
0.1460438037
59.300003
128.699997
188
39307.077698
255
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.6080831283
R Square 0.3697650909
Adjusted R Square 0.3647632266
Standard Error 319.67821483
Observations 255

ANOVA
df SS MS F Significance F
Regression 2 15109499.39725 7554749.6986 73.925453488 5.4614677E-26
Residual 252 25752928.58177 102194.16104
Total 254 40862427.97902

Coefficients Standard Error t Stat P-value Lower 95%

Intercept 6975.5212625 606.6505032038 11.498418324 7.0722412E-25 5780.77019349
BMW 64.286057347 10.0388118287 6.4037516036 7.3709014E-10 44.5153968095
walsvagan 1.1839090024 2.2408256562 0.5283360618 0.5977310696 -3.2292231618

beta computation with the help of regression tool from the data analysis tool. W
dependent to each other as the P-value to below 0.5. so we can compute the say tha
are highly dependent to forecast
 Upper 95% Lower 95.0% Upper 95.0%
8170.2723314 5780.77019349 8170.2723314
84.056717884 44.5153968095 84.056717884
5.5970411667 -3.2292231618 5.5970411667

ta analysis tool. Where all the variable are inter-

mpute the say that both varible stock price and DAX
forecast
 DAX
Date Adj Close Days T-50 MA T-200 MA
4/27/2017 144.8 1 #N/A #N/A
4/28/2017 146.0 2 #N/A #N/A
5/2/2017 145.6 3 #N/A #N/A
5/3/2017 144.2 4 #N/A #N/A
5/4/2017 145.2 5 #N/A #N/A 185
5/5/2017 145.5 6 #N/A #N/A
5/8/2017 146.9 7 #N/A #N/A
5/9/2017 146.2 8 #N/A #N/A
5/10/2017 146.7 9 #N/A #N/A 175
5/11/2017 147.2 10 #N/A #N/A
5/12/2017 146.8 11 #N/A #N/A
5/15/2017 148.0 12 #N/A #N/A
5/16/2017 147.4 13 #N/A #N/A 165
5/17/2017 144.8 14 #N/A #N/A
5/18/2017 142.6 15 #N/A #N/A
5/19/2017 143.1 16 #N/A #N/A
5/22/2017 142.9 17 #N/A #N/A

Axis Title
155
5/23/2017 143.1 18 #N/A #N/A
5/24/2017 143.1 19 #N/A #N/A
5/25/2017 142.8 20 145.3 #N/A
5/26/2017 142.6 21 145.2 #N/A 145
5/29/2017 141.9 22 145.0 #N/A
5/30/2017 141.6 23 144.8 #N/A
5/31/2017 139.4 24 144.7 #N/A
6/1/2017 140.6 25 144.4 #N/A 135
6/2/2017 141.9 26 144.1 #N/A
6/5/2017 141.9 27 143.8 #N/A
6/6/2017 139.8 28 143.6 #N/A
6/7/2017 137.9 29 143.2 #N/A 125
1 8 15 22 29 36 43 50
6/8/2017 137.8 30 142.8 #N/A
6/9/2017 137.9 31 142.3 #N/A
6/12/2017 139.3 32 141.7 #N/A
6/13/2017 139.8 33 141.3 #N/A
6/14/2017 138.0 34 141.0 #N/A
6/15/2017 136.8 35 140.8 #N/A
6/16/2017 135.6 36 140.5 #N/A
6/19/2017 135.9 37 140.1 #N/A
6/20/2017 136.1 38 139.7 #N/A
6/21/2017 135.9 39 139.3 #N/A
6/22/2017 138.9 40 139.0 #N/A
6/23/2017 137.1 41 138.8 142.1
6/26/2017 137.1 42 138.5 141.9
6/27/2017 138.1 43 138.3 141.6
6/28/2017 137.7 44 138.2 141.5
6/29/2017 136.2 45 138.1 141.3
6/30/2017 135.8 46 137.8 141.1
7/3/2017 137.6 47 137.4 140.8
7/4/2017 137.9 48 137.3 140.6
7/5/2017 137.7 49 137.3 140.4
7/6/2017 140.7 50 137.3 140.2
7/7/2017 141.2 51 137.5 140.0
7/10/2017 140.8 52 137.6 139.9
7/11/2017 142.1 53 137.6 139.7
7/12/2017 144.0 54 137.8 139.5
7/13/2017 145.4 55 138.2 139.5
7/14/2017 146.7 56 138.7 139.6
7/17/2017 146.8 57 139.3 139.7
7/18/2017 145.6 58 139.9 139.8
7/19/2017 146.4 59 140.4 139.8
7/20/2017 145.4 60 140.8 139.9
7/21/2017 141.4 61 141.2 140.0
7/24/2017 137.8 62 141.4 140.0
7/25/2017 136.9 63 141.4 139.9
7/26/2017 138.4 64 141.4 139.7
7/27/2017 136.1 65 141.5 139.7
7/28/2017 134.3 66 141.5 139.6
7/31/2017 132.9 67 141.3 139.4
8/1/2017 134.3 68 141.1 139.2
8/2/2017 133.5 69 140.9 139.0
8/3/2017 131.2 70 140.5 138.9
8/4/2017 131.9 71 140.0 138.8
8/7/2017 131.4 72 139.5 138.6
8/8/2017 131.8 73 139.0 138.4
8/9/2017 129.9 74 138.3 138.2
8/10/2017 128.7 75 137.5 138.0
8/11/2017 129.1 76 136.6 137.8
8/14/2017 130.3 77 135.6 137.7
8/15/2017 130.8 78 134.8 137.5
8/16/2017 132.1 79 134.0 137.4
8/17/2017 131.1 80 133.3 137.3
8/18/2017 130.1 81 132.8 137.1
 8/21/2017 129.1 82 132.4 136.9
8/22/2017 129.1 83 131.9 136.7
8/23/2017 129.5 84 131.5 136.5
8/24/2017 130.6 85 131.1 136.3
8/25/2017 131.1 86 130.9 136.2
8/28/2017 131.1 87 130.8 136.0
8/29/2017 129.5 88 130.7 135.9
8/30/2017 129.6 89 130.4 135.7
8/31/2017 129.6 90 130.4 135.5
9/1/2017 131.1 91 130.2 135.2
9/4/2017 131.4 92 130.2 134.9
9/5/2017 133.1 93 130.2 134.7
9/6/2017 135.0 94 130.4 134.5
9/7/2017 135.6 95 130.7 134.3
9/8/2017 136.3 96 131.0 134.0
9/11/2017 137.2 97 131.4 133.7
9/12/2017 139.8 98 131.7 133.5
9/13/2017 139.9 99 132.1 133.4
9/14/2017 139.8 100 132.6 133.2
9/15/2017 140.8 101 133.1 133.1
9/18/2017 141.7 102 133.7 133.0
9/19/2017 141.8 103 134.3 133.1
9/20/2017 141.8 104 135.0 133.3
9/21/2017 142.8 105 135.6 133.3
9/22/2017 143.8 106 136.2 133.5
9/25/2017 143.3 107 136.9 133.8
9/26/2017 145.5 108 137.6 134.0
9/27/2017 144.9 109 138.4 134.3
9/28/2017 143.9 110 139.2 134.6
9/29/2017 143.3 111 139.9 134.9
10/2/2017 143.6 112 140.5 135.2
10/3/2017 143.6 113 141.1 135.5
10/4/2017 146.8 114 141.5 135.8
10/5/2017 147.9 115 142.1 136.2
10/6/2017 148.3 116 142.7 136.7
10/9/2017 147.6 117 143.3 137.2
10/10/2017 147.2 118 143.7 137.6
10/11/2017 148.6 119 144.1 138.0
10/12/2017 149.4 120 144.6 138.4
10/13/2017 149.1 121 145.0 138.9
10/16/2017 149.6 122 145.4 139.3
10/17/2017 148.4 123 145.8 139.9
10/18/2017 149.9 124 146.2 140.3
10/19/2017 148.7 125 146.6 140.9
10/20/2017 148.2 126 146.8 141.3
10/23/2017 148.6 127 147.1 141.7
10/24/2017 150.7 128 147.2 142.2
10/25/2017 149.6 129 147.5 142.7
10/26/2017 150.0 130 147.8 143.2
10/27/2017 154.6 131 148.2 143.7
10/30/2017 159.4 132 148.8 144.3
10/31/2017 159.4 133 149.6 145.0
11/1/2017 167.9 134 150.3 145.7
11/2/2017 166.3 135 151.3 146.5
11/3/2017 165.1 136 152.3 147.2
11/6/2017 165.4 137 153.2 148.0
11/7/2017 164.1 138 154.2 148.7
11/8/2017 162.1 139 155.0 149.3
11/9/2017 161.2 140 155.6 149.8
11/10/2017 159.3 141 156.3 150.4
11/13/2017 158.9 142 156.8 150.8
11/14/2017 158.0 143 157.3 151.3
11/15/2017 156.5 144 157.8 151.7
11/16/2017 160.1 145 158.2 152.0
11/17/2017 161.1 146 158.8 152.5
11/20/2017 166.8 147 159.5 152.9
11/21/2017 170.1 148 160.3 153.5
11/22/2017 167.8 149 161.4 154.1
11/23/2017 168.8 150 162.3 154.7
11/24/2017 169.1 151 163.1 155.3
11/27/2017 168.7 152 163.6 155.9
11/28/2017 168.9 153 164.1 156.6
11/29/2017 171.9 154 164.1 157.2
11/30/2017 173.9 155 164.4 157.8
12/1/2017 169.5 156 164.9 158.5
12/4/2017 170.5 157 165.1 159.0
12/5/2017 169.5 158 165.4 159.6
12/6/2017 165.6 159 165.8 160.1
12/7/2017 166.8 160 166.0 160.6
12/8/2017 170.1 161 166.4 161.0
12/11/2017 170.3 162 167.0 161.5
12/12/2017 170.1 163 167.7 162.0
12/13/2017 169.9 164 168.4 162.6
12/14/2017 170.6 165 168.9 163.1
12/15/2017 169.1 166 169.4 163.6
12/18/2017 172.7 167 169.5 164.2
12/19/2017 172.6 168 169.7 164.8
12/20/2017 169.9 169 169.9 165.3
12/21/2017 170.9 170 170.0 165.8
12/22/2017 170.0 171 170.1 166.3
12/27/2017 169.9 172 170.1 166.7
12/28/2017 170.0 173 170.2 167.0
12/29/2017 168.7 174 170.1 167.2
1/2/2018 168.8 175 169.8 167.3
1/3/2018 170.9 176 169.8 167.3
1/4/2018 174.2 177 169.8 167.5
1/5/2018 178.2 178 170.1 167.7
1/8/2018 180.0 179 170.7 168.0
1/9/2018 180.8 180 171.4 168.5
1/10/2018 179.5 181 172.0 169.0
1/11/2018 178.0 182 172.5 169.5
1/12/2018 181.0 183 172.9 170.0
1/15/2018 181.1 184 173.5 170.5
1/16/2018 186.1 185 174.0 171.2
1/17/2018 182.7 186 174.9 171.8
1/18/2018 184.1 187 175.4 172.3
1/19/2018 185.8 188 176.0 172.8
1/22/2018 188.0 189 176.9 173.2
1/23/2018 185.8 190 177.8 173.7
1/24/2018 184.5 191 178.6 174.1
1/25/2018 182.0 192 179.4 174.5
1/26/2018 183.0 193 180.0 174.8
1/29/2018 183.6 194 180.8 175.2
1/30/2018 179.9 195 181.5 175.5
1/31/2018 178.5 196 182.0 175.6
2/1/2018 178.0 197 182.2 175.8
2/2/2018 174.9 198 182.2 176.0
2/5/2018 169.9 199 182.0 176.2
2/6/2018 166.2 200 181.4 176.3
2/7/2018 172.8 201 180.7 176.3
2/8/2018 167.9 202 180.4 176.3
2/9/2018 166.7 203 179.7 176.3
2/12/2018 169.0 204 179.0 176.2
2/13/2018 169.4 205 178.1 176.2
2/14/2018 169.8 206 177.4 176.1
2/15/2018 170.7 207 176.6 176.1
2/16/2018 171.2 208 175.8 176.1
2/19/2018 170.3 209 174.9 176.1
2/20/2018 168.4 210 174.1 176.1
2/21/2018 166.4 211 173.3 176.0
2/22/2018 167.3 212 172.5 175.9
2/23/2018 166.8 213 171.6 175.9
2/26/2018 168.8 214 170.7 175.8
2/27/2018 166.7 215 170.2 175.8
2/28/2018 164.5 216 169.5 175.7
3/1/2018 161.7 217 168.8 175.6
3/2/2018 157.9 218 168.1 175.2
3/5/2018 157.8 219 167.5 174.7
3/6/2018 160.7 220 167.1 174.2
3/7/2018 159.1 221 166.4 173.7
3/8/2018 160.4 222 166.0 173.2
3/9/2018 160.4 223 165.6 172.7
3/12/2018 161.0 224 165.2 172.2
3/13/2018 157.6 225 164.7 171.7
3/14/2018 159.9 226 164.1 171.0
3/15/2018 163.8 227 163.5 170.4
3/16/2018 164.0 228 163.1 169.9
3/19/2018 160.6 229 162.8 169.4
3/20/2018 162.0 230 162.4 168.7
3/21/2018 161.7 231 162.2 168.1
3/22/2018 159.1 232 161.9 167.5
3/23/2018 155.6 233 161.5 167.0
3/26/2018 157.0 234 160.8 166.3
3/27/2018 159.7 235 160.3 165.6
3/28/2018 157.1 236 160.0 165.1
3/29/2018 162.6 237 159.8 164.6
4/3/2018 164.0 238 160.0 164.2
4/4/2018 162.1 239 160.3 163.9
4/5/2018 166.5 240 160.4 163.7
4/6/2018 165.5 241 160.8 163.7
4/9/2018 164.4 242 161.1 163.5
4/10/2018 169.6 243 161.3 163.5
4/11/2018 171.2 244 161.7 163.5
4/12/2018 173.7 245 162.4 163.6
4/13/2018 173.5 246 163.2 163.7
4/16/2018 170.4 247 163.7 163.8
4/17/2018 172.5 248 164.0 163.8
4/18/2018 173.0 249 164.6 163.8
4/19/2018 171.1 250 165.2 163.9
4/20/2018 169.7 251 165.7 163.9
4/23/2018 168.2 252 166.3 164.0
4/24/2018 168.7 253 166.9 164.0
4/25/2018 165.7 254 167.6 164.1
4/26/2018 169.7 255 167.9 164.0
 simple moving average
185

175

165

155

145

135

125
1 8 15 22 29 36 43 50 57 64 71 78 85 92 99 06 13 20 27 34 41 48 55 62 69 76 83 90 97 04 11 18 25 32 39 46 53
1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2

Axis Title

T-50 MA T-200 MA
1 18 25 32 39 46 53
2 2 2 2 2 2
 Date Adj Close Exp Smooth
Double Exp Smooth
C(t) Smooth T(t) Trend
4/27/2017 84.3
4/28/2017 84.2 84.294739 84.294739 -0.048058
5/2/2017 84.3 84.2514868 84.25571729 84.2985849 -0.04286761
5/3/2017 83.5 84.29906548 83.49023453 83.59879443 -0.1085599
5/4/2017 83.9 83.60312925 83.79751767 83.86827365 -0.07075598
5/5/2017 85.6 83.87956312 85.55119638 85.45609467 0.095101716
5/8/2017 86.4 85.46429921 86.48632064 86.31485324 0.171467401
5/9/2017 86.1 86.30616352 86.22947381 86.09694406 0.132529744
5/10/2017 87.0 86.07892835 87.13001307 86.92766428 0.202348791
5/11/2017 86.6 86.91260974 86.84724793 86.68900041 0.158247525
5/12/2017 87.2 86.66726007 87.39431802 87.20072299 0.193595031
5/15/2017 87.3 87.18272421 87.54403623 87.35443 0.189606229
5/16/2017 86.7 87.33327062 86.88814857 86.77540542 0.112743148
5/17/2017 86.4 86.75432886 86.54732463 86.47581486 0.071509776
5/18/2017 85.2 86.46243289 85.275085 85.32573426 -0.05064926
5/19/2017 86.2 85.31724509 86.12030159 86.0895085 0.030793089
5/22/2017 85.9 86.09372451 85.93299809 85.92203196 0.010966126
5/23/2017 86.3 85.91937425 86.27759314 86.23629711 0.041296028
5/24/2017 85.8 86.23493473 85.81636899 85.82075661 -0.00438762
5/25/2017 85.2 85.81649077 85.24137409 85.2976351 -0.05626101
5/26/2017 84.3 85.29764728 84.26305075 84.40313561 -0.14008486
5/29/2017 84.6 84.40876293 84.41694367 84.53030327 -0.11335961
5/30/2017 84.2 84.54487449 84.12840785 84.25769257 -0.12928472
5/31/2017 83.3 84.27048565 83.16910035 83.37384168 -0.20474133
6/1/2017 84.9 83.38804946 84.69774769 84.74490824 -0.04716055
6/2/2017 85.9 84.76680315 85.87051693 85.80677477 0.063742162
6/5/2017 85.9 85.81368031 85.99314733 85.92405169 0.069095638
6/6/2017 84.8 85.91836803 84.91072909 84.94631653 -0.03558744
6/7/2017 84.6 84.9388386 84.56751787 84.63107111 -0.06355324
6/8/2017 84.1 84.63388206 84.05102293 84.15575269 -0.10472976
6/9/2017 84.4 84.16238911 84.32148047 84.39210229 -0.07062182
6/12/2017 84.9 84.40323891 84.82359496 84.84214985 -0.01855488
6/13/2017 85.1 84.85032569 85.03907909 85.0363577 0.002721389
6/14/2017 84.1 85.03903077 84.12201317 84.20290881 -0.08089564
6/15/2017 83.4 84.20290398 83.34612251 83.49019952 -0.144077
6/16/2017 83.4 83.4982886 83.21578521 83.35861315 -0.14282794
6/19/2017 84.0 83.37382976 83.84932991 83.92157852 -0.07224861
6/20/2017 83.7 83.93738298 83.57974667 83.66993479 -0.09018812
6/21/2017 83.6 83.6787401 83.50960737 83.59797287 -0.0883655
6/22/2017 84.2 83.60787221 84.07502859 84.10395894 -0.02893034
6/23/2017 83.6 84.11378542 83.57581796 83.64750106 -0.0716831
6/26/2017 83.5 83.65137674 83.4191731 83.49858 -0.07940689
6/27/2017 82.9 83.50613587 82.78618583 82.91591821 -0.12973238
6/28/2017 83.7 82.92461449 83.54132947 83.59061858 -0.04928911
6/29/2017 82.7 83.60446145 82.67892518 82.80213385 -0.12320867
6/30/2017 81.3 82.80844704 81.17077959 81.41989162 -0.24911203
7/3/2017 83.0 81.4328438 82.71279874 82.79908066 -0.08628192
7/4/2017 82.3 82.82528708 82.19804508 82.32327897 -0.1252339
7/5/2017 81.5 82.33452781 81.41144556 81.59680361 -0.18535804
7/6/2017 81.4 81.61045188 81.25435839 81.43714636 -0.18278796
7/7/2017 81.4 81.45704699 81.19595265 81.36743314 -0.17148049
7/10/2017 81.6 81.387702 81.44428201 81.57759796 -0.13331596
7/11/2017 83.0 81.5967729 82.86102884 82.85343 0.007598842
7/12/2017 84.2 82.86867909 84.19420616 84.06610018 0.128105976
7/13/2017 84.4 84.06686521 84.48644903 84.34342152 0.143027511
7/14/2017 83.7 84.33068742 83.89049002 83.8146431 0.075846919
7/17/2017 83.7 83.79906694 83.7282538 83.6740508 0.054202997
7/18/2017 83.3 83.66490849 83.33868454 83.32482448 0.013860065
7/19/2017 83.3 83.31848995 83.29444592 83.28586755 0.008578366
7/20/2017 83.4 83.28384809 83.3778258 83.36244729 0.015378503
7/21/2017 81.2 83.36138751 81.22725874 81.40878438 -0.18152564
7/24/2017 78.9 81.40714055 78.78134893 79.16872767 -0.38737875
7/25/2017 79.4 79.18671586 79.03613474 79.36513489 -0.32900015
7/26/2017 79.1 79.40567159 78.78026219 79.10261437 -0.32235219
7/27/2017 78.5 79.13956806 78.18045044 78.52802622 -0.34757578
7/28/2017 77.8 78.56395681 77.50572674 77.88304324 -0.3773165
7/31/2017 77.7 77.92139388 77.33063978 77.68957177 -0.358932
8/1/2017 78.9 77.73113849 78.51547341 78.73406308 -0.21858967
8/2/2017 78.9 78.77411295 78.63796606 78.82554824 -0.18758219
8/3/2017 79.4 78.85141219 79.18499451 79.30579391 -0.1207994
8/4/2017 81.3 79.32713852 81.20754856 81.13349765 0.074050914
8/7/2017 81.0 81.14771205 81.0761264 81.02075486 0.055371543
8/8/2017 80.8 81.01477121 80.8482338 80.81861354 0.029620257
8/9/2017 80.1 80.81247802 80.1074026 80.14782338 -0.04042078
8/10/2017 80.1 80.1442478 80.01015621 80.05574296 -0.04558675
8/11/2017 79.9 80.05942748 79.90501184 79.95601292 -0.05100108
8/14/2017 80.2 79.96094005 80.14604607 80.17049848 -0.02445241
8/15/2017 80.0 80.1760913 79.97700805 80.01460461 -0.03759656
8/16/2017 80.1 80.01760913 80.10077253 80.1236999 -0.02292737
8/17/2017 79.8 80.12776001 79.78997837 79.83907545 -0.04909708
8/18/2017 79.5 79.8417742 79.49340369 79.56499874 -0.07159504
8/21/2017 79.0 79.57017832 78.90363998 79.02234127 -0.11870129
8/22/2017 79.4 79.03001873 79.25653214 79.3323613 -0.07582916
 8/23/2017 79.1 79.34499917 79.03563716 79.12465411 -0.08901696
8/24/2017 79.8 79.13350082 79.6934404 79.71456462 -0.02112421
8/25/2017 79.3 79.72435098 79.27291118 79.33034494 -0.05743376
8/28/2017 79.2 79.333436 79.15319436 79.21629022 -0.06309586
8/29/2017 78.3 79.2223427 78.26523609 78.40331944 -0.13808335
8/30/2017 78.4 78.41023427 78.23087198 78.35952631 -0.12865433
8/31/2017 78.0 78.37402613 77.87365439 78.0230872 -0.1494328
9/1/2017 79.0 78.03740261 78.83930374 78.88736544 -0.0480617
9/4/2017 79.1 78.90374026 79.07902837 79.10092767 -0.02189931
9/5/2017 80.5 79.10737133 80.46389098 80.35790284 0.105988141
9/6/2017 81.8 80.36073713 81.85302903 81.6303909 0.222638133
9/7/2017 82.7 81.62007551 82.8646704 82.5703047 0.2943657
9/8/2017 82.5 82.54700935 82.81780943 82.55446434 0.263345094
9/11/2017 82.8 82.52269824 83.11302121 82.84677914 0.266242065
9/12/2017 83.6 82.81726802 83.8613703 83.55130032 0.310069976
9/13/2017 84.1 83.521725 84.37798368 84.04913703 0.328846649
9/14/2017 84.4 84.0151725 84.69892946 84.37080107 0.328128388
9/15/2017 84.8 84.33451995 85.15681966 84.81689475 0.339924917
9/18/2017 84.6 84.7804538 84.96529608 84.67368467 0.291611417
9/19/2017 84.7 84.63604808 85.00416339 84.73552871 0.26863468
9/20/2017 84.5 84.70260391 84.73407532 84.51441544 0.219659885
9/21/2017 85.1 84.48425949 85.35559965 85.09940663 0.256193016
9/22/2017 85.1 85.07442505 85.34884505 85.11655636 0.232288687
9/25/2017 84.8 85.0884389 85.01797615 84.83688361 0.181092543
9/26/2017 84.9 84.81084299 85.07237131 84.90279671 0.169574599
9/27/2017 85.0 84.8820834 85.1405993 84.98023803 0.160361271
9/28/2017 84.4 84.96120924 84.58756528 84.49205813 0.095507154
9/29/2017 85.8 84.47411912 85.91308479 85.70575833 0.207326458
10/2/2017 86.2 85.69441371 86.36486127 86.13531208 0.229549188
10/3/2017 86.2 86.11344497 86.39160176 86.18048973 0.211112034
10/4/2017 88.5 86.1553481 88.67023102 88.27116288 0.399068145
10/5/2017 88.7 88.24753751 89.10866947 88.7060222 0.402647263
10/6/2017 89.1 88.66375285 89.45323693 89.05586965 0.397367281
10/9/2017 88.9 89.01137799 89.27320262 88.92832639 0.344876228
10/10/2017 88.4 88.8841405 88.77340627 88.50531846 0.268087812
10/11/2017 88.4 88.46641225 88.66192088 88.42833973 0.233581157
10/12/2017 87.8 88.39764032 88.06200037 87.90419209 0.157808278
10/13/2017 87.3 87.87776403 87.43572531 87.34919734 0.086527975
10/16/2017 87.1 87.3307737 87.17008721 87.11557433 0.054512877
10/17/2017 87.4 87.10507917 87.49181573 87.41301052 0.078805208
10/18/2017 88.2 87.40650972 88.2717204 88.12917887 0.142541522
10/19/2017 87.4 88.12064827 87.56116269 87.49617564 0.064987047
10/20/2017 86.3 87.48106843 86.37760164 86.42611897 -0.04851732
10/23/2017 86.0 86.41810954 85.96516067 86.04676196 -0.08160129
10/24/2017 86.4 86.05081275 86.33384833 86.37451427 -0.04066593
10/25/2017 85.5 86.38307948 85.42807156 85.54738393 -0.11931237
10/26/2017 86.3 85.55230705 86.15216735 86.19480626 -0.0426389
10/27/2017 87.2 86.2072298 87.16668376 87.11321764 0.053466125
10/30/2017 87.5 87.11872388 87.55013296 87.46666838 0.083464586
10/31/2017 87.5 87.46187239 87.58396592 87.5050133 0.07895262
11/1/2017 89.3 87.49618724 89.40138832 89.16439299 0.236995327
11/2/2017 89.9 89.15561512 90.10231218 89.82314153 0.279170648
11/3/2017 89.6 89.79856421 89.85449377 89.62323122 0.231262552
11/6/2017 90.0 89.59285642 90.20010848 89.95845028 0.241658203
11/7/2017 87.4 89.93228654 87.68945731 87.69800905 -0.00855174
11/8/2017 87.2 87.67122685 87.23594085 87.28494393 -0.04900308
11/9/2017 86.9 87.28312089 86.88405633 86.96059409 -0.07653775
11/10/2017 86.3 86.96531209 86.26889885 86.39440203 -0.12550318
11/13/2017 86.2 86.40252761 86.07518283 86.20688718 -0.13170435
11/14/2017 86.1 86.22025006 85.98785045 86.11552098 -0.12767054
11/15/2017 85.3 86.13002771 85.17921094 85.36878774 -0.18957681
11/16/2017 85.3 85.38300547 85.13891728 85.31492289 -0.17600561
11/17/2017 84.9 85.33530235 84.75608356 84.95089173 -0.19480817
11/20/2017 85.2 84.97053023 84.98095267 85.13760836 -0.15665569
11/21/2017 86.8 85.15905302 86.60535285 86.60009437 0.005258483
11/22/2017 86.6 86.6179044 86.58551399 86.58253708 0.002976907
11/23/2017 86.3 86.58379224 86.34542809 86.3645478 -0.01911971
11/24/2017 86.4 86.36437562 86.3605316 86.37654011 -0.01600851
11/27/2017 85.7 86.37843486 85.68069879 85.75705496 -0.07635617
11/28/2017 84.9 85.75884529 84.88094784 85.02306718 -0.14211934
11/29/2017 84.7 85.03088183 84.58939311 84.74509748 -0.15570437
11/30/2017 84.7 84.76009088 84.52338956 84.67093931 -0.14754975
12/1/2017 83.6 84.68800909 83.43198414 83.66533896 -0.23335481
12/4/2017 85.3 83.68180091 85.07766701 85.14020021 -0.0625332
12/5/2017 85.5 85.16518189 85.39364248 85.4217658 -0.02812333
12/6/2017 85.1 85.43051729 85.03521112 85.09336245 -0.05815133
12/7/2017 84.8 85.09704993 84.7936988 84.86851931 -0.07482051
12/8/2017 85.5 84.87470319 85.39831945 85.41137258 -0.01305313
12/11/2017 85.5 85.41947302 85.47602808 85.48083014 -0.00480206
12/12/2017 86.0 85.4829455 85.98995822 85.94760281 0.042355411
12/13/2017 85.7 85.94829455 85.755154 85.73799492 0.017159081
12/14/2017 86.2 85.73382856 86.19291062 86.1375154 0.055395221
12/15/2017 85.9 86.13538286 86.00782136 85.97428836 0.033532995
12/18/2017 87.0 85.96853559 86.98401022 86.86478124 0.119228983
12/19/2017 87.1 86.86085266 87.2180671 87.08839922 0.129667883
12/20/2017 86.9 87.07608347 87.06254855 86.95880671 0.103741844
12/21/2017 87.8 86.94460835 87.93596337 87.76225126 0.173712114
12/22/2017 87.5 87.75045723 87.69786878 87.56159364 0.136275141
12/27/2017 87.3 87.54304302 87.40065581 87.30378868 0.096867131
12/28/2017 87.1 87.2883061 87.2394727 87.16606468 0.073408018
12/29/2017 86.8 87.15482971 86.90750472 86.87094907 0.036555655
1/2/2018 86.4 86.86248477 86.44163268 86.45075227 -0.00911959
1/3/2018 86.9 86.44625028 86.84669773 86.81816417 0.028533558
1/4/2018 87.5 86.81862593 87.50220351 87.41667247 0.085531033
1/5/2018 88.5 87.41386529 88.57555307 88.40022035 0.175332717
1/8/2018 89.7 88.39138653 89.83438627 89.56055351 0.273832761
1/9/2018 90.2 89.54213685 90.47017365 90.16343593 0.306737727
1/10/2018 89.4 90.13421099 89.71744144 89.50701917 0.210422278
1/11/2018 88.7 89.4734229 88.91069867 88.79274594 0.117952728
1/12/2018 89.8 88.76834409 89.91895774 89.72006807 0.198889668
1/15/2018 89.8 89.70583261 89.99018024 89.80289667 0.187283562
1/16/2018 92.6 89.78158416 92.80078437 92.37501712 0.425767251
1/17/2018 92.3 92.35415752 92.78027311 92.39507664 0.385196477
1/18/2018 93.1 92.35041395 93.45229921 93.04102731 0.411271897
1/19/2018 94.7 92.9980414 95.07899489 94.55722992 0.521764968
1/22/2018 96.3 94.51180414 96.7699569 96.14190129 0.628055608
1/23/2018 95.3 96.08518221 95.92295419 95.42899479 0.493959397
1/24/2018 94.3 95.36051732 94.85968696 94.50729362 0.35239334
1/25/2018 93.3 94.45104993 93.61849021 93.4109687 0.207521514
1/26/2018 93.8 93.37010499 94.0354084 93.80885082 0.226557575
1/29/2018 93.5 93.7840123 93.77151265 93.58954174 0.181970909
1/30/2018 92.6 93.56440213 92.83328505 92.75315036 0.080134681
1/31/2018 92.0 92.73243931 92.05876852 92.0563294 0.002439117
2/1/2018 91.5 92.04624483 91.5080268 91.55587685 -0.04785005
2/2/2018 90.2 91.55462448 90.14543022 90.31280268 -0.16737246
2/5/2018 89.3 90.31746245 89.18067788 89.42053942 -0.23986154
2/6/2018 88.1 89.43774264 87.90064227 88.23506509 -0.33442282
2/7/2018 89.1 88.26077156 88.75358162 88.98006243 -0.22648081
2/8/2018 87.5 89.01607536 87.31575402 87.65235726 -0.33660324
2/9/2018 86.6 87.67860664 86.31015331 86.7075745 -0.39742119
2/12/2018 87.3 86.74385976 86.90257836 87.21001353 -0.30743517
2/13/2018 86.7 87.25338418 86.4143916 86.73825874 -0.32386713
2/14/2018 88.0 86.77333932 87.66027678 87.84143916 -0.18116238
2/15/2018 87.4 87.87733393 87.25114039 87.45302768 -0.20188729
2/16/2018 88.1 87.47473339 87.90942709 88.03311674 -0.12368965
2/19/2018 87.3 88.05547604 87.16260363 87.34294181 -0.18033818
2/20/2018 86.8 87.3575467 86.62329083 86.83626306 -0.21297224
2/21/2018 86.8 86.85575737 86.5555577 86.75532638 -0.19976868
2/22/2018 87.2 86.77857304 87.01358789 87.15355667 -0.13996878
2/23/2018 87.1 87.1758582 86.90967006 87.04636149 -0.13669142
2/26/2018 87.8 87.06258852 87.60490528 87.66596701 -0.06106173
2/27/2018 87.7 87.68125885 87.63798435 87.69048783 -0.05250347
2/28/2018 86.8 87.69812319 86.77567637 86.90179844 -0.12612207
3/1/2018 85.3 86.90781232 85.18863767 85.44757034 -0.25893267
3/2/2018 84.0 85.46078393 83.7232547 84.09186467 -0.36860997
3/5/2018 83.5 84.11907929 83.1237206 83.51332367 -0.38960307
3/6/2018 84.2 83.55290613 83.76003809 84.05637566 -0.29633757
3/7/2018 84.9 84.09929421 84.5526638 84.75000471 -0.1973409
3/8/2018 85.0 84.78393032 84.76848672 84.92826728 -0.15978056
3/9/2018 85.1 84.95139393 84.96660134 85.09384597 -0.12724463
3/12/2018 85.7 85.11213669 85.57532039 85.63565923 -0.06033884
3/13/2018 84.6 85.65021277 84.57911139 84.72452934 -0.14541795
3/14/2018 84.2 84.73201858 84.02867119 84.21090934 -0.18223815
3/15/2018 85.1 84.22620006 84.92685153 85.01086982 -0.08401829
3/16/2018 85.9 85.03062271 85.76665122 85.76668605 -3.4838E-05
3/19/2018 85.2 85.77706317 85.17592969 85.22966332 -0.05373363
3/20/2018 86.0 85.23070452 85.92812369 85.90859117 0.019532521
3/21/2018 86.1 85.91406865 86.11781178 86.08281057 0.035001208
3/22/2018 85.3 86.08140507 85.37288131 85.40878298 -0.03590167
3/23/2018 84.2 85.40514231 84.15602714 84.29928813 -0.14326099
3/26/2018 85.2 84.30251423 85.05619829 85.10460181 -0.04840352
3/27/2018 85.8 85.11925052 85.75405648 85.73461803 0.019438452
3/28/2018 85.6 85.74092325 85.58137704 85.57940385 0.001973189
3/29/2018 88.2 85.57809053 88.12628894 87.8931395 0.233149435
4/3/2018 88.7 87.89281085 88.90761232 88.62462889 0.282983431
4/4/2018 87.4 88.60128109 87.70796351 87.55976483 0.148198682
4/5/2018 88.7 87.52913171 88.83827535 88.60079365 0.237481695
4/6/2018 89.0 88.58291047 89.20616544 88.95682843 0.249337004
4/9/2018 88.3 88.93129195 88.5979947 88.42661294 0.171381755
4/10/2018 90.0 88.39912559 90.14745972 89.85079767 0.296662052
4/11/2018 89.9 89.83091076 90.16943962 89.89774867 0.271690947
4/12/2018 89.9 89.86609378 90.20408534 89.95394396 0.250141381
4/13/2018 91.3 89.92360938 91.56888421 91.21741033 0.35147388
4/16/2018 90.7 91.18936274 91.02056668 90.75089202 0.269674661
4/17/2018 91.2 90.71293987 91.48768132 91.20005757 0.287623749
4/18/2018 90.8 91.16929489 91.09450353 90.86877083 0.225732701
4/19/2018 90.9 90.83693219 91.10787477 90.90144765 0.206427113
4/20/2018 91.0 90.87569052 91.22730289 91.02878478 0.198518114
4/23/2018 91.2 91.00556635 91.39878817 91.20272759 0.196060584
4/24/2018 91.1 91.18055394 91.3287455 91.15687612 0.171869378
4/25/2018 91.1 91.13505269 91.27415683 91.12287455 0.151282284
 Alpha= 0.1 Alpha= 0.9
Beta= 0.1

Chart Title
100

95

90

85

80

75
4/27/2017 5/27/2017 6/27/2017 7/27/2017 8/27/2017 9/27/2017 10/27/2017 11/27/2017 1

Adj Cl os e Exp Smooth Doubl e Exp Smooth

hart Title

10/27/2017 11/27/2017 12/27/2017 1/27/2018 2/27/2018 3/27/2018

p Smooth Doubl e Exp Smooth

 solver use for best DAX
hypothetical data input Coefficients
Intercept 6975.5212624598
BMW 90 64.2860573467
VOLKSWAGEN 170 1.1839090024

price of DAX 12962.5309541

IF bmw share price is 90 and wolsvagen

price is 170 the DAX will be 12962.

using data table for probable DAX

12962.5309541 85 86 87 88
165 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
166 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
167 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
168 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
169 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
170 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
171 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
172 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
173 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
174 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
175 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
176 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
177 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
178 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
179 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
180 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
181 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
 182 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
183 12962.5309540773 12962.5309540773 12962.5309540773 12962.53095
VOLKSWAGEN
share price
 goal seeking used to get dax to be 13500, what
will be the bmw price
hypothetical data inputCoefficients
Intercept 1 6975.5212624598
BMW 98.3605849869 64.2860573467
VOLKSWAGEN 170 1.1839090024
13500
price of DAX
if we want DAX to be 13500 chnging the BMW price
than the price of BMW to be 98.36

89 90 91 92 93
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
12962.53095 12962.53095 12962.5309540773 12962.5309540773 12962.530954077
 goal seeking used to get dax to be 14000,
what will be the volkswagen price
hypothetical data inputCoefficients
Intercept 1 6975.5212624598
BMW 98.3605849869 64.2860573467
VOLKSWAGEN 592.3297558901 1.1839090024
14000
price of DAX
if we want DAX to be 14000 chnging the
volkswagen price than the price of BMW to be
98.36

94 95 BMW SHARE PRICE

12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541
12962.53095 12962.5309541