Spreadsheet: 691488d1597724984-return-value-if-two-or-three-matches-meet-the-criteria-example-datasheet
Sheet: EURUSD

 |  |  |  |  |  | EURUSD |  | TF: | 1 | min |  |  | 1m |  |  |  |  |  | 5m |  |  |  |  |  | 15m |  |  |  |  |  | 60m |  |  |  |  |  | 240m |  |  |  |  |  | 1m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240m
 |  |  |  |  |  | Date | Time | Open | High | Low | Close |  | 21 | 34 | 55 | 89 | 144 | 233 | 21 | 34 | 55 | 89 | 144 | 233 | 21 | 34 | 55 | 89 | 144 | 233 | 21 | 34 | 55 | 89 | 144 | 233 | 21 | 34 | 55 | 89 | 144 | 233 | maHLDiff | WZ Phase | WZ Top | WZ Bot | UB1 | UB2 | UB3 | UB4 | UB5 | UB6 | LB1 | LB2 | LB3 | LB4 | LB5 | LB6 | maHLDiff | WZ Phase | WZ Top | WZ Bot | UB1 | UB2 | UB3 | UB4 | UB5 | UB6 | LB1 | LB2 | LB3 | LB4 | LB5 | LB6 | maHLDiff | WZ Phase | WZ Top | WZ Bot | UB1 | UB2 | UB3 | UB4 | UB5 | UB6 | LB1 | LB2 | LB3 | LB4 | LB5 | LB6 | maHLDiff | WZ Phase | WZ Top | WZ Bot | UB1 | UB2 | UB3 | UB4 | UB5 | UB6 | LB1 | LB2 | LB3 | LB4 | LB5 | LB6 | maHLDiff | WZ Phase | WZ Top | WZ Bot | UB1 | UB2 | UB3 | UB4 | UB5 | UB6 | LB1 | LB2 | LB3 | LB4 | LB5 | LB6
2020-06-01 00:00:00 | 6/01/20  00:00 | 2020-06-01 00:00:00 | 2020.06.01 | 00:00:00 |  | 2020-06-01 00:00:00 | 00:00:00 | 1.11137 | 1.11165 | 1.11128 | 1.11165 | 1 |  |  |  |  |  |  | 1.10998095238095 | 1.10979735294117 | 1.10951163636363 | 1.11027168539325 | 1.11139930555555 | 1.1107057081545 | 1.10962523809523 | 1.11053705882353 | 1.11132672727272 | 1.11037707865168 | 1.10847034722222 | 1.10540622317596 | 1.11081095238095 | 1.10930588235294 | 1.105962 | 1.10262662921348 | 1.09799451388888 | 1.09624064377682 | 1.10371047619047 | 1.09883264705881 | 1.09727963636363 | 1.09168921348314 | 1.08981298611111 | 1.08883081545064 | 0 | 0 | 0.008 | -0.008 | 0.013 | 0.021 | 0.034 | 0.05500000000000001 | 0.08900000000000001 | 0.144 | -0.013 | -0.021 | -0.034 | -0.05500000000000001 | -0.08900000000000001 | -0.144 | 0.001887669191920072 | 1 | 1.12251163636363 | 1.09839930555555 | 1.13051163636363 | 1.14351163636363 | 1.16451163636363 | 1.19851163636363 | 1.25351163636363 | 1.34251163636363 | 1.09039930555555 | 1.07739930555555 | 1.05639930555555 | 1.02239930555555 | 0.9673993055555502 | 0.8783993055555502 | 0.005920504096760038 | 3 | 1.13940622317596 | 1.07732672727272 | 1.16040622317596 | 1.19440622317596 | 1.24940622317596 | 1.33840622317596 | 1.48240622317596 | 1.71540622317596 | 1.05632672727272 | 1.02232672727272 | 0.9673267272727201 | 0.8783267272727201 | 0.7343267272727201 | 0.5013267272727201 | 0.01457030860413 | 5 | 1.18524064377682 | 1.02181095238095 | 1.24024064377682 | 1.32924064377682 | 1.47324064377682 | 1.70624064377682 | 2.08324064377682 | 2.69324064377682 | 0.9668109523809499 | 0.87781095238095 | 0.73381095238095 | 0.50081095238095 | 0.12381095238095 | -0.48618904761905 | 0.01487966073982983 | 5 | 1.17783081545064 | 1.01471047619047 | 1.23283081545064 | 1.32183081545064 | 1.46583081545064 | 1.69883081545064 | 2.07583081545064 | 2.68583081545064 | 0.9597104761904699 | 0.8707104761904699 | 0.7267104761904699 | 0.4937104761904699 | 0.1167104761904699 | -0.4932895238095301
2020-06-01 00:01:00 | 6/01/20  00:01 | 2020-06-01 00:00:00 | 2020.06.01 | 00:01:00 |  | 2020-06-01 00:00:00 | 00:01:00 | 1.11148 | 1.11165 | 1.11139 | 1.11165 | 2 |  |  |  |  |  |  | 1.10998095238095 | 1.10979735294117 | 1.10951163636363 | 1.11027168539325 | 1.11139930555555 | 1.1107057081545 | 1.10962523809523 | 1.11053705882353 | 1.11132672727272 | 1.11037707865168 | 1.10847034722222 | 1.10540622317596 | 1.11081095238095 | 1.10930588235294 | 1.105962 | 1.10262662921348 | 1.09799451388888 | 1.09624064377682 | 1.10371047619047 | 1.09883264705881 | 1.09727963636363 | 1.09168921348314 | 1.08981298611111 | 1.08883081545064 | 0 | 0 | 0.008 | -0.008 | 0.013 | 0.021 | 0.034 | 0.05500000000000001 | 0.08900000000000001 | 0.144 | -0.013 | -0.021 | -0.034 | -0.05500000000000001 | -0.08900000000000001 | -0.144 | 0.001887669191920072 | 1 | 1.12251163636363 | 1.09839930555555 | 1.13051163636363 | 1.14351163636363 | 1.16451163636363 | 1.19851163636363 | 1.25351163636363 | 1.34251163636363 | 1.09039930555555 | 1.07739930555555 | 1.05639930555555 | 1.02239930555555 | 0.9673993055555502 | 0.8783993055555502 | 0.005920504096760038 | 3 | 1.13940622317596 | 1.07732672727272 | 1.16040622317596 | 1.19440622317596 | 1.24940622317596 | 1.33840622317596 | 1.48240622317596 | 1.71540622317596 | 1.05632672727272 | 1.02232672727272 | 0.9673267272727201 | 0.8783267272727201 | 0.7343267272727201 | 0.5013267272727201 | 0.01457030860413 | 5 | 1.18524064377682 | 1.02181095238095 | 1.24024064377682 | 1.32924064377682 | 1.47324064377682 | 1.70624064377682 | 2.08324064377682 | 2.69324064377682 | 0.9668109523809499 | 0.87781095238095 | 0.73381095238095 | 0.50081095238095 | 0.12381095238095 | -0.48618904761905 | 0.01487966073982983 | 5 | 1.17783081545064 | 1.01471047619047 | 1.23283081545064 | 1.32183081545064 | 1.46583081545064 | 1.69883081545064 | 2.07583081545064 | 2.68583081545064 | 0.9597104761904699 | 0.8707104761904699 | 0.7267104761904699 | 0.4937104761904699 | 0.1167104761904699 | -0.4932895238095301
2020-06-01 00:02:00 | 6/01/20  00:02 | 2020-06-01 00:00:00 | 2020.06.01 | 00:02:00 |  | 2020-06-01 00:00:00 | 00:02:00 | 1.11166 | 1.11167 | 1.11138 | 1.11138 | 3 |  |  |  |  |  |  | 1.10998095238095 | 1.10979735294117 | 1.10951163636363 | 1.11027168539325 | 1.11139930555555 | 1.1107057081545 | 1.10962523809523 | 1.11053705882353 | 1.11132672727272 | 1.11037707865168 | 1.10847034722222 | 1.10540622317596 | 1.11081095238095 | 1.10930588235294 | 1.105962 | 1.10262662921348 | 1.09799451388888 | 1.09624064377682 | 1.10371047619047 | 1.09883264705881 | 1.09727963636363 | 1.09168921348314 | 1.08981298611111 | 1.08883081545064 | 0 | 0 | 0.008 | -0.008 | 0.013 | 0.021 | 0.034 | 0.05500000000000001 | 0.08900000000000001 | 0.144 | -0.013 | -0.021 | -0.034 | -0.05500000000000001 | -0.08900000000000001 | -0.144 | 0.001887669191920072 | 1 | 1.12251163636363 | 1.09839930555555 | 1.13051163636363 | 1.14351163636363 | 1.16451163636363 | 1.19851163636363 | 1.25351163636363 | 1.34251163636363 | 1.09039930555555 | 1.07739930555555 | 1.05639930555555 | 1.02239930555555 | 0.9673993055555502 | 0.8783993055555502 | 0.005920504096760038 | 3 | 1.13940622317596 | 1.07732672727272 | 1.16040622317596 | 1.19440622317596 | 1.24940622317596 | 1.33840622317596 | 1.48240622317596 | 1.71540622317596 | 1.05632672727272 | 1.02232672727272 | 0.9673267272727201 | 0.8783267272727201 | 0.7343267272727201 | 0.5013267272727201 | 0.01457030860413 | 5 | 1.18524064377682 | 1.02181095238095 | 1.24024064377682 | 1.32924064377682 | 1.47324064377682 | 1.70624064377682 | 2.08324064377682 | 2.69324064377682 | 0.9668109523809499 | 0.87781095238095 | 0.73381095238095 | 0.50081095238095 | 0.12381095238095 | -0.48618904761905 | 0.01487966073982983 | 5 | 1.17783081545064 | 1.01471047619047 | 1.23283081545064 | 1.32183081545064 | 1.46583081545064 | 1.69883081545064 | 2.07583081545064 | 2.68583081545064 | 0.9597104761904699 | 0.8707104761904699 | 0.7267104761904699 | 0.4937104761904699 | 0.1167104761904699 | -0.4932895238095301
2020-06-01 00:03:00 | 6/01/20  00:03 | 2020-06-01 00:00:00 | 2020.06.01 | 00:03:00 |  | 2020-06-01 00:00:00 | 00:03:00 | 1.11165 | 1.11165 | 1.11144 | 1.11163 | 4 |  |  |  |  |  |  | 1.10998095238095 | 1.10979735294117 | 1.10951163636363 | 1.11027168539325 | 1.11139930555555 | 1.1107057081545 | 1.10962523809523 | 1.11053705882353 | 1.11132672727272 | 1.11037707865168 | 1.10847034722222 | 1.10540622317596 | 1.11081095238095 | 1.10930588235294 | 1.105962 | 1.10262662921348 | 1.09799451388888 | 1.09624064377682 | 1.10371047619047 | 1.09883264705881 | 1.09727963636363 | 1.09168921348314 | 1.08981298611111 | 1.08883081545064 | 0 | 0 | 0.008 | -0.008 | 0.013 | 0.021 | 0.034 | 0.05500000000000001 | 0.08900000000000001 | 0.144 | -0.013 | -0.021 | -0.034 | -0.05500000000000001 | -0.08900000000000001 | -0.144 | 0.001887669191920072 | 1 | 1.12251163636363 | 1.09839930555555 | 1.13051163636363 | 1.14351163636363 | 1.16451163636363 | 1.19851163636363 | 1.25351163636363 | 1.34251163636363 | 1.09039930555555 | 1.07739930555555 | 1.05639930555555 | 1.02239930555555 | 0.9673993055555502 | 0.8783993055555502 | 0.005920504096760038 | 3 | 1.13940622317596 | 1.07732672727272 | 1.16040622317596 | 1.19440622317596 | 1.24940622317596 | 1.33840622317596 | 1.48240622317596 | 1.71540622317596 | 1.05632672727272 | 1.02232672727272 | 0.9673267272727201 | 0.8783267272727201 | 0.7343267272727201 | 0.5013267272727201 | 0.01457030860413 | 5 | 1.18524064377682 | 1.02181095238095 | 1.24024064377682 | 1.32924064377682 | 1.47324064377682 | 1.70624064377682 | 2.08324064377682 | 2.69324064377682 | 0.9668109523809499 | 0.87781095238095 | 0.73381095238095 | 0.50081095238095 | 0.12381095238095 | -0.48618904761905 | 0.01487966073982983 | 5 | 1.17783081545064 | 1.01471047619047 | 1.23283081545064 | 1.32183081545064 | 1.46583081545064 | 1.69883081545064 | 2.07583081545064 | 2.68583081545064 | 0.9597104761904699 | 0.8707104761904699 | 0.7267104761904699 | 0.4937104761904699 | 0.1167104761904699 | -0.4932895238095301
2020-06-01 00:04:00 | 6/01/20  00:04 | 2020-06-01 00:00:00 | 2020.06.01 | 00:04:00 |  | 2020-06-01 00:00:00 | 00:04:00 | 1.1115 | 1.11165 | 1.11149 | 1.11165 | 5 |  |  |  |  |  |  | 1.10998095238095 | 1.10979735294117 | 1.10951163636363 | 1.11027168539325 | 1.11139930555555 | 1.1107057081545 | 1.10962523809523 | 1.11053705882353 | 1.11132672727272 | 1.11037707865168 | 1.10847034722222 | 1.10540622317596 | 1.11081095238095 | 1.10930588235294 | 1.105962 | 1.10262662921348 | 1.09799451388888 | 1.09624064377682 | 1.10371047619047 | 1.09883264705881 | 1.09727963636363 | 1.09168921348314 | 1.08981298611111 | 1.08883081545064 | 0 | 0 | 0.008 | -0.008 | 0.013 | 0.021 | 0.034 | 0.05500000000000001 | 0.08900000000000001 | 0.144 | -0.013 | -0.021 | -0.034 | -0.05500000000000001 | -0.08900000000000001 | -0.144 | 0.001887669191920072 | 1 | 1.12251163636363 | 1.09839930555555 | 1.13051163636363 | 1.14351163636363 | 1.16451163636363 | 1.19851163636363 | 1.25351163636363 | 1.34251163636363 | 1.09039930555555 | 1.07739930555555 | 1.05639930555555 | 1.02239930555555 | 0.9673993055555502 | 0.8783993055555502 | 0.005920504096760038 | 3 | 1.13940622317596 | 1.07732672727272 | 1.16040622317596 | 1.19440622317596 | 1.24940622317596 | 1.33840622317596 | 1.48240622317596 | 1.71540622317596 | 1.05632672727272 | 1.02232672727272 | 0.9673267272727201 | 0.8783267272727201 | 0.7343267272727201 | 0.5013267272727201 | 0.01457030860413 | 5 | 1.18524064377682 | 1.02181095238095 | 1.24024064377682 | 1.32924064377682 | 1.47324064377682 | 1.70624064377682 | 2.08324064377682 | 2.69324064377682 | 0.9668109523809499 | 0.87781095238095 | 0.73381095238095 | 0.50081095238095 | 0.12381095238095 | -0.48618904761905 | 0.01487966073982983 | 5 | 1.17783081545064 | 1.01471047619047 | 1.23283081545064 | 1.32183081545064 | 1.46583081545064 | 1.69883081545064 | 2.07583081545064 | 2.68583081545064 | 0.9597104761904699 | 0.8707104761904699 | 0.7267104761904699 | 0.4937104761904699 | 0.1167104761904699 | -0.4932895238095301
2020-06-01 00:05:00 | 6/01/20  00:05 | 2020-06-01 00:00:00 | 2020.06.01 | 00:05:00 |  | 2020-06-01 00:00:00 | 00:05:00 | 1.11163 | 1.11165 | 1.1115 | 1.11163 | 6 |  |  |  |  |  |  | 1.11007761904762 | 1.10986558823529 | 1.10956309090909 | 1.11026943820224 | 1.11139166666666 | 1.11072201716738 | 1.10962523809523 | 1.11053705882353 | 1.11132672727272 | 1.11037707865168 | 1.10847034722222 | 1.10540622317596 | 1.11081095238095 | 1.10930588235294 | 1.105962 | 1.10262662921348 | 1.09799451388888 | 1.09624064377682 | 1.10371047619047 | 1.09883264705881 | 1.09727963636363 | 1.09168921348314 | 1.08981298611111 | 1.08883081545064 | 0 | 0 | 0.008 | -0.008 | 0.013 | 0.021 | 0.034 | 0.05500000000000001 | 0.08900000000000001 | 0.144 | -0.013 | -0.021 | -0.034 | -0.05500000000000001 | -0.08900000000000001 | -0.144 | 0.001828575757569784 | 1 | 1.12256309090909 | 1.09839166666666 | 1.13056309090909 | 1.14356309090909 | 1.16456309090909 | 1.19856309090909 | 1.25356309090909 | 1.34256309090909 | 1.09039166666666 | 1.07739166666666 | 1.05639166666666 | 1.02239166666666 | 0.9673916666666601 | 0.8783916666666601 | 0.005920504096760038 | 3 | 1.13940622317596 | 1.07732672727272 | 1.16040622317596 | 1.19440622317596 | 1.24940622317596 | 1.33840622317596 | 1.48240622317596 | 1.71540622317596 | 1.05632672727272 | 1.02232672727272 | 0.9673267272727201 | 0.8783267272727201 | 0.7343267272727201 | 0.5013267272727201 | 0.01457030860413 | 5 | 1.18524064377682 | 1.02181095238095 | 1.24024064377682 | 1.32924064377682 | 1.47324064377682 | 1.70624064377682 | 2.08324064377682 | 2.69324064377682 | 0.9668109523809499 | 0.87781095238095 | 0.73381095238095 | 0.50081095238095 | 0.12381095238095 | -0.48618904761905 | 0.01487966073982983 | 5 | 1.17783081545064 | 1.01471047619047 | 1.23283081545064 | 1.32183081545064 | 1.46583081545064 | 1.69883081545064 | 2.07583081545064 | 2.68583081545064 | 0.9597104761904699 | 0.8707104761904699 | 0.7267104761904699 | 0.4937104761904699 | 0.1167104761904699 | -0.4932895238095301
2020-06-01 00:06:00 | 6/01/20  00:06 | 2020-06-01 00:00:00 | 2020.06.01 | 00:06:00 |  | 2020-06-01 00:00:00 | 00:06:00 | 1.11159 | 1.11165 | 1.11159 | 1.11159 | 7 |  |  |  |  |  |  | 1.11007761904762 | 1.10986558823529 | 1.10956309090909 | 1.11026943820224 | 1.11139166666666 | 1.11072201716738 | 1.10962523809523 | 1.11053705882353 | 1.11132672727272 | 1.11037707865168 | 1.10847034722222 | 1.10540622317596 | 1.11081095238095 | 1.10930588235294 | 1.105962 | 1.10262662921348 | 1.09799451388888 | 1.09624064377682 | 1.10371047619047 | 1.09883264705881 | 1.09727963636363 | 1.09168921348314 | 1.08981298611111 | 1.08883081545064 | 0 | 0 | 0.008 | -0.008 | 0.013 | 0.021 | 0.034 | 0.05500000000000001 | 0.08900000000000001 | 0.144 | -0.013 | -0.021 | -0.034 | -0.05500000000000001 | -0.08900000000000001 | -0.144 | 0.001828575757569784 | 1 | 1.12256309090909 | 1.09839166666666 | 1.13056309090909 | 1.14356309090909 | 1.16456309090909 | 1.19856309090909 | 1.25356309090909 | 1.34256309090909 | 1.09039166666666 | 1.07739166666666 | 1.05639166666666 | 1.02239166666666 | 0.9673916666666601 | 0.8783916666666601 | 0.005920504096760038 | 3 | 1.13940622317596 | 1.07732672727272 | 1.16040622317596 | 1.19440622317596 | 1.24940622317596 | 1.33840622317596 | 1.48240622317596 | 1.71540622317596 | 1.05632672727272 | 1.02232672727272 | 0.9673267272727201 | 0.8783267272727201 | 0.7343267272727201 | 0.5013267272727201 | 0.01457030860413 | 5 | 1.18524064377682 | 1.02181095238095 | 1.24024064377682 | 1.32924064377682 | 1.47324064377682 | 1.70624064377682 | 2.08324064377682 | 2.69324064377682 | 0.9668109523809499 | 0.87781095238095 | 0.73381095238095 | 0.50081095238095 | 0.12381095238095 | -0.48618904761905 | 0.01487966073982983 | 5 | 1.17783081545064 | 1.01471047619047 | 1.23283081545064 | 1.32183081545064 | 1.46583081545064 | 1.69883081545064 | 2.07583081545064 | 2.68583081545064 | 0.9597104761904699 | 0.8707104761904699 | 0.7267104761904699 | 0.4937104761904699 | 0.1167104761904699 | -0.4932895238095301
2020-06-01 00:07:00 | 6/01/20  00:07 | 2020-06-01 00:00:00 | 2020.06.01 | 00:07:00 |  | 2020-06-01 00:00:00 | 00:07:00 | 1.11157 | 1.1119 | 1.11157 | 1.11167 | 8 |  |  |  |  |  |  | 1.11007761904762 | 1.10986558823529 | 1.10956309090909 | 1.11026943820224 | 1.11139166666666 | 1.11072201716738 | 1.10962523809523 | 1.11053705882353 | 1.11132672727272 | 1.11037707865168 | 1.10847034722222 | 1.10540622317596 | 1.11081095238095 | 1.10930588235294 | 1.105962 | 1.10262662921348 | 1.09799451388888 | 1.09624064377682 | 1.10371047619047 | 1.09883264705881 | 1.09727963636363 | 1.09168921348314 | 1.08981298611111 | 1.08883081545064 | 0 | 0 | 0.008 | -0.008 | 0.013 | 0.021 | 0.034 | 0.05500000000000001 | 0.08900000000000001 | 0.144 | -0.013 | -0.021 | -0.034 | -0.05500000000000001 | -0.08900000000000001 | -0.144 | 0.001828575757569784 | 1 | 1.12256309090909 | 1.09839166666666 | 1.13056309090909 | 1.14356309090909 | 1.16456309090909 | 1.19856309090909 | 1.25356309090909 | 1.34256309090909 | 1.09039166666666 | 1.07739166666666 | 1.05639166666666 | 1.02239166666666 | 0.9673916666666601 | 0.8783916666666601 | 0.005920504096760038 | 3 | 1.13940622317596 | 1.07732672727272 | 1.16040622317596 | 1.19440622317596 | 1.24940622317596 | 1.33840622317596 | 1.48240622317596 | 1.71540622317596 | 1.05632672727272 | 1.02232672727272 | 0.9673267272727201 | 0.8783267272727201 | 0.7343267272727201 | 0.5013267272727201 | 0.01457030860413 | 5 | 1.18524064377682 | 1.02181095238095 | 1.24024064377682 | 1.32924064377682 | 1.47324064377682 | 1.70624064377682 | 2.08324064377682 | 2.69324064377682 | 0.9668109523809499 | 0.87781095238095 | 0.73381095238095 | 0.50081095238095 | 0.12381095238095 | -0.48618904761905 | 0.01487966073982983 | 5 | 1.17783081545064 | 1.01471047619047 | 1.23283081545064 | 1.32183081545064 | 1.46583081545064 | 1.69883081545064 | 2.07583081545064 | 2.68583081545064 | 0.9597104761904699 | 0.8707104761904699 | 0.7267104761904699 | 0.4937104761904699 | 0.1167104761904699 | -0.4932895238095301