Spreadsheet: 88063d1287981129-least-square-moving-average-34periodmovingavg
Sheet: Sheet1

 |  | 34 period
Point | Raw Data | Least Square
1 | 1.63145 | 1.63399
2 | 1.63166 | 1.63388
3 | 1.63189 | 1.63379
4 | 1.63356 | 1.63385
5 | 1.63469 | 1.63398
6 | 1.63404 | 1.63402
7 | 1.63375 | 1.63392
8 | 1.63397 | 1.63384
9 | 1.63374 | 1.63372
10 | 1.63531 | 1.6337
11 | 1.63507 | 1.63368
12 | 1.63482 | 1.63359
13 | 1.63488 | 1.63356
14 | 1.63387 | 1.63344
15 | 1.63536 | 1.63353
16 | 1.63353 | 1.63344
17 | 1.63373 | 1.63346
18 | 1.63472 | 1.63358
19 | 1.63515 | 1.63372
20 | 1.63781 | 1.63411
21 | 1.63717 | 1.63438
22 | 1.63656 | 1.63458
23 | 1.63644 | 1.63484
24 | 1.63757 | 1.63531
25 | 1.63759 | 1.63581
26 | 1.64004 | 1.63651
27 | 1.63925 | 1.63704
28 | 1.64168 | 1.63786
29 | 1.6418 | 1.63867
30 | 1.64201 | 1.63942
31 | 1.6422 | 1.64014 |  |  |  |  |  | Test Area
32 | 1.64292 | 1.64084 |  | 34 Day average |  |  |  | Point | Raw Data
33 | 1.64154 | 1.64133 | Day | MovAvg | Trend Line Values |  |  | 1 | 1.63145
34 | 1.64135 | 1.6417 | 34 |  |  |  |  | 2 | 1.63166
35 | 1.64099 | 1.64191 | 35 |  |  |  |  | 3 | 1.63189
36 | 1.64123 | 1.64211 | 36 |  |  |  |  | 4 | 1.63356
37 | 1.64168 | 1.64233 | 37 |  |  |  |  | 5 | 1.63469
38 | 1.64191 | 1.64262 | 38 |  |  |  |  | 6 | 1.63404
39 | 1.64256 | 1.643 | 39 |  |  |  |  | 7 | 1.63375
40 | 1.64193 | 1.64324 | 40 |  |  |  |  | 8 | 1.63397
41 | 1.64161 | 1.64339 | 41 |  |  |  |  | 9 | 1.63374
42 | 1.64141 | 1.64348 | 42 |  |  |  |  | 10 | 1.63531
43 | 1.64523 | 1.64396 | 43 |  |  |  |  | 11 | 1.63507
44 | 1.64459 | 1.6444 | 44 |  |  |  |  | 12 | 1.63482
45 | 1.6447 | 1.64479 | 45 |  |  |  |  | 13 | 1.63488
46 | 1.64624 | 1.64529 | 46 |  |  |  |  | 14 | 1.63387
47 | 1.64571 | 1.64567 | 47 |  |  |  |  | 15 | 1.63536
48 | 1.64678 | 1.64606 | 48 |  |  |  |  | 16 | 1.63353
49 | 1.64595 | 1.64639 | 49 |  |  |  |  | 17 | 1.63373
50 | 1.64721 | 1.64669 | 50 |  |  |  |  | 18 | 1.63472
51 | 1.6471 | 1.64692 | 51 |  |  |  |  | 19 | 1.63515
52 | 1.6467 | 1.6471 | 52 |  |  |  |  | 20 | 1.63781
53 | 1.64581 | 1.64714 | 53 |  |  |  |  | 21 | 1.63717
54 | 1.64645 | 1.64736 | 54 |  |  |  |  | 22 | 1.63656
55 | 1.64505 | 1.64734 | 55 |  |  |  |  | 23 | 1.63644
56 | 1.64413 | 1.64714 | 56 |  |  |  |  | 24 | 1.63757
57 | 1.64311 | 1.64678 | 57 |  |  |  |  | 25 | 1.63759
58 | 1.64377 | 1.64653 | 58 |  |  |  |  | 26 | 1.64004
59 | 1.64313 | 1.64617 | 59 |  |  |  |  | 27 | 1.63925
60 | 1.64386 | 1.64601 | 60 |  |  |  |  | 28 | 1.64168
61 | 1.64385 | 1.64579 | 61 |  |  |  |  | 29 | 1.6418
62 | 1.64434 | 1.64574 | 62 |  |  |  |  | 30 | 1.64201 |  |  |  |  | << I think this is the trendline you want from the averages.
63 | 1.64465 | 1.64572 | 63 |  |  |  |  | 31 | 1.6422 |  |  |  |  | The values for the Moving Avg are in Col E
64 | 1.6445 | 1.64568 | 64 |  |  |  |  | 32 | 1.64292 |  |  |  |  | The values for the line are given in Col F
65 | 1.64547 | 1.64575 | 65 |  |  |  |  | 33 | 1.64154
66 | 1.64637 | 1.64595 | 66 |  |  |  |  | 34 | 1.64135
67 | 1.64675 | 1.64609 | 67 |  |  |  |  | 35 | 1.64099
68 | 1.6447 | 1.64596 | 68 |  |  |  |  | 36 | 1.64123
69 | 1.64527 | 1.64586 | 69 |  |  |  |  | 37 | 1.64168
70 | 1.64702 | 1.64595 | 70 |  |  |  |  | 38 | 1.64191
71 | 1.64572 | 1.64588 | 71 |  |  |  |  | 39 | 1.64256
72 | 1.64574 | 1.64582 | 72 |  |  |  |  | 40 | 1.64193
73 | 1.64654 | 1.64586 | 73 |  |  |  |  | 41 | 1.64161
74 | 1.64706 | 1.64591 | 74 |  |  |  |  | 42 | 1.64141
75 | 1.64603 | 1.64579 | 75 |  |  |  |  | 43 | 1.64523
76 | 1.64422 | 1.64543 | 76 |  |  |  |  | 44 | 1.64459
77 | 1.64378 | 1.64524 | 77 |  |  |  |  | 45 | 1.6447
78 | 1.64452 | 1.6451 | 78 |  |  |  |  | 46 | 1.64624
79 | 1.645 | 1.64502 | 79 |  |  |  |  | 47 | 1.64571
80 | 1.64546 | 1.64508 | 80 |  |  |  |  | 48 | 1.64678
81 | 1.64477 | 1.64504 | 81 |  |  |  |  | 49 | 1.64595
82 | 1.64586 | 1.64519 | 82 |  |  |  |  | 50 | 1.64721
83 | 1.64424 | 1.64511 | 83 |  |  |  |  | 51 | 1.6471
84 | 1.6435 | 1.64503 | 84 |  |  |  |  | 52 | 1.6467
85 | 1.64455 | 1.64508 | 85 |  |  |  |  | 53 | 1.64581
86 | 1.64255 | 1.64489 | 86 |  |  |  |  | 54 | 1.64645
87 | 1.64164 | 1.64457 | 87 |  |  |  |  | 55 | 1.64505
88 | 1.6381 | 1.64391 | 88 |  |  |  |  | 56 | 1.64413
89 | 1.63875 | 1.64329 | 89 |  |  |  |  | 57 | 1.64311
90 | 1.64037 | 1.64282 | 90 |  |  |  |  | 58 | 1.64377
91 | 1.64014 | 1.64229 | 91 |  |  |  |  | 59 | 1.64313
92 | 1.6402 | 1.64181 | 92 |  |  |  |  | 60 | 1.64386
93 | 1.63886 | 1.64117 | 93 |  |  |  |  | 61 | 1.64385
94 | 1.63699 | 1.64038 | 94 |  |  |  |  | 62 | 1.64434
95 | 1.63695 | 1.63962 | 95 |  |  |  |  | 63 | 1.64465
96 | 1.63712 | 1.63894 | 96 |  |  |  |  | 64 | 1.6445
97 | 1.63545 | 1.63813 | 97 |  |  |  |  | 65 | 1.64547
98 | 1.63428 | 1.63723 | 98 |  |  |  |  | 66 | 1.64637
99 | 1.63535 | 1.63655 | 99 |  |  |  |  | 67 | 1.64675
100 | 1.63281 | 1.6357 | 100 |  |  |  |  | 68 | 1.6447
101 | 1.63298 | 1.63495 | 101 |  |  |  |  | 69 | 1.64527
102 | 1.6345 | 1.63432 | 102 |  |  |  |  | 70 | 1.64702
103 | 1.63551 | 1.63389 | 103 |  |  |  |  | 71 | 1.64572
104 | 1.63545 | 1.63361 | 104 |  |  |  |  | 72 | 1.64574
105 | 1.63578 | 1.63334 | 105 |  |  |  |  | 73 | 1.64654
106 | 1.63718 | 1.63329 | 106 |  |  |  |  | 74 | 1.64706
107 | 1.63779 | 1.63339 | 107 |  |  |  |  | 75 | 1.64603
108 | 1.63688 | 1.63347 | 108 |  |  |  |  | 76 | 1.64422
109 | 1.63617 | 1.63345 | 109 |  |  |  |  | 77 | 1.64378
110 | 1.63584 | 1.63334 | 110 |  |  |  |  | 78 | 1.64452
111 | 1.63516 | 1.63318 | 111 |  |  |  |  | 79 | 1.645
112 | 1.63455 | 1.63303 | 112 |  |  |  |  | 80 | 1.64546
113 | 1.63495 | 1.633 | 113 |  |  |  |  | 81 | 1.64477
114 | 1.63436 | 1.63299 | 114 |  |  |  |  | 82 | 1.64586
115 | 1.63597 | 1.63317 | 115 |  |  |  |  | 83 | 1.64424
116 | 1.63531 | 1.63338 | 116 |  |  |  |  | 84 | 1.6435
117 | 1.63357 | 1.63336 | 117 |  |  |  |  | 85 | 1.64455
118 | 1.63448 | 1.63345 | 118 |  |  |  |  | 86 | 1.64255
119 | 1.63581 | 1.6338 | 119 |  |  |  |  | 87 | 1.64164
120 | 1.63359 | 1.63382 | 120 |  |  |  |  | 88 | 1.6381
121 | 1.63325 | 1.6338 | 121 |  |  |  |  | 89 | 1.63875
122 | 1.6336 | 1.63365 | 122 |  |  |  |  | 90 | 1.64037
123 | 1.63375 | 1.63358 | 123 |  |  |  |  | 91 | 1.64014
124 | 1.6329 | 1.63353 | 124 |  |  |  |  | 92 | 1.6402
125 | 1.63228 | 1.63344 | 125 |  |  |  |  | 93 | 1.63886
126 | 1.63214 | 1.63338 | 126 |  |  |  |  | 94 | 1.63699
127 | 1.63296 | 1.63337 | 127 |  |  |  |  | 95 | 1.63695
128 | 1.63193 | 1.63316 | 128 |  |  |  |  | 96 | 1.63712
129 | 1.63168 | 1.63295 | 129 |  |  |  |  | 97 | 1.63545
130 | 1.63249 | 1.63287 | 130 |  |  |  |  | 98 | 1.63428
131 | 1.63046 | 1.63248 | 131 |  |  |  |  | 99 | 1.63535
132 | 1.63098 | 1.63211 | 132 |  |  |  |  | 100 | 1.63281
133 | 1.63132 | 1.63185 | 133 |  |  |  |  | 101 | 1.63298
134 | 1.62863 | 1.63116 | 134 |  |  |  |  | 102 | 1.6345
135 | 1.62851 | 1.63049 | 135 |  |  |  |  | 103 | 1.63551
136 | 1.62829 | 1.62991 | 136 |  |  |  |  | 104 | 1.63545
137 | 1.62917 | 1.62952 | 137 |  |  |  |  | 105 | 1.63578
138 | 1.6304 | 1.6293 | 138 |  |  |  |  | 106 | 1.63718
139 | 1.62978 | 1.62905 | 139 |  |  |  |  | 107 | 1.63779
140 | 1.62912 | 1.62883 | 140 |  |  |  |  | 108 | 1.63688
141 | 1.62961 | 1.62875 | 141 |  |  |  |  | 109 | 1.63617
142 | 1.63062 | 1.62877 | 142 |  |  |  |  | 110 | 1.63584
143 | 1.63038 | 1.62876 | 143 |  |  |  |  | 111 | 1.63516
144 | 1.62993 | 1.6287 | 144 |  |  |  |  | 112 | 1.63455
145 | 1.62939 | 1.62857 | 145 |  |  |  |  | 113 | 1.63495
146 | 1.6286 | 1.62835 | 146 |  |  |  |  | 114 | 1.63436
147 | 1.62896 | 1.62822 | 147 |  |  |  |  | 115 | 1.63597
148 | 1.62795 | 1.62797 | 148 |  |  |  |  | 116 | 1.63531
149 | 1.62788 | 1.62784 | 149 |  |  |  |  | 117 | 1.63357
150 | 1.62765 | 1.62769 | 150 |  |  |  |  | 118 | 1.63448
151 | 1.62888 | 1.62761 | 151 |  |  |  |  | 119 | 1.63581
152 | 1.62908 | 1.62764 | 152 |  |  |  |  | 120 | 1.63359
153 | 1.62845 | 1.62769 | 153 |  |  |  |  | 121 | 1.63325
154 | 1.62555 | 1.62733 | 154 |  |  |  |  | 122 | 1.6336
155 | 1.6285 | 1.62732 | 155 |  |  |  |  | 123 | 1.63375
156 | 1.62843 | 1.62734 | 156 |  |  |  |  | 124 | 1.6329
157 | 1.62893 | 1.62746 | 157 |  |  |  |  | 125 | 1.63228
158 | 1.62843 | 1.6275 | 158 |  |  |  |  | 126 | 1.63214
159 | 1.62753 | 1.62742 | 159 |  |  |  |  | 127 | 1.63296
160 | 1.62812 | 1.62742 | 160 |  |  |  |  | 128 | 1.63193
161 | 1.62785 | 1.62746 | 161 |  |  |  |  | 129 | 1.63168
162 | 1.62793 | 1.62747 | 162 |  |  |  |  | 130 | 1.63249
163 | 1.62957 | 1.62768 | 163 |  |  |  |  | 131 | 1.63046
164 | 1.62924 | 1.6279 | 164 |  |  |  |  | 132 | 1.63098
165 | 1.63051 | 1.62817 | 165 |  |  |  |  | 133 | 1.63132
166 | 1.62943 | 1.62834 | 166 |  |  |  |  | 134 | 1.62863
167 | 1.62979 | 1.62858 | 167 |  |  |  |  | 135 | 1.62851
168 | 1.62964 | 1.62866 | 168 |  |  |  |  | 136 | 1.62829
169 | 1.62895 | 1.62864 | 169 |  |  |  |  | 137 | 1.62917
170 | 1.62881 | 1.6286 | 170 |  |  |  |  | 138 | 1.6304
171 | 1.62879 | 1.6286 | 171 |  |  |  |  | 139 | 1.62978
172 | 1.62939 | 1.62874 | 172 |  |  |  |  | 140 | 1.62912
173 | 1.62972 | 1.62889 | 173 |  |  |  |  | 141 | 1.62961
174 | 1.63069 | 1.62911 | 174 |  |  |  |  | 142 | 1.63062
175 | 1.6289 | 1.62915 | 175 |  |  |  |  | 143 | 1.63038
176 | 1.62838 | 1.62919 | 176 |  |  |  |  | 144 | 1.62993
177 | 1.62875 | 1.62927 | 177 |  |  |  |  | 145 | 1.62939
178 | 1.62951 | 1.62942 | 178 |  |  |  |  | 146 | 1.6286
179 | 1.62994 | 1.62959 | 179 |  |  |  |  | 147 | 1.62896
180 | 1.62992 | 1.62971 | 180 |  |  |  |  | 148 | 1.62795
181 | 1.62949 | 1.62979 | 181 |  |  |  |  | 149 | 1.62788
182 | 1.62922 | 1.62978 | 182 |  |  |  |  | 150 | 1.62765
183 | 1.62922 | 1.62976 | 183 |  |  |  |  | 151 | 1.62888
184 | 1.62842 | 1.62963 | 184 |  |  |  |  | 152 | 1.62908
185 | 1.62827 | 1.62955 | 185 |  |  |  |  | 153 | 1.62845
186 | 1.62785 | 1.62944 | 186 |  |  |  |  | 154 | 1.62555
187 | 1.62887 | 1.62941 | 187 |  |  |  |  | 155 | 1.6285
188 | 1.62749 | 1.62906 | 188 |  |  |  |  | 156 | 1.62843
189 | 1.62651 | 1.62876 | 189 |  |  |  |  | 157 | 1.62893
190 | 1.6276 | 1.62858 | 190 |  |  |  |  | 158 | 1.62843
191 | 1.62817 | 1.62851 | 191 |  |  |  |  | 159 | 1.62753
192 | 1.62929 | 1.62853 | 192 |  |  |  |  | 160 | 1.62812
193 | 1.62808 | 1.62836 | 193 |  |  |  |  | 161 | 1.62785
194 | 1.62863 | 1.62829 | 194 |  |  |  |  | 162 | 1.62793
195 | 1.62831 | 1.62816 | 195 |  |  |  |  | 163 | 1.62957
196 | 1.62706 | 1.62789 | 196 |  |  |  |  | 164 | 1.62924
197 | 1.62821 | 1.62785 | 197 |  |  |  |  | 165 | 1.63051
198 | 1.62668 | 1.62763 | 198 |  |  |  |  | 166 | 1.62943
199 | 1.62656 | 1.62748 | 199 |  |  |  |  | 167 | 1.62979
200 | 1.6279 | 1.62744 | 200 |  |  |  |  | 168 | 1.62964
201 | 1.62739 | 1.62737 | 201 |  |  |  |  | 169 | 1.62895
202 | 1.62807 | 1.62738 | 202 |  |  |  |  | 170 | 1.62881
203 | 1.62853 | 1.62741 | 203 |  |  |  |  | 171 | 1.62879
204 | 1.62915 | 1.62751 | 204 |  |  |  |  | 172 | 1.62939
205 | 1.62943 | 1.62763 | 205 |  |  |  |  | 173 | 1.62972
206 | 1.62855 | 1.62768 | 206 |  |  |  |  | 174 | 1.63069
207 | 1.62677 | 1.62756 | 207 |  |  |  |  | 175 | 1.6289
208 | 1.6269 | 1.62753 | 208 |  |  |  |  | 176 | 1.62838
209 | 1.62256 | 1.62692 | 209 |  |  |  |  | 177 | 1.62875
210 | 1.6232 | 1.62638 | 210 |  |  |  |  | 178 | 1.62951
211 | 1.62496 | 1.62609 | 211 |  |  |  |  | 179 | 1.62994
212 | 1.62494 | 1.62586 | 212 |  |  |  |  | 180 | 1.62992
213 | 1.62616 | 1.62582 | 213 |  |  |  |  | 181 | 1.62949
214 | 1.62673 | 1.62586 | 214 |  |  |  |  | 182 | 1.62922
215 | 1.62582 | 1.62578 | 215 |  |  |  |  | 183 | 1.62922
216 | 1.62504 | 1.62562 | 216 |  |  |  |  | 184 | 1.62842
217 | 1.62477 | 1.62546 | 217 |  |  |  |  | 185 | 1.62827
218 | 1.6253 | 1.62532 | 218 |  |  |  |  | 186 | 1.62785
219 | 1.62553 | 1.62522 | 219 |  |  |  |  | 187 | 1.62887
220 | 1.62508 | 1.62506 | 220 |  |  |  |  | 188 | 1.62749
221 | 1.62603 | 1.62508 | 221 |  |  |  |  | 189 | 1.62651
222 | 1.62616 | 1.62505 | 222 |  |  |  |  | 190 | 1.6276
223 | 1.62584 | 1.62493 | 223 |  |  |  |  | 191 | 1.62817
224 | 1.62647 | 1.62495 | 224 |  |  |  |  | 192 | 1.62929
225 | 1.62566 | 1.62492 | 225 |  |  |  |  | 193 | 1.62808
226 | 1.62531 | 1.62492 | 226 |  |  |  |  | 194 | 1.62863
227 | 1.62593 | 1.62495 | 227 |  |  |  |  | 195 | 1.62831
228 | 1.62651 | 1.62508 | 228 |  |  |  |  | 196 | 1.62706
229 | 1.6252 | 1.62506 | 229 |  |  |  |  | 197 | 1.62821
230 | 1.6269 | 1.62517 | 230 |  |  |  |  | 198 | 1.62668
231 | 1.62623 | 1.62527 | 231 |  |  |  |  | 199 | 1.62656
232 | 1.62331 | 1.62497 | 232 |  |  |  |  | 200 | 1.6279
233 | 1.62149 | 1.62447 | 233 |  |  |  |  | 201 | 1.62739
234 | 1.62041 | 1.62395 | 234 |  |  |  |  | 202 | 1.62807
235 | 1.62141 | 1.62356 | 235 |  |  |  |  | 203 | 1.62853
236 | 1.62045 | 1.62312 | 236 |  |  |  |  | 204 | 1.62915
237 | 1.61847 | 1.62253 | 237 |  |  |  |  | 205 | 1.62943
238 | 1.61731 | 1.6219 | 238 |  |  |  |  | 206 | 1.62855
239 | 1.61907 | 1.62154 | 239 |  |  |  |  | 207 | 1.62677
240 | 1.62092 | 1.62138 | 240 |  |  |  |  | 208 | 1.6269
241 | 1.61973 | 1.62103 | 241 |  |  |  |  | 209 | 1.62256
242 | 1.61958 | 1.6207 | 242 |  |  |  |  | 210 | 1.6232
243 | 1.61976 | 1.62018 | 243 |  |  |  |  | 211 | 1.62496
244 | 1.62056 | 1.6198 | 244 |  |  |  |  | 212 | 1.62494
245 | 1.61869 | 1.61932 | 245 |  |  |  |  | 213 | 1.62616
246 | 1.62246 | 1.6193 | 246 |  |  |  |  | 214 | 1.62673
247 | 1.62263 | 1.61938 | 247 |  |  |  |  | 215 | 1.62582
248 | 1.62177 | 1.61942 | 248 |  |  |  |  | 216 | 1.62504
 |  |  |  |  |  |  |  | 217 | 1.62477
 |  |  |  |  |  |  |  | 218 | 1.6253
 |  |  |  |  |  |  |  | 219 | 1.62553
 |  |  |  |  |  |  |  | 220 | 1.62508
 |  |  |  |  |  |  |  | 221 | 1.62603
 |  |  |  |  |  |  |  | 222 | 1.62616
 |  |  |  |  |  |  |  | 223 | 1.62584
 |  |  |  |  |  |  |  | 224 | 1.62647
 |  |  |  |  |  |  |  | 225 | 1.62566
 |  |  |  |  |  |  |  | 226 | 1.62531
 |  |  |  |  |  |  |  | 227 | 1.62593
 |  |  |  |  |  |  |  | 228 | 1.62651
 |  |  |  |  |  |  |  | 229 | 1.6252
 |  |  |  |  |  |  |  | 230 | 1.6269
 |  |  |  |  |  |  |  | 231 | 1.62623
 |  |  |  |  |  |  |  | 232 | 1.62331
 |  |  |  |  |  |  |  | 233 | 1.62149
 |  |  |  |  |  |  |  | 234 | 1.62041
 |  |  |  |  |  |  |  | 235 | 1.62141
 |  |  |  |  |  |  |  | 236 | 1.62045
 |  |  |  |  |  |  |  | 237 | 1.61847
 |  |  |  |  |  |  |  | 238 | 1.61731
 |  |  |  |  |  |  |  | 239 | 1.61907
 |  |  |  |  |  |  |  | 240 | 1.62092
 |  |  |  |  |  |  |  | 241 | 1.61973
 |  |  |  |  |  |  |  | 242 | 1.61958
 |  |  |  |  |  |  |  | 243 | 1.61976
 |  |  |  |  |  |  |  | 244 | 1.62056
 |  |  |  |  |  |  |  | 245 | 1.61869
 |  |  |  |  |  |  |  | 246 | 1.62246
 |  |  |  |  |  |  |  | 247 | 1.62263
 |  |  |  |  |  |  |  | 248 | 1.62177