Months’ mean

Overview Macrobond has easy-to-use tools for calculating rolling mean, but what to do when you want to calculate mean from all Januaries, Februaries, etc.? See below for a solution. Example Months’ mean for 10 years There are a few ways to calculate months’ mean – in this file you can compare them. File presents method … Continue reading “Months’ mean”

Cross section

Overview Settings Include only observations where there are values for all series Do not include series used in calculations in the output Include new series automatically Calculations Examples Overview Example of general use of Cross section analysis showing adding up multiple series: The Cross section analysis produces output series by performing a calculation across a … Continue reading “Cross section”

How to add/sum up series?

If you want to sum values across few series, there are two main ways to achieve this: 1. Formula language You can sum multiple series by typing a simple expression with the ‘+’ sign. It will add up only common part for all series. 2. Cross Section analysis Use the Cross section analysis to calculate … Continue reading “How to add/sum up series?”