From Macrobond formula language building blocks you can create more complicated formulas. They are called ‘user defined formulas’ and have a dot at the beginning. To see the elements of the formula select Edit from the main menu at the top of the application and click ‘User defined functions.’ In new window navigate to the … Continue reading “How formula with dot works?”
Analytics Series browser Series list Analysis tree Analyses Formula language Once you’ve found and selected the data to work with, the next step is doing something with it in the Analytics tab. This is where you’ll be executing calculations, linking your workflow with external resources or tools, and applying customizable chart styles and tables. Analytics … Continue reading “Analyzing data – overview”
Purpose How to create and save your own formula? Create new formula Simple example Advanced 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”
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”
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?”
You should refer to a date using the Date() formula. Date(year, month, day) It returns the observation number of the specified date. Make sure you input the components of the date in the right order. For example: Date(2017, 01, 01) For more information: Formula analysis