News

News

Your Overview of Data AdditionsMar 22, 2017

China’s economic indicator targets, Airbus exports, poll data for the Turkish referendum, and the PISA Global Education Survey.


We’ve added a lot of data for smaller economies in the last few weeks, but in this post, we’re going to highlight additions for some of our larger economies. We’ll also be taking a look at an OECD addition, the PISA Global Education Survey. To see the full list of data, with links to the application, scroll to the end of the page.


China: NDRC targets for economic indicators

We’ve added targets for economic indicators defined by the National Development and Reform Commission in China. The commission meets annually to define targets for the year, which we’ve added for the following indicators:

  • GDP growth
  • M2 money supply
  • Per capita energy consumption
  • Social Financing
  • Urban new employment
  • Urban registered unemployment

Macrobond chart

France: Airbus Exports

The name says it all in the case of this addition. The data was sourced from the French customs office and covers the value and number of Airbus sold per month. In the chart below we’re looking at a simple arithmetic calculation of the average value per Airbus sold, between 2004 and 2017, using these two time-series. As a bonus, when you click on the chart to open the document in Macrobond, you’ll find an extra chart showing the use of the slice functionality.


Macrobond chart

Turkey: Poll Data for the Constitutional Referendum

You can now keep track of the polls regarding the constitutional referendum in Turkey, to be held on the 16th of April, 2017. The question at hand is whether or not to grant the president of Turkey, Erdogan, sole executive, legislative and judiciary power over the country. At this point, there is less than a month to go, with 12% of those polled still undecided. As you’ll see in the chart below, the latest data shows that the Nos are leading for now, but by a tight margin of 48,6% to 45.5%.


Macrobond chart

OECD: PISA Global Education Survey

The PISA survey is conducted every three years. The survey provides an overview of the performance of students in different countries as a measure of the efficacy of the education system of each country. In the most recent results (released in December 2016) Singapore took the lead. The chart below shows the scores in science for the top 27 countries, as well as the score change since 2006.


Macrobond chart

Data additions by country/region

Albania

Banking Ratios of Banking System
Economic Sentiment Index
National Account Change in Inventories & Statistical Discrepancy
Non-Performing Loans
Foreign Trade
Total Retail Sales

Algeria

Balance Sheet of Central Bank
Discount Rate
Domestic Credit

Armenia

Retained Earnings/Loss

Azerbaijan

Retail Trade

Burundi

CPI

China

Economic Indicators for Target Growths

Denmark

Ejendomstorvet - Danish Association of Commercial Estate Agents, Real Estate Stocks Data

Djibouti

Monetary Aggregates

France

Exportation of Airbus

Georgia

External Debt
FDI by sector
Foreign Trade by Country
International Reserves
Nominal Wage Growth

Greece

HCPI

Hong Kong

Population Projections

Japan

Economy Watchers Survey, Seasonally Adjusted Data

Kazakhstan

Interest Rates of Banks on Extended Loans

Netherlands

Harmonised CPI
Net Migration

Philippines

Employment by Region

Russia

Population Savings

Seychelles

International Reserves

Singapore

Import & Export of Services

Spain

HCPI Detailed Data
Tourists with Main Destination the Balearic Islands

Swaziland

Policy Rates

Turkey

Constitutional Referendum Opinion Polls

World

BIS

Locational Banking Statistics – by source
Locational Banking Statistics – by country
Locational Banking Statistics – by concept

OECD

PISA Global Education Survey

Get the news delivered to your inbox

If you like keeping up with the what’s new, but you’re more of an email person, then this is for you! Click on the link below to get this bi-weekly overview of the data additions by email.

Sign up to get this news in your inbox.

More

Macrobond 1.17Mar 3, 2017

Release notes

New features in version 1.17 of the Macrobond application


The latest update of the Macrobond application includes features that will substantially increase productivity, by giving you more control and a simpler way of doing tasks.


The new features and tools in 1.17 will allow you to:

  • customize the way you navigate data
  • save time creating charts and tables
  • simplify and improve the way you present your work
  • increase the ease with which you perform analyses

Below you’ll find a description of the new features, as well as links to relevant learning materials on the help site.

For information about installing the latest version, see the section on how to upgrade, at the end of this post.

If you would like help with installation or have any questions about how to get access, please don’t hesitate to contact the Macrobond team.


Smart Data Navigation

We have two new features that will substantially improve the ease with which you find data: Favorites and Bookmarks. Don’t let the unassuming names of these features fool you, they pack a considerable punch when it comes to customizing the way you access data in the application.


Series favorites

In version 1.17 you can tag series as favorites and organize and access them in the new favorites tab. This allows you to create your own collection of series, organized in a way that makes sense for how you use them.

A typical use case might be for series you use often and would like easy access to, or to use as a reference to facilitate consistent use of time series across departments or organizations.

Favorites

Click here to see a quick video tutorial about how to tag and organize favorites.


Data tree bookmarks

In the latest version of the application you can bookmark specific locations in the data tree. All your bookmarks will be located in the new Bookmarks tab, where you can rename the titles, and organize them into different groups. The result is a completely customized way to find and select the data you want to use. Bookmarks can also be used as a collection of shortcuts to different points in the tree.

Bookmarks

To view a quick video tutorial on using this feature click here.


See which series have been used in other documents

Look out for the small blue square in the notes column of any database listing. It indicates that a series has been used in one or more documents associated with your Macrobond account. Right-click on the icon to view or access the documents the series has been used in. Because the icon identifies which series have been used in documents before, it can also help you quickly locate relevant series when selecting from an extensive listing.

Used_in_Document

For more information on making use of this icon click here.


Optimized presentation

Subtitle per pane

You can now specify a subtitle per pane in time and scatter charts.

Subtitles_for_panes

Twitter – chart size

For everyone who wants to make sure their charts are tweeted at the same size they have set in the application there is a new size setting, called current, that will allow you to do so. Simply select current from the Twitter dialog, instead of selecting one of the two Twitter-optimized sizes.

Twitter_-_Current_option

Presentation documents – Auto pagination

In addition to pages and folders, there is a new type of section that you can add to a presentation document called paginator, which will automatically organize charts into separate pages. Using paginator allows you to specify the number of charts you want to display on a single page. All the charts in a paginator section will be automatically be divided into pages according to the number you specified, and the order in which they are listed. Any changes you make to the order or number of charts in a paginator section will automatically be reflected in the pages.

In the example below, there are 10 charts and the paginator has been set to show four charts on each page. This results in two pages with four charts and one with the remaining two.

For a refresher on how to create presentation documents, have a look at this video.

Pres_Doc_-_Paginator

Presentation documents – Full screen slide show

We have now added slideshow capability to presentation documents. Simply click on the button indicated in the image below to enter presentation mode.

You can use the arrow keys, page up/down buttons on your keyboard, or the mouse wheel to navigate. In addition to navigating between slides, the presentation is also interactive. If you have multiple charts on a slide, and want to highlight one, double click on it to view the chart alone. Use the backspace key, or back on the mouse to return to the previous view.

Pres_Doc_-_Slide_Show

Presentation documents – Export as PowerPoint presentation

Presentations can now be exported to PowerPoint from the file menu, to create and save it as a PowerPoint document (pptx) file.

Pres_Doc_-_export_to_PPT

Presentation documents – Quick view of chart in separate window

Press the P button in the toolbar or Ctrl+Q, in order to view a chart in a separate window. Besides being a quick way to create a new presentation document this is also a way to use a second display when building a Macrobond document. This is especially useful for seeing changes to a chart in real-time, as you make adjustments to an analysis, for example.

Pres_Doc_-_Quick_view_of_chart

For more information click here.



Presentation documents – Fixed size of header/footer

Setting a fixed size for the page header and footer will ensure that all the pages in a presentation document have a uniform layout, as the size will no longer be determined by the content. This can also be used as a way to define blank spaces you want to use once you’ve exported the document, such as for additional formatting of a PowerPoint presentation, for example.

Pres_Doc_-_Header_&_Footer_height

Presentation documents – Page margin

The page margin is the space between the border of the page and the charts on the page. To get an even margin on all sides of the charts, set the page margin to the same values as used for the spacing.

The page margin can be set in your presentation document stylesheet for your convenience.

Pres_Doc_-_Spacing

Analytics

Vector Auto Regression – Diff

It is common to calculate first order differences of series that are expressed as “levels”, before using them in a VAR model. This can be accomplished by using a formula or Rate of change analysis before the VAR analysis. If you want to reverse that process, aggregate the estimated values and then view them as “levels”, you can use a new setting called diff to simplify the process. By checking “Diff” for a series, the analysis will calculate differences, use them in the model and then aggregate the differences when producing the estimated series.


Vector Auto Regression – Impulse response

Select this option in order to calculate the response in one equation, to an impulse in another. To do so, specify the equation, variable, and the number of periods for the impulse.


Rolling aggregate

Previously, a rolling sum could be calculated for a series by using Macrobond formula language. To make this process quicker, rolling sum has now been added as an optional setting when applying an aggregate calculation to a series.

Rolling_Aggregate

Enhanced Integration

Excel add-in

When adding data to excel from a Macrobond document, you now have the possibility to alter the scale of the values from within Excel. Previously this could only be done by making the adjustments in the application and exporting the modified dataset to Excel again.

Excel_-_Scale

SQL Connector

In the SQL Database Connector, you can specify the attribute DisplayUnit for a series. This will then be displayed as the unit in the Macrobond application. For more information about the SQL connector, click here


How To Upgrade

The new version can be installed directly via the Macrobond application by clicking on the yellow ribbon, which appears on the screen, or by selecting Check for update in the Help menu. If you need assistance, a description of how to upgrade may be found here.

If you are unable to make use of automatic updates or use the setup program on https://www.macrobond.com/go/installation, then please note that upgrades from versions prior to 1.16 cannot be done by simply installing a patch (MSP file). You need to install the base installation (MSI file) and the corresponding patch (MSP file).

In Macrobond 1.17 we have dropped support for Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. The minimum requirements are now Windows 7 or Windows Server 2008 R2.

If you are running a version of Windows not supported by this version of Macrobond, you can continue to run the older version until support ends for that version. Those dates can be found here: https://help.macrobond.com/additional-materials/product-versions/

More

Your Overview of Data AdditionsFeb 8, 2017

Expanding our coverage of sub-Saharan Africa, adding detailed datasets, and more time-series from the OECD MEI database.


Coverage of sub-Saharan Africa

When adding primary source data for countries, we start by creating a good, general foundation of the most basic and commonly used indicators, such as GDP, inflation, monetary aggregates and policy rates.


In the last two weeks, we’ve focused on building a robust coverage of countries in sub-Saharan Africa. With first-time additions for Botswana, Zimbabwe, Ghana, Gambia, and Senegal, as well as expanding coverage of South Africa. For a complete list of which countries, we’ve added data for, and links to the various indicators we have added, navigate to the end of this post.


Adding detailed datasets

In cases where we already provide broad coverage of emerging markets, the type of additions we make are often based on user requests. For example, we’ve added time series that provide a more detailed or nuanced understanding of unemployment statistics for Brazil, and banking and credit statistics for Argentina, as you can see in the charts below.


Macrobond chart

Macrobond chart

OECD Main Economic Indicators

We have expanded our coverage of the OECD MEI database to include debt rations for institutional sectors. The example below looks at the total household debt as a percentage of GDI, for different countries. For the complete list, and links to find the data in the application, please see the list of data additions at the end of this post.


Macrobond chart

Data additions by country/region

Albania

Monetary Statistics

Argentina

Cement Sales
CPI for Buenos Aires
Daily Data on Deposits
Daily Data on Loans

Armenia

Monetary Aggregates
Money Transfers of Individuals

Åland Islands

CPI

Bahrain

Foreign Reserves

Botswana

GDP

Brazil

Average Retail Ethanol Prices by States
Estimated Employment by Metropolitan Regions & Federal District
Tax Collections
Unemployment Rate by Metropolitan Regions & Federal District

Chile

Banking Sector Credit to Private Sector

Costa Rica

Central Bank Reserve Assets

Egypt

Total Unemployment

Gambia

CPI
Rediscount Rate

Ghana

International Reserves
PPI

Iceland

Bankruptcies
Income Statement by Sector
New Registrations & Existing Enterprises & Organizations

Iraq

Monetary Aggregates

Japan

BOJ Government Bond Market Operations

Jordan

CPI Weights
Domestic Credit
Domestic Debt
External Debt
External Public Debt
Residential Building Permits

Macedonia

Capacity Utilization
Export by Countries
Public Debt

Mongolia

Domestic Credit

New Zealand

GDP Production Approach by Region

Senegal

M0

South Africa

Banking Sector Data

Sweden

Wage & Salary Structures & Employment in the PrimaryMunicipalities

Switzerland

Domestic Loans Utilization

Taiwan

Government & Private Enterprises Loans & Discounts

Ukraine

Household Deposits
Lending Rates

U.K.

ASDA Income Tracker Survey

U.S.

Tourism Export & Import

Zimbabwe

CPI
Monetary Aggregates

World:

Eurostat (Example: Belgium)

Employment by Sex, Age, Educational Attainment Level & NUTS 2Regional
Final Consumption of Households by Consumption Purpose (COICOP 3 Digit)(ESA 2010)
Internet Purchases by Individuals
Temporary Employees as A Percentage of the Total Number of Employees,by Sex & Age (%)

OECD (Example: Sweden)

Debts Percentage of GDP

Get the news delivered to your inbox

If you like keeping up with the what’s new, but you’re more of an email person, then this is for you! Click on the link below to get this bi-weekly overview of the data additions by email.

Sign up to get this news in your inbox.

More

Your Overview of Data AdditionsJan 11, 2017

Three weeks of data additions for our first post of the new year


Welcome, and Welcome Back!

Now that everyone is back into the swing of things (just about), and before people depart for skiing (or surfing) trips, let’s get going with the data news again. Usually I write a little something about the data or the charts, but this week we’ll be keeping it short and simple, since we have three weeks’ worth of data additions to cover, and a few basics to introduce our new readers to.


When, where, how, and what

As before, we’ll be posting an update of data additions every second Wednesday to highlight any priorities or major projects our data team has been working on, as well as providing you with a list of links to access the data in the application. Once it’s released, you can open the news from the start page of the application. You can also receive the news by email. You’ll find a link to sign up, at the end of this article.

Below you’ll find four example charts. Go ahead and click on a chart to have it open in the application. As always, you’ll find a list of the data additions arranged alphabetically, by country or region, at the end of the post.

Do let us know if there is any data you would be interested in seeing in the application, our first priority in adding data is making sure that our users have access to the data they need, as quickly as possible.



Happy reading,

The News Team



Macrobond chart

Macrobond chart

Macrobond chart

Macrobond chart

Data additions by country/region

Denmark

Employment Data at Municipality Level

Ecuador

International Reserves

France

French Political Data Ipsos Favorable Ratings
Polls for Second Tour of French Presidential Elections

Georgia

Domestic Credit

India

Ownership Pattern of Government of India Dated Securities

Israel

Exports by Commodity
Exports by Country
Monetary Base (Currency Held by the Public)
NPL Breakdown by Sector

Lebanon

Budget & Treasury Transactions
Payment Cards
Treasury Statement
Unemployment Rate

Macedonia

Monetary Aggregates

Malaysia

Mean & Median Wages Survey

Mongolia

External Debt

Netherlands

Political Parties Polls

Norway

Employed Persons by Sex & Major Industry Division (SIC2007) Females
Employed Persons by Sex & Major Industry Division (SIC2007) Males
Employed Persons by Sex & Major Industry Division (SIC2007) Males & Females
Real Estate Norway Rental Index

Paraguay

Foreign Debt

Philippines

Daily Basic Pay

Romania

Foreign Trade by Country

Russia

Domestic Debt

Slovenia

Non-Performing Exposures

Sweden

Annual Real Estate Registrations of Title
Construction Started

Spain

Complete & Part-Time Working Day Employment
Labour Market Social Security Affiliations
Retail Sales by Type

Switzerland

Flow of Funds by Sectors
Pension Fund Statistics
Securities Holdings in Bank Custody Accounts

Tanzania

Money Supply

Thailand

Labor Cost Indices

U.K.

London Incomes
Public Finance Net Borrowing
P2P Lending Data (Peer to Peer Finance Association)

U.S.

Milliman 100 Pension Funding Index

Europe

ECB (example of entry point)
Payments & Settlement Systems Statistics


Get the news delivered to your inbox

If you like keeping up with the what’s new, but you’re more of an email person, then this is for you! Click on the link below to get this bi-weekly overview of the data additions by email.

Sign up to get this news in your inbox.

More

More Intuitive Data NavigationDec 13, 2016

New features that will enhance the way you find data


The database is growing...

Over the last year, we've been working on making it more intuitive and efficient for users to find data in the application. Ongoing development and improvement is one of the cornerstones of the company, which is very clear when you look at our rapidly growing database.

Our policy is to accommodate user requests for data as often, and as quickly as possible. Since the launch of the application, our core data offering has evolved to cover everything from standard indicators for all countries, to a growing coverage of primary sources, more granular data, and even additions specific to current events.


Macrobond chart

But it’s also easier to navigate

If ongoing development and improvement is one of the cornerstones, then enhancing productivity is the raison d'etre of the application. No matter how much data we have or how many tools or features we add, these developments won't be worth anything if it becomes laborious or time consuming to make use of them.

And, with that said - let me present to you...


A recap of 2016's data navigation improvements

If you've had your head down hard at work all year, then this is a good chance to find out which improvements you might have missed. Who knows, if you make use of some of these, you might even be able to look up once in a while during 2017.


The Data Structure Project

Two focus areas

  • Restructuring the By Source view to present data using the same structure as the source. A gradual process, starting with certain categories for developed markets.
  • A scaling function to simplify the way you view this data, allowing you to customize which, and how much data is shown for a selected category. Read more here.

Replicating the source structure

To date we have restructured more than 320 releases for 38 different countries.

For China, for example, 26 releases from seven different sources have been restructured. Below is an example of SouFun CREIS Real Estate Hundred Cities.

Macrobond chart

SouFun CREIS Real Estate Hundred Cities


The focus for this project has been on releases in selected categories:

  • National Accounts
  • CPI
  • Balance of Payments
  • Banking & Credit

Other restructured releases not in these categories include but are not limited to:


Coming in 2017

Continued restructuring of releases for the Banking & Credit category

Prioritizing the Flow of Funds category

Introducing this structure to the By country view, where relevant


The By Concept view

What is it?

As the name suggests, it's a separate view of the economics database that allows you to navigate data by concept, such as Banking and Credit or Foreign Finance, for both national and international sources. Read more about it here. We have also added certain international sources that we believe users would benefit from viewing this way. None of these databases were included in the Economics database previously, and could only be viewed as distinct trees.


National Sources

Since the launch of this view, we have added a few new nodes for national sources, focusing on deepening granularity for:

  • GDP types
  • Inflation target rates
  • Monetary base

International Sources


For international sources (that users can find under All sources), we have added:

  • IMF IFS
  • UN World Population Prospects
  • Heritage Foundation data
  • World Bank Doing Business, BIS Credit and JEDH
  • OECD Quarterly National Accounts.
  • ECB data

Macrobond chart
ECB data viewed by concept

Coming in 2017

Structuring Eurostat data for access through the By concept view

More

Your overview of the data additionsMar 8, 2017

Varied additions, from Chinese e-commerce data to the Credit Suisse Global Wealth Report


This week we have a diverse selection of data additions to highlight:

  • Chinese e-commerce statistics
  • US bond price data from Treasury Direct
  • Sovereign bond holdings data from Bruegel
  • ENTSOE Transparency Platform (electricity)
  • Securities holdings statistics from ECB
  • The Credit Suisse Global Wealth Report

Chinese e-commerce data

This data provides further insight into consumer behavior in China. On average e-commerce represents 14% of total retail sales. As you can see in the chart below, during 2015 and 2016 e-commerce peaked in November.


Macrobond chart

US bond prices

This data covers bid, ask and close prices, collected and compiled by TreasuryDirect. The data is updated on a daily basis, and published for every day the US market is open. Therefore, US holidays will not reflect a value.


Sovereign bond holdings

This data is collected and compiled by Bruegel, a European think tank in Brussels, specializing in economics. The data is sourced from national sources and covers sectoral holdings of sovereign bonds across twelve countries. For the most part data goes back to the nineties and is available at quarterly frequency.


Macrobond chart

Electricity Data for Europe

This data is provided by ENTSOE, the European Network of Transmission System Operators for Electricity. The data covers electricity consumption, prices and production. It is collected from TSOs, power exchanges or other qualified third parties, in an effort to facilitate transparency in the European electricity market.


Macrobond chart

Securities holdings statistics by sector

This data is collected by the European Central Bank and distributed as an aggregate of Euro Area 19. It is collected on a security-by-security basis, and provides information on securities held by Euro area resident sectors, broken down by instrument type and selected issuer countries.


The Credit Suisse Global Wealth Report

The Global Wealth Report is a comprehensive source of information on global household wealth. It provides complete estimates of wealth, covering all regions and the entire wealth spectrum. The report is released annually, and goes back to 2010.


Macrobond chart

Data additions by country/region

Armenia

Average Monthly Nominal Wages
Volume of Trade Turnover

Azerbaijan

External Debt

Belgium

Harmonized CPI Detailed Data

China

E-Commerce Retail Sales
Renminbi/FX Spot (Monthly)
Urban Depositors Price Expectations

Czech Republic

CPI Detailed Breakdown

Egypt

Banks Deposits excluding CBE

France

Contribution to Growth of Some Factors to Companies Profit Rate

Georgia

Total Import (Including C Hepatitis Medicaments)

Germany

Emigration Administrative Area
Immigration by Administrative Area
Net Migration by Administrative Area

Hong Kong

Real Estate Projects Number

Indonesia

Arrivals by Ports
Departures by Ports
Insurance Companies Balance Sheet
Insurance Companies Income Statement
Insurance Ratios

Ireland

Foreign Trade of Services

Italy

Resident Foreigners by Administrative Area

New Zealand

Average Weekly Earnings Regional Breakdown
Births by Region
Deaths by Region
People Outside Labor Force by Education & Gender
Total Population by Region

Russia

Total Population

Sri Lanka

External Debt

Tanzania

Interest Rates (monthly)

Thailand

Deposit Rates
Repo Rate

U.S.

MAPI Industrial Outlook
TreasuryDirect Index-Linked Bonds Price Data
TreasuryDirect Nominal Bonds Price Data
TreasuryDirect Treasury Bill Price Data

World:

Bruegel

Sovereign Bond Holdings

Credit Suisse

Global Wealth Report

ECB

Euro Area 19 Securities Holdings Statistics

ENTSOE

Transparency Platform – electricity data

Portland State University

Chinn-Ito Index (Financial Openness)

Get the news delivered to your inbox

If you like keeping up with the what’s new, but you’re more of an email person, then this is for you! Click on the link below to get this bi-weekly overview of the data additions by email.

Sign up to get this news in your inbox.

More

Your Overview of Data AdditionsFeb 22, 2017

New databases from World Bank and IMF, more in-depth data on Europe, and broader coverage of data for Asia.


New IMF and World Bank databases added

We have added two new databases to the application, Government Finance Statistics (GFS) from IMF, and Global Financial Development (GFD) from World Bank. Both of these databases can easily be located under the specific views for the sources, in the application.

The GFS statistics are issued quarterly, covering 145 IMF member countries. The database includes statistics on revenue, expenses, transactions in nonfinancial assets and financial assets and liabilities, as well as stocks of assets and liabilities of general government and its subsectors.

The GFD database form World Bank provides statistics of financial system characteristics from 206 economies. It includes measures of financial depth, access, efficiency, and stability. The data is provided on national and regional levels, and updated annually.


Macrobond chart

More in-depth European data

In the last two weeks, we have also added more data to our coverage of Europe. These additions are either in the form of providing more granular views of statistics, by adding new sub-categories, or providing alternative sources for indicators that are already covered. An example of the latter can be seen in the chart below.


Macrobond chart

Broader coverage of Asian data

There’s been a general increase in additions for Asian countries, across a variety of different indicators recently. You’ll find a full list and links to the data at the end of this post, as well as two examples for South Korea and Sri Lanka in the charts below.


Macrobond chart
Macrobond chart

Data additions by country/region

Armenia

Foreign Trade (Monthly)
Financial Market Interest Rates
Volume of Construction
Yield of Government Securities in Primary Market

China

Pledged Supplemental Lending (PLS)
Standing Lending Facility (SLF) & Medium-Term Lending Facility (MLF)

Croatia

Pension Insurance System
ROAA & ROAE

Czech Republic

FX Forwards
Treasury Securities by Type of Holder
Predetermined Short-Term Net Drains on Foreign Currency Assets

Egypt

Unemployment by Gender
Foreign Customers Treasury Bills Outstanding

Finland

Total Industry Turnover Index
Foreign Trade Industry Turnover Index

Germany

IFO Survey on Manufacturing Industry, Expectations with Regard to Export Business in the Next 3 Months

Indonesia

Food Prices by Region
GDP Expenditure Approach by Regions
Implicit Price Deflator
NPL Ratio
Number of Departure Passenger of International Flight at Main Airports in Indonesia

Italy

Production Approach Total Value Added

Jordan

Foreign Trade by Country
Foreign Trade by Commodity
Industrial Production of Phosphate
Residential Building Permits
Tourists Arrivals

Lebanon

Beirut International Airport Passengers Flow

Moldova

Evolution of Average Earnings

New Zealand

Average Weekly Earnings by Gender & Region
Employment by Gender & Region
Employment by Industry & Region

Russia

Corporate Profits

Saudi Arabia

Crude Oil Export

Scotland

Housing Statistics on All Sectors New Build Starts & Completions
Supply of New Housing

South Korea

Predetermined Short-Term Net Drains on Foreign Currency Assets – Loans, Securities & Deposits
Predetermined Short-Term Net Drains on Foreign Currency Assets – Aggregate Long & Short Positions in Forwards & Futures

Spain

Affiliation to the Spanish Social Security by Economic Activity
Spanish Ministry of Development Construction by Status

Sri Lanka

Domestic Credit

Sweden

SBAB New Mortgage Lending Data

Switzerland

Credit Suisse Purchasing Managers’ Index

Ukraine

Public & Publicly Guaranteed Debt

World:

IMF

Government Finance Statistics (GFS)

World Bank

Global Financial Development

Get the news delivered to your inbox

If you like keeping up with the what’s new, but you’re more of an email person, then this is for you! Click on the link below to get this bi-weekly overview of the data additions by email.

Sign up to get this news in your inbox.

More

Your Overview of Data AdditionsJan 25, 2017

Major expansion of emerging markets coverage, and IMF CPIS, LME COT Report and ECBC databases added.


Emerging Markets

In the last two weeks, we have substantially expanded our detailed coverage of emerging markets data. The latest additions were focused on banking and credit, government and public finance, foreign finance and national accounts data. The data was added for a broad range of countries, including, but not limited to Thailand, Panama, Kenya, Georgia, Mauritius, Armenia, and Azerbaijan, which is shown in the chart below. You’ll find links to access the data for each country in the list at the end of this post.


Macrobond chart

IMF CPIS Database

CPIS, which stands for Coordinated Portfolio Investment Survey, is a database from the IMF covering economies’ holdings of portfolio investment securities. CPIS data is compiled from the following separate datasets, per country:

  • Equity and investment fund shares
  • Long-term debt instruments
  • Short term debt instruments

Below you have an example of data showing the distribution of China ’s investment across various countries.

CPIS data can be accessed directly via the IMF database in the application, or via the link provided at the end of the post.


Macrobond chart

LME – Commitments of Traders (COT) Report

Below we have an example of data from the London Metals Exchange COT report, showing the positions of different institutional investors in the aluminum market. The report provides an understanding of the predominant business activity of the LME members and their clients. It represents the daily open positions statistics that are reported, based on the futures positions on LME traded contracts and Delta equivalent traded option positions.


Macrobond chart

ECBC Bond Market Statistics

The European Covered Bond Council is an organization that represents over 95% of the covered bond issuers around the world. Their Statistics and Data Working Group collects and publishes statistics for all covered bond jurisdictions. Statistics are compiled from the issuer level by experts in each country to ensure accuracy and comprehensive coverage. The bar chart below is a comparison of outstanding market debt and new issuances, in 2016, as well as the change since 2007.


Macrobond chart

Data additions by country/region

Albania

Debt Maturity
Public Debt Stock
Wage Index

Armenia

Total Loans to Residents (Excluding Financial Institutions)

Azerbaijan

Deposits
Real Effective Exchange Rate

Bahrain

Public Debt Instruments

China

Gross Regional Product, Agriculture, Forestry, Animal Husbandry & Fishery by Province

Denmark

Foreign Workforce by Branch & Nationality

Egypt

Foreign Currency Reserves
Other Reserve Assets

Georgia

Estimate of GDP growth

Hong Kong

Mandatory Provident Fund

Iceland

Non-Performing Loans

Indonesia

Unemployment by Region

Ivory Coast

Current Account

Italy

Industry Turnover Sector Totals

Kenya

PPI

Macedonia

Wages & Salaries
Tourism - Arrivals
Tourism - Overnight Stays

Mauritius

Balance of Payments
Central Government Budget
CPI & Headline Inflation
Employment
Unemployment
Industrial Production
International Reserves
Labour Productivity & Unit Labour Cost
Merchandise Trade
Monetary Aggregates
National Accounts (Quarterly)
Tourism
Wage Rate

Namibia

CPI

Panama

Domestic Credit

South Africa

Capital Adequacy

Switzerland

Company Bankruptcies

Tanzania

PPI

Thailand

Manufacturing Labour Productivity Index

Uganda

PPI

U.K.

National Grid Data on Electricity Demand & Generation

U.S.

Systemic Risk Indicator

World:

ECBC

Covered Bond Statistics

Eurostat (Example of Belgium)

Low-Wage Earners as a Proportion of All Employees (Excluding Apprentices)

IMF

Coordinated Portfolio Investment Survey (CPIS)

LME COT Report

Futures & Swaps

Get the news delivered to your inbox

If you like keeping up with the what’s new, but you’re more of an email person, then this is for you! Click on the link below to get this bi-weekly overview of the data additions by email.

Sign up to get this news in your inbox.

More

Your Overview of Data AdditionsDec 21, 2016

The Fraser Institute Economic Freedom of the World report, full history of the BoE Three Centuries macroeconomic dataset, and German federal elections polling data


The Fraser Institute Economic Freedom of the World report is now available in the application. To produce the report, 42 pieces of data are used to measure the economic freedom of 157 countries around the world. To navigate directly to this data in the application follow this link. For more information on the report you can visit the website.


Macrobond chart

For exceptionally long histories of macroeconomic variables in the UK, the Bank of England Three Centuries macroeconomic dataset is a valuable resource. In addition to policy rate data going back to 1694 that was added at an earlier point in time, you can now access the entire dataset in the application with full histories for every series. For direct access to the dataset in the application, use this link. The dataset is divided into the following categories:


  • Financial Markets
  • Fiscal
  • Labor, Capital & Productivity
  • Money & Credit
  • National Accounts
  • Trade
  • Wages

Macrobond chart

We have also added polling data for the 2017 German federal elections. The polling data provided is sourced from seven different institutions. You can see an example of three of those in the chart below, or open navigate directly to the data in the application via this link.



Macrobond chart

Finally, a chart to illustrate the additional credit breakdowns that were added for Israel.


Macrobond chart

Data additions by country/region

Austria

Flow of Funds

Botswana

Balance of Payments
CPI
Government Budget
Foreign Trade
International Reserves
Monetary Aggregates
National Accounts
Public Debt

Georgia

Industrial Production

Germany

Opinion Polls for the German Federal Elections 2017

Hong Kong

Foreign Investment by Currency

Israel

Exports by Technology Intensity & Industries
External Debt by Debt Maturity
Lending Rate (Prime Rate)
Outstanding Credit & Debt Breakdown

Kazakhstan

Banking System Monetary Survey
CPI Weights
Investments in Fixed Capital

Kenya

Diaspora Remittances

Lebanon

Export Breakdown
General Government Budget

Lithuania

Monthly Unemployment Rate

Philippines

Household Survey of Consideration of Good Time to Buy
Inflation Expectations Survey

Portugal

Autonomous Funds & Services Fiscal Data
General Government Fiscal Data
Local and Regional Government Fiscal Data
Social Security Fiscal Data

Serbia

Non-Performing Loans
Household Savings

Seychelles

Central Government Budget

South Africa

TransUnion Consumer Credit Index

U.K.

Bank of England Three Centuries Macroeconomic Dataset
Bank of England MFIs Assets

U.S.

Divisia Monetary Data
ICI Weekly Estimated ETF Net Issuance

Vietnam

Average Income by Sector

Zambia

Balance of Payment
CPI
Foreign Trade
GDP
Industrial Production

World:

Eurostat (Germany as example entry point)

Immigration by Age & Sex
Immigration by Five Year Age Group, Sex & Citizenship

Faostat (Sweden as example entry point)

Forestry Data

OECD

OECD Output Gap
More

Your Overview of Data AdditionsDec 7, 2016

French polling data, target inflation rates, & more OECD databases added


An abundance of data has been added over the last two weeks, including increased primary source coverage for existing countries, first time coverage of others, multiple databases from international sources, and data on target inflation rates. Have a look at the list at the end of this article for links to these additions in the application. Below is an example of some of the primary source data added for Cyprus.


Macrobond chart

While it’s still early, and the final candidates will only be announced in March, you can now access polling series created by our analysts. To create these series, data from various French polling institutions was aggregated by calculating the average of all the hypotheses.



Macrobond chart

We are currently working on a project to expand our data coverage of the asset management industry - here an example of a survey by IMA, the Investment Management Institution.


Macrobond chart

Data additions by country/region

Armenia

Gross External Debt


Australia

Auction Clearance Rates

Inflation Target Rate


Azerbaijan

Foreign Trade


Brazil

Electricity Consumption by Sector


Cayman Islands

Value & Volume of Real Estate Transactions


Chile

Long-term & Short-Term External Debt

Inflation Target Rate


China

Target Inflation Rate

Public & Private Debt Share of GDP


Cyprus

Central Bank Reserves

CPI

External Trade by Commodity

General Government Cumulative Budget

Gross Value Added

Industrial Output Price Index

Retail Sales Value Index

Tourist Revenue

Wage Growth Rate


Czech Republic

Target Inflation Rate


France

Presidential Elections


Georgia

Foreign Debt


Israel

Core CPI

Target Inflation Rate

IIP

State of the Economy Index


Japan

Target Inflation Rate


Kazakhstan

Core CPI

Interest Rates of Banks on Attracted Deposits

Monetary Survey


Kenya

Commercial Banks Assets & Liabilities

Employment


Malaysia

Government Investment Issues


Netherlands

Bankruptcies Sector Breakdown


New Zealand

Target Inflation Rate


Nigeria

Consumer & Business Survey

Deposit Money Banks Assets & Liabilities

Public Debt (Quarterly)


Norway

Deposit Money Banks Assets & Liabilities

Non-Life Insurance (Finance Norway)

Prices per Square Meter of Detached Houses


Philippines

Target Inflation Rate


Portugal

Government Bonds


Romania

Economic Activity Rate

Employment Rate


Rwanda

Government Benchmark Rates

Interbank Rates

Policy Rates


Serbia

Discount Rate

Short-Term, Medium & Long-Term Debt


Seychelles

BOP

CPI

Deposit & Lending Rates

Earnings

Employment

Interbank Rates

Industrial Production

Monetary Aggregates

Merchandise Trade

National Accounts

Unemployment


South Africa

Quarterly Financial Statistics (QFS)

Inflation Targeting Framework


South Korea

Target Inflation Rate


Switzerland

Empty Housing Data


Thailand

Energy Prices

Inflation Target Rate

Visitor Statistics


U.K.

Inflation Target Rate

Labour Productivity per Hour

UK Investment Management Association Asset Management Survey

Chartered Institute of Personnel Development Labour Market Outlook


Ukraine

Targeting Inflation


Uruguay

Annual Population Estimates

Employment Rate


U.S.

Consumer Credit, Annual Rate

CoreLogic HPI

Hornstein-Kudlyak-Lange Non-Employment Index


World:

BIS

Effective Exchange Rate Indices Daily


ECB

Example of International Reserves of the Eurosystem (BPM6)


OECD

Example entry for GINI Coefficients

Example entry for Labor Union Membership

Example entry for Pension Markets in Focus



Get the news delivered to your inbox

If you like keeping up with the what’s new, but you’re more of an email person, then this is for you! Click on the link below to get this bi-weekly overview of the data additions by email.

Sign up to get this news in your inbox.

More

See our products see more ›

© Copyright 2007-2017 - Macrobond Financial AB