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?”
Drag the analysis up or down. You can only move analyses within the same branch. This does not affect calculations but can help you reorganize your document. If you want to swap a higher analysis with a lower one (higher/lower in tree hierarchy), you can right-click on the analysis and click on ‘Move up’. Note … Continue reading “How to rearrange analyses in the Analysis tree?”
To delete a document, go to the upper menu, File and choose Open. Locate the document you would like to delete, select it and click the ‘Delete’ button at the top of the window. Note that the document will still be available in the Recently deleted folder in the account from where the document was … Continue reading “How to delete a document?”
Add or insert the Rebase analysis in the analysis tree. This is different from the Index builder analysis, which is used for portfolio construction as well as creating indices from weighted averages of several series. You’ll find more information on using the Rebase here: Rebase analysis How to create an index? Rebase in Slice analysis
You can only add two axes to a chart in Macrobond. To display series on a second y-axis, click on the corresponding series, and check box for the setting ‘Use alternate scale’ in Presentation properties. It is not possible to add third y-axis in Macrobond. For more information: Elements of the chart
Click on the Series list and select your desired currency from the Currency drop-down list. For more information: Currency conversion
Click on the y-axis and go to the Presentation properties tab. In the Axis panel, set ‘Synchronize’ to ‘Values’. To display two y-axes with different values, please see: How to display multiple y-axes? For more information: Elements of the chart
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?”
Click on the x-axis and open the Presentation properties tab at the top of the window. In the Labels group you can manipulate the scaling of the axis. The automatic setting will label the scale with the frequency that allows for the best view. Unchecking it will enable you to use the manual step option which … Continue reading “How to change how time range is displayed on the x-axis?”
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)?”