Category: Finding

Class, AR & Prices

Class of series

Each series in Macrobond has a class metadata which affects how they behave when they are transformed to higher or lower frequency. You can check the class of series under Time series information:
Class is a metadata which informs main app how to treat series when using Frequency conversion. Under Conversion settings' Automatic option you can see that series have assigned different methods:

What Stock, Flow and Step mean?

CLASS Description Result of changing to higher frequency (i.e., Annual -> Monthly) Result of changing to lower frequency (i.e., Monthly -> Annual) Used currency conversion method
Stock Series is measured at one specific time, and represents a quantity existing at that certain point in time (i.e., December 31, 2004), which may have accumulated in the past.

Examples: Indices and Percent series; continuous-series, i.e., unemployment, savings, house loan, central bank’s balance sheet, GDP series with AR or Chained.

 Using same value for all points in time in selected period. Using last value in selected period. Last 5d median.
Flow Series is measured over an interval of time. Therefore a flow would be measured per unit of time (i.e., a year). Flow is roughly analogous to rate or speed in this sense.

Examples: Countable series; i.e., GDP, salary, interest rate payments.

 Distributing annual value over 12 months. Aggregating / summing up monthly values to a year. Last value.
Step Series is measured in steps, and is static most of the time.

Examples: Policy rates, mortgage lending rates, prime rates.

 Using same value for all points in time in selected period. Using last value in selected period. Average value.

Can I choose class of series?

Our regular series' metadata are managed by our team. This cannot be changed by user. When you create your own in-house series on you will see 'Class' field where you can select Flow, Step, Stock or Not specified.

Can I change class of series?

In analyses this is possible only in Seasonal Adjustment X-13 analysis. Note this doesn't mean it will be calculated as such because model behind this analysis has its limitations.

Changing from Flow to Stock (how to decumulate series?)

You can change series from Flow to Stock with one of these formulas:

if(Counter()=StartOfYear(), series, momentum(series, 1))
if(Month()=1, series, momentum(series, 1))

Annual Rate (AR)

Generally GDP-series have class Flow. Series with AR (Annual Rate) in description have Stock class because they are already accumulated - in order to compare both these types of series you need to divide AR-series by 4 (if series is quarterly), for example let's compare these:

canaac0554/4    Canada, Gross Domestic Product, Total, Constant Prices, SA, AR, Market Prices, CAD
canaac0585    Canada, Gross Domestic Product, Total, Constant Prices, Market Prices, CAD

Prices

Current Price = Nominal price - series with this description are not adjusted for inflation.
Constant Price = Real price - series with this description are adjusted for inflation.

How to change Current to Constant? (inflation adjusted series)

Divide series by same country's CPI series. For example:

uscaes0301/(uscpi/LastValid(uscpi))

In Macrobond we have aliased frequently used series so you can easily construct codes as country_code+cpi. For more information about these abbreviations see List of countries & regions and Macrobond key series names.

How to change Constant to Current?

Multiply Constant Price GDP (Real) by GDP Deflator and divide by 100 to calculate Current Price GDP (Nominal). For example:

imfweo_cn_ngdp_r*imfweo_cn_ngdp_d/100

How to create chain linked series?

In Rebase analysis wse ‘Relative’ rebase method.

Discontinued series

When the source discontinues its time series, we also change their status in our database. Most series are discontinued because:

  • The source introduced new methodology.
  • The source decided to stop publishing particular indicator.

What happens when series is being discontinued?

In our database

Series will appear in red-ish color and its status is changed to ‘Discontinued’ (visible in Time Series Information).

After discontinuation series might still be located in data-tree node next to new series. But it might happen that the whole release was discontinued as well. In such case, entire node might be removed from data-tree, but those series are still in our database. You can find them with 'Include discontinued' filter' through Search tab.

Files saved on Personal/Department/Company Account

Symbol will appear on chart tile. You can ignore it or open the document to delete or change the series.

How to find discontinued series?

Add superseded

This feature is available in Macrobond 1.30 and later.

Macrobond may be required to create a new time series with a recent historical start point if there is a change made to the methodology of the time series or any other change. You can now easily locate related discontinued time series by right-clicking on series and selecting 'Add superseded'.

You can combine series with formula, for more information see Join().

Data-tree

In data-tree, enable the filtering option and tick 'Include discontinued series':

Search tab

In Search tab, choose 'Include discontinued' from the Filter drop-down list:

Then type in query and press 'Enter'.

Yellow bar

If on Series list you have a discontinued series, the yellow bar will appear above such document. You can click on it. New window will appear with information (if provided by the source) why series was discontinued and possible replacement.

You can opt-out from these warnings or automatically select alternative series. Note there is also an ‘replace all’ option.

When you select replacement series you can use 'Compare in Browse' button to see how much new series differ from old one. Then you can decide if you want to select alternative series.

How to connect old series with new one?

To connect series use formula:

Join(series1, series2)

It can be translated as Join(older series, newer series). After last value of series1 Macrobond will add values from series2 from the respective points in time.

This can also be modified by third parameter which will point exactly where to connect series':

Join(series1, series2, Start(series2))

Join(series1, series2, Date(yyyy, mm, dd))

For other types of joining series with formulas see All about extending series - Join().

Different views – entry-points and how to work with them

Core databases

You can navigate our data via three points of entry:

  • Country & Region
  • Source & Release
  • Concept & Category

Time series browsers are located in Browse and Analytics activity tabs (they work same way). The first step to navigating the data is selecting an entry-point to look at from the drop-down menu. Selecting an entity from the tree will generate a list of data in the pane below.

Country & Region

Here the data is organized primarily by country and regions, and then by economic categories. Data categories and subcategories are only shown if data is available for the selected country. The region 'World' also contains data that does not belong to any country. For instance, Commodity Indices or Emissions data can be found there.
In this view, you can apply filters to only display specific countries and regions in the list. See on Using the tree filter how to do this.

Special nodes

In this view you can see special nodes:

  • International Sources - located in nodes covered by the National sources, it gathers data from International sources regarding particular topic
  • High-Frequency Indicators - with various data which has Daily or Weekly frequency

Source & Release

Source & Release is structured similarly to Country & Region, but beneath each node you will find the sources corresponding to that country or region. In this view, you will find national sources by accessing each country, and international sources by accessing regions, such as 'World'. Note that it is the country, or region, of the source that you should select, and not the country that the data references.

For certain releases, we categorize and organize the data in accordance with the source.

You can apply filters to only display specific countries and regions in the list. This means that only sources associated with these countries will be displayed in the tree.

Concept & Category

This view is an easy way to access similar key data, or concepts, for several countries. The data is organized using the standard Macrobond economic categories and key concept sub-categories.

The National sources category only includes indicators from local or primary sources. Because of methodological differences, granular data can’t be compared across local sources, which means that only a limited selection of indicators are provided for this view. All sources include harmonized data provided by international sources like IMF, Eurostat, ECB or OECD.

Searching & filtering

You can quickly get to the country by pressing a key with letter. You will be sent to the first country which starts with this letter.

Clicking once on the arrow to expand a data node will keep it where it was and will not automatically adjust the view in the series browser.

If you double-click or press Enter to open a node of the data tree, the selected node will be moved to the top of the window to facilitate the navigation within it.

Importance of data (the red exclamation mark)

In the application, we use red exclamation marks to indicate when a time series is a key series for that category. These series can be one of two types:

  • the headline series of a given publication
  • the key series of a given country, which we’ve defined to facilitate cross country comparison

The Notes column will also display the following information:

  • the series is used in a document (the blue square)
  • has been marked as favorite (the yellow star)
  • has a revision (the three violet lines)

To see which type of series is being indicated, hover your cursor over the time series in question, as shown in the images below.

Enabling the exclamation marks column

To enable this column, please make sure that the Notes column is selected to be displayed.

Using search bar

You can manually navigate the data-tree, or you can use search bar.
Use the search bar to search for the names of sources or releases. Then select a result to see the data. Here the series are listed alphabetically. If you want to see a series in relation to the rest of the data set, use the Actions ribbon > Locate in tree function.

If you’re unsure of the name of the release you’re looking for or you want to see the data in an organized structure, you'll be better off navigating the tree by hand.

Using the tree filter

Tree filter can save you time on finding data by eliminating the need to scroll though a long list of countries to find those you’re interested in.

The advantage of using a country filter is that the filter is automatically applied across all databases. In the pictures below, for example, we’ve applied a Euro Area filter. You can see that both the Country & Region view of the economics database and the IMF database only include the filtered countries.
   
The filtering countries feature is not available under Concept & Category view since the data tree is not based on geographical attributes.

How to filter?

Tree filters are applied in the series browser under the search bar and above the data tree. Click on it to open the drop-down menu.

Available options

  • No tree filter - this option disables the filters and makes the entire data tree available.
  • List of available filters -  all the filters you’ve loaded are listed here so they can quickly be applied.
  • Edit - this appears when a filter is set and allows you to edit the countries included in the selected filter.
  • Load - use this to load filters that are saved but not available in the quick list. You can load region filters that have been saved in your company or department accounts.
  • New - you can create a new filter directly from the series browser with this option.

Creating a filter

There are two ways in which you can create a new region filter: using the “new” option in the filter list drop-down menu or creating and saving a region filter in the search activity. All filters are saved together, so filters you create in the Search activity are also available in the Analytics activity and vice versa.

  • Create a filter directly from the series browser in the analytics activity.
    1. Select New from the filter list drop-down menu
    2. Select an account to save the filter in
    3. Name the filter
    4. Search for and select countries to include in the filter
  • Create and save a region filter in the search activity. See how to do this here.

Setting the default filter

To set a default filter, use the star button next to it. This filter will be applied automatically in every new document.

Clear your filter

Remember that the last filter you applied will stay active for all documents in the current Macrobond window. You should select No tree filter again if you want to remove it.

Organizing results

You can use columns to define the type of series information shown, as well as to sort the list of time series. If you haven’t made any changes to the columns yourself, you should have four basic categories in place.

By right-clicking on any column header, you can customize which columns should be displayed, and in which order. When selecting which categories to add, keep in mind that you’ll be using these parameters to sort the list of time series later on.

Structured view/Flat view

In some nodes if you look to the top left corner of the list, you’ll notice various tabs. Each tab groups series that share a common attribute. Tabs are only made available if there's a significant number of time series with common attributes.

Some nodes also have more structured view with levels.

If you prefer not to use tabs and structured view, simply select Flat, to combine all the time series into a single list.

Filtering results

To activate the filter settings, click on the filter icon. You can narrow down the list by specifying which frequency the series should be in and also include or exclude discontinued series. All discontinued series are shown in red, to make them easy to distinguish.

Shortcuts to access data - Bookmarks & Favorites

When you find time series or node you would like to use more often you can create a shortcut to it. For individual time series you can use Favorites functionality (the yellow star icon) and for nodes there is a Bookmarks functionality. See them under Customized shortcuts to access data.

Using filters

Overview

Filters will help to speed up the process of finding the data you want to use. Currently you can use the drop-down Filters and pane on the left called Quick filters (This feature is available in Macrobond 1.28 and later.).

  1. Text search
  2. Filters
  3. Quick filters

Filters vs Quick filters

Filters are selected, more standard metadata while Quick filters are designed to use all power of our metadata and let you know about all possibilities and connections. This is also reflected in the different interfaces. Note you can combine all methods (text, filters, quick filters).

Filters

Each of the filters from drop-down menu has its own specific parameters. They can include or exclude information, be combined together and saved for later use.

Types

Frequency

Available frequencies are: Annual, Semi annual, Quarterly, Quad monthly, Bi monthly, Monthly, Weekly, Daily.

Region

Filter for countries and regions. Under Load > Macrobond you can find many predefined region filters  i.e., EU, ASEAN, Southern Africa.

Source

Here you can type in the source of the data. You can type in one word, press Enter, and it will show you all available sources with it, or use a shortening i.e., BIS, OECD, CIDC.

Category

Each series has assigned category - the one that is used in the data-tree - so you can, for example, search only through series located under ESG or Forecasts category.

Seasonal adjusted

Add it if you want to include or exclude seasonally adjusted time series.

Types of data

If you want to, for example, search for Volvo data but only within companies or securities, this is the best filter for such query.

Include discontinued

Add it if you want to include discontinued time series.

Concept

Search with concepts - groups of series with same theme defined by us. Note that this filter works without any search query.

Release

Search with releases - data packages containing all data which were published together at the same time by the source. Note that this filter works without any search query.

Stores revision history

Add it if you want to include time series which have revision (vintage) history.

Load

Here you can load predefined and saved filter lists.

Predefined & saved Filters

In Search tab you can save your own filters. It can be list - of a one-type filter, for example Region filter with number of countries, or you can apply few filters (i.e., Region, Source and Frequency) and save them as a filter set.

Filter list

To save created filter list click on a diskette icon. You can choose to which account it should be saved. To use that filter again, select from drop-down menu Load.

See here pre-1.28 version view

For a Region filter type there is a shortcut arrow > in the drop-down menu with most recent used filters. You can also pin a filter there to always have an easy access to it.

Filter sets

When you activate more than one filter you will have a filter set - and you can save it with the button on the right side of Search tab panel. As you can see below there is also a Load option and Clear - the latter will remove all current filters from the panel.
You can set to use the filter set as a default for your future queries.

How to use Filters?

Click on drop-down menu and select one of the filters. To add, for example, Regions type in country name, press Enter key, select the right filter. Repeat that for other countries.

You can add many filters and then perform search once again.

See here pre-1.28 version view

Include, Exclude, Not any & Disable

With + and - signs on the left side of the filter panel you can decide if you want to include or exclude particular parameter or set the whole filter's category as 'Not any' (This feature is available in Macrobond 1.28 and later.). The x sign will disable entire filter (but it will not delete it).

See here pre-1.28 version view

By metadata from a series

You can include and exclude parameters based on a series. Right-click on it and select Include only or Exclude. You will see not only the name of the parameter but also what it means in the context of this series.

Quick filters

This feature is available in Macrobond 1.28 and later.

Quick filters are designed to explore databases through available metadata. If you need more space you can hide this pane with pin/unpin in the right-top corner.

How to use Quick filters?

Type something in text field. You'll get all metadata sorted by the number to the right of each - this is the number of available series.

When you add a filter, it will be added as a temporary filter (orange background) that will be cleared if you change the search text. If you want to keep it or modify it, you can click on it and it will become an ordinary filter. If you click on a filter and realize you did not get what you were looking for, you can easily remove a filter by clicking on the "x".

Organizing the results

To organize your search result, click on a column's description. Beside default view you can sort them in ascending or descending order.

To add more columns right-click on columns bar and select the ones in which you are interested. The Notes column contains Used in and Importance information.

See here pre-1.28 version view

Finding data – overview

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, which is: The Browse, Analytics, Search and Releases tabs. As we review them, we will look closely at some of the features that will help you navigate them as effectively as possible.

Browse vs. Analytics

When looking for data in the application there are four options. Depending on what you want to do with the data or what you know about the series, you might go into Browse, Analytics, Search or Releases.

The application database can be navigated directly via Browse or Analytics. Browse is good to use if you simply want a quick way to review headline series for different countries and company data as the selected series are instantly visualized. For more information about this feature see Comparing main indicators.

The Analytics tab is the powerhouse of the application. If you start by looking for the data here in Analytics, you’ll be able to analyze and chart your work in the same workspace.

How it works

When opening the drop-down menu, you’ll see three main entry points to navigate the database, as well as a list of specialized databases that allow you to access the data separately. These are available in Browse as well as in Analytics.

Country & Region

For each of the three main entry points, the structure is organized according to a different principle, for example Country and Region, which is what you’d use if want to look at a variety of data for a particular country.

Source & Release

For finding data from a specific source, choose the Source & Release view, especially if you’re familiar with the way the source organizes its data.

Concept & Category

If you’re looking for one indicator to compare across several countries, unemployment for example, the Concept & Category view is the place to go.

Add-on databases

You can also access data from a specific sources directly. When you do so the data will be presented the same way that the source does.

In-house data

Here you have access to all your Account in-house and Excel in-house data. This is another place except from My series tab, where you can easily access series created by you. For more about these see Account in-house – creating & managing and Excel in-house – creating & managing.

Features for navigating data

Next, let’s look at tree filters, bookmarks and favorites. You can use these to customize and organize the data in a way that suits your work and will make finding data much faster.

Country/region filter

We’ll start with the tree filter. This allows you to define and apply filters based on countries and regions. That way you can limit the data you are shown in the tree to the countries you are interested in, as opposed to having to look through the entire collection.

Bookmarks

Bookmarks are a great way to keep track of the data categories you’re interested in or look at often. What’s good about using bookmarks is that you can view the data in a separate, dedicated tab. Separate tab allows you to keep data well-maintained and tidy in one easily accessible place.

Favorites

Favorites are similar but allow you to highlight specific series, rather than branches of the database as you would with Bookmarks. There are many benefits to saving series as favorites, it's especially helpful as a way to highlight the correct series to use in different cases, if there are a few similar options in the database.

Search tab

Now, let’s have a look at finding data in Search using keywords. Using the search tab allows you to get results from all the databases in the application simultaneously, as opposed to searching in the series browser. For more see Search – overview.

Filters

The application contains many millions of time series, so it’s likely that a single keyword relates to multiple series. To get the right results quickly you can use filters to tailor your search. Filters are based on series attributes such as frequency, region, or source. For more see Using the tree filter in Browse or Using filters in Search.

Locate in tree

When you’ve found a series via Search it can be helpful to view it in a database tree structure, especially if you’re interested in related series. That’s where Locate in Tree comes in, it’s one of the actions you can take when you click on a series. By choosing one of the 3 views, you’ll be able to see where to find the series in that database and take a look at the other data located there.

Releases tab

To finish off we’ll take a quick look at the Releases tab where you can view and monitor data updates from all the sources. Selecting a particular release gives you access to a variety of information and the main indicators included in that release. Filters are also available in this activity, to help you refine the results. For more see In Releases activity tab.

Time series information – accessing the metadata

Each series has its own metadata containing information about source, frequency, unit, class, currency, inflation adjustment, additional comments, methodology, release dates etc. You can quickly access it from anywhere in the application.

How to access metadata?

Regardless of which Activity tab you are in, the action is always available.

  1. Click on the relevant time series in the list (one or more), making sure it’s highlighted
  2. Navigate to the Actions ribbon
  3. Look to the group of actions available under Presentations
  4. Select Time series information

You can also use blue 'i' icon in the Action ribbon or right-click on a series in data-tree.

This will automatically open the tab where the metadata is displayed. It will stay there unless you close the specific Time series information tab. When clicking in Browse tab, it will open there, but if you click from anywhere else it will open in Analytics tab as an 'orange' preview window.

See here Browse tab view

Disappearing metadata

If you transform data then metadata like Class no longer applies and will not be visible when you try to check outcome with Time series information. This will also affect other things like Class automatic detection under Seasonal Adjustment Census X-13 analysis, but you can select it manually.

Using the Actions ribbon

Each Activity tab is like a workspace, with tools and features suited to particular types of tasks. For example, browsing data, or performing analyses. So, what happens if you want to use a tool from a different activity to the one you are currently working in? To do this with as little disruption, and as few clicks as possible, you’ll find shortcuts to those tools in the command bar. Those shortcuts are what we call Actions.

What is Actions ribbon?

Actions are what you see in the different-colored blocks under the Actions tab. These commands are applied to time series or other entities such as releases, when working in any of the Activity tabs (except style sheets and web publish). The available commands, or Actions, are steered by which time series you’ve selected.

How are Actions organized?

As you can see, the actions are divided into groups. The first thing to notice is that the color of the group reflects the color of the activity tab the action will be performed in. The second thing is that a single activity might have more than one group. For example, as you see in the image above, there is one group with options for presenting the selected time series, and another for transforming the time series, but the result of both actions will be displayed in Browse (green). Descriptions of each group are provided below. When you click on a group box it’ll expand over the other boxes. It will expand downwards if needed.

Browse

The first block you’ll see on the left, is for actions performed in Browse. If you will create chart for quick review you can add from there other time series. How to create such chart see in Visualize time series for a quick review.

Add to documents

Use the actions to add the selected series to a new document in Analytics, or to add it to any of the documents you have open in the Analytics tab at the time.

Presentation

These actions give you different options for visualizing the data in Browse. This is useful if you’d like to quickly view the data over a certain period of time (for more see Visualize time series for a quick review), or accessing the metadata in Time Series Information for example (for more see Time series information – accessing the metadata information).

Transformations

Choose from a few simple calculations to apply to the selected time series. This action results in a chart being generated in Browse - for more information see Visualize time series for a quick review.

Locate series in tree

Locate the selected series in the tree, for any of the database views. This is useful if you’ve found a time series outside of the tree structure (in Browse or Analytics) and you’d like to view the series relative to categories, subcategories or related series. For more information see Locate series in tree.

Releases

View the relevant release for the selected time series. This is useful if you’d like to add a series you just found to your list of favorites for easy access at a different point in time.

Search

Use these actions to perform a search based on the selected time series. It’s a useful way to quickly find the same type of series for other countries, for example.

Quick View

This feature is available in Macrobond 1.30 and later.

The new “Quick views” provides superior dataset exploration. You can now select ready-made templates combining charts and tables in one screen, via the mouse or through keyboard shortcuts.

With a time series selected, the Presentation Actions box now allows for several operations to open up pre-defined templates in a “Quick View” tab:

By popular request, this Quick View tab includes the option to open a chart and table in the same view:

And, even more conveniently, these functions can be assigned keyboard shortcuts in the Quick View settings.

For more information :

Keyboard shortcuts

 

My lists activity tab

Overview

You can save list just like in-house series - on Personal, Department or Company account - then use it in other documents and share it with your colleagues. My lists' accounts can be found in Series browser panel next to Bookmarks:

For more information about lists see Lists of series.

Creating list

from My lists tab

Just like there is My series tab for in-house series there is also a My lists tab. Press Create new list or '+' sign, select location and type of list. In the new window, type in needed information. Your list is ready.

Types of lists

  • List by region - series are organized by region. For more information see here.
  • Plain list - this type is not restricted to have just one series per region. You can have any mix of series, but you cannot as easily combine lists. For more information see here.
  • List of regions -  it consists of unique regions (not time series). It can be used as a search filter or as a parent for creating lists by region with common set of regions. It cannot be used on its own in analyses. This type of list is available from My lists tab and Search tab. For more information see here.

Concept for Region and child lists

Concepts which connects series in Concept & Category data-tree view can be used to create Region list and its child list.

Region list

Use '+' button and select 'List by region'. In new list select Concept. After that start selecting countries/regions in Region column. Macrobond will display the right series based on the Concept group.

Child list

You can easily create lists with same regions but other Concepts defined by Macrobond. This is done by creating a child list from a List of regions or List by regions. If the parent list is changed, the child list will be automatically updated.

from Lists tab (on Series list)

You might want to create list while working on a document. In such case Lists tab might be useful. See more under Lists of series. Note that  you cannot create List of regions from there.

Adding list to a document

While in Analytics, open My lists panel, select list and press Add selected list or double-click on the list.

Editing list

Go to My lists tab and double-click on a list. After applying changes save list with icon in upper menu.

Deleting list

Go to My lists tab, right-click on a list and select Delete or press Delete key.

Databases in Macrobond

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 that are licensed separately and integrated with application. The core data package contains two types of database: Macrobond’s proprietary databases, and national and international databases.

Macrobond Proprietary Databases

These databases cover macroeconomic, financial, and equity indicators that have been grouped and organized into a tree-structure by Macrobond. They feature thousands of primary sources from around the world. The proprietary databases have the following titles:

  • Country & Region
  • Source & Release
  • Concept & Category
  • Equity – fundamentals
  • Equity – prices
  • Futures

National & International Databases

For these databases, we have reproduced the original source structure and classification in the application. For the most part, these databases are from international sources that provide harmonized data across countries. However, we have chosen to reproduce the structure of certain primary sources, as well. You’ll find the data sets typically cover most, if not all, the data available from the source.

Add-on Databases

Although we try and include as much data as we can in our core package, certain commercial data providers require that individual licenses be purchased by the client. To make this as convenient as possible, these databases are integrated into your application account, and maintained and updated by Macrobond so that you still have the ease of accessing all your data in the same place.

On Start tab you can see current full list of available data packages and see to which ones you currently have access. (This feature is available in Macrobond 1.28 and later.)

Vintage data

This feature requires Macrobond Data+ license. 

You can download vintage versions (revision history) of time series through Macrobond. Note that not all time series may have vintage data or they do not have data from the period you want. For more information see Vintage data.

Database in Chinese

This feature is available in Macrobond 1.29 and later.

We have introduced prepared in advance translations for our databases. This feature is available only for Chinese. You can change database’s language under Configuration > Settings > DB language:

Search activity tab – ‘Macrobond defined’ and ‘By description’

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 results. If not, you can use 'By description' in the Actions ribbon to customize your search results.
See here pre-1.28 version view

 

Searching with 'Macrobond defined'

This feature utilizes various series metadata. It could be attribute connecting data from harmonized databases such as OECD or IMF (Concept & Category view in our data-tree) or the one connecting components of the indicator.

Just click on the series and locate Macrobond defined in the Actions ribbon's Search panel. Since version 1.28 if you are in Analytics tab it will open in Analytics tab's left panel.

See here pre-1.28 version view

 

Searching with 'By description'

Macrobond defined might not be available for every series you search for, so if you’ve clicked on the series, and Macrobond defined is not displayed in the search actions group, it’s because it’s not available for that series. In that case, you can try using 'By description' instead. You will need to adjust the query. The simplest way to do this is to remove country.

See here pre-1.28 version view

 

Note that sometimes you will need to delete parts of description or exclude something. Or use a filter. For more information about all methods see Finding data in Search tab.

How to add data to a file?

Hold down Ctrl or Shift key to select all the countries you want to add, and then click Add to document  > New document.

See here pre-1.28 version view