Commands
Any single command or stack of commands is specified in the command line panel and executed by pressing either the Ctrl+Enter keys together or the “green arrow” button in the upper left corner of that panel. Please note that the plug-in is not developed to check the sensibility of your computations. To yield sensible results, the chain-linked indices to be aggregated or disaggregated have to have the same reference period. In this sense, the reference period is defined as the period for which the series is based to an average of 100.
Each command described in this section is essentially a sequence of mandatory and optional arguments. To distinguish the two types of arguments, the latter are displayed in brackets. Comments can be added as entire lines by using the # symbol as the first character in the respective lines. However, please note that comments cannot be added after commands.
Chain linking: the CLI.CC command
The $\text{CLI.CC}$ command is used to aggregate and/or disaggregate two or more continuously chained indices. To this end, the following steps are carried out under the assumption that all continuously chained indices involved in the calculation have the same base and reference periods:
- Each index is unchained.
- A weighted sum/difference of the unchained time series is calculated, where the weight of each unchained series in period $t$ is given by the last value of the respective weighting series in period $t-1$.
- In cases where a subindex’s weight is changed to $0$ in period $t-1$, the subindex is unchanged and its value keeps the amount of period $t-1$.
- The resulting series is chained. To obtain a time series showing the long-term growth compared to the first observation, the aggregated growth factors are continuously multiplied. For the first period, a starting value of 100 is set.
- The aggregate is normalised to the desired reference period, so that the reference period equals 100.
The specification of the command is given by
\[\text{[Name=]CLI.CC,index1,[weight1,]}+/-\text{,index2,[weight2,]...,refperiod}\]with the following arguments:
| \(\text{Name}\) | Name of the continuously chained aggregate to be displayed in the Results panel. If not specified, it is set to Formula n, where n is the line of the command in the command line panel of the MyKIX document. |
| \(\text{index1}\) | First index from the Index Data panel to be used in the aggregation/disaggregation. |
| \(\text{weight1}\) | Weighting series from the Weight Data panel which corresponds to the first index \(index1\). If not specified, the weighting series with the same running number as the first index is taken automatically. |
| \(+/-\) | Operator used to indicate aggregation (\(+\)) or disaggregation (\(-\)). All operations are executed “from left to right”. |
| \(\text{index2}\) | Second index from the Index Data panel to be used in the aggregation/disaggregation. |
| \(\text{weight2}\) | Weighting series from the Weight Data panel which corresponds to the second index \(index2\). If not specified, the weighting series with the same running number as the second index is taken automatically. |
| \(\text{...}\) | Additional indices, corresponding weighting series and operators to be included in the aggregation/disaggregation. |
| \(\text{refperiod}\) | Depend on the period unit (monthly, quarterly, semi-annual or annual) the user has to choice the correct reference period of the continuously chained index (for example: the notation $\text{IV-2012}$ means the April of $2012$ for monthly time series; for quarterly time series it means the fourth quarter of $2012$). |
- A continuously chained aggregate of the index series $i1$ and $i2$, where $w1$ and $w2$ are used as respective weighting series from the Weight Data panel and with reference period fourth quarter of 2012, with the name Formula 1,
- A disaggregated continuously chained index with the name Formula 2 derived by subtracting the continuously chained index $i4$ from the continuously chained aggregate $i5$, using the weighting series $w4$ for index series $i4$ and $w5$ for the aggregate $i5$ and with reference period fourth quarter of 2012,
- A continuously chained aggregate with the name Formula 3, where the index series $i1$ and $i2$ are aggregated with the aid of the weighting series $w6$ and $w7$, and subtracting the component index series $i4$ using $w4$ as weighting series from the Weight Data panel, with reference period first quarter of 2015 and renamed by user's choice.
Contribution to growth: the CTG.CC command
The $\text{CTG.CC}$ command is used to compute the growth contribution of a continuously chained component to a continuously chained aggregate with the method of Rentzsch 2019. To this end, the following steps are carried out:
- The continuously chained component and the continuously chained aggregate are unchained.
- The period-on-period growth rates of the unchained components are weighted by their preceding periods’ weighting shares.
- The overall growth and partial growth rates are cumulated over all relevant periods.
The specification of the command is given by
\[\text{[Name=]CTG.CC,iContr,[wContr,]iTotal,[wTotal,]lags}\]with the following arguments:
| $\text{Name}$ | Name of the growth contribution to be displayed in the Results panel. If not specified, it is set to Formula n, where n is the line of the command in the command line panel of the MyKIX document. |
| $\text{iContr}$ | Continuously chained index from the Index Data panel, the growth contribution of which is to be computed. |
| $\text{wContr}$ | Weighting series from the Weight Data panel which corresponds to the chain-linked index $iContr$. If not specified, the weighting series with the same running number as the continuously chained index is taken automatically. |
| $\text{iTotal}$ | Continuously chained aggregate from the Index Data panel. |
| $\text{wTotal}$ | Weighting series from the Weight Data panel which corresponds to the continuously chained aggregate $iTotal$. If not specified, the weighting series with the same running number as the continuously chained aggregate is taken automatically. |
| $\text{lags}$ | Time span that the growth contribution is calculated for. The syntax does not depend on the periodicity of the data. For example, a lag of $1$ calculates the contribution to the period-on-period growth rate. To obtain the contribution to the year-on-year growth rate, the lag for monthly data must be set to $12$ and for quarterly data to $4$. Alternatively, $-1$ or $-2$ may be used for a lag of $1$ or $2$ years, respectively. |
Note that the $\text{CTG.CC}$ command always assumes an additive aggregation of the continuously chained components to the continuously chained aggregate.
- The contribution of the continuously chained component $i1$ to the growth rate of the continuously chained aggregate $i3$, compared to the previous quarter and named Formula 1, where $w1$ and $w3$ are used as respective weighting series from the Weight Data panel,
- The contribution of the continuously chained component $i3$ to the growth rate of the continuously chained aggregate $i5$, compared to the previous year (four periods) and named Formula 2, where $w3$ and $w5$ are used as weighting series from the Weight Data panel,
- The contribution of the continuously chained component $i2$ to the growth rate of the continuously chained aggregate $i3$, compared to the previous quarter and named Formula 3, where $w7$ and $w3$ are used as weighting series from the Weight Data panel and the result is renamed by user's choice.