Case #8

Calculating a rolling correlation

Objective

Calculating a 5 years rolling correlation

Adding a pane to the chart

Inverting the y-axis

Solution

If you get stuck, use the worksheet to see what to do next.

If you need more detailed help, have a look at the learning resources below.

The Macrobond document is also available for download here.

Worksheet

Learning resources for this case

Rate of change analysis

Smoothing analysis

Covariation analysis

Graph layout

Adding an alternate scale to charts

Adding Annotations to a Chart 

Working with panes