This tutorial covers how to use International Financial Statistics. This tutorial will cover:
1. How to build and refine a data query
2. The scope of data available in the database
3. How to export, chart, and graph your data results
To begin, from the Parrish Library homepage, select the List of Business Databases on the left side of the page.
Then select International Financial Statistics from the list of Parrish databases.
(If you are off campus, it will ask for your Purdue username and password.)
International Financial Statistics allows you to search and download financial data and time series data on countries of international and domestic finance.
Once you access International Financial Statistics, you’ll be taken to the Query Builder. This has options for creating your own dataset that is customized to your needs. Let’s explore some of these options and build a sample dataset.
On the lefthand side of the page, you'll see different aspects you can use to search.
As a general note, you need not go in order when selecting the aspects of your search. For example, you can select a period of time before you choose countries or units.
For our search, we’ll start with the top and work our way down the list.
Click "Country" on the lefthand side to begin.
When you click on “Country” you will find that you can not only search by country, but by regions and groups or institutions and international organizations. You’ll want to select all that is applicable to your search.
For our example, we’ll click on "Country" in the list given, and then select Antigua and Australia.
Note that as you select items from the checklists, the database will keep track of what you’ve selected under the aspect you're choosing from. It should register that you've clicked 2 items.
You can reset this at any time by clicking "Reset".
Here, you can choose the different data elements you’re looking for. You can break it down in any way you want.
For our example, let's look at consumer and producer prices, interest rates, and exchange rates.
First, click Consumer Prices, and then click All Consumer Prices.
Next, click Producer Prices, and then click All Producer Prices.
Then, click Financial Indicators, and select Interest Rates, then click Interest Rates (Lending).
Finally, scroll down and click on Exchange Rates, then select National Currency per US Dollar, period average.
Now, let's move onto Units. Click "Units" to get started.
Here, you can select different measurements.
Select national currency per US Dollar.
Also select percent change over corresponding period of previous year for our units
Please note that when you complete your own search, you may not get all of these same options. The options you get depend on the selections you’ve already made and what kind of data is available for your selections.
Now, click "Time."
Here, you can choose time by frequency and you can specify a time frame.
We’ll select annual frequency and select 2004-2014 as the time frame.
Once you’ve made all your selections, you’ll want to click on “View Data."
Now, you should see a spreadsheet of data come up with your selected countries on the left.
You’ll have a row for every country and concept combination you chose.
For example, notice that there is a consumer prices row for each country, and a national currency per US dollar row per country.
Note: If for some reason one of those rows is missing for a country you search for on your own, that might be because that country doesn’t measure or report those numbers.
If you want to export your data, you can do it as a MS Word, MS Excel, or Adobe Acrobat file by clicking the respective icons in the top toolbar of the window.
You can also graph or chart your data.
In the upper toolbar, click the graph button. This is the button that looks like a bar graph.
You should see a graph show up in the same window.
Now you know how to build a data query, how to refine your dataset, and how to export and graph your dataset using International Financial Statistics. If you have any further questions, contact us at email@example.com
Thank you for using this tutorial.