How are exchange rates determined? Relevant parameters How it’s converted? Which series was used in conversion? Currency conversion methods What’s behind ‘Automatic’ method? What’s behind ‘Legacy’ method? Applying currency conversion to a single series (manual conversion) Convert series from Local currency to USD or EUR Convert series from USD or EUR to Local currency Convert … Continue reading “Currency conversion”
Overview Using Open documents tab Using Documents tab Switching between directories Preview document Copy path Open containing folder Overview To improve workflow, we introduced new tabs in one of the Analytics tab activity’s segments: Open documents – a vertical view of all open documents, including a thumbnail. Documents – alternative way to open documents instead … Continue reading “Working with documents”
Overview Settings General Select method for creating matrix Select series Output PCA elements Eigenvectors/Matrix Eigenvalues/Category chart & table Principal components/Time chart & table Example Questions I have checked ‘Use correlation (normalize input)’ – is it possible to show this normalized series? I have five different sets of data, but the matrix tab only shows the … Continue reading “Principal components analysis”
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”
Overview Working with Cross sampling analysis Input – Lists Settings Calculations Settings for calculation methods Relative dates Point in time Time intervals Output mode Organizing output Groups Individual series Order Missing input Replacing individual series How to create chart with Cross sampling and Lists? How to have two different colors for one List? Using Transpose … Continue reading “Cross sampling”
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 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 or change analysis’ settings. Transpose can be used with Category chart, Category scatter chart and Category table. … 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”