Spreadsheet: 744903d1629550498-index-and-match-lookup-to-find-the-last-number-over-50-uspmi
Sheet: USD-PMI

USD - PMI |  |  |  | Occurance | Percentage | [NAME] | 1 | 2 | 3 |  |  |  |  |  |  | TABLE #1
 |  |  | Count Pos |  |  | Upper |  |  |  | Mean |  | Mean |  |  |  | 3 |  | 3 |  | LOWEST END SCORE |  |  | MAX | MIN
 |  |  | Count Neg |  |  | Lower |  |  |  | Standard Error |  | Standard Error |  |  |  | >=50 | Y | >=0 | Y | 5 | Inflation | N/A | 8 | 5
 |  |  | 0 count |  |  |  |  | Adj Av Pos Ret |  | Median |  | Median |  |  |  | >=50 | Y | <0 | N | 0 | Inflation | FLIP | 5 | 0
 |  |  |  |  |  |  |  | [NAME] |  | Mode |  | Mode |  |  |  | <50 | N | >=0 | Y | 0 | Deflation | FLIP | 0 | -5
NEXT RELASE | ACTUAL |  | Actual | Actual % | Normal Count | Normal |  | [NAME] |  | Standard Deviation |  | Standard Deviation |  |  |  | <50 | N | <0 | N | -5 | Deflation | N/A | -5 | -8
2021-07-01 00:00:00 | USD-PMI | 1 |  |  |  | 0.682 |  | count |  | Sample Variance |  | Sample Variance |  |  |  | TABLE #2
 |  | 2 |  |  |  | 0.954 |  | Av Pos Ret |  | Kurtosis |  | Kurtosis |  |  |  | 3 |  | LOWEST END SCORE | MAX | MIN
 |  | 3 |  |  |  | 0.998 |  | [NAME] |  | Skewness |  | Skewness |  |  |  | Y | N | -8 | -8 | -10
 |  |  |  | Occurance | Percentage | [NAME] | 0.5 / 3.5 | 1.5 / 4.5 | 2.5 / 5.5 | Range |  | Range |  |  |  | N | Y | 8 | 10 | 8
 |  |  | Count Above 1 std |  |  | Upper 3.5 TO 5.5 |  |  |  | Minimum |  | Minimum
 |  |  | Count Below 1 std |  |  | Lower 0.5 TO 2.5 |  |  |  | Maximum |  | Maximum |  |  |  | SCORE CARD
 |  |  | 0 count |  |  |  |  | Adj Av Pos Ret |  | Sum |  | Sum |  |  |  | Manufacturing PMI |  |  | Score
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | >50 and growing |  |  | [NAME] to +8 | Short bias | Inflation
 |  |  | Actual | Actual % | Normal Count | Normal |  | [NAME] |  | Count |  | Count |  |  |  | >50 and slowing |  |  | 0 to +5 | Short bias | Inflation
 |  | 1 |  |  |  | 0.682 |  | count |  |  |  |  |  |  |  | <50 and slowing |  |  | -5 to -8 | Long bias | Deflation
 |  | 2 |  |  |  | 0.954 |  | Av Pos Ret |  |  |  |  |  |  |  | <50 and growing |  |  | 0 to -5 | Long bias | Deflation
 |  | 3 |  |  |  | 0.998 |  | [NAME] |  |  |  |  |  |  |  | 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
https://uk.investing.com/economic-calendar/ism-manufacturing-pmi-173
U.S. ISM Manufacturing Purchasing Managers Index (PMI)
 |  |  |  |  | CORRISPOND WITH TABLE#1
Current | Change | COUNT | C>=50,D<0 | C<50,D>0 | PMI ABOVE 50 Y/N | PMI CHAGE ABOVE 0 Y/N | CHECK FOR DEFLATION | CHECK FOR INFLATION | MAX NORMAL SCORE | MIN NORMAL SCORE | INFL/DEFL MAX | INFL/DEFL MIN | SCORE INFL/DEFL, LOWEST END SCALE | SCORE NORMAL, LOWEST END SCALE | PRE FLIP | FINAL FLIP | PRE SCORE | CHANGE BEFORE FLIP | CHANGE FLIPED | CALCULATED SCORE | FINAL MAX | FINAL MIN | Final Score
0
46.2
50.2
43.6
37.4
29.4
30.3
35
45.5
50.1
55.5
58.2
53
49.2
48.8
49.6
51.6
53.5
50.7
46.7
48.3
42.5
40
36.1
37.8
38.2
38.3
36.8
37.8
35.5
38.3
38.4
38.3
38.8
39.4
39.2
42.8
46
54.4
53.9
54.2
56.1
57.5
63.6
63.1
62.5
64.4
66
69.9
60.5
61.3
58.9
61
58.6
58.1
56.1
53
50
50.8
50.3
50.6
50.3
49.9
47.8
48.2
47.1
47.8
47.9
47.7
49.9
50.9
52
50.7
51.2
51
51
49.7
53.4
50.5
48
52.6
52.4
51.2
51.2
50.5
54.9
52.6
55
55.5
57.2
57.4
57.5
59.3
60
60.7
58.8
61
57.5
56.2
54.6
55.8
55.5
59.3
58.2
56
54.5
55.4
55.6
56
54.7
54.1
51.5
52.2
49.3
47.3
45.9
45.1
46
46.8
46.8
47.4
47.2
49.1
49.9
50
49.5
49.2
46.6
46.1
44.5
43.2
41.3
40.8
39.2
39.4
40.7
42.8
44.5
50.3
50.6
52.9
54.9
53.1
49.5
46.8
47.3
52.7
54.6
52.6
55.7
53.6
53.9
53.4
49.7
50.3
53.6
54.2
55.8
55.2
53.5
50.2
51.2
49.6
50.2
50.7
50.8
53.4
53.8
55.6
56
56.5
56.9
57.4
58.2
58.8
58.5
58
59
59.4
59.2
56.1
57.4
55.1
52.1
51.5
46.7
45.9
50.7
47.1
48.1
46.7
45.9
46.2
45.5
45.9
46.9
49.3
49.1
53.6
49.7
51.6
51.1
50.5
53
55.2
53.8
53.1
53.8
53.7
56.1
54.9
57.7
56.3
53.9
56.4
55.7
54.5
53.8
52.9
52.9
52.2
50.9
48.9
49.2
49.3
48.7
48.7
48.2
46.8
50.6
51.7
52.4
52.3
54.3
55.8
53.6
54.8
57
57.2
58.1
57.8
56.7
55.8
54.9
54.7
53.2
51.4
52.5
49.9
49.7
48.7
48.5
43.9
42.3
42.1
43.1
42.7
41.3
43.2
43.5
46.3
46.2
40.8
44.1
45.3
47.5
50.7
52.4
52.4
53.1
53.6
50.2
50.3
50.5
49
48.5
51.6
51.3
48.8
46.3
46.1
49
49
51
53.2
52.4
55.2
58.4
60.1
60.8
59.9
60.6
60.6
61.4
60.5
59.9
58.5
57.4
56.3
56.2
57.2
56.8
55.5
55.2
52.2
50.8
52.4
52.8
52.4
56.8
57.2
56.7
55.1
55
55.8
54.3
55.2
53.7
52
53
53.7
52.2
51.4
50.3
51.4
49.5
51.9
50.7
52.6
52.5
52.6
52.4
50.9
51
51.1
50.5
49
50.3
48.3
48.6
48.6
49.6
50.2
50
49.9
43.5
38.9
36.2
32.4
35.6
35.8
36.3
40.1
42.8
44.8
48.9
52.9
52.6
55.7
53.6
55.9
58.4
56.5
59.6
60.4
59.7
56.2
55.5
56.3
54.4
56.9
56.6
57
60.8
61.4
61.2
60.4
53.5
55.3
50.9
50.6
51.6
50.8
52.7
53.9
54.1
52.4
53.4
54.8
53.5
49.7
49.8
49.6
51.5
51.7
49.5
50.7
53.1
54.2
51.3
50.7
49
50.9
55.4
55.7
56.2
56.4
57.3
57
51.3
53.2
53.7
54.9
55.4
55.3
57.1
59
56.6
59
58.7
55.5
53.5
52.9
51.5
51.5
52.8
53.5
52.7
51.1
50.2
50.1
48.6
48.2
48.2
49.5
51.8
50.8
51.3
53.2
52.6
49.4
51.5
51.9
53.2
54.7
56
57.7
57.2
54.8
54.9
57.8
56.3
58.8
60.8
58.7
58.2
59.7
59.1
60.7
59.3
57.9
58.7
60
58.4
60.8
59.5
57.5
58.8
54.3
56.6
54.2
55.3
52.8
52.1
51.7
51.2
49.1
47.8
48.3
48.1
47.2
50.9
50.1
49.1
41.5
43.1
52.6
54.2
56
55.4
59.3
57.5
60.7
58.7
60.8
64.7
60.7
61.2
60.6
59.5