The Global Trade Atlas (GTA) is a powerful browser-based application that allows ... Flow – Trade flow to or from a Reporting Country, either Import or Export .
WELCOME TO THE GLOBAL TRADE ATLAS®! The Global Trade Atlas (GTA) is a powerful browser-based application that allows the user to access international trade statistics with precision and ease. With the GTA, it’s possible to view both product data and country data, either separately or together. The GTA also has many special features, such as the ability to automatically convert your data screen into an Excel worksheet without any cutting or pasting and the ability to create a Saved Query for data that you view on a routine basis. This tutorial will take you through the basics of the GTA so you can start using immediately upon becoming a subscriber.
GTA Definitions Here are a few terms that are helpful in understanding the GTA: •
Reporting Country – A country whose statistics we publish
Partner Country – A trading partner of a Reporting Country
Flow – Trade flow to or from a Reporting Country, either Import or Export
Global View – A way of viewing the statistics of a certain commodity or commodities in your subscription; the default background for the Global View is blue and white.
Country View – A way of viewing the statistics for a particular Reporting Country in your subscription; the default background color for the Country View is green and white.
Eurostat Confidentiality Notes – European Union countries suppress trade data for some commodities by including the trade in special suppression codes. These confidentiality notes identify and cross-reference regular detail codes to suppression codes where there data is reported.
Reporting Country Publication Notes – Publication notes provided by Reporting Countries which advise the user of special circumstances regarding their data. This could be the exclusion of certain codes from reported data or changes in reporting methodology.
Global Trade Atlas Navigator Screen For first time users, we recommend that you initially use the Global View. This allows you to see all reporting countries within your subscription. n w
q r o p s
n You can change the color of your main screen by selecting a color button of your choice. o In the Reporter dropdown you can select Global View to view all countries in your subscription, or you can select an individual country.
p Use the Product dropdown to select a commodity code or a product group. Or, type a commodity code in the HS code box and go directly to it. q Data Availability and Latest Update: -
Data Availability provides a list of the beginning and latest data for all Reporting Countries. Latest Update contains the most recent updates over the past month.
r The Reference section contains features which allow you to: -
Look up HS codes Check publication notes for Reporting countries Look up Eurostat Confidentiality notes by country or code View available tariff schedules
s The Account Setting section lets you see at a glance the current settings on your account. This is helpful to you, and also to your GTI rep if you have a need for assistance.
t Advisories are provided to inform you of special circumstances or changes in published data.
u The Saved Query feature allows you to save the settings for a particular page that you view routinely. This option saves all of the active settings including conversions, product groups and country groups.
w The Information Window is located above the GTA Navigator and is where you will preview your Data Availability, Latest Update and Reference selections.
Looking Up an HS Code When you click on ‘Find HS Code . . .’ the HS code lookup will appear in the information window. This feature allows you to look up HS codes by providing key words or by drilling down. As an example, if you type the key word corn as below and click ‘Search’,
you will see:
On this results page, you simply click the HS number of the commodity, and it will automatically be entered into the HS Code box on the GTA Navigator screen, as seen on the previous page. Then click ‘Submit’ to view the data. As shown above, there may be multiple results from a search, in which case you should read the descriptions and select the appropriate HS Code.
Many users are interested in knowing the detail codes for countries for specific 6-digit codes. From the 6-digit codes, when you click on the button ‘ ’ to drill down you will get a list of all detail codes available for the 6-digit code by Reporter and by Flow as shown below.
Eurostat Confidentiality Notes Eurostat Confidentiality Notes are now available in the GTA. When selecting this option the following will appear in the information window above the GTA Navigator:
Confidentiality Notes can be selected by Reporter or Product or both. Once a selection is made the user has the option of opening the page in a new window by clicking on the ‘Enlarge’ button.
To view the description for a code, simply click on the code and a pop-up box will appear.
Reporting Country Publication Notes To view publication notes for Reporting Countries, click on ‘Reporting Country publication notes’ in the Reference section. The following view will appear in the information window. You can click on your country of interest to view the notes.
Tariff Schedules We routinely receive tariff schedules for various countries, but not all. Those schedules that we have available will be published in the GTA. File formats vary, including Word, Excel, text and PDF. When ‘Tariff Schedules’ is selected a list of countries whose schedules are available will appear in the information window as shown below. You can click on the country name to view the file.
Global View by Reporting Country
n Reporting Total – the sum of the reporting countries in your account o Reporting countries – ranked by the December 2006 YTD Value p % Change – the percent change in value between the two most recent years You arrive at the screen above by selecting Global View and HS code 100590, Maize (Corn), and time period Year to Date for December 2006. You can change the sort order by clicking on another year or on the Reporting Country heading to sort Reporting countries alphabetically. Global View , Selected Partner Country
n A specific partner of choice (e.g. China above) can be selected from the dropdown containing ‘Partner Country: World’. o You can change the time period to Monthly, Quarterly, or Annual and select the desired month and year using the dropdowns. p You also have the ability to view a less detailed code from the HS code dropdown, in this case with code 100590 you can opt to view 10 or 1005. To view a reporting country’s data in more detail, simply click the country name in the reporting country column. We will select Japan for this example.
Country View by Partner Country
n Partner Countries – the top trading partners from whom Japan imports corn, January – June 2007 o HS Dropdown – the ability to select a detail level code for Japan p % Share – the % share of Japan’s imports from each country Now you are viewing Japan’s imports of corn for the period January – June for the past three years by partner country. You can see that Japan’s imports of corn from the United States increased, while imports from Peru decreased by 26 percent. If you want to view the detailed information for Japan’s imports from a particular country (for example, United States) just click on the country name in the “Partner Country” column on the left side of the screen.
Country View by Commodity
n From the HS dropdown you can change to the 2-, 4-, or 6-digit level of detail for a specified commodity. oYou can change the selected partner country from United States to another country of your choosing by changing the partner country in the dropdown on the right side of the screen. By clicking on United States on the previous page, we now see Japanese imports of corn from United States, classified by commodity. As you can see there are several detail classifications for this 6-digit code. You can still change the time period and sort by different time periods just as you did in the previous screens.
Above the data and the headings in the GTA, there is a set of tabs, as seen in the image above. These tabs allow you to easily move from monetary value to other types of data for a certain commodity or product group. With the tabs, you easily access: Quantity – the physical amount of trade displayed with a unit of measure (kilograms for example) Unit Price – the monetary value divided by the quantity, an average of transactions Qty & Val – the monetary value and quantity displayed side by side
By clicking on the Quantity tab you can switch from monetary value to physical quantity of trade for a selected commodity. In the above example, we can see the quantity of Spanish imports of HS 0401 from the world. The unit T stands for Metric Tons (a full list of unit abbreviations in available in the GTA Help section). Spain imported 565,056 tons of milk from the rest of the world in 2006, with France as the largest partner at 303,012 tons.
Unit Price Tab
By clicking the Unit Price tab, you can view the average price per ton of a commodity imported into Spain from each partner country. In the above instance, the most expensive average ton from a trading partner in 2006 is that from Netherlands, at $2,916.23 per ton. The overall average price per ton of Spanish Imports of milk in the year 2006 is $481.19.
Qty & Val Tab (Quantity & Value)
The Qty & Val (Quantity & Value) tab displays both sets of data used to calculate unit price—value and quantity—side by side. In the above example, you can see Spain imported 565,056 tons of milk from the world in 2006, at a total cost of $271,902,199. Please note: The Qty & Val tab is not available in the Monthly Series, Quarterly Series or Annual Series time periods.
Global Trade Atlas Custom Toolbar The toolbar contains special features and appears at the bottom right of the GTA unless you change your user preferences. The Global View icon appears at the bottom left.
Will take you from Country view to Global view Go to Home page, GTA Navigator User Profile (see the next page) View Import Data View Export Data Extract data on your screen into Excel Extract data on your screen into a text file View Help Menu Refresh the screen Download Facility for custom data downloads Convert quantities from one unit of measure to another (Tons to Kilograms, etc.) Save Query Log off of the GTA
User Profile Menu
The User Profile Menu is divided into multiple sections: • General Settings – Allows you access to settings in your account which you can change to suit your preferences • Subscription – Displays the reporting countries, commodities and data to which you subscribe • Product Group – Allows you to create or modify product groups within your account • Country Group – Allows you to create or modify country groups within your account
User Profile: General Settings
You can change any of the general settings in your account by selecting new criteria above and clicking the submit button at the bottom of the screen.
Conclusion You have completed the introductory GTA tutorial; now you know the basic interface functions that will help you get started once you become a subscriber. There are more sophisticated tools within the GTA than are displayed in this tutorial. If you would like to learn about some of these special functions (product groups, country groups, etc.), please call us at the numbers listed below. Thank you for your interest in the Global Trade Atlas. If you have any questions, please call us domestically at 803-765-1860, or internationally at 01-803-765-1860.