Spreadsheet: 93515d1293084380-linear-regression-formula-help-linear
Sheet: Sheet1

60 Minute |  |  |  |  |  |  |  |  | 240 Minute
# | Date | Time | Open | High | Low | Close | Linear Regression |  | # | Date | Time | Open | High | Low | Close | Linear Regression
1 | 2010.01.04 | 1900-01-01 00:00:00 | 1.4304 | 1.4338 | 1.4299 | 1.4335 | / |  | 1 | 2010.01.04 | 1900-01-01 00:00:00 | 1.4304 | 1.4415 | 1.4299 | 1.4389 | /
2 | 2010.01.04 | 01:00:00 | 1.4304 | 1.4395 | 1.4299 | 1.4394 | / |  | 2 | 2010.01.04 | 04:00:00 | 1.4389 | 1.4455 | 1.4385 | 1.4438 | /
3 | 2010.01.04 | 02:00:00 | 1.4304 | 1.4399 | 1.4299 | 1.4376 | / |  | 3 | 2010.01.04 | 08:00:00 | 1.4438 | 1.444 | 1.4409 | 1.4411 | /
4 | 2010.01.04 | 03:00:00 | 1.4304 | 1.4415 | 1.4299 | 1.4389 | / |  | 4 | 2010.01.04 | 12:00:00 | 1.4411 | 1.4425 | 1.4402 | 1.4423 | /
5 | 2010.01.04 | 04:00:00 | 1.4389 | 1.4404 | 1.4385 | 1.4396 | / |  | 5 | 2010.01.04 | 16:00:00 | 1.4424 | 1.4438 | 1.4405 | 1.4422 | /
6 | 2010.01.04 | 05:00:00 | 1.4389 | 1.4432 | 1.4385 | 1.4421 | / |  | 6 | 2010.01.04 | 20:00:00 | 1.4422 | 1.4483 | 1.4414 | 1.4452 | /
7 | 2010.01.04 | 06:00:00 | 1.4389 | 1.4449 | 1.4385 | 1.4424 | / |  | 7 | 2010.01.05 | 1900-01-01 00:00:00 | 1.4452 | 1.4453 | 1.4398 | 1.4417 | /
8 | 2010.01.04 | 07:00:00 | 1.4389 | 1.4455 | 1.4385 | 1.4438 | / |  | 8 | 2010.01.05 | 04:00:00 | 1.4417 | 1.4453 | 1.4386 | 1.4416 | /
9 | 2010.01.04 | 08:00:00 | 1.4438 | 1.444 | 1.4416 | 1.4417 | / |  | 9 | 2010.01.05 | 08:00:00 | 1.4416 | 1.4423 | 1.4345 | 1.4369 | /
10 | 2010.01.04 | 09:00:00 | 1.4438 | 1.444 | 1.4411 | 1.4414 | / |  | 10 | 2010.01.05 | 12:00:00 | 1.4369 | 1.4372 | 1.4348 | 1.4364 | /
11 | 2010.01.04 | 10:00:00 | 1.4438 | 1.444 | 1.4409 | 1.4412 | / |  | 11 | 2010.01.05 | 16:00:00 | 1.4364 | 1.4368 | 1.4333 | 1.4355 | /
12 | 2010.01.04 | 11:00:00 | 1.4438 | 1.444 | 1.4409 | 1.4411 | / |  | 12 | 2010.01.05 | 20:00:00 | 1.4355 | 1.4362 | 1.4282 | 1.4328 | /
13 | 2010.01.04 | 12:00:00 | 1.4411 | 1.4421 | 1.4407 | 1.4411 | / |  | 13 | 2010.01.06 | 1900-01-01 00:00:00 | 1.4329 | 1.4382 | 1.4326 | 1.4348 | /
14 | 2010.01.04 | 13:00:00 | 1.4411 | 1.4421 | 1.4402 | 1.4412 | / |  | 14 | 2010.01.06 | 04:00:00 | 1.4348 | 1.4392 | 1.4335 | 1.4387 | /
15 | 2010.01.04 | 14:00:00 | 1.4411 | 1.4421 | 1.4402 | 1.4412 | 1.442755833333333 |  | 15 | 2010.01.06 | 08:00:00 | 1.4387 | 1.4434 | 1.4382 | 1.4408 | 1.436280833333333
16 | 2010.01.04 | 15:00:00 | 1.4411 | 1.4425 | 1.4402 | 1.4423 | 1.44229 |  | 16 | 2010.01.06 | 12:00:00 | 1.4408 | 1.4416 | 1.439 | 1.4401 | 1.436340833333333
17 | 2010.01.04 | 16:00:00 | 1.4424 | 1.4438 | 1.4411 | 1.4418 | 1.44227 |  | 17 | 2010.01.06 | 16:00:00 | 1.4401 | 1.4446 | 1.4393 | 1.4404 | 1.437096666666667
18 | 2010.01.04 | 17:00:00 | 1.4424 | 1.4438 | 1.4411 | 1.4419 | 1.441974166666667 |  | 18 | 2010.01.06 | 20:00:00 | 1.4404 | 1.4415 | 1.4354 | 1.4386 | 1.4371425
19 | 2010.01.04 | 18:00:00 | 1.4424 | 1.4438 | 1.4405 | 1.4415 | 1.4416475 |  | 19 | 2010.01.07 | 1900-01-01 00:00:00 | 1.4386 | 1.4398 | 1.4327 | 1.4334 | 1.436154166666667
20 | 2010.01.04 | 19:00:00 | 1.4424 | 1.4438 | 1.4405 | 1.4422 | 1.441518333333334 |  | 20 | 2010.01.07 | 04:00:00 | 1.4334 | 1.435 | 1.4298 | 1.4327 | 1.435205833333333
21 | 2010.01.04 | 20:00:00 | 1.4422 | 1.4441 | 1.4417 | 1.4426 | 1.441754166666667 |  | 21 | 2010.01.07 | 08:00:00 | 1.4327 | 1.4333 | 1.4303 | 1.4326 | 1.434870833333333
22 | 2010.01.04 | 21:00:00 | 1.4422 | 1.4472 | 1.4414 | 1.4463 | 1.442911666666667 |  | 22 | 2010.01.07 | 12:00:00 | 1.4326 | 1.4326 | 1.4302 | 1.4317 | 1.434166666666667
23 | 2010.01.04 | 22:00:00 | 1.4422 | 1.4476 | 1.4414 | 1.4476 | 1.4444725 |  | 23 | 2010.01.07 | 16:00:00 | 1.4317 | 1.4326 | 1.43 | 1.4313 | 1.4336025
24 | 2010.01.04 | 23:00:00 | 1.4422 | 1.4483 | 1.4414 | 1.4452 | 1.445078333333333 |  | 24 | 2010.01.07 | 20:00:00 | 1.4313 | 1.4334 | 1.4286 | 1.4318 | 1.43279
25 | 2010.01.05 | 1900-01-01 00:00:00 | 1.4452 | 1.4453 | 1.4402 | 1.4419 | 1.444759166666667 |  | 25 | 2010.01.08 | 1900-01-01 00:00:00 | 1.4318 | 1.4333 | 1.4288 | 1.4303 | 1.431675833333333
26 | 2010.01.05 | 01:00:00 | 1.4452 | 1.4453 | 1.4402 | 1.4431 | 1.444690833333334 |  | 26 | 2010.01.08 | 04:00:00 | 1.4303 | 1.4414 | 1.4262 | 1.4325 | 1.431125833333333
27 | 2010.01.05 | 02:00:00 | 1.4452 | 1.4453 | 1.4402 | 1.4418 | 1.4442475 |  | 27 | 2010.01.08 | 08:00:00 | 1.4325 | 1.4438 | 1.4321 | 1.4415 | 1.432465833333334
28 | 2010.01.05 | 03:00:00 | 1.4452 | 1.4453 | 1.4398 | 1.4417 | 1.4437625
29 | 2010.01.05 | 04:00:00 | 1.4417 | 1.4453 | 1.4416 | 1.4437 | 1.443759166666667
30 | 2010.01.05 | 05:00:00 | 1.4417 | 1.4453 | 1.4416 | 1.4426 | 1.4434275
31 | 2010.01.05 | 06:00:00 | 1.4417 | 1.4453 | 1.4386 | 1.4404 | 1.442675833333333
32 | 2010.01.05 | 07:00:00 | 1.4417 | 1.4453 | 1.4386 | 1.4416 | 1.442195
33 | 2010.01.05 | 08:00:00 | 1.4416 | 1.4423 | 1.4385 | 1.4401 | 1.44137
34 | 2010.01.05 | 09:00:00 | 1.4416 | 1.4423 | 1.4382 | 1.439 | 1.440270833333333
35 | 2010.01.05 | 10:00:00 | 1.4416 | 1.4423 | 1.4345 | 1.4363 | 1.438675
36 | 2010.01.05 | 11:00:00 | 1.4416 | 1.4423 | 1.4345 | 1.4369 | 1.437425
37 | 2010.01.05 | 12:00:00 | 1.4369 | 1.4372 | 1.4363 | 1.4367 | 1.4367625
38 | 2010.01.05 | 13:00:00 | 1.4369 | 1.4372 | 1.4362 | 1.4365 | 1.436465
39 | 2010.01.05 | 14:00:00 | 1.4369 | 1.4372 | 1.4357 | 1.4361 | 1.436028333333333
40 | 2010.01.05 | 15:00:00 | 1.4369 | 1.4372 | 1.4348 | 1.4364 | 1.435451666666666
41 | 2010.01.05 | 16:00:00 | 1.4364 | 1.4365 | 1.4333 | 1.4347 | 1.434761666666666
42 | 2010.01.05 | 17:00:00 | 1.4364 | 1.4368 | 1.4333 | 1.4368 | 1.434615833333333
43 | 2010.01.05 | 18:00:00 | 1.4364 | 1.4368 | 1.4333 | 1.4357 | 1.434315833333333
44 | 2010.01.05 | 19:00:00 | 1.4364 | 1.4368 | 1.4333 | 1.4355 | 1.434384166666667
45 | 2010.01.05 | 20:00:00 | 1.4355 | 1.4362 | 1.4352 | 1.4354 | 1.434486666666667
46 | 2010.01.05 | 21:00:00 | 1.4355 | 1.4362 | 1.4344 | 1.4356 | 1.434524166666667
47 | 2010.01.05 | 22:00:00 | 1.4355 | 1.4362 | 1.4289 | 1.431 | 1.43373
48 | 2010.01.05 | 23:00:00 | 1.4355 | 1.4362 | 1.4282 | 1.4328 | 1.433435833333333
49 | 2010.01.06 | 1900-01-01 00:00:00 | 1.4329 | 1.4351 | 1.4326 | 1.4351 | 1.433733333333333
50 | 2010.01.06 | 01:00:00 | 1.4329 | 1.4382 | 1.4326 | 1.4378 | 1.434420833333333
51 | 2010.01.06 | 02:00:00 | 1.4329 | 1.4382 | 1.4326 | 1.4376 | 1.4351025
52 | 2010.01.06 | 03:00:00 | 1.4329 | 1.4382 | 1.4326 | 1.4348 | 1.435063333333333
53 | 2010.01.06 | 04:00:00 | 1.4348 | 1.4356 | 1.4335 | 1.4356 | 1.435238333333334
54 | 2010.01.06 | 05:00:00 | 1.4348 | 1.4371 | 1.4335 | 1.4358 | 1.435430833333333
55 | 2010.01.06 | 06:00:00 | 1.4348 | 1.4371 | 1.4335 | 1.4353 | 1.435550000000001
56 | 2010.01.06 | 07:00:00 | 1.4348 | 1.4392 | 1.4335 | 1.4387 | 1.436291666666667
57 | 2010.01.06 | 08:00:00 | 1.4387 | 1.4415 | 1.4382 | 1.4402 | 1.437575833333333
58 | 2010.01.06 | 09:00:00 | 1.4387 | 1.4415 | 1.4382 | 1.4404 | 1.438676666666667
59 | 2010.01.06 | 10:00:00 | 1.4387 | 1.4415 | 1.4382 | 1.4397 | 1.439464166666667
60 | 2010.01.06 | 11:00:00 | 1.4387 | 1.4434 | 1.4382 | 1.4408 | 1.440399166666667
61 | 2010.01.06 | 12:00:00 | 1.4408 | 1.4412 | 1.4401 | 1.4411 | 1.441298333333333
62 | 2010.01.06 | 13:00:00 | 1.4408 | 1.4416 | 1.4401 | 1.4406 | 1.441325833333333
63 | 2010.01.06 | 14:00:00 | 1.4408 | 1.4416 | 1.439 | 1.44 | 1.441208333333333
64 | 2010.01.06 | 15:00:00 | 1.4408 | 1.4416 | 1.439 | 1.4401 | 1.441241666666667
65 | 2010.01.06 | 16:00:00 | 1.4401 | 1.4446 | 1.4399 | 1.4424 | 1.442065833333333
66 | 2010.01.06 | 17:00:00 | 1.4401 | 1.4446 | 1.4399 | 1.4425 | 1.4427725
67 | 2010.01.06 | 18:00:00 | 1.4401 | 1.4446 | 1.4393 | 1.4404 | 1.442475833333333
68 | 2010.01.06 | 19:00:00 | 1.4401 | 1.4446 | 1.4393 | 1.4404 | 1.442145833333333
69 | 2010.01.06 | 20:00:00 | 1.4404 | 1.4415 | 1.4395 | 1.4399 | 1.441601666666666
70 | 2010.01.06 | 21:00:00 | 1.4404 | 1.4415 | 1.438 | 1.4391 | 1.440695
71 | 2010.01.06 | 22:00:00 | 1.4404 | 1.4415 | 1.4357 | 1.4368 | 1.439590833333333
72 | 2010.01.06 | 23:00:00 | 1.4404 | 1.4415 | 1.4354 | 1.4386 | 1.439169166666667
73 | 2010.01.07 | 1900-01-01 00:00:00 | 1.4386 | 1.4398 | 1.4357 | 1.4363 | 1.438258333333333
74 | 2010.01.07 | 01:00:00 | 1.4386 | 1.4398 | 1.435 | 1.4353 | 1.437115
75 | 2010.01.07 | 02:00:00 | 1.4386 | 1.4398 | 1.4338 | 1.4349 | 1.436131666666667
76 | 2010.01.07 | 03:00:00 | 1.4386 | 1.4398 | 1.4327 | 1.4334 | 1.434973333333333
77 | 2010.01.07 | 04:00:00 | 1.4334 | 1.4339 | 1.4314 | 1.4318 | 1.433554166666666
78 | 2010.01.07 | 05:00:00 | 1.4334 | 1.4339 | 1.4298 | 1.4333 | 1.4326375
79 | 2010.01.07 | 06:00:00 | 1.4334 | 1.435 | 1.4298 | 1.4319 | 1.431563333333333
80 | 2010.01.07 | 07:00:00 | 1.4334 | 1.435 | 1.4298 | 1.4327 | 1.431194166666667
81 | 2010.01.07 | 08:00:00 | 1.4327 | 1.4333 | 1.4303 | 1.4312 | 1.430718333333333
82 | 2010.01.07 | 09:00:00 | 1.4327 | 1.4333 | 1.4303 | 1.4324 | 1.430535
83 | 2010.01.07 | 10:00:00 | 1.4327 | 1.4333 | 1.4303 | 1.4308 | 1.430165
84 | 2010.01.07 | 11:00:00 | 1.4327 | 1.4333 | 1.4303 | 1.4326 | 1.430403333333333
85 | 2010.01.07 | 12:00:00 | 1.4326 | 1.4326 | 1.4306 | 1.4322 | 1.430620833333334
86 | 2010.01.07 | 13:00:00 | 1.4326 | 1.4326 | 1.4305 | 1.4307 | 1.430341666666667
87 | 2010.01.07 | 14:00:00 | 1.4326 | 1.4326 | 1.4302 | 1.4304 | 1.4303825
88 | 2010.01.07 | 15:00:00 | 1.4326 | 1.4326 | 1.4302 | 1.4317 | 1.430635833333334
89 | 2010.01.07 | 16:00:00 | 1.4317 | 1.4326 | 1.43 | 1.4316 | 1.430846666666667
90 | 2010.01.07 | 17:00:00 | 1.4317 | 1.4326 | 1.43 | 1.4311 | 1.430975833333333
91 | 2010.01.07 | 18:00:00 | 1.4317 | 1.4326 | 1.43 | 1.4308 | 1.4309275
92 | 2010.01.07 | 19:00:00 | 1.4317 | 1.4326 | 1.43 | 1.4313 | 1.430851666666667
93 | 2010.01.07 | 20:00:00 | 1.4313 | 1.4317 | 1.4307 | 1.4312 | 1.430964166666667
94 | 2010.01.07 | 21:00:00 | 1.4313 | 1.4317 | 1.4286 | 1.4293 | 1.430483333333334
95 | 2010.01.07 | 22:00:00 | 1.4313 | 1.4317 | 1.4286 | 1.4311 | 1.430609166666667
96 | 2010.01.07 | 23:00:00 | 1.4313 | 1.4334 | 1.4286 | 1.4318 | 1.430744166666667
97 | 2010.01.08 | 1900-01-01 00:00:00 | 1.4318 | 1.4332 | 1.4313 | 1.433 | 1.431314166666667
98 | 2010.01.08 | 01:00:00 | 1.4318 | 1.4333 | 1.4313 | 1.4322 | 1.4314625
99 | 2010.01.08 | 02:00:00 | 1.4318 | 1.4333 | 1.4296 | 1.4302 | 1.4313325
100 | 2010.01.08 | 03:00:00 | 1.4318 | 1.4333 | 1.4288 | 1.4303 | 1.431233333333333
101 | 2010.01.08 | 04:00:00 | 1.4303 | 1.4303 | 1.4276 | 1.4289 | 1.430643333333333
102 | 2010.01.08 | 05:00:00 | 1.4303 | 1.4414 | 1.4262 | 1.4402 | 1.432789166666666
103 | 2010.01.08 | 06:00:00 | 1.4303 | 1.4414 | 1.4262 | 1.4355 | 1.4337275
104 | 2010.01.08 | 07:00:00 | 1.4303 | 1.4414 | 1.4262 | 1.4325 | 1.4338325
105 | 2010.01.08 | 08:00:00 | 1.4325 | 1.4356 | 1.4321 | 1.4355 | 1.434573333333333
106 | 2010.01.08 | 09:00:00 | 1.4325 | 1.4407 | 1.4321 | 1.4393 | 1.4360825
107 | 2010.01.08 | 10:00:00 | 1.4325 | 1.4438 | 1.4321 | 1.4423 | 1.438170833333333
108 | 2010.01.08 | 11:00:00 | 1.4325 | 1.4438 | 1.4321 | 1.4415 | 1.4397775