Spreadsheet: 722105d1615041128-index-and-match-function-if-0-is-higher-or-lower-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | score card |  | >50 and growing |  |  | [NAME] to +8 | Short bias | Inflation
 |  |  |  |  |  |  |  |  |  |  | >50 and slowing |  |  | 0 to +5 | Short bias | Inflation
 |  |  |  |  |  |  |  |  |  |  | <50 and slowing |  |  | -5 to -8 | Long bias | Deflation
 |  |  |  |  |  |  |  |  |  |  | <50 and growing |  |  | 0 to -5 | Long bias | Deflation
 |  |  |  |  |  |  |  |  |  |  | Peak >50,slowing for 1st time |  |  | -8 to -10 | Long bias | Predict Deflation
 |  |  |  |  |  |  |  |  |  |  | Trough <50,growing for 1st time |  |  | +8 to +10 | Short bias | predict Inflation
 |  |  | 2nd previous | 2nd previus change | previous | previous change | current | change |  | need to calculate to a maximum of the score card
 |  | 2016-05-01 00:00:00 | 49.2 |  | 50 |  | 51.3 |  | arrey
 |  | 2016-06-01 00:00:00 | 50 |  | 51.3 |  | 53.2 |  |  |  |  |  | 2nd previous |  | previous |  | current |  | array result | [NAME] value
 |  | 2016-07-01 00:00:00 | 51.3 |  | 53.2 |  | 52.6 |  |  |  |  |  | >=50 | >=0 | >=50 | >=0 | >=50 | >=0 | 5 | 8
 |  | 2016-08-01 00:00:00 | 53.2 |  | 52.6 |  | 49.4 |  |  |  |  |  | >=50 | <0 | >=50 | >=0 | >=50 | >=0 | 5 | 8
 |  | 2016-09-01 00:00:00 | 52.6 |  | 49.4 |  | 51.5 |  |  |  |  |  | >=50 | <0 | >=50 | <0 | >=50 | >=0 | 5 | 8
 |  | 2016-10-01 00:00:00 | 49.4 |  | 51.5 |  | 51.9 |  |  |  |  |  | >=50 | >=0 | >=50 | <0 | >=50 | <0 | 0 | 5
 |  | 2016-11-01 00:00:00 | 51.5 |  | 51.9 |  | 53.2 |  |  |  |  |  | >=50 | <0 | >=50 | <0 | >=50 | <0 | 0 | 5
 |  | 2016-12-01 00:00:00 | 51.9 |  | 53.2 |  | 54.7 |  |  |  |  |  | >=50 | >=0 | >=50 | >=0 | >=50 | <0 | -8 | -10
 |  | 2017-01-01 00:00:00 | 53.2 |  | 54.7 |  | 56 |  |  |  |  |  | <50 | <0 | <50 | <0 | <50 | >=0 | -8 | 10
 |  | 2017-02-01 00:00:00 | 54.7 |  | 56 |  | 57.7 |  |  |  |  |  | <50 | >=0 | <50 | <0 | <50 | <0 | -5 | -8
 |  | 2017-03-01 00:00:00 | 56 |  | 57.7 |  | 57.2 |  |  |  |  |  | <50 | <0 | <50 | <0 | <50 | <0 | -5 | -8
 |  | 2017-04-01 00:00:00 | 57.7 |  | 57.2 |  | 54.8 |  |  |  |  |  | <50 | >=0 | <50 | >=0 | <50 | >=0 | 0 | -5
 |  | 2017-05-01 00:00:00 | 57.2 |  | 54.8 |  | 54.9 |  |  |  |  |  | <50 | >=0 | <50 | <0 | <50 | >=0 | 0 | -5
 |  | 2017-06-01 00:00:00 | 54.8 |  | 54.9 |  | 57.8 |  |  |  |  |  | <50 | <0 | <50 | <0 | <50 | >=0 | 0 | -5
 |  | 2017-07-01 00:00:00 | 54.9 |  | 57.8 |  | 56.3
 |  | 2017-08-01 00:00:00 | 57.8 |  | 56.3 |  | 58.8
 |  | 2017-09-01 00:00:00 | 56.3 |  | 58.8 |  | 60.8
 |  | 2017-10-01 00:00:00 | 58.8 |  | 60.8 |  | 58.7
 |  | 2017-11-01 00:00:00 | 60.8 |  | 58.7 |  | 58.2
 |  | 2017-12-01 00:00:00 | 58.7 |  | 58.2 |  | 59.7
 |  | 2018-01-01 00:00:00 | 58.2 |  | 59.7 |  | 59.1
 |  | 2018-02-01 00:00:00 | 59.7 |  | 59.1 |  | 60.8
 |  | 2018-03-01 00:00:00 | 59.1 |  | 60.8 |  | 59.3
 |  | 2018-04-01 00:00:00 | 60.8 |  | 59.3 |  | 57.3
 |  | 2018-05-01 00:00:00 | 59.3 |  | 57.3 |  | 58.7
 |  | 2018-06-01 00:00:00 | 57.3 |  | 58.7 |  | 60.2
 |  | 2018-07-01 00:00:00 | 58.7 |  | 60.2 |  | 58.1
 |  | 2018-08-01 00:00:00 | 60.2 |  | 58.1 |  | 61.3
 |  | 2018-09-01 00:00:00 | 58.1 |  | 61.3 |  | 59.8
 |  | 2018-10-01 00:00:00 | 61.3 |  | 59.8 |  | 57.7
 |  | 2018-11-01 00:00:00 | 59.8 |  | 57.7 |  | 59.3
 |  | 2018-12-01 00:00:00 | 57.7 |  | 59.3 |  | 54.1
 |  | 2019-01-01 00:00:00 | 59.3 |  | 54.1 |  | 56.6
 |  | 2019-02-01 00:00:00 | 54.1 |  | 56.6 |  | 54.2
 |  | 2019-03-01 00:00:00 | 56.6 |  | 54.2 |  | 55.3
 |  | 2019-04-01 00:00:00 | 54.2 |  | 55.3 |  | 52.8
 |  | 2019-05-01 00:00:00 | 55.3 |  | 52.8 |  | 52.1
 |  | 2019-06-01 00:00:00 | 52.8 |  | 52.1 |  | 51.7
 |  | 2019-07-01 00:00:00 | 52.1 |  | 51.7 |  | 51.2
 |  | 2019-08-01 00:00:00 | 51.7 |  | 51.2 |  | 49.1
 |  | 2019-09-01 00:00:00 | 51.2 |  | 49.1 |  | 47.8
 |  | 2019-10-01 00:00:00 | 49.1 |  | 47.8 |  | 48.3
 |  | 2019-11-01 00:00:00 | 47.8 |  | 48.3 |  | 48.1
 |  | 2019-12-01 00:00:00 | 48.3 |  | 48.1 |  | 47.2
 |  | 2020-01-01 00:00:00 | 48.1 |  | 47.2 |  | 50.9
 |  | 2020-02-01 00:00:00 | 47.2 |  | 50.9 |  | 50.1
 |  | 2020-03-01 00:00:00 | 50.9 |  | 50.1 |  | 49.1
 |  | 2020-04-01 00:00:00 | 50.1 |  | 49.1 |  | 41.5
 |  | 2020-05-01 00:00:00 | 49.1 |  | 41.5 |  | 41.3
 |  |  | 41.5 |  | 41.3
 |  |  | 41.3