News

News

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 Data AdditionsNov 23, 2016

Emerging & frontier markets, greater granularity for Spain & the UK, & a cost-of-living index for European cities


Expanded Coverage of Emerging and Frontier Markets

Those of you who have been following the data additions news for a while now will know that this is a recurring theme. While we don’t always mention it in the news, expanding our coverage of emerging markets is an ongoing project for our data teams. The most recent additions saw a substantial increase in coverage for this segment, with data being added for Bolivia, Malawi, Mongolia, Georgia, India, and Armenia.


Macrobond chart

National-source data for Rwanda and Uganda

Data from national sources has been added for these countries, and will continue to be expanded over time. The first additions focus on the most relevant economic indices such as CPI, national accounts, and foreign trade, amongst others. View the complete list of indices that have been added (with links to the data in the application) for the two countries, at the end of this post.


Increased granularity for UK & Spain

More granular banking and credit data is now available for Spain and the UK. For Spain, the additions include balance sheet and flows, deposits and loans, and profit and loss data, for two additional MFI categories. For the UK, the focus was on BOE/FCA MLAR Mortgage Lenders & Administrators Statistics.


Macrobond chart


Macrobond chart


Crowd-sourced cost-of-living data for European cities

Numbeo provides data from continuous, crowd-sourced inputs about, amongst other things, the cost of living. The data available in Macrobond covers European cities, and includes indices for the cost of living, rent, groceries, local purchasing power, and restaurant prices. It’s worth mentioning that New York has been used as a benchmark in calculating the indices, see the chart below for an example. You can read more about Numbeo’s methodology and calculations here.


Macrobond chart


Data by country/region

Armenia

International Reserves

Bolivia

International Reserves

Brazil

Central Bank of Brazil Monetary Policy Committee Meeting Schedule

China

PBoC Monetary Policy Committee Call Dates

Georgia

Foreign Exchange Reserves

India

Flow of Funds
RBI Monetary Policy Committee Meetings Dates

Japan

Basic Figures on Fails

Jordan

Employment

Malawi

CPI

Mongolia

Foreign Trade Annual Data

Norway

Public Pension Base Rate (NAV)

Romania

Economic Activity

Rwanda

Balance of Payments 
CPI 
Foreign Trade
National Accounts
Monetary Statistics

South Africa

Annual Balance of Payments

Spain

Balance Sheet & Flows of Credit Institutions, Deposit-Taking Institutions & Credit Financial Intermediaries
Deposit-Taking Institutions & Credit Financial Intermediaries Deposits & Loans
Profit & Loss Account

Uganda

CPI
Foreign Trade
International Reserves
Leading Indicators
Money Supply
National Accounts

U.K.

BOE/FCA MLAR Mortgage Lenders & Administrators Statistics 

Europe

Numbeo European Cities Cost of Living Indices

OECD ANA (example: Sweden)

Value Added & Its Components by Activity

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 AdditionsNov 9, 2016

South African Trade Conditions Survey, FAOSTAT data, & expanding coverage of primary sources


SATAI & SATEI

The recently added Trade Conditions Survey for South Africa is now available in the application. The main indicators are the trade activity and trade expectations indices, shown in the chart below. In addition to these indicators the survey also covers inventory holdings, new orders, backlog on orders received, supplier deliveries, input and selling-price movements, export and import activity of business, and job creation activities and prospects. The data is updated monthly, with new statistics for the month being released ten days after month’s end.


Macrobond chart

FAOSTAT data added

The Food and Agriculture Organization of the United Nations provides detailed data on crops and livestock products, live animals and trade Indices. The data available in the application includes the following variables: export quantity, export value and export unit value, import quantity, import value and import unit value. The dataset includes all food and agriculture products imported and/or exported annually, by all the countries in the world. An example of the data can be seen in the chart below. As for how you interpret it, that probably depends on whether you’re French, Italian, or Spanish…


Macrobond chart

Ipsos MORI Economic Sentiment Survey

We have increased our coverage of UK economic sentiment surveys to include this economic optimism index from Ipsos MORI, with monthly data available from 1978.


Macrobond chart

Primary-source coverage for Belarus & Barbados

Work is being done on an ongoing basis to provide not only international-source data, but also primary-source data from more countries. Most recently we expanded our coverage of national sources to include data for Belarus and Barbados. The first additions cover a variety of key indicators, all of which can be accessed in the application under Economics - By country, or directly, by following the links in the list below.


Macrobond chart

Data additions by Country/ Region

Armenia

Annual Import
Annual Export

Barbados

Balance of Payments
Foreign Exchange Reserves
Government & Public Finance
Import & Export
Industrial Production
Labor Market
National Accounts
Non-Performing Loans
Prices

Belarus

Banking System Survey
Consumer Credit to Households
Central Government Debt
Foreign Debt

Finland

Job Vacancy Statistics
CPI Special Aggregates

Israel

Public Sector Credit

New Zealand

International Visitor Survey

Pakistan

Foreign Direct Investment

Slovakia

Average Wages Growth Index

South Africa

Trade Activity Index
Trade Expectations Index

Spain

INE International Trade in Service Survey

U.K.

Ipsos MORI Economic Optimism Index
Scotland Residential Sales, Price Bracket

U.S.

Census Annual Survey of Pensions
Longer Run FOMC Summary of Economic Projections for the Growth Rate of Real GDP
Median Hourly Wage

World

Dallas Fed Global Economic Indicators
Eurostat Harmonized Unemployment Rates (Example)
Eurostat Employees by Sex, Age & Economic Activity (Example)
Eurostat Employees by Sex, Age & Occupation (Example)
FAO Trade Indices

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 + RNov 3, 2016

The easiest way to access Macrobond data directly in R.


At a certain point, it becomes undeniable that a growing number of users would benefit greatly from the addition of one feature or another. In these cases, the question remains as to what we should prioritize, and how adding these features will affect the overall usability of the application.

After an increasing number of requests, and a period of focused effort, we are happy to announce that a Macrobond API for R is now available.


Installation and use of the Macrobond API for R

To use the R API you must be running Macrobond version 1.16.26 or later. To update, simply click on Help > Check for update, in the top menu bar of the application, or see this page: https://www.macrobond.com/index.php/support/installation

If you are unable to update the application yourself, please contact your IT department. In most cases, it is a simple process for them to execute.

Unlike with Python, for example, to activate the API for R, you will have to install an R package in R. For more information about installation, technical requirements and examples please visit this page https://help.macrobond.com/add-ins/the-macrobond-api-for-r/.


What can you do with the Macrobond API for R?

  • Easily access any time series from Macrobond from within R, including values, dates and metadata.
  • Convert a set of time series to a common calendar and optionally a common currency.
  • Fill in missing values using a variety of methods.
  • Upload your own series to the in-house database which can then be used in the Macrobond application, and optionally shared with others.
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

Halifax House Price Index from MarkitNov 22, 2016

Users can now acquire a license from Markit to access the data in the application.

The Markit Halifax House Price Index covers all (12) UK regions. Indices include all houses all buyers, existing homes, first time buyers, and former owner occupiers. The database is made up of 122 house price indices, of which five are monthly, 65 are quarterly, and 52 are annual indices.

Licenses are acquired through Markit, but feel free to contact your account manager if you have any questions.

More

PMA databases available via MacrobondNov 8, 2016

Users can now acquire a license to access PMA real estate data directly in the application


PMA European Real Estate Data

The initial offering will include European real estate data at city level, for the office, logistics, and high street retail categories. Each of these three databases includes indicators of economy, property fundamentals, and rents and investment.

The data can be accessed by country, or concept, directly within the application and includes historic and forecast annual time series, for key indicators including supply, demand, rents, yields and total returns. The data is updated every six months.

Acquiring a license for PMA data in Macrobond is arranged directly with PMA. For contact details please visit their website. https://www.pma.co.uk/home/eng/contact.asp



Macrobond chart

About PMA

PMA was established in 1982 and has grown to become one of the largest truly independent property consultancies, dedicated to the provision of high quality, objective, research and forecasting.  PMA provides regular forecasts of commercial property market performance in key office, retail, and industrial markets in the UK, continental Europe, Asia-Pacific and the US. The company also supplies headline projections for the major global residential markets. These forecasts are supported by comprehensive reporting, enquiry facilities and briefings.

More

Your Overview of Data AdditionsOct 26, 2016

Polling data on Italy's upcoming constitutional referendum, leading indicators & survey data, & a special request


Polling Data for Italy's constitutional referendum

On the fourth of December 2016, Italians will cast their vote for or against the constitutional referendum, intended to streamline the legislative process by drastically limiting the power of the senate in parliament. If the outcome of the vote is against these reforms, Prime Minister Renzi has said that he will resign – a clear opportunity for Italy’s largest opposition group, the Five Star Movement. Given the growing uncertainty surrounding the state of the EU, and the precarious state of the Italian economy, the outcome of this referendum will not be insignificant. As seen below, current polls have the two camps neck-and-neck, with a slight advantage for the Nos. With less than two months until the referendum, will the current government be able to rally the support it needs?


Macrobond chart

More leading indicators and survey data for various countries

As the heading suggests we continue to expand our offering of the aforementioned data. A few highlights from our efforts include the IEACW monitor for the UK, leading indicator data for Mexico and Lebanon, as well as business tendency survey data for Israel.


Macrobond chart

A special user request

Recently we received a request from a user who wanted a way to highlight the periods in the US during which the governing party was either Democrat or Republican. Our solution was to calculate a series in which 0 indicates a Republican president and 1 indicates a Democrat president. In this case, calculating a series allowed for more flexible use of the series – either as a fill range, as shown in the chart below, or for more advanced calculations. You’ll find a link to the data in the list at the end of the post.


Macrobond chart

DG COMM Eurobarometer: Public Opinion Survey

We've made a substantial addition of data to this dataset in recent weeks. Many of you will be familiar with what it covers, but for those who aren't: The Eurobarometer is a bi-annual survey conducted by the Directorate of the European Commission. It surveys samples of the population from 34 countries (for a complete list see the metadata provided in the application). The purpose of the survey is to analyze the perceptions of citizens using questions covering a range of socio-political and economic topics.


Macrobond chart

Data additions by country & region

Austria

Harmonized Unemployment Rate

Belarus

Credit Rates
Interbank Rates
Money Supply
Retail Trade Turnover
Nominal & Real Wages
Unemployment Rate

Belgium

GDP per Capita

Chile

GDP per Capita

Finland

Interest Rate Margins on Loans
Life Insurance
Owner-occupied Cost of Housing

Greece

Predetermined Short-term Net Drains on Foreign Currency Assets

Italy

Constitutional Referendum Poll
Gross Earnings per Employee & per Hour
Permanent, Temporary & Self-employed Employees

Israel

Business Tendency Survey

Jamaica

Balance of Payments

Japan

Break Even Inflation Rate
Measures of Underlying Inflation
MOF Business Survey

Lebanon

Coincident Indicator
Commercial Banks Deposits

Mexico

Leading Indicator

New Zealand

Median Hourly & Weekly Earnings

Paraguay

Balance of Payments

Spain

Transfer of Property Rights
Spain Electricity Demand

U.K.

ICAEW Business Confidence Monitor

U.S.

Governing Party

European Commission

DG COMM Eurobarometer

OECD

Private sector debt (Sweden used as entry point example)


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