Overview Creating list Moving list to an account Working with lists Single list Combining lists My lists tab Missing input Types of lists List of regions Child list List by region Child list Concept for Region and child list Plain list Child list Overview This is a great way to organize large sets of series. … Continue reading “Lists of series”
This feature requires Macrobond Data+ license. Overview Series with and without vintage data Viewing available revision history What does Start column mean? Set Vintage request for all series in document How to set time in Vintage field? Set Vintage request for one series Formula editor hints How to add vintage time series from data-tree? How to set … Continue reading “Vintage data (Revision history)”
Overview After which analyses I can use Transpose? How to use it? Examples Overview Example of general use of Transpose analysis showing how to swap the axes of Category chart: This analysis changes position of data – data from x-axis will be shown on y-axis and vice versa. You do not need to re-arrange series … Continue reading “Transpose”
Purpose How to create and save your own formula? Create new formula Simple example Advance example Incorrect formula Description Finding and applying saved formula How to copy user defined formula to other accounts? Examples Purpose Not everything can be pre-programmed in Macrobond formula language but from these blocks you can build exactly what you need. … Continue reading “User defined formulas (User defined functions)”
Overview Important information How calculation works? Series names Numerical constants Arithmetic operations Functions Observation windows (rolling) Observation numbers Logical values and functions Operators The formula editor User defined functions Overview The purpose of the Macrobond formula language is to make calculations on series. The series are typically time series, and the result of a formula … Continue reading “The Macrobond formula language”
Overview Why use Formulas? How to work with Formula analysis? Aliases Expression Case sensitivity Include input series as output Applying formulas: Series list vs. Formula analysis How to create a formula in the Series list? How to create a formula in the analysis tree? Frequency How does the Formula language work? Input variables Dates Window … Continue reading “Introduction to Formula”
Overview Estimation model Working with Rolling regression analysis Settings How to create simple rolling regression model? Common errors Forecast Report How to output indicators? Calculating regression with formulas Examples Questions Why rolling regression’s average residual is not zero? Why model’s values are different than the ones coming from a same model but rolling? Overview Example … Continue reading “Rolling regression”
Overview Estimation model Working with Regression analysis Settings How to create simple regression model? How to add best fit line through different series’ last values? Common errors Too few time series in graph Degree of freedom is too low Forecast How it works? Dynamic forecast Report Overview How to output coefficients? Errors Calculation range end … Continue reading “Regression”
Built-in formulas Extend() Extend with last value to the end of a period Extend with another value to a specified point in time Extend with last YoY percentage from same series ExtendLinear() vs LinearExtended() Extend trend from part of series Extend with value x observations from end of series Extend with x last values and … Continue reading “All about extending series”
How to: annualize a monthly P/P series with a formula? change the color of a series when it’s below / above 0 (or any other value)? create an if condition/statement? create a continuous growth rate? combine an if condition/statement with the logical operators and/or? disaggregate a series? make an index out of P/P series? replace … Continue reading “Calculations with formulas”