Spreadsheet: 220881d1363290500-some-wrong-if-function-results-number-test-ss
Sheet: Trade Sheet

 |  |  |  |  |  |  |  | STOP |  |  |  |  |  |  |  |  |  |  | STOP
INCORRECT  ANSWERS  ARE  IN  YELLOW FILL |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0.1
 |  |  | SIG |  |  |  | SIG | SIG EXIT |  |  |  |  | SIG |  |  |  |  | SIG | SIG EXIT
 | DIR | ENTRY | EXIT | HIGH | LOW | MAE | EXIT | OR STOP |  |  | DIR | ENTRY | EXIT | HIGH | LOW | MAE |  | EXIT | OR STOP
 | L | 733 | 743 | 733.2 | 732.9 | -0.1000000000000227 | 10 | 10 |  |  | L | 105 | 115 | 106 | 104.99 | -0.01000000000000512 | -0.01000000000000512 | 10 | 10
 | L | 733 | 743 | 738.5 | 732.8 | -0.2000000000000455 | 10 | 10 |  |  | L | 105 | 115 | 106 | 104.98 | -0.01999999999999602 | -0.01999999999999602 | 10 | 10
 | L | 733 | 743 | 733.4 | 732.6999999999999 | -0.3000000000000682 | 10 | 10 |  |  | L | 105 | 115 | 106 | 104.97 | -0.03000000000000114 | -0.03000000000000114 | 10 | 10
 | L | 733 | 743 | 738.2 | 732.6 | -0.3999999999999773 | 10 | 10 |  |  | L | 105 | 115 | 106 | 104.96 | -0.03999999999999204 | -0.03999999999999204 | 10 | 10
 | L | 733 | 743 | 733.6 | 732.5 | -0.5 | 10 | 10 |  |  | L | 105 | 115 | 106 | 104.95 | -0.04999999999999716 | -0.04999999999999716 | 10 | 10
 | L | 733 | 743 | 736.5 | 732.4 | -0.6000000000000227 | 10 | 10 |  |  | L | 105 | 115 | 106 | 104.94 | -0.06000000000000227 | -0.06000000000000227 | 10 | 10
 | L | 733 | 743 | 733.8 | 732.3 | -0.7000000000000455 | 10 | 10 |  |  | L | 105 | 115 | 106 | 104.93 | -0.06999999999999318 | -0.06999999999999318 | 10 | 10
 | L | 733 | 743 | 734.6 | 732.1999999999999 | -0.8000000000000682 | 10 | 10 |  |  | L | 105 | 115 | 106 | 104.92 | -0.0799999999999983 | -0.0799999999999983 | 10 | 10
 | L | 733 | 743 | 734 | 732.1 | -0.8999999999999773 | 10 | 10 |  |  | L | 105 | 115 | 106 | 104.91 | -0.0899999999999892 | -0.0899999999999892 | 10 | 10
 | L | 733 | 743 | 734.1 | 732 | -1 | 10 | -1 |  |  | L | 105 | 115 | 106 | 104.9 | -0.09999999999999432 | -0.09999999999999432 | 10 | 10
 | L | 733 | 743 | 739.8 | 731.9 | -1.100000000000023 | 10 | -1 |  |  | L | 105 | 115 | 106 | 104.89 | -0.1099999999999994 | -0.1099999999999994 | 10 | -0.1
 | L | 733 | 743 | 734.7 | 731.8 | -1.200000000000045 | 10 | -1 |  |  | L | 105 | 115 | 106 | 104.88 | -0.1199999999999903 | -0.1199999999999903 | 10 | -0.1
 | L | 733 | 743 | 734.4 | 731.6999999999999 | -1.300000000000068 | 10 | -1 |  |  | L | 105 | 115 | 106 | 104.87 | -0.1299999999999955 | -0.1299999999999955 | 10 | -0.1
 | L | 733 | 743 | 734.5 | 731.6 | -1.399999999999977 | 10 | -1 |  |  | L | 105 | 115 | 106 | 104.86 | -0.1400000000000006 | -0.1400000000000006 | 10 | -0.1
 | L | 733 | 743 | 734.6 | 731.5 | -1.5 | 10 | -1 |  |  | L | 105 | 115 | 106 | 104.85 | -0.1499999999999915 | -0.1499999999999915 | 10 | -0.1
 | L | 733 | 743 | 734.7 | 731.4 | -1.600000000000023 | 10 | -1 |  |  | L | 105 | 115 | 106 | 104.84 | -0.1599999999999966 | -0.1599999999999966 | 10 | -0.1
 | L | 733 | 743 | 734.8 | 731.3 | -1.700000000000045 | 10 | -1 |  |  | L | 105 | 115 | 106 | 104.83 | -0.1700000000000017 | -0.1700000000000017 | 10 | -0.1
 | L | 733 | 743 | 734.9 | 731.1999999999999 | -1.800000000000068 | 10 | -1 |  |  | L | 105 | 115 | 106 | 104.82 | -0.1799999999999926 | -0.1799999999999926 | 10 | -0.1
 | L | 733 | 743 | 735 | 731.1 | -1.899999999999977 | 10 | -1 |  |  | L | 105 | 115 | 106 | 104.81 | -0.1899999999999977 | -0.1899999999999977 | 10 | -0.1
 | L | 733 | 743 | 735.1 | 731 | -2 | 10 | -1 |  |  | L | 105 | 115 | 106 | 104.8 | -0.2000000000000028 | -0.2000000000000028 | 10 | -0.1
 | If stop at J2 is set  to 1.4  or  1.9 |  |  |  |  |  |  |  |  |  | If stop at U2 is set  to .02  .04  .05  .07 thru .13  .15  .16  .18  .19
 | an incorrect choice is made in column I |  |  |  |  |  |  |  |  |  | an incorrect choice is made in column T
 |  |  |  |  |  |  |  | STOP |  |  |  |  |  |  |  |  |  |  | STOP
 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 0.1 | .
 |  |  | SIG |  |  |  | SIG | SIG EXIT |  |  |  |  | SIG |  |  |  |  | SIG | SIG EXIT
 | DIR | ENTRY | EXIT | HIGH | LOW | MAE | EXIT | OR STOP |  |  | DIR | ENTRY | EXIT | HIGH | LOW | MAE |  | EXIT | OR STOP
 | S | 743 | 733 | 743.1 | 732.2 | -0.1000000000000227 | 10 | 10 |  |  | S | 115 | 105 | 115.01 | 105.01 | -0.01000000000000512 | -0.01000000000000512 | 10 | 10
 | S | 743 | 733 | 743.2 | 735.4 | -0.2000000000000455 | 10 | 10 |  |  | S | 115 | 105 | 115.02 | 104.98 | -0.02000000000001023 | -0.02000000000001023 | 10 | 10
 | S | 743 | 733 | 743.3000000000001 | 732.2 | -0.3000000000000682 | 10 | 10 |  |  | S | 115 | 105 | 115.03 | 104.97 | -0.03000000000000114 | -0.03000000000000114 | 10 | 10
 | S | 743 | 733 | 743.4 | 733.2 | -0.3999999999999773 | 10 | 10 |  |  | S | 115 | 105 | 115.04 | 104.96 | -0.04000000000000625 | -0.04000000000000625 | 10 | 10
 | S | 743 | 733 | 743.5 | 732.2 | -0.5 | 10 | 10 |  |  | S | 115 | 105 | 115.05 | 104.95 | -0.05000000000001137 | -0.05000000000001137 | 10 | 10
 | S | 743 | 733 | 743.6 | 734.4 | -0.6000000000000227 | 10 | 10 |  |  | S | 115 | 105 | 115.06 | 104.94 | -0.06000000000000227 | -0.06000000000000227 | 10 | 10
 | S | 743 | 733 | 743.7 | 732.2 | -0.7000000000000455 | 10 | 10 |  |  | S | 115 | 105 | 115.07 | 104.93 | -0.07000000000000739 | -0.07000000000000739 | 10 | 10
 | S | 743 | 733 | 743.8000000000001 | 733.6 | -0.8000000000000682 | 10 | 10 |  |  | S | 115 | 105 | 115.08 | 104.92 | -0.0799999999999983 | -0.0799999999999983 | 10 | 10
 | S | 743 | 733 | 743.9 | 732.2 | -0.8999999999999773 | 10 | 10 |  |  | S | 115 | 105 | 115.09 | 104.91 | -0.09000000000000341 | -0.09000000000000341 | 10 | 10
 | S | 743 | 733 | 744 | 732.2 | -1 | 10 | -1 |  |  | S | 115 | 105 | 115.1 | 104.9 | -0.1000000000000085 | -0.1000000000000085 | 10 | -0.1
 | S | 743 | 733 | 744.1 | 737.7 | -1.100000000000023 | 10 | -1 |  |  | S | 115 | 105 | 115.11 | 104.89 | -0.1099999999999994 | -0.1099999999999994 | 10 | -0.1
 | S | 743 | 733 | 744.2 | 733 | -1.200000000000045 | 10 | -1 |  |  | S | 115 | 105 | 115.12 | 104.88 | -0.1200000000000045 | -0.1200000000000045 | 10 | -0.1
 | S | 743 | 733 | 744.3000000000001 | 732.2 | -1.300000000000068 | 10 | -1 |  |  | S | 115 | 105 | 115.13 | 104.87 | -0.1300000000000097 | -0.1300000000000097 | 10 | -0.1
 | S | 743 | 733 | 744.4 | 732.2 | -1.399999999999977 | 10 | -1 |  |  | S | 115 | 105 | 115.14 | 104.86 | -0.1400000000000006 | -0.1400000000000006 | 10 | -0.1
 | S | 743 | 733 | 744.5 | 732.2 | -1.5 | 10 | -1 |  |  | S | 115 | 105 | 115.15 | 104.85 | -0.1500000000000057 | -0.1500000000000057 | 10 | -0.1
 | S | 743 | 733 | 744.6 | 732.2 | -1.600000000000023 | 10 | -1 |  |  | S | 115 | 105 | 115.16 | 104.84 | -0.1600000000000108 | -0.1600000000000108 | 10 | -0.1
 | S | 743 | 733 | 744.7 | 732.2 | -1.700000000000045 | 10 | -1 |  |  | S | 115 | 105 | 115.17 | 104.83 | -0.1700000000000017 | -0.1700000000000017 | 10 | -0.1
 | S | 743 | 733 | 744.8000000000001 | 732.2 | -1.800000000000068 | 10 | -1 |  |  | S | 115 | 105 | 115.18 | 104.82 | -0.1800000000000068 | -0.1800000000000068 | 10 | -0.1
 | S | 743 | 733 | 744.9 | 732.2 | -1.899999999999977 | 10 | -1 |  |  | S | 115 | 105 | 115.19 | 104.81 | -0.1900000000000119 | -0.1900000000000119 | 10 | -0.1
 | S | 743 | 733 | 745 | 732.2 | -2 | 10 | -1 |  |  | S | 115 | 105 | 115.2 | 104.8 | -0.2000000000000028 | -0.2000000000000028 | 10 | -0.1
 | If stop at J31 is set  to   .4   .9     1.4   or  1.9 |  |  |  |  |  |  |  |  |  | If stop at U31 is set  to .08 or .11
 | an incorrect choice is made in column I |  |  |  |  |  |  |  |  |  | an incorrect choice is made in column T