News

News

Your Overview of Data AdditionsApr 26, 2016

From Wall Street bonuses to the balance sheet of Sri Lanka’s central bank


To get you started this week we have a nice little data treat in the form of Wall Street bonuses. Going all the way back to 1985 this data gives you a look at the averages and totals for bonuses paid out, and year over year change. If you want to see whether the grass really is greener, or if you’re really keeping up with the Joneses, follow this link.


US - Securities Industry


As always, we’re adding to our emerging markets data. Currently we’re focusing on Asia and the Middle East, specifically in the public finance and banking sectors.


Sri Lanka - International Reserves


Our final chart displays some of the latest additions of detailed time series for the Spanish labor market. The data covers indicators such as unemployment, employment, active population and affiliated workers, at both provincial and autonomous community level.


Spain - Unemployment, March 2016


The Data by Country

Global

LPX & NMX Infrastructure Indices

Bahrain

General Government Budget
Balance of Payments
Aggregated Balance Sheet & Flows of MFI Sector

Denmark

Real Estate Prices > Apartments
Sadolin & Albæk Market Barometer

Kuwait

Monetary Aggregates

Lebanon

Balance of Payments
National Accounts
Consumer Price Index
Government & Public Finance

Mongolia

Government & Public Finance

Pakistan

Balance Sheet & Flows of MFI Sector

Spain

Diverse labor market statistics

Sri Lanka

Balance Sheet & Flows of MFI Sector
Deposits & Loans
General Government

Uganda

Real Estate Indicators

United States

New York City Bonus Pool
More

Thoughts from The Dev TeamApr 18, 2016

On hard choices, simplifying your workflow, and our new Python (API)


Welcome to the first in a series of monthly posts from the product development team. In these posts we’ll be giving you a look at what we’ve been working on here in Gothenburg, Sweden, as well as general ruminations from our department. I guess it will be mostly me, Thomas Olsson, writing these posts, but occasionally someone else from the team might join in.


K.I.S.S.

We think that the Macrobond application is the best tool to use for pretty much everything our users need to do (not so strange, when you consider that we built it that way). That being said, there are some users who have not, yet, come to realize this, and so they continue to want to use other tools! Oh, the irony…

Allow me to clarify. Our philosophy is to offer the most commonly used statistical functions in an easy-to-use way. This sometimes means that we may not offer all the possible settings for certain analyses.

On purpose.

And with good reason! By leaving out features that are rarely used, we can make a more user-friendly interface. Which means more time for our users to do what they really want to be doing, instead of trying to wrestle with an unruly tool. Deciding what to leave out however, that is one of the most difficult parts of building a product. (Whatever else can be said about the man, in my view this was one of the true strengths of Steve Jobs, and essential to the success of the first iPhone. He dared to leave things out.)

What if you need more options?

That’s where APIs come in. What an API (Application Programming Interface) does is to make different applications collaborate. To give you an example let’s compare a workflow with and without an API. Let’s say you’re working in Macrobond and find some data you would like to put through EViews.

Without an API:

  1. Download the data from Macrobond
  2. Save it in Excel
  3. Open EViews
  4. Upload the data from the Excel file

With an API:

  1. Open EViews

With an API you can access the Macrobond data in EViews directly.

For a long time now, we’ve offered users the possibility to integrate Excel, EViews, and MATLAB into their workflow in the Macrobond application, via APIs for these programs. So those users who prefer to stick to the tools they know, or those that need features that aren’t widely used by their peers, can choose what works best for them. If you’re using Macrobond in conjunction with these tools and don’t know how to make use of these APIs, read this.


Macrobond + Python

Now we have added an API for Python to that list. Python is a programming platform, popular amongst financial analysts for powerful libraries like NumPy, SciPy and Pandas.

If you’re a fan of Python (the platform, not the British comedy ensemble, although naturally these things are not mutually exclusive) you’ll be pleased to know, when running Macrobond on the same computer as Python, you can:

  • Use any time series, including values, dates, and metadata, in Python
  • Convert a set of time series to a common calendar and optionally, a common currency
  • Fill in missing values in a few different ways
  • Upload your own series to your in-house database in Macrobond, which can then be used in the application and even shared with others

Downloading a time series and printing the values can be done with just a few lines of code:


import win32com.client
c = win32com.client.Dispatch("Macrobond.Connection")
d = c.Database
s = d.FetchOneSeries("usgdp")
print (s.Values)


The Facts

The API is included in the Macrobond application from version 1.15.88.

In the documentation on our help site you’ll find information about all the possibilities you have with the Python API, as well as many examples: https://help.macrobond.com/add-ins/macrobond-python-api/

More

Your Overview of Data AdditionsApr 4, 2016

Making additions to our database is part of the day-in-day-out at Macrobond, and up until now we’ve published a weekly list of the main additions made. From now on we will be publishing data additions every other Wednesday. But we’ll kick off this change with our first post today.

These posts provide a less time consuming way to get an overview of data additions. Posts might highlight trends in data requests from our users, point out some of the more unusual data additions, as well as provide updates on progress made in ongoing projects. We will also include some example charts to give you a sense of the type of time series these additions include. For those of you who prefer to simply scan the list- not to worry. The list of data additions by country, with links to the application, will still be included.

So, what’s new?

Many users have expressed an interest in expanded emerging markets coverage. For the latest additions we’ve focused on adding data for the Middle East.

Middle East data



Under any one category, the data included can be highly detailed, as well as consist of long histories. If you see a country or region that’s of interest to you, we suggest exploring the data within the application, via the links provided. It’s the simplest way to stay up-to-date on new series that could impact your analyses.

Irish data



We’ve also made some additions for specific client requests. Sometimes we’re quite surprised by the level of detail these additions include. For example, if you’ve been waiting to investigate home building prices in Uruguay, you can now compare the price of a variety of 12cm bricks. No detail too small, as they say.

Uruguayan data


We will be back with more additions every other Wednesday, from the 13th of April. So check in then for the next review, either here or in your application news feed.

Bahrain

CPI

Indonesia

Residential Property Price Index by Region

Ireland

Loan Approvals

Jordan

Central Bank Balance Sheet
Deposits & Loans

Norway

Guest Nights

OECD

Gross Domestic Expenditure on Research & Development

Serbia

Construction Permits

Uruguay

Home Building Prices
More

International BEA data addedSep 15, 2015

International dataset was added in Macrobond separate BEA database. This addition ensures all BEA data categories are now available in MB.

The data is available in this location:

BEA > United States > International

What’s included?

Direct Investment & Multinational Enterprises (MNEs)

This dataset contains two types of statistics:

∙   Income and financial transactions in direct investment that underlie the U.S. balance of payments statistics and direct investment positions that underlie the U.S. international investment positions.
Operations and finances of U.S. parent enterprises and their foreign affiliates and U.S. affiliates of foreign MNEs.

International Transactions

BEA's international transactions (balance of payments) accounts include all transactions between U.S. and foreign residents.

International Investment Position

BEA's international investment position accounts include the end of period value of accumulated stocks of U.S. financial assets and liabilities.

BEA NEWS

More

ECB data addedJun 3, 2015

Detailed data from ECB has been added in a separate database and made available to Macrobond clients.

What’s included? Data from following datasets presented by regional breakdown.


Bank Lending Survey Statistics
Balance Sheet Items
Statistics on Consolidated Banking Data
Exchange Rates
Financial Vehicle Corporation
Indices of Consumer Prices
Insurance Corporations & Pension Funds Statistics
Investment Funds Balance Sheet Statistics
List of MFIs
MFI Interest Rate Statistics
Money Market Survey
Residential Property Price Index Statistics
Securities
Banking Structural Financial Indicators
Short-Term Statistics
Balance of Payments and International Investment Position (BPM6)
Quarterly Sector Accounts
National Accounts, Main Aggregates
MFIs lending margins


All series available under a separate node “ECB”.

More

Macrobond + CANSIMApr 22, 2016

CANSIM database added to Macrobond’s core data package


As a Macrobond user you can now access the CANSIM database in the Macrobond application. CANSIM is Statistics Canada's key socioeconomic database. Updated daily, CANSIM provides fast and easy access to a large range of the latest statistics available in Canada.


The CANSIM database in the Macrobond application contains 5,5 million time series, across a variety of categories. An overview of the categories can be seen in the image below, and explored in more detail in the application via this link. All users have access to the CANSIM database as part of our core offering. This means you can access the data immediately, without having to purchase it as an add-on database.


Canada, Cansim


For those who are familiar with CAMSIM, vector codes and table codes can be used to easily search and navigate the CANSIM database within Macrobond. Table codes can be searched via the database-specific search field in Macrobond, and CANSIM vectors can be searched by adding the prefix ‘cansim_’ to the vector code.


Below you can see a bar chart of the GDP data available per sector and province.



Canada, Cansim GDP per Sector

More

Your Overview of Data AdditionsApr 15, 2016

Nowcasting from the New York Fed, and Forecasts from Fannie Mae


This week we’re looking at the recently released (as of April 12th 2016), recently requested, and even more recently added Nowcasting Report, from the Federal Reserve Bank of New York. Why the urgency? Have a read through this article from the NY Fed to get a better idea about what’s included.

USA: Federal Reserve Bank of New York Nowcasting Report

Real estate price indicators and forecasts

Apart from our ongoing project to extend data coverage for emerging markets, we have also noted a trend in requests for more real estate data.

Ireland Real Estate Prices, Average Price, All Property Types


This week, several price indicators have been added, for Germany from VDA, as well as on a city or region level for Ireland. For the U.S., you can now find forecasted data on the real estate and construction sectors, from the U.S. agency, Fannie Mae.


US Housing starts; joined with forecast from Fannie Mae


Data additions by country/region

For a more comprehensive list of data additions made in the past few weeks, have a look at the list below. The links provided will take Macrobond users directly to the data in the application database.


Australia

BEC Import & Export
General Government Budget by State

Bahrain

GDP

Bangladesh

Deposits & Loans

Euro Area

STOXX 50 Corporate Bond Index

Germany

Reserve Maintenance
VDP Property Price Index

Finland

Socio-demographic Labor Force Statistics

Hong Kong

International Investment Position

Ireland

CSO Estimates of Household Income
House Prices Statistics

Malaysia

International Investment Position

Portugal

Tourism Statistics

Thailand

International Investment Position

United Kingdom

ICAP £ RIR Index

U.S.

Births & Birth Rates
Fannie Mae Housing Forecast
Port of Houston Container Traffic
New York Federal Reserve Bank Nowcasting Report

More

The Data Structure ProjectMar 10, 2016

The results of our annual customer survey suggested that our users were more satisfied with service, data and functionality than they were with data navigation. To address this, we started a project intended to re-structure how data is presented and navigated. One aim was to present data in a way that mirrors the sources- making it more familiar to many users. The other aim was for users who are unfamiliar with the data and sources to also find, and select data with ease.


This project is something that we will develop on an ongoing basis. At this point, however, we have made enough progress to present it to you. The project is focused on restructuring source data. This will allow you to move between a general, and detailed view of the data available, in a single pane, without having to perform multiple searches. This development is available from version 1.15.44 of the application.


As this is an ongoing project we are happy to hear your suggestions of which sources you would most benefit from having restructured. This way we can prioritize working on the sources most relevant to you. Let us know via the help menu in the application or by using our contact form.


The following example shows data from IMF, BOPS: Australia, IIP. Click on the link to see this view in the application.


Level one of five

When the slider is all the way to the left, at level one, you are provided with a top-level overview, in which you can see the top-level time series from within the set.


Level one of five


With the simple functionality of a slider (seen above), it becomes easy to navigate between, and view the different levels, of data available. The orange dots indicate that a more detailed view of the time series is available.


Level three of five

Level three of five

As always, you are able to quickly view metadata by holding the cursor over a time series.


Level five of five

Level five of five


This view shows the full extent of available series from the source. Those series that are shown in lighter grey text indicate that they are not available for this particular tab/view, in this case, Quarterly, USD.


Click on the links below to see other examples in the application.
BEA: US, GDP & Personal Income.
Economics - by source: US, Domestic Nonfinancial Sectors

More

National & Industry BEA data addedJul 6, 2015

National & Industry datasets added in a separate database increased coverage of the BEA data.

The data is available in this location:

BEA > United States > National
BEA > United States > Industry

What’s included?

GDP & Personal Income Tables

  • Domestic Product and Income
  • Personal Income and Outlays
  • Government Current Receipts and Expenditures
  • Foreign Transactions
  • Saving and Investment
  • Income and Employment by Industry
  • Supplemental Tables

Underlying Detail Tables

  • Real Inventories and Sales
  • Personal Consumption Expenditures
  • Government Current Receipts and Expenditures
  • Foreign Transactions
  • Gross Private Domestic Investment and Capital Transfers (NET)
  • Motor Vehicle Output
  • Other Tables

Fixed Assets Tables

  • Fixed Assets and Consumer Durable Goods
  • Private Fixed Assets by Type
  • Private Fixed Assets by Industry
  • Nonresidential Fixed Assets
  • Residential Fixed Assets
  • Private Fixed Assets
  • Government Fixed Assets
  • Consumer Durable Goods
  • Chained Dollar Tables

GDP by Industry

  • Value Added by Industry
  • Gross Output by Industry
  • Intermediate Inputs by Industry
  • KLEMS


What will be included soon?
We’re already working on including International data:

  • Direct Investment & MNEs
  • International Transactions
  • International Investment Position

and two recent BEA Regional data additions:

  • Regional Income
  • Regional Product


Data structure

Data series can be found using search function along with BEA CODE.

For example BEA, United States, Real Gross Domestic Product, Total, SA, Chained, AR, USD can be found by typing it’s BEA code A191RX. When sorted by series name, National Data can be viewed in exactly the same order as in source tables.


BEA NEWS

More

Oxford Economics Global Economic Databank added to MacrobondMay 12, 2015

Oxford Economics was founded in 1981 as a commercial venture with Oxford University’s business college to provide economic forecasting and modelling to UK companies and financial institutions expanding abroad. Since then, they have become one of the world’s foremost independent global advisory firms, providing reports, forecasts and analytical tools on 200 countries, 100 industrial sectors and over 3,000 cities. Their best-of-class global economic and industry models and analytical tools give an unparalleled ability to forecast external market trends and assess their economic, social and business impact.

More detailed information about the data is available in this document.

Contact your Macrobond sales representative if you are interested in this data.

If you are already a subscriber to both Oxford and Macrobond you are entitled to access through our platform at no additional cost. Contact your Oxford representative for access.



Oxford Economics - chart
More

See our products see more ›

© Copyright 2007-2016 - Macrobond Financial AB