Spreadsheet: 93131d1292626719-optimising-correlation-by-skewing-data-dummyworkbook3
Sheet: Sheet1

 |  | 1990-01-01 00:00:00 | 6.559 | 0.789 | 0.789 | 0.789 | 1 |  |  |  |  | OFFSET | 0
 |  | 1990-01-02 00:00:00 | 6.525 | 0.7865 | 0.7865 | 0.7865
 |  | 1990-01-03 00:00:00 | 6.473000000000001 | 0.7837 | 0.7837 | 0.7837 |  |  |  |  |  | STDEV xi (ascending) | 0.3258721561979135
 |  | 1990-01-04 00:00:00 | 6.49 | 0.7894 | 0.7894 | 0.7894 |  |  |  |  |  | STDEV yi (corresponding) | 0.0124107687692503
 |  | 1990-01-05 00:00:00 | 6.515000000000001 | 0.785 | 0.785 | 0.785 |  |  |  |  |  | COVARIANCE | 0.002464235382489033
 |  | 1990-01-08 00:00:00 | 6.507000000000001 | 0.7858 | 0.7858 | 0.7858 |  |  |  |  |  | STDEV PRODUCT | 0.00404432397890932
 |  | 1990-01-09 00:00:00 | 6.507000000000001 | 0.7874 | 0.7874 | 0.7874
 |  | 1990-01-10 00:00:00 | 6.524 | 0.7897 | 0.7897 | 0.7897 |  | 1 | $[NAME] |  |  | ρ | 0.6093071166750572
 |  | 1990-01-11 00:00:00 | 6.48 | 0.7929 | 0.7929 | 0.7929
 |  | 1990-01-12 00:00:00 | 6.462000000000001 | 0.7932 | 0.7932 | 0.7932 |  |  | 101 |  |  | CORREL: | 0.6140673285240811
 |  | 1990-01-15 00:00:00 | 6.453 | 0.7937 | 0.7937 | 0.7937
 |  | 1990-01-16 00:00:00 | 6.302 | 0.7925 | 0.7925 | 0.7925
 |  | 1990-01-17 00:00:00 | 6.346 | 0.795 | 0.795 | 0.795
 |  | 1990-01-18 00:00:00 | 6.168000000000001 | 0.7962 | 0.7962 | 0.7962
 |  | 1990-01-19 00:00:00 | 6.238 | 0.7946 | 0.7946 | 0.7946
 |  | 1990-01-22 00:00:00 | 6.264000000000001 | 0.796 | 0.796 | 0.796
 |  | 1990-01-23 00:00:00 | 6.165000000000001 | 0.7767 | 0.7767 | 0.7767
 |  | 1990-01-24 00:00:00 | 6.165000000000001 | 0.7658 | 0.7658 | 0.7658
 |  | 1990-01-25 00:00:00 | 6.154 | 0.7613 | 0.7613 | 0.7613
 |  | 1990-01-26 00:00:00 | 6.137 | 0.7712 | 0.7712 | 0.7712
 |  | 1990-01-29 00:00:00 | 6.076000000000001 | 0.764 | 0.764 | 0.764
 |  | 1990-01-30 00:00:00 | 6.120000000000001 | 0.768 | 0.768 | 0.768
 |  | 1990-01-31 00:00:00 | 5.546000000000001 | 0.7736 | 0.7736 | 0.7736
 |  | 1990-02-01 00:00:00 | 5.520000000000001 | 0.7731 | 0.7731 | 0.7731
 |  | 1990-02-02 00:00:00 | 5.459000000000001 | 0.776 | 0.776 | 0.776
 |  | 1990-02-05 00:00:00 | 5.441000000000001 | 0.7687 | 0.7687 | 0.7687
 |  | 1990-02-06 00:00:00 | 5.398000000000001 | 0.767 | 0.767 | 0.767
 |  | 1990-02-07 00:00:00 | 5.415000000000001 | 0.7592 | 0.7592 | 0.7592
 |  | 1990-02-08 00:00:00 | 5.485000000000001 | 0.756 | 0.756 | 0.756
 |  | 1990-02-09 00:00:00 | 5.582000000000001 | 0.7519 | 0.7519 | 0.7519
 |  | 1990-02-12 00:00:00 | 5.520000000000001 | 0.7532 | 0.7532 | 0.7532
 |  | 1990-02-13 00:00:00 | 5.608000000000001 | 0.7506 | 0.7506 | 0.7506
 |  | 1990-02-14 00:00:00 | 5.538 | 0.746 | 0.746 | 0.746
 |  | 1990-02-15 00:00:00 | 5.476000000000001 | 0.7526 | 0.7526 | 0.7526
 |  | 1990-02-16 00:00:00 | 5.476000000000001 | 0.7577 | 0.7577 | 0.7577
 |  | 1990-02-19 00:00:00 | 5.440000000000001 | 0.7615 | 0.7615 | 0.7615
 |  | 1990-02-20 00:00:00 | 5.307 | 0.7592 | 0.7592 | 0.7592
 |  | 1990-02-21 00:00:00 | 5.315000000000001 | 0.7685 | 0.7685 | 0.7685
 |  | 1990-02-22 00:00:00 | 5.369000000000002 | 0.764 | 0.764 | 0.764
 |  | 1990-02-23 00:00:00 | 5.387 | 0.768 | 0.768 | 0.768
 |  | 1990-02-26 00:00:00 | 5.438000000000001 | 0.7684 | 0.7684 | 0.7684
 |  | 1990-02-27 00:00:00 | 5.464 | 0.7575 | 0.7575 | 0.7575
 |  | 1990-02-28 00:00:00 | 5.878 | 0.7606 | 0.7606 | 0.7606
 |  | 1990-03-01 00:00:00 | 5.783000000000001 | 0.7655 | 0.7655 | 0.7655
 |  | 1990-03-02 00:00:00 | 5.819000000000001 | 0.7621 | 0.7621 | 0.7621
 |  | 1990-03-05 00:00:00 | 5.741000000000001 | 0.7607 | 0.7607 | 0.7607
 |  | 1990-03-06 00:00:00 | 5.785 | 0.7631 | 0.7631 | 0.7631
 |  | 1990-03-07 00:00:00 | 5.767000000000001 | 0.7623 | 0.7623 | 0.7623
 |  | 1990-03-08 00:00:00 | 5.715 | 0.763 | 0.763 | 0.763
 |  | 1990-03-09 00:00:00 | 5.610000000000001 | 0.761 | 0.761 | 0.761
 |  | 1990-03-12 00:00:00 | 5.610000000000001 | 0.7597 | 0.7597 | 0.7597
 |  | 1990-03-13 00:00:00 | 5.556000000000001 | 0.7645 | 0.7645 | 0.7645
 |  | 1990-03-14 00:00:00 | 5.627000000000001 | 0.7642 | 0.7642 | 0.7642
 |  | 1990-03-15 00:00:00 | 5.592000000000001 | 0.7585 | 0.7585 | 0.7585
 |  | 1990-03-16 00:00:00 | 5.663 | 0.7545 | 0.7545 | 0.7545
 |  | 1990-03-19 00:00:00 | 5.627000000000001 | 0.7565 | 0.7565 | 0.7565
 |  | 1990-03-20 00:00:00 | 5.654 | 0.7583 | 0.7583 | 0.7583
 |  | 1990-03-21 00:00:00 | 5.601000000000001 | 0.754 | 0.754 | 0.754
 |  | 1990-03-22 00:00:00 | 5.690000000000001 | 0.7539 | 0.7539 | 0.7539
 |  | 1990-03-23 00:00:00 | 5.699000000000002 | 0.749 | 0.749 | 0.749
 |  | 1990-03-26 00:00:00 | 5.699000000000002 | 0.7473 | 0.7473 | 0.7473
 |  | 1990-03-27 00:00:00 | 5.672000000000001 | 0.7477 | 0.7477 | 0.7477
 |  | 1990-03-28 00:00:00 | 5.739000000000001 | 0.7483 | 0.7483 | 0.7483
 |  | 1990-03-29 00:00:00 | 5.669 | 0.754 | 0.754 | 0.754
 |  | 1990-03-30 00:00:00 | 5.528 | 0.7555 | 0.7555 | 0.7555
 |  | 1990-04-02 00:00:00 | 5.546000000000001 | 0.7611 | 0.7611 | 0.7611
 |  | 1990-04-03 00:00:00 | 5.554 | 0.7625 | 0.7625 | 0.7625
 |  | 1990-04-04 00:00:00 | 5.633000000000001 | 0.768 | 0.768 | 0.768
 |  | 1990-04-05 00:00:00 | 5.607000000000001 | 0.7667 | 0.7667 | 0.7667
 |  | 1990-04-06 00:00:00 | 5.643000000000001 | 0.7656 | 0.7656 | 0.7656
 |  | 1990-04-09 00:00:00 | 5.617000000000001 | 0.7634 | 0.7634 | 0.7634
 |  | 1990-04-10 00:00:00 | 5.599 | 0.7665 | 0.7665 | 0.7665
 |  | 1990-04-11 00:00:00 | 5.617000000000001 | 0.7665 | 0.7665 | 0.7665
 |  | 1990-04-12 00:00:00 | 5.583 | 0.7687 | 0.7687 | 0.7687
 |  | 1990-04-13 00:00:00 | 5.6 | 0.7657 | 0.7657 | 0.7657
 |  | 1990-04-16 00:00:00 | 5.574 | 0.765 | 0.765 | 0.765
 |  | 1990-04-17 00:00:00 | 5.476000000000001 | 0.7673 | 0.7673 | 0.7673
 |  | 1990-04-18 00:00:00 | 5.369 | 0.7705 | 0.7705 | 0.7705
 |  | 1990-04-19 00:00:00 | 5.369 | 0.7735 | 0.7735 | 0.7735
 |  | 1990-04-20 00:00:00 | 5.342000000000001 | 0.7725 | 0.7725 | 0.7725
 |  | 1990-04-23 00:00:00 | 5.297000000000001 | 0.7653 | 0.7653 | 0.7653
 |  | 1990-04-24 00:00:00 | 5.252000000000001 | 0.7684 | 0.7684 | 0.7684
 |  | 1990-04-25 00:00:00 | 5.197000000000001 | 0.7681 | 0.7681 | 0.7681
 |  | 1990-04-26 00:00:00 | 5.118 | 0.7553 | 0.7553 | 0.7553
 |  | 1990-04-27 00:00:00 | 5.206000000000001 | 0.753 | 0.753 | 0.753
 |  | 1990-04-30 00:00:00 | 5.506 | 0.7533 | 0.7533 | 0.7533
 |  | 1990-05-01 00:00:00 | 5.436 | 0.7465 | 0.7465 | 0.7465
 |  | 1990-05-02 00:00:00 | 5.436 | 0.7542 | 0.7542 | 0.7542
 |  | 1990-05-03 00:00:00 | 5.506 | 0.7572 | 0.7572 | 0.7572
 |  | 1990-05-04 00:00:00 | 5.744 | 0.7573 | 0.7573 | 0.7573
 |  | 1990-05-07 00:00:00 | 5.734999999999999 | 0.7571 | 0.7571 | 0.7571
 |  | 1990-05-08 00:00:00 | 5.753 | 0.7592 | 0.7592 | 0.7592
 |  | 1990-05-09 00:00:00 | 5.735999999999999 | 0.7576 | 0.7576 | 0.7576
 |  | 1990-05-10 00:00:00 | 5.780999999999999 | 0.761 | 0.761 | 0.761
 |  | 1990-05-11 00:00:00 | 5.923 | 0.7618 | 0.7618 | 0.7618
 |  | 1990-05-14 00:00:00 | 5.949999999999999 | 0.7685 | 0.7685 | 0.7685
 |  | 1990-05-15 00:00:00 | 5.933 | 0.766 | 0.766 | 0.766
 |  | 1990-05-16 00:00:00 | 5.933999999999999 | 0.764 | 0.764 | 0.764
 |  | 1990-05-17 00:00:00 | 5.917 | 0.764 | 0.764 | 0.764
 |  | 1990-05-18 00:00:00 | 5.847999999999999 | 0.7639 | 0.7639 | 0.7639
 |  | 1990-05-21 00:00:00 | 5.866 | 0.765 | 0.765 | 0.765
 |  | 1990-05-22 00:00:00 | 5.911 | 0.7675 | 0.7675 | 0.7675
 |  | 1990-05-23 00:00:00 | 5.974 | 0.765 | 0.765 | 0.765
 |  | 1990-05-24 00:00:00 | 5.940999999999999 | 0.7634 | 0.7634 | 0.7634
 |  | 1990-05-25 00:00:00 | 5.923999999999999 | 0.769 | 0.769 | 0.769
 |  | 1990-05-28 00:00:00 | 5.907 | 0.769 | 0.769 | 0.769
 |  | 1990-05-29 00:00:00 | 5.959 | 0.7676 | 0.7676 | 0.7676
 |  | 1990-05-30 00:00:00 | 5.984999999999999 | 0.7735 | 0.7735 | 0.7735
 |  | 1990-05-31 00:00:00 | 5.618 | 0.7688 | 0.7688 | 0.7688
 |  | 1990-06-01 00:00:00 | 5.775 | 0.77 | 0.77 | 0.77
 |  | 1990-06-04 00:00:00 | 5.801 | 0.7698 | 0.7698 | 0.7698
 |  | 1990-06-05 00:00:00 | 5.776 | 0.7726 | 0.7726 | 0.7726
 |  | 1990-06-06 00:00:00 | 5.767999999999999 | 0.7738 | 0.7738 | 0.7738
 |  | 1990-06-07 00:00:00 | 5.786 | 0.7791 | 0.7791 | 0.7791
 |  | 1990-06-08 00:00:00 | 5.769 | 0.7725 | 0.7725 | 0.7725
 |  | 1990-06-11 00:00:00 | 5.751999999999999 | 0.7705 | 0.7705 | 0.7705
 |  | 1990-06-12 00:00:00 | 5.734999999999999 | 0.7735 | 0.7735 | 0.7735
 |  | 1990-06-13 00:00:00 | 5.85 | 0.7735 | 0.7735 | 0.7735
 |  | 1990-06-14 00:00:00 | 5.876999999999999 | 0.7755 | 0.7755 | 0.7755
 |  | 1990-06-15 00:00:00 | 5.780999999999999 | 0.7776 | 0.7776 | 0.7776
 |  | 1990-06-18 00:00:00 | 5.738 | 0.7807 | 0.7807 | 0.7807
 |  | 1990-06-19 00:00:00 | 5.719999999999999 | 0.7853 | 0.7853 | 0.7853
 |  | 1990-06-20 00:00:00 | 5.693999999999999 | 0.7848 | 0.7848 | 0.7848
 |  | 1990-06-21 00:00:00 | 5.721 | 0.791 | 0.791 | 0.791
 |  | 1990-06-22 00:00:00 | 5.74 | 0.788 | 0.788 | 0.788
 |  | 1990-06-25 00:00:00 | 5.651 | 0.784 | 0.784 | 0.784
 |  | 1990-06-26 00:00:00 | 5.686999999999999 | 0.7874 | 0.7874 | 0.7874
 |  | 1990-06-27 00:00:00 | 5.741999999999999 | 0.7875 | 0.7875 | 0.7875
 |  | 1990-06-28 00:00:00 | 5.82 | 0.7879 | 0.7879 | 0.7879