Spreadsheet: monika_causholli__28233__BSCTMP Substitute Correlations
Sheet: Sheet3

Date | BSCTMP | SBSK | BSCTMP % chg | SBSK % chg |  |  | SBSK
1990-01-01 00:00:00 | 560 | 750 |  |  |  | correlation
1990-02-01 00:00:00 | 550 | 730
1990-03-01 00:00:00 | 540 | 710
1990-04-01 00:00:00 | 530 | 690
1990-05-01 00:00:00 | 520 | 670
1990-06-01 00:00:00 | 510 | 650 |  |  |  | Prices
1990-07-01 00:00:00 | 500 | 640 |  |  |  |  | BSCTMP
1990-08-01 00:00:00 | 490 | 630 |  |  |  |  | SBSK
1990-09-01 00:00:00 | 480 | 625
1990-10-01 00:00:00 | 470 | 620
1990-11-01 00:00:00 | 460 | 610 |  |  |  | 1 month lag
1990-12-01 00:00:00 | 450 | 600 |  |  |  | 2 month lag
1991-01-01 00:00:00 | 445 | 580 |  |  |  | 3 month lag
1991-02-01 00:00:00 | 440 | 560 |  |  |  | 4 month lag
1991-03-01 00:00:00 | 435 | 540 |  |  |  | 5 month lag
1991-04-01 00:00:00 | 430 | 520 |  |  |  | 6 month lag
1991-05-01 00:00:00 | 425 | 505
1991-06-01 00:00:00 | 420 | 490
1991-07-01 00:00:00 | 415 | 475 |  |  |  | 1 month lead
1991-08-01 00:00:00 | 410 | 460 |  |  |  | 2 month lead
1991-09-01 00:00:00 | 400 | 445 |  |  |  | 3 month lead
1991-10-01 00:00:00 | 390 | 430 |  |  |  | 4 month lead
1991-11-01 00:00:00 | 390 | 435 |  |  |  | 5 month lead
1991-12-01 00:00:00 | 395 | 445 |  |  |  | 6 month lead
1992-01-01 00:00:00 | 400 | 465
1992-02-01 00:00:00 | 405 | 480
1992-03-01 00:00:00 | 410 | 480
1992-04-01 00:00:00 | 415 | 510
1992-05-01 00:00:00 | 420 | 515
1992-06-01 00:00:00 | 425 | 520
1992-07-01 00:00:00 | 440 | 550
1992-08-01 00:00:00 | 435 | 545
1992-09-01 00:00:00 | 430 | 540
1992-10-01 00:00:00 | 420 | 525
1992-11-01 00:00:00 | 405 | 500
1992-12-01 00:00:00 | 385 | 465
1993-01-01 00:00:00 | 360 | 410
1993-02-01 00:00:00 | 330 | 380
1993-03-01 00:00:00 | 330 | 380
1993-04-01 00:00:00 | 330 | 390
1993-05-01 00:00:00 | 330 | 390
1993-06-01 00:00:00 | 330 | 390
1993-07-01 00:00:00 | 330 | 380
1993-08-01 00:00:00 | 330 | 370
1993-09-01 00:00:00 | 330 | 360
1993-10-01 00:00:00 | 320 | 350
1993-11-01 00:00:00 | 315 | 345
1993-12-01 00:00:00 | 315 | 365
1994-01-01 00:00:00 | 330 | 385
1994-02-01 00:00:00 | 340 | 400
1994-03-01 00:00:00 | 350 | 400
1994-04-01 00:00:00 | 400 | 445
1994-05-01 00:00:00 | 400 | 460
1994-06-01 00:00:00 | 460 | 520
1994-07-01 00:00:00 | 460 | 520
1994-08-01 00:00:00 | 530 | 590
1994-09-01 00:00:00 | 530 | 590
1994-10-01 00:00:00 | 600 | 660
1994-11-01 00:00:00 | 600 | 660
1994-12-01 00:00:00 | 600 | 660
1995-01-01 00:00:00 | 660 | 720
1995-02-01 00:00:00 | 660 | 720
1995-03-01 00:00:00 | 735 | 795
1995-04-01 00:00:00 | 735 | 795
1995-05-01 00:00:00 | 735 | 795
1995-06-01 00:00:00 | 820 | 880
1995-07-01 00:00:00 | 820 | 880
1995-08-01 00:00:00 | 820 | 880
1995-09-01 00:00:00 | 820 | 880
1995-10-01 00:00:00 | 810 | 880
1995-11-01 00:00:00 | 790 | 880
1995-12-01 00:00:00 | 750 | 860
1996-01-01 00:00:00 | 650 | 790
1996-02-01 00:00:00 | 460 | 590
1996-03-01 00:00:00 | 360 | 480
1996-04-01 00:00:00 | 330 | 420
1996-05-01 00:00:00 | 330 | 420
1996-06-01 00:00:00 | 375 | 470
1996-07-01 00:00:00 | 400 | 530
1996-08-01 00:00:00 | 410 | 530
1996-09-01 00:00:00 | 415 | 530
1996-10-01 00:00:00 | 405 | 530
1996-11-01 00:00:00 | 400 | 525
1996-12-01 00:00:00 | 390 | 520
1997-01-01 00:00:00 | 380 | 515
1997-02-01 00:00:00 | 370 | 500
1997-03-01 00:00:00 | 370 | 480
1997-04-01 00:00:00 | 370 | 470
1997-05-01 00:00:00 | 390 | 500
1997-06-01 00:00:00 | 415 | 520
1997-07-01 00:00:00 | 435 | 550
1997-08-01 00:00:00 | 450 | 560
1997-09-01 00:00:00 | 450 | 560
1997-10-01 00:00:00 | 450 | 560
1997-11-01 00:00:00 | 450 | 560
1997-12-01 00:00:00 | 440 | 540
1998-01-01 00:00:00 | 420 | 520
1998-02-01 00:00:00 | 410 | 510
1998-03-01 00:00:00 | 410 | 510
1998-04-01 00:00:00 | 410 | 510
1998-05-01 00:00:00 | 410 | 510
1998-06-01 00:00:00 | 410 | 530
1998-07-01 00:00:00 | 410 | 520
1998-08-01 00:00:00 | 400 | 495
1998-09-01 00:00:00 | 370 | 460
1998-10-01 00:00:00 | 350 | 450
1998-11-01 00:00:00 | 350 | 450
1998-12-01 00:00:00 | 350 | 450
1999-01-01 00:00:00 | 350 | 450
1999-02-01 00:00:00 | 350 | 450
1999-03-01 00:00:00 | 360 | 460
1999-04-01 00:00:00 | 390 | 465
1999-05-01 00:00:00 | 410 | 490
1999-06-01 00:00:00 | 420 | 510
1999-07-01 00:00:00 | 430 | 520
1999-08-01 00:00:00 | 430 | 520
1999-09-01 00:00:00 | 470 | 560
1999-10-01 00:00:00 | 470 | 560
1999-11-01 00:00:00 | 500 | 590
1999-12-01 00:00:00 | 500 | 590
2000-01-01 00:00:00 | 530 | 620
2000-02-01 00:00:00 | 530 | 620
2000-03-01 00:00:00 | 540 | 620
2000-04-01 00:00:00 | 580 | 660
2000-05-01 00:00:00 | 580 | 660
2000-06-01 00:00:00 | 580 | 660
2000-07-01 00:00:00 | 610 | 690
2000-08-01 00:00:00 | 610 | 690
2000-09-01 00:00:00 | 610 | 690
2000-10-01 00:00:00 | 610 | 690
2000-11-01 00:00:00 | 610 | 690
2000-12-01 00:00:00 | 600 | 680
2001-01-01 00:00:00 | 570 | 660
2001-02-01 00:00:00 | 530 | 630
2001-03-01 00:00:00 | 490 | 580
2001-04-01 00:00:00 | 450 | 530