Finding specific time series Selecting database view Country & Region Special nodes Source & Release Concept & Category Searching & filtering Importance of data (the red exclamation mark) Data-tree search bar Data-tree filter How to filter? Creating a filter Setting the default filter Clear your filter Shortcuts to data Organizing results Tabs Levels Structured view/Flat … Continue reading “Browsing data-tree”
Some sources show missing values as ‘0’, ‘ – ‘ or ‘n/a’. We always check what each source use for particular data set and unify all those variables into one system. We have two types of missing data in our database: N/A – there should be a value in this point in time but for … Continue reading “Missing values and N/As”
Class of series What Stock, Flow and steps mean? Annual Rate (AR) and Aggregate series as Stock Can I choose class of series? Can I change class of series? Changing from Flow to Stock (how to decumulate series?) Annual Rate (AR) Prices How to change Current to Constant? (inflation adjusted series) How to change Constant … Continue reading “Class, AR & Prices”
Browsing in Analytics tab How it works? Features for navigating data Search tab in Analytics tab Release tab This article will introduce you to the fundamentals of finding data in the application. We’ll take a look at the different activities you can use to find data: Browse, Search and Releases tabs. Browsing in Analytics tab … Continue reading “Finding data – overview”
Macrobond Proprietary Datasets National & International Datasets Third Party Datasets Vintage data Datasets in Chinese The Data you access via Macrobond is either part of the core package, or from our commercial add-on databases. The former is a comprehensive foundation of data that comes with the application, the latter is a selection of commercial databases … Continue reading “Databases in Macrobond”
Purpose Searching with ‘Macrobond defined’ Searching with ‘By description’ How to add data to a file? Purpose Search is a useful function to quickly find the same indicator for different countries. There are two ways to do this. If the relevant indicator is Macrobond defined, all it takes is a single click to generate the … Continue reading “Search panel – ‘Macrobond defined’ and ‘By description’”
Overview Locate series in tree in Analytics activity Search activity Overview Most time series are available in more than one view of the database, such as Source & Release or Concept & Category. ‘Locate series in Tree’ is an action that makes it easy to hop between these different views when looking at a particular … Continue reading “Locate series in Tree”
Structure of codes Prefixes you might encounter in Macrobond Data stored in Macrobond Calculated in-house series External sources Excel in-house Bloomberg connector SQL connector FactSet Direct & Terminal Integration Structure of codes Series provided by Macrobond are identified by a unique name such as usgdp, which can contain letters, numbers and underscores. Series provided by the … Continue reading “Naming patterns”
The complete list of Currency codes in the Macrobond application: Code Description
The list of the Country & Region codes in the Macrobond application (note this is not a complete list of all available versions of regions, just the most common ones): Code Description