News

News

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 AdditionsOct 12, 2016

FOMC Meetings data, Economic Freedom Index & the Lloyds Bank Business Barometer


Will the US see a rates hike this year? Which country has the greatest labor freedom in Europe? And, just how is business confidence in the UK recovering after Brexit in June? Have a look at the selection of our latest additions to the database for insight into these and other questions. If you didn't see Monday’s news, you’ll have missed that the entire JEDH database is now available in Macrobond. Read more about the addition here.


Macrobond chart


Macrobond chart

Macrobond chart


Data additions by country & region

Finland

Regional Accounts: Output & Employment

Germany

Employees Liable for Social Security

Ireland

New residential property index

Lebanon

Banks & Financial Institutions Assets

Electricity Production

Nigeria

Money Supply

Norway

Unemployment by region, registered (NAV)

Unemployment by occupation, registered (NAV)

Unemployment by region, registered & government (NAV)

Unemployment by occupation, registered & government (NAV)

Portugal

Fiscal Data by State

Sweden

Foreign Trade by Commodity Group (SPIN)

U.K.

Lloyds Bank Business Barometer

Federation of Small Businesses, Small Business Index

U.S.

FiveThirtyEight Presidential Polls-only Forecast

FOMC Dissents

Global

The Heritage Foundation

Economic Freedom Index


OECD Corporate Income Tax Rates

e.g. OECD > Main Economic Indicators > Sweden > Public Sector, Taxation & Market Regulation > Taxation



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 AdditionsSep 28, 2016

A quick run-through of the highlights for the last two weeks of additions


Expanding coverage of BIS databases

One of our most eagerly anticipated additions is part of an ongoing effort to offer the complete collection of Bank of International Settlements (BIS) databases. Most recently, additions were made to the Credit-to-non-financial sectors database, an example of which you’ll see in the chart below. To explore this and other BIS data, click on the link provided in the list at the end of this post.


Macrobond chart

EBA Risk Dashboard & key risk indicators

From the European Banking Authority (EBA) we bring you the Risk Dashboard and key risk indicators. The Risk Dashboard summarizes the main risks and vulnerabilities in the banking sector in the European Union. The data is produced by evaluating the evolution of risk indicators from a sample of banks in the EU.


Macrobond chart

What else is new?

As usual, other additions to the database include more detailed coverage across emerging and developed markets, for economic and financial indicators. From Monetary statistics for Azerbaijan and business and consumer confidence indices for Israel, to loans to non-financial corporations in Ireland, and demand for business credit in Brazil.


Macrobond chart Macrobond chart

Data by country

Azerbaijan

Monetary Statistics

Brazil

Serasa Experian Demand for Business Credit

Chile

Financial System Deposits

Indonesia

Value of Non-Oil and Gas Imports by Commodity

Ireland

Private Sector Credit & Deposits

Israel

Business Confidence Index
Consumer Confidence Index

Italy

Contractual Wages

Japan

BOJ Monetary Policy Meetings

Libya

Monetary Base
Foreign Trade
nternational Reserves
Public Finance

Macao

Overnight and Same-Day Visitors by Country

Malaysia

Deposits by Type

Namibia

Broad Money

New Zealand

ANZ Inflation Gauge

Peru

Consumer Confidence Index

Philippines

Universal and Commercial Banks' Deposits

Puerto Rico

Gross National Product
Gross Public Debt

Spain

Tourist Movements on Borders

Sweden

Financial Soundness Indicators by IMF

Turkey

Foreign Direct Investment

U.K.

Quarterly Stamp Duty Statistics
Rents Data

Regional/Global

BIS: Credit to GDP
EBA: Risk Dashboard & Key Risk Indicators

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

JEDH Data added to MacrobondOct 10, 2016

External debt, selected foreign assets, & creditor/debtor comparison data from the Joint External Debt Hub (JEDH) is now available in Marcobond.


What’s included in the JEDH addition?

The short answer: Everything. If that doesn’t suffice then here is some basic information you might find useful. JEDH is a collaborative effort from BIS, the IMF, OECD, and the World Bank to disseminate external-debt data from developed, developing and transition countries and territories. It enhances the transparency, timeliness and availability of external debt statistics and their metadata, to a global audience of users. The chart at the end of this post (Paris Club Claims – Top 20 Countries) provides you with an example of the type of data available, and can be clicked on to open it in the application.


How to find the data?

You can access the data from two different entry points. Selecting the JEDH database directly (as shown in the image below) gives you access to all the data grouped by country.


Macrobond application screenshot


Using By source as your point of entry, and navigating to JEDH in the tree, gives you access to the data primarily organized by indicator, and listed by country.


Macrobond application screenshot


Selected indicators from the JEDH will also be searchable via the By concept database in the near future.


Macrobond application screenshot
More

Your Overview of Data AdditionsSep 14, 2016

A quick run-through of the highlights for the last two weeks of additions


2016 US Election-winner predictions

At this stage, news of the US general election is ubiquitous, seemingly more so than usual, if that’s possible. So if ever a data addition was au courante, this one would be the dictionary definition of the word: US election-winner data from PredictWise, producing a new prediction every 2-3 minutes (frequency is daily in the application). If you’re not familiar with PredictWise it’s good to know that they analyze individual level- markets, polls, and historical- data (big data), with a primary focus on markets. For those of you who can’t stand the suspense, you’ll find the answer you’ve been looking for in the chart below. Note that the example shows the probability of each candidate winning, rather than the margin by which they will win.


Macrobond chart

UK

If you’ve trained your eye on what’s happening in the UK after the now less talked-about, but still relevant Brexit, you may be interested to know that you can easily look up BOE MPC meeting dates in the application. Not something we’re going to make a pretty chart of, but definitely worth marking in your calendar.

Emerging Markets

From China we bring you an addition to our social financing datasets. Besides monthly flows, and yearly aggregates, you can view the data as a 12-month rolling sum, making it easier to read.


Macrobond chart

Urban Audit from Eurostat

A valuable source of insight into urban conditions in cities in the EU and EFTA, the Urban Audit provides indicators of the quality of life in these cities. The data cover demography, housing, health, labor market, education, and environment, amongst others. Data is available for all countries covered by the source. However, the links provided in the list below navigate to a single country to serve as an example of where the data is located in the tree.

Global

From the US Energy Information Administration (EIA) comes the Short Term Energy Outlook, providing an overview of the energy markets both globally and for the US. The chart below takes a look at the Brent spot average, supply, and consumption data, highlighting when supply exceeds consumption and vice versa.


Macrobond chart: EIA - Short Term Energy Outlook

Data by region

Chile

Predetermined short-term net drains on foreign currency assets


China

Total: Social financing 12-month rolling sum


Finland
Shares of GDP


Germany

IAB labor market barometer

Japan

Public debt held by the central bank, by individual instrument


Iran

Monetary aggregates


Puerto Rico

Gross public debt

National accounts


Spain

Monthly labor cost per worker


Taiwan

Deposits & loans


U.K.

BOE MPC meetings

Population estimates

Scotland land & building transaction tax


U.S.

EIA Short-Term Energy Outlook

PredictWise: Winner of the US 2016 general election

Public debt held by the central bank, by individual instrument


OECD

Discouraged Workers

Involuntary Part Time Workers

Labor force participation rate, by sex


Eurostat (Data organized by country, links provide example of placement in tree.)

Farm labor statistics


Urban Audit: Larger urban zones & cities breakdown for various topics

Demography

Living conditions

Education & training

Culture & tourism

Labor market

Economy & finance

Transport

Environment

Perception 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

See our products see more ›

© Copyright 2007-2016 - Macrobond Financial AB