Exercise #3

Disaggregating a series


In this exercise, we’ll use a formula to disaggregate a series. Normally, you can do this with a simple rate of change, but sometimes you’ll want to use a formula to specify some additional conditions.

In this case, we want to disaggregate the series cntrad1290 (China Current Prices, Total, Aggregate, CNY). This is Chinese data that is aggregated on a yearly basis and does not have values for January. Therefore, we’ll need to disaggregate only the values from March to December and split the February value between January and February.

Step 1 (expandable paragraph)

Step 2 (expandable paragraph)

Step 3 (expandable paragraph)

Step 4 (expandable paragraph)

Summary (expandable paragraph)

To the see exact construction of the document, you can download the file here.

To learn more about Formulas in Macrobond have a look at these articles: Formula.