System Overview

The DOT Online system was developed based on the DOT CD-ROM Browser product, and many of the functions are quite similar. The DOT Online provides subscribers with the same data coverage as the DOT Browser product. The DOT database contains approximately 100,000 time series covering more than 190 countries.

The Country and World Tables, as presented in the quarterly printed copy of DOT, are available as selection options. The Economic Concept View provides a cross-country view of the concepts in the DOT by individual or groups of countries.

Capabilities of DOT Online

DOT Online includes capabilities for the following:

• browsing the directory tree,
• drilling down through the structure of the database,
• selecting either individual time series or groupings of time series within a table presentation,
• saving selected data and metadata in a variety of formats, including a spreadsheet
• and saving and loading a query of selected time series.

Browsing the DOT Directory Tree

The DOT directory tree is browsed using an expanding tree mechanism. Initially, only the first level of the directory hierarchy is displayed. Each item at this level is represented with a file folder. Any item within this level can be further expanded by double clicking it, which will cause the next level of the tree for this item to be displayed beneath it, and so on, for each level in the tree.

The database icon signifies either a cross-country grouping of series or a grouping in a standard presentation that may be selected, and combined with series from another grouping. Clicking on such an entry will cause a selection box to the right of the tree display to be filled with a list of time series, from which individual time series or groups of series may be selected. To select more than one country and/or series you can, in certain instances, hold down the Control (CTRL) key and move up and down with your directional keys or mouse to select additional items.

Changing the Period Setting

To change the frequency or period of data observations that are to be retrieved, click on the Retrieval Period Change button in the upper left corner under the Browser button. The dialog box that appears contains fields for single or multiple frequency settings and will expand to display additional boxes for high or low frequency, start period and year, and end period and year.

To select a retrieval period containing dates of more than one frequency, click on the Multiple Frequency setting. The retrieval period dialog will expand to include additional boxes for specifying the order of the dates and to display the period setting for each frequency. For each frequency of dates to be included in the retrieval period, select the desired frequency, start and end period, and years as noted above.

Simply click on the Next button to enter each desired frequency and then be sure to click on Save at the end of your selections.

Retrieving Series

Retrieving Individual Series

Once the desired economic concepts and/or countries have been highlighted in the far right selection box, the individual series may be selected (illustrated examples of this procedure follow later in this document) by following these steps:

1. First, if you are using the Country Tables view, click on the Continue button, or if you are using the Economic Concept view, click on the View/Select Available Items button;

2. Click on the Check button to select all available items, or click each of the desired items individually;

3. Click on the Add button (which appears as a plus (+) sign).

This will cause the selected series and associated metadata to be added to the Currently Selected Series Box (viewable by clicking on the magnifying glass symbol at the top right of the screen). These series may be combined with series from another entry in the tree directory, by making selections and following the three steps outlined above. Once all the desired series have been selected and placed in the Currently Selected Series Box, any unwanted series may be deleted, by clicking on the minus (-) sign.

Output the series by clicking on the Retrieve button located to the right of “Series” and selecting an output format. Click on the Retrieve button again. This will create a file in accordance with the options that are set on the Options button, including requested metadata fields and data values for all periods for which data are found in the underlying database. If a series does not exist at all within the underlying database, then a blank row will appear.

Retrieving an Entire Table

Once you have expanded the directory tree of the Country Tables and World Tables views, the “Selection Table” Retrieve button is shown in blue (indicating it is available). Clicking on this button will cause an entire table to be selected. This does not mean that all concepts listed in the table exist for every country. When a table is retrieved, there may be rows for which only the time series code and table descriptor exist; this means that the time series does not exist for the country selected.

Country Tables

The Country Tables of the Direction of Trade Statistics (DOT) provide access to time series for a particular country through a collection of tables that correspond to the country pages in the quarterly DOT publication. Often, the relationship among individual series can be inferred from the table; for example, indentation is typically used to indicate that a group of series are components of a summary series. Not all tables exist for all countries and generally the contents of any particular table differ from country to country. This Country Table selection supports the retrieval of either the entire table or selected series from the table.

To retrieve results for the Country Tables, see the example below.

First, choose the country of interest. In this example we have chosen Aruba. After you have selected the country, simply click Continue. You will then have an opportunity to check off which series codes and subjects you wish to obtain information about, or click the Check button to select all items as shown in the examples below.

Please note.

Selecting the Add Series (+), shown above, allows you to select only the specific items. Choosing the Check all items, as shown below, allows you to pick all the items in that list.

Following confirmation of the Currently Selected Series simply click on the X next to Close in the upper right hand corner of the screen.

Now you are able to save the information by clicking on the blue Retrieve button on the far right portion of the Online screen. When that button is selected you will then have the option to choose what Output Format you desire. You may choose as many formats as you would like. You also can name the file using the Description field noted below the Output Format options. Since this system is real-time and each report is dynamic, please be patient for the few seconds it takes the system to display your results. Some formats will display faster than others, such as Excel. An example of this screen can be found below following the explanation of Output Formats.

Output Formats

The output formats available in DOT Online include Comma Separated Value File (CSV), Microsoft Excel File, HTML File, and TAB Delimited File. These formats allow for a table structure similar to that of the DOT Browser on CD-ROM product. The structure is based on the browser interface selections and options, and is displayed using the chosen file format listed above. The metadata items precede the time series observations and are based on the defaults plus any additional metadata fields specified from the Options button. When a table is retrieved, there may be rows for which only the time series code and table descriptor exist; this means that the time series does not exist for the country selected.

After selecting the appropriate Output Format, naming the files and choosing to Save or Remove the files, select the blue Retrieve button on the far right side of the Browse screen.  The results will appear as displayed below.

Retrieval Options

A number of options are available to control the selection of data. To access any of the following options, click on the Options button as shown below.

(DATA FINDS YOU is no longer available and will be removed from the DOT Online interface in a pending release.)

CONSTRAINTS: Constraining the Display of the Directory Tree

The presentation of the DOT directory tree can be limited to specific countries or specific subject topics by setting constraints on the Options button. This option is set by clicking on the Options button, selecting Constraints, then selecting one or more of the countries listed in the Restrict By Country box and/or one or more subjects in the Restrict By Subject box, and then clicking on the Save button. This will cause the current constraints to appear in the box directly below the Constraints box. If the constraints do not fit within the visible portion of the box, then a vertical scroll bar will appear at the right of the box to enable viewing of the constraints. All constraints may be removed by clicking on the Delete button. Setting Constraints can be a useful way of narrowing in on the data that is desired for one or more countries and/or subjects.

METADATA

Metadata is information about a time series contained in separate fields that are mapped to fields in the underlying database. These fields, which may be selected for inclusion in the output file, are described in the table below.

Field Name	Description
Begin Period	The first year for which the series exists in the source database. If blank, then the series does not exist.
End Period	The last year for which the series exists in the source database. If blank, then the series does not exist.
Update Date	The date the series was last updated in the source database.
Base Year	The base year for an indexed series, stored as a four-digit year.
Country	The country or country group associated with a series. The country is either derived from the country code contained within the series code or provided when the source database is registered.
Country Code	The three-digit numeric country code associated with a series.
Data Source	The source database for a series.
Data Type	Indicates whether the data is observed as "Average", "Flow", "Stock" or "Unknown" data.
Descriptor	A textual description or label for the series. If the English Descriptor in the database is blank, the national descriptor is used instead.
Fiscal Year End	Three-character month abbreviation indicating the month in which fiscal year data end.
National Descriptor	The descriptor for the series in the national or official language of the country.
Partner Country	The partner country associated with a series, applicable for direction of trade data and to denote claims or liabilities on partner countries.

SCALE: Scaling Observation Values

Clicking on the Options button and selecting the desired choice within the Scale Options box may adjust the scaling of observations to be retrieved in the spreadsheet. This allows data values retrieved to be stored and displayed with a common magnitude, e.g., units, thousands, millions, billions or trillions. The value of the Scale metadata field is also changed accordingly, to match the scale in which the data are actually stored and presented within the spreadsheet. No scaling is applied to the observation values of series that are identified as index numbers, growth rates, percent changes, etc. If no scale option is specified in the Scale Options box, then by default, the magnitude of the series as specified in the underlying DOT database will generally determine the scaling that is applied to the observation values.

ORIENTATION / GROUPING: Selecting and Creating Output Orientation and Grouping Options

Wherever multiple countries or concepts may be selected, you can control the order in which they appear in the output file, i.e., sorted by Country or by Concept, with data going across the columns or down the rows. Click on the Options button and select Output Orientation and Grouping Options. Make the appropriate selections based on your requirements and then be sure to click Save.

Restore to system default settings AND Save settings for future sessions

To automatically retain all changes to option and retrieval period settings in future sessions, click on the Options button and then check the Save Settings for Future Sessions button on the bottom right of the screen. This process will also automatically save your Retrieval Period Settings. To restore the default option and retrieval period settings, click on the Restore to System Default Settings button on the bottom left of the Options screen.

Search

Searching DOT Database Using Time Series Codes

To Search the DOT database using time series codes (time series names),

• Click on the Search button
• Enter desired strings including wildcards in time series key sub-fields, according to Naming Conventions for DOT Time Series (listed toward the end of this document) or select the desired country, subject, and/or partner country from the drop-down list
• Click on Search button to return list of time series matching wildcard specification
• Select the desired series within the list of found series
• Click on Add (+) to add the series to the Currently Selected Series box.

Downloads, Help, and Show Selected Series Icons

By selecting the Recent Downloads Icon in the far right corner of the Browse screen, the user is able to see a list of the data recently retrieved using this program. Below is a screen that identifies where to locate the Icon.

The Online Help Icon is located to the right of the Recent Download icon on the far right of the Browse screen. And, as you have found, this provides the user with Help on the IFS Online system. If further assistance is desired, please send an email to statisticsquery@imf.org.

By selecting the “Show Selected Series” button, which is the magnifying glass shown above, you can verify what Series you have chosen for your output. This item is always visible. When you choose that Icon the following screen will appear. You may delete any items or add any items at any time during your session.

Naming Conventions for DOT Time Series

The following describes the meaning of the thirteen-character DOT time series code, as an aid to locating data. DOT time series codes provide information about the time series that supplements the text descriptors. Positions 1-3 of the code refer to the country and/or area; positions 4-8 refer to the subject; position 9 and 10 are fixed with "Z" and "F", respectively, and positions 11-13 contain the partner country codes.

Illustration of a DOT time series code:

The code 21370..DZF111 can be broken down by position, as illustrated below.

Position	Description	Code	Translation
1-3	Country Code	213	Argentina
4-8	Subject
4-5	Positions	70	Exports
6-7	Positions	...	none
8	Position	D	Always "D"
9	Version	Z	Always "Z"
10	Publication	F	Always "F"
11-13	Partner Country	111	United States

Description of codes used in the DOT database, by position

Positions 1-3: Country/Area Codes

The first three positions of a DOT time series identify the country or area to which the time series data relate. The term "country" does not in all cases refer to a territorial entity that is a sovereign state as understood by international law and practice; the term also covers some non-sovereign territorial entities for which statistical data are maintained and provided internationally on a separate and independent basis.

The country code always consists of three numerics. For the most part, the first digit reflects a regional grouping, as follows:

0	world or all country aggregates
1	industrial countries
2,3	Western Hemisphere
4	Middle East
5,8	Asia
6,7	Africa
9	centrally managed or formerly centrally managed and other economies

Data pertaining to an area provide aggregated data for countries that comprise that area. Area groupings may vary by source; users are encouraged to consult the online Country and Area Codes file for the listing of area membership.

Positions 4-8: Topic/Subject Codes

In positions 4 through 8 of the time series code is the topic/subject code. It is a five-position alphanumeric code indicating the topic or subject for each time series.

The subjects included in the time series code are:

Position in Time Series Code	Content	Meaning/Editing Specification
4-5	70	Exports
	71	Imports
6	P	Percent Distribution
	C	Annual Percent Change

Positions 9-10: Version and Source Codes

9 – 10

ZF

Always "ZF"

Positions 11-13: Partner Country/Area Codes

11, 12, 13

Numeric

The 11-13 positions contain partner country/area codes as specified above.

Additional Helpful Hints and Information

Deleting Series

To delete an individual series from the Currently Selected Series box, highlight the unwanted series and press the delete key. The delete button appears as a minus symbol in a blue box.

Economic Concept View

The Economic Concept View provides a high-level summary of the data contained in DOT. This view allows the retrieval of similar concepts across a number of countries, to the extent that they exist.

Not All Requested Data are Retrieved

If some of the data that was requested are not retrieved within the spreadsheet, check the Frequency and Period Setting. It may be that the requested series in the database does not exist for the requested frequency, or if it does exist at the requested frequency, does not exist for the requested period. A blank in these fields means that the series does not exist at this frequency.