Spreadsheet: 682160d1591938093-slope-function-in-pivot-table-slope-test
Sheet: DAILY EQUITY GAINERS

DATE | KNOWN X | SYMBOL | % OFF HIGH | DAILY GAIN | KNOWN Y
2020-06-05 00:00:00 | 1 | A | 0.0083 | -0.0083 | 90.38
2020-06-08 00:00:00 | 2 | A | 0.0093 | -0.001 | 90.29
2020-06-09 00:00:00 | 3 | A | 0.015 | -0.0058 | 89.77
2020-06-10 00:00:00 | 4 | A | 0.0146 | 0.0004 | 89.81
2020-06-11 00:00:00 | 5 | A | 0.067 | -0.0532 | 85.03
2020-06-05 00:00:00 | 1 | AA | 0 | 0.0369 | 12.07
2020-06-08 00:00:00 | 2 | AA | 0.4334 | 0.0754 | 12.98
2020-06-09 00:00:00 | 3 | AA | 0.4505 | -0.03 | 12.59
2020-06-10 00:00:00 | 4 | AA | 0.4688 | -0.0334 | 12.17
2020-06-11 00:00:00 | 5 | AA | 0.5452 | -0.1438 | 10.42
2020-06-05 00:00:00 | 1 | AAAU | 0.0428 | -0.0205 | 16.76
2020-06-08 00:00:00 | 2 | AAAU | 0.032 | 0.0113 | 16.95
2020-06-09 00:00:00 | 3 | AAAU | 0.0228 | 0.0094 | 17.11
2020-06-10 00:00:00 | 4 | AAAU | 0.0091 | 0.014 | 17.35
2020-06-11 00:00:00 | 5 | AAAU | 0.016 | -0.0069 | 17.23
2020-06-05 00:00:00 | 1 | AACG | 0.3334 | -0.0001 | 0.86
2020-06-08 00:00:00 | 2 | AACG | 0.3064 | 0.0405 | 0.8947
2020-06-09 00:00:00 | 3 | AACG | 0.2868 | 0.0283 | 0.92
2020-06-10 00:00:00 | 4 | AACG | 0.2249 | 0.0868 | 0.9999
2020-06-11 00:00:00 | 5 | AACG | 0.1318 | 0.1201 | 1.12
2020-06-05 00:00:00 | 1 | AADR | 0.1243 | 0.0073 | 50.35
2020-06-08 00:00:00 | 2 | AADR | 0.1252 | -0.0011 | 50.3002
2020-06-09 00:00:00 | 3 | AADR | 0.118 | 0.0083 | 50.7159
2020-06-10 00:00:00 | 4 | AADR | 0.1071 | 0.0123 | 51.34
2020-06-11 00:00:00 | 5 | AADR | 0.143 | -0.0401 | 49.2803
2020-06-05 00:00:00 | 1 | AAL | 0.3899 | 0.1118 | 18.59
2020-06-08 00:00:00 | 2 | AAL | 0.3334 | 0.0925 | 20.31
2020-06-09 00:00:00 | 3 | AAL | 0.3912 | -0.0867 | 18.55
2020-06-10 00:00:00 | 4 | AAL | 0.4414 | -0.0825 | 17.02
2020-06-11 00:00:00 | 5 | AAL | 0.5281 | -0.1551 | 14.38
2020-06-05 00:00:00 | 1 | AAMC | 0.04 | 0.0283 | 18
2020-06-08 00:00:00 | 2 | AAMC | 0.362 | 0.0131 | 18.235
2020-06-09 00:00:00 | 3 | AAMC | 0.3355 | 0.0414 | 18.99
2020-06-10 00:00:00 | 4 | AAMC | 0.2824 | 0.08 | 20.51
2020-06-11 00:00:00 | 5 | AAMC | 0.472 | -0.2643 | 15.09
2020-06-05 00:00:00 | 1 | AAME | 0.0769 | -0.0055 | 1.8
2020-06-08 00:00:00 | 2 | AAME | 0.2912 | 0.0278 | 1.85
2020-06-09 00:00:00 | 3 | AAME | 0.272 | 0.027 | 1.9
2020-06-10 00:00:00 | 4 | AAME | 0.2644 | 0.0105 | 1.92
2020-06-11 00:00:00 | 5 | AAME | 0.2835 | -0.026 | 1.87
2020-06-05 00:00:00 | 1 | AAN | 0 | 0.044 | 45.57
2020-06-08 00:00:00 | 2 | AAN | 0.1583 | 0.0814 | 49.28
2020-06-09 00:00:00 | 3 | AAN | 0.1722 | -0.0164 | 48.47
2020-06-10 00:00:00 | 4 | AAN | 0.2207 | -0.0586 | 45.63
2020-06-11 00:00:00 | 5 | AAN | 0.283 | -0.08 | 41.98
2020-06-05 00:00:00 | 1 | AAOI | 0.2173 | 0.0173 | 9.98
2020-06-08 00:00:00 | 2 | AAOI | 0.1969 | 0.0261 | 10.24
2020-06-09 00:00:00 | 3 | AAOI | 0.2396 | -0.0532 | 9.695
2020-06-10 00:00:00 | 4 | AAOI | 0.2635 | -0.0315 | 9.39
2020-06-11 00:00:00 | 5 | AAOI | 0.3216 | -0.0788 | 8.65
2020-06-05 00:00:00 | 1 | AAON | 0 | 0.0414 | 58.37
2020-06-08 00:00:00 | 2 | AAON | 0.0328 | -0.0094 | 57.82
2020-06-09 00:00:00 | 3 | AAON | 0.0417 | -0.0092 | 57.29
2020-06-10 00:00:00 | 4 | AAON | 0.0574 | -0.0164 | 56.35
2020-06-11 00:00:00 | 5 | AAON | 0.132 | -0.0791 | 51.89
2020-06-05 00:00:00 | 1 | AAP | 0 | 0.0274 | 146.1
2020-06-08 00:00:00 | 2 | AAP | 0 | 0.0017 | 146.35
2020-06-09 00:00:00 | 3 | AAP | 0.0146 | -0.0146 | 144.21
2020-06-10 00:00:00 | 4 | AAP | 0.0408 | -0.0266 | 140.38
2020-06-11 00:00:00 | 5 | AAP | 0.0903 | -0.05 | 133.13
2020-06-05 00:00:00 | 1 | AAPL | 0 | 0.0285 | 331.5
2020-06-08 00:00:00 | 2 | AAPL | 0 | 0.0059 | 333.46
2020-06-09 00:00:00 | 3 | AAPL | 0 | 0.0316 | 343.99
2020-06-10 00:00:00 | 4 | AAPL | 0 | 0.0257 | 352.84
2020-06-11 00:00:00 | 5 | AAPL | 0.048 | -0.048 | 335.9
2020-06-05 00:00:00 | 1 | AAT | 0.2966 | 0.0553 | 32.83
2020-06-08 00:00:00 | 2 | AAT | 0.2533 | 0.0615 | 34.85
2020-06-09 00:00:00 | 3 | AAT | 0.2867 | -0.0448 | 33.29
2020-06-10 00:00:00 | 4 | AAT | 0.3381 | -0.0665 | 30.89
2020-06-11 00:00:00 | 5 | AAT | 0.3947 | -0.0855 | 28.25
2020-06-05 00:00:00 | 1 | AAU | 0.0204 | 0.0213 | 0.48
2020-06-08 00:00:00 | 2 | AAU | 0 | 0.0208 | 0.49
2020-06-09 00:00:00 | 3 | AAU | 0 | 0.0592 | 0.519
2020-06-10 00:00:00 | 4 | AAU | 0 | 0.0875 | 0.5644
2020-06-11 00:00:00 | 5 | AAU | 0.1409 | -0.1409 | 0.4849