Spreadsheet: 677228d1589252060-dynamic-range-bottom-to-top-formula-volatility
Sheet: Sheet1

 | Open | High | Low | Close | TR(1) | ATR | ARC | SAR | Action & Order | Buy | Hold | Sell | P&L
2019-11-18 00:00:00 | 29.24 | 29.74 | 29.01 | 29.49 |  |  |  |  |  |  |  |  |  | Yclose-high | Yclose-low | high-low |  | Constant
2019-11-19 00:00:00 | 29.62 | 29.67 | 29.18 | 29.44 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.8
2019-11-20 00:00:00 | 29.3 | 29.48 | 28.88 | 29.17
2019-11-21 00:00:00 | 29.2 | 30.49 | 29.15 | 29.79
2019-11-22 00:00:00 | 29.87 | 30.17 | 29.58 | 30.03 |  |  |  |  | Sell
2019-11-25 00:00:00 | 30.13 | 30.57 | 30.05 | 30.54 |  |  |  |  | Buy | Buy |  |  |  |  |  |  |  |  |  | IF CLOSE < (MAX - ARC) and PREV(BUY) THEN SELL
2019-11-26 00:00:00 | 30.57 | 30.99 | 30.4 | 30.96 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF CLOSE < (MAX - ARC) and PREV(SELL) THEN SELL
2019-11-27 00:00:00 | 31 | 31.36 | 30.93 | 31.17 |  |  |  |  |  | Buy |  |  |  |  |  |  |  |  |  | IF CLOSE > (MIN + ARC) and PREV(BUY) THEN BUY
2019-11-29 00:00:00 | 31.11 | 31.14 | 30.78 | 30.91 |  |  |  |  |  | Hold |  |  |  |  |  |  |  |  |  | IF CLOSE > (MIN + ARC) and PREV(SELL) THEN BUY
2019-12-02 00:00:00 | 30.91 | 30.95 | 29.97 | 30.42 |  |  |  |  |  |  | Sell
2019-12-03 00:00:00 | 29.94 | 30.01 | 29.48 | 29.97 |  |  |  |  |  |  |  | Hold
2019-12-04 00:00:00 | 30.18 | 30.33 | 29.91 | 30 |  |  |  |  |  |  | Hold
2019-12-05 00:00:00 | 30.08 | 30.36 | 29.92 | 30.04 |  |  |  |  |  |  | Buy
2019-12-06 00:00:00 | 30.35 | 30.47 | 29.98 | 30.19 |  |  |  |  |  | Sell
2019-12-09 00:00:00 | 30.12 | 30.75 | 30.12 | 30.21 |  |  |  |  |  |  |  | Hold
2019-12-10 00:00:00 | 30.23 | 30.26 | 29.77 | 29.84 |  |  |  |  |  |  | Hold
2019-12-11 00:00:00 | 29.95 | 30.6 | 29.86 | 30.55 |  |  |  |  |  |  | Hold
2019-12-12 00:00:00 | 30.47 | 30.59 | 29.93 | 30.3
2019-12-13 00:00:00 | 30.24 | 30.61 | 30.24 | 30.39
2019-12-16 00:00:00 | 30.52 | 31.28 | 30.41 | 30.97
2019-12-17 00:00:00 | 31.07 | 31.21 | 30.63 | 30.7
2019-12-18 00:00:00 | 30.69 | 31.91 | 30.63 | 31.68
2019-12-19 00:00:00 | 31.75 | 32.42 | 31.61 | 32.03
2019-12-20 00:00:00 | 32.12 | 32.25 | 31.54 | 32.13
2019-12-23 00:00:00 | 32.13 | 32.8 | 31.99 | 32.43
2019-12-24 00:00:00 | 32.44 | 32.71 | 32.42 | 32.5
2019-12-26 00:00:00 | 32.59 | 32.89 | 32.42 | 32.63
2019-12-27 00:00:00 | 32.75 | 32.84 | 32.22 | 32.55
2019-12-30 00:00:00 | 32.49 | 32.5 | 31.82 | 32.03
2019-12-31 00:00:00 | 31.86 | 32.32 | 31.77 | 32.05
2020-01-02 00:00:00 | 32.31 | 32.5 | 31.96 | 32.3
2020-01-03 00:00:00 | 31.71 | 32.1 | 31.26 | 31.52
2020-01-06 00:00:00 | 31.23 | 31.71 | 31.16 | 31.64
2020-01-07 00:00:00 | 31.8 | 32.7 | 31.72 | 32.54
2020-01-08 00:00:00 | 32.35 | 33.4 | 32.35 | 33.05
2020-01-09 00:00:00 | 33.53 | 33.54 | 33 | 33.22
2020-01-10 00:00:00 | 32.86 | 33.01 | 32.46 | 32.78
2020-01-13 00:00:00 | 32.97 | 33.07 | 32.49 | 32.69
2020-01-14 00:00:00 | 32.69 | 33.12 | 32.64 | 32.82
2020-01-15 00:00:00 | 32.99 | 33.51 | 32.95 | 33.23
2020-01-16 00:00:00 | 33.5 | 34.27 | 33.03 | 34.19
2020-01-17 00:00:00 | 33.82 | 34.39 | 33.58 | 34.22
2020-01-21 00:00:00 | 34.08 | 34.39 | 33.87 | 34.09
2020-01-22 00:00:00 | 34.29 | 34.54 | 33.96 | 34.02
2020-01-23 00:00:00 | 33.99 | 34.36 | 33.72 | 33.89
2020-01-24 00:00:00 | 34.11 | 34.11 | 32.97 | 33.19
2020-01-27 00:00:00 | 32.31 | 32.93 | 32.15 | 32.78
2020-01-28 00:00:00 | 33.06 | 33.66 | 32.85 | 33.42
2020-01-29 00:00:00 | 33.59 | 33.88 | 33.29 | 33.63
2020-01-30 00:00:00 | 32.86 | 33.23 | 32.39 | 33.22
2020-01-31 00:00:00 | 33.11 | 33.14 | 32.08 | 32.48
2020-02-03 00:00:00 | 32.56 | 33.24 | 32.45 | 33.07
2020-02-04 00:00:00 | 33.75 | 34.12 | 33.4 | 33.96
2020-02-05 00:00:00 | 34 | 34.16 | 33.19 | 33.39
2020-02-06 00:00:00 | 36.53 | 39.64 | 36.42 | 38.41
2020-02-07 00:00:00 | 37.63 | 38.15 | 36.84 | 37.03
2020-02-10 00:00:00 | 36.63 | 36.85 | 35.65 | 35.96
2020-02-11 00:00:00 | 36.12 | 36.28 | 35.53 | 35.65
2020-02-12 00:00:00 | 36.19 | 37.02 | 36.17 | 36.79
2020-02-13 00:00:00 | 36.43 | 37.32 | 36.21 | 37.16
2020-02-14 00:00:00 | 37 | 37.35 | 36.58 | 36.91
2020-02-18 00:00:00 | 36.78 | 38.07 | 36.68 | 38.06
2020-02-19 00:00:00 | 38.09 | 38.91 | 37.94 | 38.77
2020-02-20 00:00:00 | 38.76 | 39.06 | 37.96 | 39.05
2020-02-21 00:00:00 | 38.67 | 38.76 | 38.04 | 38.31
2020-02-24 00:00:00 | 36.5 | 36.59 | 35.3 | 35.89
2020-02-25 00:00:00 | 36.18 | 36.45 | 34.89 | 35.21
2020-02-26 00:00:00 | 35.28 | 35.82 | 34.44 | 34.63
2020-02-27 00:00:00 | 33.73 | 34.2 | 32.47 | 33.01
2020-02-28 00:00:00 | 31.86 | 33.37 | 31.51 | 33.2
2020-03-02 00:00:00 | 36 | 36.86 | 35.14 | 35.82
2020-03-03 00:00:00 | 36.02 | 36.48 | 34.41 | 34.93
2020-03-04 00:00:00 | 35.76 | 36 | 34.77 | 36
2020-03-05 00:00:00 | 35.03 | 35.73 | 34.52 | 34.97
2020-03-06 00:00:00 | 33.81 | 33.99 | 32.51 | 33.46
2020-03-09 00:00:00 | 31.81 | 35.36 | 30.62 | 32.46
2020-03-10 00:00:00 | 33.9 | 34.78 | 33.12 | 34.31
2020-03-11 00:00:00 | 33.3 | 33.46 | 30.01 | 31.3
2020-03-12 00:00:00 | 29.08 | 29.69 | 26.7 | 26.78
2020-03-13 00:00:00 | 28.83 | 29.41 | 26.4 | 29.29
2020-03-16 00:00:00 | 26.12 | 28.35 | 23.92 | 24.04
2020-03-17 00:00:00 | 24.38 | 25.84 | 23.18 | 24.48
2020-03-18 00:00:00 | 22.95 | 23.49 | 20 | 22
2020-03-19 00:00:00 | 22.11 | 25.17 | 20.66 | 24.13
2020-03-20 00:00:00 | 24.97 | 25.86 | 23.7 | 23.95
2020-03-23 00:00:00 | 23.8 | 25.25 | 23.5 | 24.69
2020-03-24 00:00:00 | 25.79 | 26.46 | 24.13 | 25.85
2020-03-25 00:00:00 | 25.85 | 27.46 | 24.52 | 25.97
2020-03-26 00:00:00 | 26.15 | 27.03 | 25.63 | 26.41
2020-03-27 00:00:00 | 25.56 | 25.83 | 24.76 | 25.29
2020-03-30 00:00:00 | 25.25 | 25.94 | 24.6 | 25.59
2020-03-31 00:00:00 | 25.79 | 26.33 | 24.4 | 24.56
2020-04-01 00:00:00 | 23.7 | 24.39 | 23.05 | 23.32
2020-04-02 00:00:00 | 23 | 23.58 | 22.36 | 23.02
2020-04-03 00:00:00 | 24.1 | 24.32 | 22.75 | 23.09
2020-04-06 00:00:00 | 24.1 | 25.05 | 23.79 | 24.93
2020-04-07 00:00:00 | 25.97 | 26.86 | 25.31 | 25.61
2020-04-08 00:00:00 | 26.79 | 28.46 | 25.92 | 27.86
2020-04-09 00:00:00 | 28.48 | 29.05 | 27.28 | 27.77
2020-04-13 00:00:00 | 27.55 | 27.62 | 26.24 | 27.21
2020-04-14 00:00:00 | 28 | 28.41 | 27.6 | 27.94
2020-04-15 00:00:00 | 27.1 | 27.64 | 26.75 | 27.51
2020-04-16 00:00:00 | 26.86 | 27.17 | 25.96 | 26.55
2020-04-17 00:00:00 | 27.16 | 27.92 | 26.47 | 26.7