Using the Series list

As presented in the Overview video for this section, in every Macrobond document you build, the analyses and chart presentations you apply to the data are added to a tree schema - called the Analysis tree. What we are going to look at now is the first branch of the analysis tree, the Series list. Any changes you make to the series list will influence the analyses and presentations that follow.

NOTE:

If you are already familiar the features of the Series list and are interested in using a specific setting, select one of the how to guides from the links below.

The Series list is the first node of the Analysis tree, and opens to the right to show all the data. The purpose of the Series list is to prepare the series for further analysis and presentation by converting all series to a common calendar and filling in missing values. You can also convert series to a common currency, add forecasts, and set a data range.

Series name and description

Series added to a document are listed in the Series List, and are comprised of two components.

  • The series name provided in the Expression field e.g. eubank0133
  • The description e.g. Euro Area, ECB Consolidated Balance Sheet & Flows of MFI Sector, Eurosystem, Total Assets & Liabilities, All, EUR

The order of operations

When making modifications to the data in the series list, certain operations are necessarily prior to others. Please bear this in mind as it will affect any further changes that are made.

Whether you perform all, or only a few of the modifications available, you should proceed in the following order:

  1. Add forecasts to the relevant series in the list
  2. Select how missing values will be treated
  3. Select the currency conversion
  4. Select the frequency, and if necessary a method for frequency conversion
  5. Apply the data range, to limit all the time series to a specific range of time.
  6. Apply formulas to the various series in the list.

Series information

You can use the Series information tab to check metadata information for series you have selected in the series list. This is an easy way to check series metadata without having to leave the analysis tree.

Formula editor

Use the formula language to customize your calculations beyond the options available via the analysis tree.

Open the formula editor by clicking on the ‘fx’ button, to the right of the series name in the expression field. The name of the series in that field will automatically be added to the editor.

You'll find a selection of formulas in a list to the right of the editor.