There are two main possibilities to aggregate series: 1. Aggregate analysis Specify the period over which you want to aggregate the series. You also have the option of making this a rolling sum. 2. Formulas AggregateSum(series) Sums up all values from the start of the series. AggregateSumAnnual(series) Sums up values of a series on a … Continue reading “How to aggregate a series?”
There are two main possibilities to calculate percentage changes: 1. The Rate of Change analysis Set the Method as ‘Change over period %’, and then choose the length. 2. Formula You can also calculate percentage change over period with the formula: cop(series, length) Examples for Y/Y, M/M and Q/Q changes, respectively: cop(segdp, YearsLength(1)) cop(segdp, MonthsLength(1)) … Continue reading “How to calculate percentage change (Y/Y, Q/Q, P/P, M/M)?”
There are two main possibilities to achieve this: 1. The Conversion settings tab in Series List You can set the ‘Missing Value Method’ as ‘Zero Value’. 2. Formula You can also use the formula: Null0(series) For more information: Formula analysis
To convert a ratio to a percentage, you need to multiply the ratio by 100. There are two main possibilities to achieve this: 1. The Arithmetic analysis Set the 2nd operation field to ‘Multiply’ and ‘Value operand’ to 100: 2. Formula You can also use the formula language, by appending ‘*100’ at the end of … Continue reading “How to turn series into percentage?”
Some formulas require you to define a window length. Let’s take as example the formula for a rolling mean: Mean(series, window) For the window length you should input the number of observations over which the function will be calculated. The number of observations is based on the frequency of the document. Instead of typing a … Continue reading “How to specify window length in formula language?”
To reverse the sign of a series, use the following expression in the Series list: -series To invert a series, use this expression in Series list: 1/series For example: 1/eur
Mathematical functions Statistical functions Date and observation number functions Series operations Logical functions Financial Here you can find the details regarding the Macrobond formula language. In the function descriptions below, the following convention has been used when naming parameters: value The parameter can be either a number or a series. The type of the result … Continue reading “Built-in formula functions”