How the databases work
You may download unlimited quantities of data from the NIER’s website free of charge. The data may also be processed, copied and distributed to other users, including for commercial use. This applies to both manual retrieval and automated retrieval via the database’s API.
How to use the forecast database and statistical database
If a table exceeds 1,000 rows and 30 columns, not all of the table will appear on screen, but you can still download it as an Excel file or in another format. The limit for downloads is 250,000 cells.
Automated data retrieval
The interface for the databases makes it easy to search and download data. It also allows you to adjust the table settings and save your searches, and so gain direct access to updated data as they are published without needing to perform a new search in the interface (see Figure 3 above). This will be enough for most users, but those who wish to automate and program their searches to an even greater degree can use the database’s API. The API can be used in various ways but requires some programming skills (see Figure 4 above).
Excel interface for the forecast database
An Excel-based system is provided to help with automatically updating tables. The Excel files can be linked to the forecast database and are updated automatically when the database is updated.
The aim is partly to offer a ready-made Excel system for users who wish to download large customised segments of the forecast database, and partly to provide an example for those who are interested in programming their own data retrieval in Excel (VBA). The NIER will accept no liability for any errors in this system.
Follow these steps
- Download the files APIMall.xlsm Excel, 29.5 kB. and APIStyrfil.xlsm Excel, 62.3 kB. and place them in the same folder.
- Open APIStyrfil.xlsm Excel, 62.3 kB. and follow the instructions.
|File type icon||Filename||File size||File upload date|
|APIMall.xlsm Excel, 29.5 kB.||29.5 kB||2016-06-28 09.05|
|APIStyrfil.xlsm Excel, 62.3 kB.||62.3 kB||2016-06-28 09.05|
Business and consumer surveys
The Economic Tendency Survey forms part of the European Commission’s Joint Harmonised EU Programme of Business and Consumer Surveys and is part-funded by the EU. The time series published by the NIER may differ from the corresponding series published by the European Commission, partly because the two use different methods to seasonally adjust the time series. The Commission also calculates the net balances for the questions in the consumer survey slightly differently and bases its consumer confidence indicator on a different set of questions.
The results for the Economic Tendency Survey’s questions for consumers form part of Sweden’s official statistics, which must always be available in electronic form.