Retrieve Forecast Data to Your Spreadsheet

With our Excel-based system for API download, you can create spreadsheet files that are linked to the Forecast database. The database API ensures your files are automatically updated whenever a new forecast is published.

You can build your own customised package of tables, based on the tables in the Forecast database. When a new quarterly forecast is published, you can easily update your tables with new data.

When you want to automate

Searching and downloading data is made easy by the database interface. You have the option to save a specific search and thus get instant access to updated forecast data. These features cover the needs of most users.

Using the database API (Application Programming Interface), however, lets you fully explore the possibilities of automating. The API can be used in different ways, but requires some programming skills.

Self-instructing system

NIER is not able to provide advice or assistance regarding API usage. However, we have developed a simple Excel-based system for creating and automatically updating files linked to the Forecast database, designed to be self-instructing.

The aim is to offer a complete system for Excel users who want to download large custom-made parts of the Forecast database, and to provide an example for those who want to program their own application in Excel (VBA).

NIER assumes no responsibility or liability for any errors in the system.

How to get started

  1. Download the files APIMall.xlsmExcel and APIStyrfil.xlsmExcel and place them in the same folder.
  2. Open APIStyrfil.xlsmExcel and follow the instructions.

Files

Files available for download
File type icon Filename File size File upload date
APIMall.xlsm 29.5 kB 2016-06-28 09.05
APIStyrfil.xlsm 62.3 kB 2016-06-28 09.05

Subscribe to our newsletters

Email

Newsletters:
Current reports on the economy
Working Papers