Spreadsheet: 804408d1668068502-correl-if-and-functions-not-working-together-nasdaq-global-smart-airlines-index-
Sheet: AEROFLOT

Date | Open | For correlation | >15/07/2021 <11/01/2022 | >04/01/2022 <11/01/2022 | >12/01/2022 <20/01/2022 | >17/02/2022 <24/02/2022 | >24/03/2022 <30/03/2022 | >17/02/2022 <16/08/2022
2021-07-15 00:00:00 | 67.76 | 786.87
2021-07-16 00:00:00 | 66.78 | 783.51
2021-07-19 00:00:00 | 66.7 | 772.19
2021-07-20 00:00:00 | 67.68 | 743.53
2021-07-21 00:00:00 | 67.8 | 774.15
2021-07-22 00:00:00 | 67.22 | 796.14
2021-07-23 00:00:00 | 66.94 | 787.6
2021-07-26 00:00:00 | 66.4 | 789.76
2021-07-27 00:00:00 | 66.1 | 799.21
2021-07-28 00:00:00 | 67.44 | 796.76
2021-07-29 00:00:00 | 67.24 | 807.2
2021-07-30 00:00:00 | 67.16 | 805.46
2021-08-02 00:00:00 | 66.78 | 794.77
2021-08-03 00:00:00 | 67.24 | 794.13
2021-08-04 00:00:00 | 66.78 | 795.14
2021-08-05 00:00:00 | 67.32 | 778.8
2021-08-06 00:00:00 | 66.86 | 796.97
2021-08-09 00:00:00 | 66.9 | 798.06
2021-08-10 00:00:00 | 67.04 | 790.34
2021-08-11 00:00:00 | 67.12 | 796.05
2021-08-12 00:00:00 | 67 | 803.6
2021-08-13 00:00:00 | 66.8 | 795.16
2021-08-16 00:00:00 | 66.92 | 787.83
2021-08-17 00:00:00 | 67 | 781.64
2021-08-18 00:00:00 | 67.92 | 772.08
2021-08-19 00:00:00 | 67.2 | 769.4
2021-08-20 00:00:00 | 67.14 | 752.91
2021-08-23 00:00:00 | 68.44 | 756.99
2021-08-24 00:00:00 | 68.28 | 771.24
2021-08-25 00:00:00 | 68.22 | 785.3
2021-08-26 00:00:00 | 68.06 | 790.2
2021-08-27 00:00:00 | 68.64 | 779.58
2021-08-30 00:00:00 | 69.28 | 790.26
2021-08-31 00:00:00 | 69.32 | 777.92
2021-09-01 00:00:00 | 69.48 | 782.9
2021-09-02 00:00:00 | 69.42 | 782.59
2021-09-03 00:00:00 | 69.4 | 785.06
2021-09-07 00:00:00 | 68.16 | 775.98
2021-09-08 00:00:00 | 67.44 | 769.68
2021-09-09 00:00:00 | 66.74 | 765.05
2021-09-10 00:00:00 | 66.98 | 772.41
2021-09-13 00:00:00 | 67.38 | 759.19
2021-09-14 00:00:00 | 66.98 | 767.67
2021-09-15 00:00:00 | 67.02 | 759.23
2021-09-16 00:00:00 | 66.64 | 761.49
2021-09-17 00:00:00 | 66.8 | 761.85
2021-09-20 00:00:00 | 66.16 | 760.02
2021-09-21 00:00:00 | 67.12 | 765.14
2021-09-22 00:00:00 | 67.28 | 761.78
2021-09-23 00:00:00 | 67.1 | 774.81
2021-09-24 00:00:00 | 69.1 | 788.5
2021-09-27 00:00:00 | 70.4 | 792.52
2021-09-28 00:00:00 | 69.12 | 803.7
2021-09-29 00:00:00 | 69.9 | 789.17
2021-09-30 00:00:00 | 69.96 | 789.64
2021-10-01 00:00:00 | 70 | 775.44
2021-10-04 00:00:00 | 69.22 | 798.43
2021-10-05 00:00:00 | 69.86 | 791.19
2021-10-06 00:00:00 | 70.64 | 790.29
2021-10-07 00:00:00 | 71.06 | 785.21
2021-10-08 00:00:00 | 70.98 | 787.45
2021-10-11 00:00:00 | 70.36 | 786.63
2021-10-12 00:00:00 | 70.7 | 780.99
2021-10-13 00:00:00 | 70.22 | 779.09
2021-10-14 00:00:00 | 70.08 | 773.43
2021-10-15 00:00:00 | 69.68 | 779.38
2021-10-18 00:00:00 | 69.76 | 783.18
2021-10-19 00:00:00 | 69.26 | 777.67
2021-10-20 00:00:00 | 68.58 | 775.05
2021-10-21 00:00:00 | 67.64 | 772.35
2021-10-22 00:00:00 | 67.9 | 772.61
2021-10-25 00:00:00 | 67.84 | 767.72
2021-10-26 00:00:00 | 67.52 | 762.57
2021-10-27 00:00:00 | 68.94 | 761.05
2021-10-28 00:00:00 | 68.18 | 755.42
2021-10-29 00:00:00 | 68.48 | 760.61
2021-11-01 00:00:00 | 67.98 | 761.42
2021-11-02 00:00:00 | 67.64 | 772.39
2021-11-03 00:00:00 | 67.92 | 773.31
2021-11-05 00:00:00 | 68.42 | 777.81
2021-11-08 00:00:00 | 68.8 | 813.76
2021-11-09 00:00:00 | 68.6 | 813.35
2021-11-10 00:00:00 | 67.84 | 813.33
2021-11-11 00:00:00 | 67.08 | 802.41
2021-11-12 00:00:00 | 65.98 | 795.98
2021-11-15 00:00:00 | 67.68 | 788.71
2021-11-16 00:00:00 | 67.1 | 794.47
2021-11-17 00:00:00 | 66.92 | 782.8
2021-11-18 00:00:00 | 67.14 | 778.36
2021-11-19 00:00:00 | 66.04 | 772.27
2021-11-22 00:00:00 | 65.2 | 754.31
2021-11-23 00:00:00 | 64.72 | 753.98
2021-11-24 00:00:00 | 64.22 | 754.09
2021-11-26 00:00:00 | 60.98 | 753.14
2021-11-29 00:00:00 | 61.1 | 707.47
2021-11-30 00:00:00 | 60.32 | 709.21
2021-12-01 00:00:00 | 62 | 696.55
2021-12-02 00:00:00 | 62.84 | 684.36
2021-12-03 00:00:00 | 62.26 | 708.58
2021-12-06 00:00:00 | 61.08 | 702.17
2021-12-07 00:00:00 | 62.4 | 726.52
2021-12-08 00:00:00 | 61.64 | 734.45
2021-12-09 00:00:00 | 61.04 | 743.13
2021-12-10 00:00:00 | 60.2 | 734.14
2021-12-13 00:00:00 | 60.02 | 731.49
2021-12-14 00:00:00 | 59.5 | 712.52
2021-12-15 00:00:00 | 59.36 | 708.16
2021-12-16 00:00:00 | 60.16 | 708.69
2021-12-17 00:00:00 | 60.04 | 703.43
2021-12-20 00:00:00 | 59.02 | 704.8
2021-12-21 00:00:00 | 59.68 | 696.56
2021-12-22 00:00:00 | 59.18 | 725.84
2021-12-23 00:00:00 | 59.2 | 733.35
2021-12-27 00:00:00 | 59.08 | 742.75
2021-12-28 00:00:00 | 58.92 | 744.56
2021-12-29 00:00:00 | 58.98 | 748.87
2021-12-30 00:00:00 | 59.16 | 745.17
2022-01-03 00:00:00 | 60.7 | 746.28
2022-01-04 00:00:00 | 63.3 | 758.34
2022-01-05 00:00:00 | 60.98 | 773.8
2022-01-06 00:00:00 | 62.96 | 765.06
2022-01-10 00:00:00 | 63.02 | 773.82
2022-01-11 00:00:00 | 63.2 | 769
2022-01-12 00:00:00 | 62.44 | 775.81
2022-01-13 00:00:00 | 60.16 | 774.94
2022-01-14 00:00:00 | 59.86 | 779.52
2022-01-18 00:00:00 | 55.46 | 779.39
2022-01-19 00:00:00 | 56.62 | 765.86
2022-01-20 00:00:00 | 57.2 | 757.96
2022-01-21 00:00:00 | 56.56 | 754.92
2022-01-24 00:00:00 | 52.22 | 739.02
2022-01-25 00:00:00 | 52.4 | 729.11
2022-01-26 00:00:00 | 52.64 | 728.65
2022-01-27 00:00:00 | 55.02 | 726.64
2022-01-28 00:00:00 | 55.54 | 713.56
2022-01-31 00:00:00 | 57.32 | 713.03
2022-02-01 00:00:00 | 57.12 | 729.74
2022-02-02 00:00:00 | 57.2 | 744.68
2022-02-03 00:00:00 | 55.7 | 745.24
2022-02-04 00:00:00 | 56.18 | 739.44
2022-02-07 00:00:00 | 56.18 | 737.42
2022-02-08 00:00:00 | 57.18 | 752.69
2022-02-09 00:00:00 | 59.2 | 766.98
2022-02-10 00:00:00 | 59.76 | 780.72
2022-02-11 00:00:00 | 58.3 | 780.08
2022-02-14 00:00:00 | 57.3 | 769.11
2022-02-15 00:00:00 | 59.42 | 759.51
2022-02-16 00:00:00 | 60.42 | 785.12
2022-02-17 00:00:00 | 58.08 | 791.3
2022-02-18 00:00:00 | 55.7 | 775.93
2022-02-22 00:00:00 | 49.52 | 762.44
2022-02-24 00:00:00 | 35.7 | 744.16
2022-02-25 00:00:00 | 36.74 | 743.58
2022-02-28 00:00:00 | 36.74 | 765.78
2022-03-24 00:00:00 | 30.7 | 742.07
2022-03-25 00:00:00 | 25.1 | 752
2022-03-28 00:00:00 | 25.86 | 759.51
2022-03-29 00:00:00 | 30.1 | 753.17
2022-03-30 00:00:00 | 37.54 | 774.77
2022-03-31 00:00:00 | 37.74 | 768.28
2022-04-01 00:00:00 | 38.8 | 760.42
2022-04-04 00:00:00 | 40.9 | 762.73
2022-04-05 00:00:00 | 37.76 | 760.02
2022-04-06 00:00:00 | 37.18 | 742.6
2022-04-07 00:00:00 | 37.58 | 727.74
2022-04-08 00:00:00 | 36.94 | 722.77
2022-04-11 00:00:00 | 35.46 | 714
2022-04-12 00:00:00 | 34.06 | 719.15
2022-04-13 00:00:00 | 33.86 | 719.86
2022-04-14 00:00:00 | 32.74 | 739.7
2022-04-18 00:00:00 | 31.32 | 743.88
2022-04-19 00:00:00 | 30.52 | 739.02
2022-04-20 00:00:00 | 32.5 | 751.8
2022-04-21 00:00:00 | 31.12 | 755.99
2022-04-22 00:00:00 | 30.62 | 757.21
2022-04-25 00:00:00 | 29.02 | 738.09
2022-04-26 00:00:00 | 30.18 | 732.42
2022-04-27 00:00:00 | 32.4 | 712.67
2022-04-28 00:00:00 | 30.8 | 711.99
2022-04-29 00:00:00 | 31.14 | 725.75
2022-05-04 00:00:00 | 31.2 | 716.84
2022-05-05 00:00:00 | 30.7 | 725.97
2022-05-06 00:00:00 | 30.1 | 704
2022-05-11 00:00:00 | 29.92 | 660.38
2022-05-12 00:00:00 | 29.32 | 654.39
2022-05-13 00:00:00 | 29.26 | 645.09
2022-05-16 00:00:00 | 29.52 | 662.72
2022-05-17 00:00:00 | 30.36 | 658.66
2022-05-18 00:00:00 | 30.06 | 683.3
2022-05-19 00:00:00 | 29.56 | 667.4
2022-05-20 00:00:00 | 29.32 | 663.89
2022-05-23 00:00:00 | 28.4 | 660.62
2022-05-24 00:00:00 | 28.6 | 671.23
2022-05-25 00:00:00 | 28.5 | 656.37
2022-05-26 00:00:00 | 29.4 | 668.17
2022-05-27 00:00:00 | 28.54 | 689.6
2022-05-30 00:00:00 | 28.58 | 708.02
2022-05-31 00:00:00 | 28 | 707.75
2022-06-01 00:00:00 | 27.94 | 697.81
2022-06-02 00:00:00 | 26.98 | 688.38
2022-06-03 00:00:00 | 26.74 | 702.37
2022-06-06 00:00:00 | 25.92 | 695.15
2022-06-07 00:00:00 | 27.2 | 702.83
2022-06-08 00:00:00 | 27.14 | 710.79
2022-06-09 00:00:00 | 26.36 | 694.97
2022-06-10 00:00:00 | 26.3 | 674.64
2022-06-14 00:00:00 | 25.96 | 610.71
2022-06-15 00:00:00 | 25.94 | 605.06
2022-06-16 00:00:00 | 26.86 | 615.45
2022-06-17 00:00:00 | 27.52 | 586.24
2022-06-20 00:00:00 | 28.14 | 598.04
2022-06-21 00:00:00 | 26.88 | 605.18
2022-06-22 00:00:00 | 26.76 | 604.84
2022-06-23 00:00:00 | 26.92 | 602.65
2022-06-24 00:00:00 | 26.82 | 593.55
2022-06-27 00:00:00 | 27.9 | 614.61
2022-06-28 00:00:00 | 28.78 | 610.79
2022-06-29 00:00:00 | 27.8 | 608.08
2022-06-30 00:00:00 | 26.68 | 596.94
2022-07-01 00:00:00 | 26.74 | 596.45
2022-07-05 00:00:00 | 28.26 | 603.13
2022-07-06 00:00:00 | 27.34 | 589.7
2022-07-07 00:00:00 | 27.78 | 590.03
2022-07-08 00:00:00 | 27.6 | 600.39
2022-07-11 00:00:00 | 27.7 | 602.15
2022-07-12 00:00:00 | 27.3 | 591.07
2022-07-13 00:00:00 | 26.68 | 608.63
2022-07-14 00:00:00 | 26.86 | 602.58
2022-07-15 00:00:00 | 27.06 | 597.18
2022-07-18 00:00:00 | 27.08 | 610.08
2022-07-19 00:00:00 | 26.68 | 613.23
2022-07-20 00:00:00 | 26.6 | 638.79
2022-07-21 00:00:00 | 27.58 | 642.49
2022-07-22 00:00:00 | 27.3 | 636.63
2022-07-25 00:00:00 | 27.82 | 631.23
2022-07-26 00:00:00 | 27.94 | 633.86
2022-07-27 00:00:00 | 27.76 | 624.61
2022-07-28 00:00:00 | 27.7 | 636.65
2022-07-29 00:00:00 | 27.7 | 641.81
2022-08-01 00:00:00 | 27.44 | 650.56
2022-08-02 00:00:00 | 26.92 | 655.26
2022-08-03 00:00:00 | 26.96 | 650.22
2022-08-04 00:00:00 | 26.62 | 659.46
2022-08-05 00:00:00 | 26.16 | 661.68
2022-08-08 00:00:00 | 26.84 | 657.38
2022-08-09 00:00:00 | 27 | 662.45
2022-08-10 00:00:00 | 27.06 | 658.43
2022-08-11 00:00:00 | 27 | 676.38
2022-08-12 00:00:00 | 27.14 | 678.6
2022-08-15 00:00:00 | 27.22 | 685.73
2022-08-16 00:00:00 | 27.08 | 691.78
2022-08-17 00:00:00 | 27.02 | 695.28
2022-08-18 00:00:00 | 27 | 682.39
2022-08-19 00:00:00 | 26.88 | 682.03
2022-08-22 00:00:00 | 27 | 665.15
2022-08-23 00:00:00 | 27.18 | 648.77
2022-08-24 00:00:00 | 27.4 | 650.74
2022-08-25 00:00:00 | 27.18 | 659.29
2022-08-26 00:00:00 | 28.24 | 674.39
2022-08-29 00:00:00 | 29.4 | 653.16
2022-08-30 00:00:00 | 28.74 | 651.73
2022-08-31 00:00:00 | 28.9 | 647.5
2022-09-01 00:00:00 | 28.84 | 634.48
2022-09-02 00:00:00 | 30.96 | 626.73
2022-09-06 00:00:00 | 30 | 624.46
2022-09-07 00:00:00 | 30.92 | 621.8
2022-09-08 00:00:00 | 30.48 | 637.85
2022-09-09 00:00:00 | 30.6 | 639.51
2022-09-12 00:00:00 | 30.66 | 649.77
2022-09-13 00:00:00 | 29.88 | 659.52
2022-09-14 00:00:00 | 29.38 | 632.36
2022-09-15 00:00:00 | 29.38 | 635.65
2022-09-16 00:00:00 | 29.18 | 632.92
2022-09-19 00:00:00 | 28.96 | 617.35
2022-09-20 00:00:00 | 27.46 | 628.76
2022-09-21 00:00:00 | 26.22 | 618.7
2022-09-22 00:00:00 | 26.86 | 606.36
2022-09-23 00:00:00 | 26.08 | 595.32
2022-09-26 00:00:00 | 22.64 | 577.07
2022-09-27 00:00:00 | 23.38 | 571.04
2022-09-28 00:00:00 | 23.36 | 568.82
2022-09-29 00:00:00 | 22.7 | 582.13
2022-09-30 00:00:00 | 23.14 | 569.47
2022-10-03 00:00:00 | 24.02 | 565.09
2022-10-04 00:00:00 | 23.36 | 578.15
2022-10-05 00:00:00 | 23.6 | 605.26
2022-10-06 00:00:00 | 23.36 | 600.49
2022-10-07 00:00:00 | 22.44 | 594.24