10
10 WITS Registration in details 2. Click on Registration to open the WITS registration home page 1. Type the WITS web site address in your Internet Explorer browser

11
11 WITS Registration in details Click on the button to start the registration process

12
12 WITS Registration in details You must check the box to activate the Continue Registration button.

13
13 WITS Registration in details Fill all the fields and click the button to continue with the next registration page. Use your professional email address rather than a personal one.

14
14 WITS Registration in detail Government Government offices Sponsored Consultants for UNCTAD or World Bank Paid by Subscription All others New Form is under consideration

15
15 WITS Registration in details Your registration is completed. Click on the link to close the registration window.

16
16 WITS Registration in details Your WITS account is opened immediately for governments and for others as soon as your sponsor confirms it or your payment is received. You then receive a confirmation email with: your password; a link to download the WITS client software.

18
18 Overview: Help and information The Help and Information menu gives access to information on: Data availability for each database (4 catalogs) Available product classifications (nomenclatures) and their structure Concordances between classifications WITS client software version (About us) As well as direct access to: WITS online help WITS information website

25
25 Databases with trade data About 70 countries only; Import flows only. Trade data at national tariff line level. IDB About 70 countries; Import flows only. Trade data at national tariff line level. TRAINS HS 6 digits at the most detailed level Best country/period coverage (from 1962 in SITC and 1988 in HS); Imports and Exports (and Re-exports for some cases) COMTRADE CONSPROS Trade data at a glance:

26
26 Data availability In Help & Information, open a catalog and look for availability of data you are interested in; Information is displayed by country, year and product nomenclature.

27
27 Data availability: COMTRADE catalog Use the vertical scroll bar to go through the countries, the horizontal one to go through the years. The catalog shows Country/Period data availability by Nomenclature/Revision. Information box on codes used in the table: I: imports E: Exports R: Re-exports

28
28 Data availability: other catalogs Information on data availability can be retrieved the same way for the TRAINS and IDB database catalogs.

29
29 A word on Nomenclatures Trade data have been recorded according to several product nomenclatures depending on the database and year: Standard International Trade Classification (SITC) Harmonized Commodity Description and Coding System (HS) Data can be displayed in some other nomenclatures thanks to concordances and up to HS 6 digit level.

30
30 Querying COMTRADE Quick Query / COMTRADE by country, period generates output for all products for one reporter, one (or all) partner(s) and one year.

32
32 COMTRADE by Country/Period 2. Select the level (tier) of the products. In other words, how detailed you would like the system to display the data. The Tier structure depends on the chosen nomenclature. Query specification in details:

34
34 COMTRADE by Country/Period Query specification in details: 4. Select the Reporting Country, which means the one for which you want to display the type of flow you selected.

35
35 COMTRADE by Country/Period Query specification in details: 5. Select the Year. WITS displays only the years for which data exist in COMTRADE.

36
36 COMTRADE by Country/Period 6. Select the Partner Country. You can choose either one individual country, World (one aggregated flow for all partners) or All Partners (one flow by partner country). Query specification in details:

37
37 COMTRADE by Country/Period Query specification in details: 7. Once the parameters are all set, click on View data to send the request to the WITS server and display the data.

38
38 COMTRADE by Country/Period Data can be sorted for any field by clicking on column headings. WITS indicates the number of lines retrieved from the database.

39
39 COMTRADE by Country/Period Check the box to see a description of each product line. Extracted data can be saved as a file and opened in a statistical or spreadsheet software for further computation.

40
40 COMTRADE by Product Quick Query / COMTRADE by product produces output for one product for one or more years, reporters and partner countries.

41
41 COMTRADE by Product Query specification in details: Choose Nomenclature, Tier and Flow type as seen in COMTRADE by Country/Period.

42
42 COMTRADE by Product Query specification in details: Choose the Product category you want to display. The level of details depends on the chosen Tier.

43
43 COMTRADE by Product Query specification in details: Once the parameters are all set, click on View data to send the request to the WITS server and display the data. Check the Years, Reporters and Partners you want. Note that you can select several items in each field

44
44 COMTRADE by Product WITS displays one line for each selected reporter having data matching your query. Click on the plus sign to get detailed data for the corresponding country.

45
45 COMTRADE by Product WITS displays selected partners and trade value for a given product and reporter for each selected and available year. Scroll down to see next selected reporter dataset.

46
46 Dealing with mirror data When some data are missing, it can be useful to use partners mirror data (exports – imports) to fill gaps. However, one has to be very careful because: Of the FOB – CIF issue; Of the difference in reporting quality when a country deals with imports and exports; Of the difference in reporting quality from one country to another. Example: Pakistan (exports)– China (imports) in 2001 236 M US$557 M US$

47
47 Querying TRAINS TRAINS – Trade, tariffs, NTBs produces output for the value of imports at the tariff line level (where available) for all partners, for a single product in a single year. TRAINS – View and export raw data produces output for the value of imports at the tariff line level for all products, for a single year. TRAINS - User criteria allows for retrieving all import lines above a user specified value.

49
49 TRAINS – View & Export Raw Data 2. Select the reporting country (Reporter), Year and Partner. Once the parameters are all set, click on View data to send the request to the WITS server and display the data.

50
50 TRAINS – View & Export Raw Data WITS displays the number of commodity lines for which USA imports from Pakistan. Extracted data can be saved as a file and opened in a statistical or spreadsheet software for further computation. Click on the column heading to sort by most traded products. The most imported product line.

51
51 TRAINS – Trade, Tariffs & NTBs Lets see who are Pakistan main competitors on the US market for product 61102020. Were going to query TRAINS using the Quick Query TRAINS – Trade, tariffs, NTBs to retrieve this information.

52
52 TRAINS – Trade, Tariffs & NTBs We select United States as for the Market, Year 2000, we keep the native Nomenclature (HS 1996) and select chapter 61 as for the Product category. WITS looks for the product lines matching our parameters.

53
53 TRAINS – Trade, Tariffs & NTBs Once WITS has finished retrieving the lines, it indicates the number of matching lines. Scroll through the list of lines and select the one you want.

55
55 Querying IDB WTO – Integrated database retrieves the value of imports of a product from one specific partner or from all partners for a given reporter in a given year. WTO – View and export raw data retrieves the value of imports from all active partners for all products at the national tariff line level for a given country in a given year.

56
56 TRADE : ADVANCED QUERIES The Advanced Query is a more complex but more powerful and flexible tool for sophisticated queries : Can retrieve trade for several years, partners and products with a single query; Can retrieve aggregated trade for groups of countries or products; The process goes through two steps : The user defines, saves and submits his query The server runs the query and notifies when results are ready.

59
59 Advanced Query Definition Once the Data Source has been selected, a set of folders appears on the top left side of the Query Definition window. Those folders may vary depending on the chosen data source.

60
60 Advanced Query Definition Each and every folder has to be filled before you can save and submit your query. {

62
62 Advanced Query Definition Scroll down the Available markets list and click on Pakistan to select it as a reporter. Pakistan is added to the list of Reporters. Selecting Reporters

63
63 Advanced Query Definition If you want to remove items from your selection, you can either unselect them individually or use the Unselected All button to remove all and restart your selection from scratch. Selecting Reporters

64
64 Advanced Query Definition Now, click on the Products folder. The product selection panel appears. Advanced Query offers many possibilities for selecting Products. To get results, you have to use nomenclatures available for the selected reporter(s). Selecting Products

66
66 Advanced Query Definition Lets detail the Product Selection Panel. Once a nomenclature is chosen, you can select products by combining Items, Clusters, Aggregates or using a Search tool.

67
67 Advanced Query Definition Selecting Items The Folder icon indicates that there are sub-categories available. Double-click on a folder to open it and display sub-categories. The Item icon indicates that it s the most detailed available category.Check category and/or item boxes to select the corresponding level of details. WITS will return one line for each selected and available category/item. Here division 33 and sub- group 3300 are selected.

68
68 Advanced Query Definition Selecting Clusters Check a Cluster to select all categories for this level of details. Here the All 2-digit (Divisions) cluster is selected. WITS will return one line by Division category. The Cluster selection is a shortcut for selecting many elements in one click.

69
69 Advanced Query Definition Selecting Aggregates Check an Aggregate box to select all categories and items included in that aggregate. WITS comes with a set of pre-defined aggregates and users can create more aggregates that will be added to the list. Here the Textiles aggregate is selected. WITS will return one line of information for each selected aggregate.

71
71 Advanced Query Definition The selection can be modified at anytime by unchecking selected items and/or checking new ones. Here, several items have been removed and only the Textiles aggregate has been kept.

72
72 Advanced Query Definition Selecting Partners Now, click on the Partner Countries folder. The selection panel appears. It is the same as the one we ve seen for selecting Reporters.

73
73 Advanced Query Definition Selecting Partners We select individual countries from Partner countries, and the EEC15 from the Partner Regions. Regions are group of countries that can be used either as a shortcut for selecting several individual countries at once or as an aggregate for all countries included in the group.

74
74 Advanced Query Definition Selecting Years Select the Years folder and check the year(s) you want from the selection panel.

77
77 Advanced Query Definition We have to Save the query before we can submit it. We ll be able to re-open it later for further use or adjustment. Click OK to save your query using the Name and Description you gave at the beginning of the query definition.

78
78 The Breakdowns feature allows you to decide if you want a group of countries (reporters or partners) to be shown as an aggregate only (keep the boxes unchecked) or also as individual countries (check the boxes). Advanced Query Submission Click on Submit to send your query to the WITS server. We check the Include partner country group breakdowns to see details for each individual country of the EU. Click on OK to send your query to the WITS server.

79
79 Advanced Query Submission Click on OK to send your query to the WITS server. After a few seconds, the WITS server confirms your submission by displaying this information window.

80
80 The Query Status Panel The time required to complete your query and to receive the results depends on several factors: The size of your query; The quality of your internet connection; The number and size of queries sent by other WITS users (first come first served principle). Your query will take from a few seconds to several minutes to be operated by the WITS server.

81
81 The Query Status Panel Click on Status to check if your query has been completed and to access the results. Each line of the table corresponds to a query. Each user sees only it s own submitted queries. This line corresponds to the query we ve just submitted. The empty View column indicates that results are not ready yet. This is confirmed by the Running reference in the Status column. When results are ready, a binocular is displayed in the View column and the Status column indicates Completed.

82
82 The Query Status Panel The status update is done manually by clicking the Refresh button Results are now ready, click on the binocular to display the Output Report of the corresponding query.

83
83 Advanced Query Results The Results window displays data matching the query and available in the queried database. Here, we get results for both the 4 Quad country group as well as for individual countries belonging to that group (remember the partner breakdown check).

86
86 Bound Tariffs Bound tariffs are specific commitments made by individual WTO member governments; The bound tariff is the maximum tariff level for a given commodity line; A country may bind only part of its tariff structure: concept of binding coverage;

89
89 Preferential Tariffs Preferential tariffs are granted to a subset of trading partners under some exception to the MFN principle Preferences differ between partners and agreements: some countries have access to several preference schemes: Example: ACP countries have access to both EBA and Cotonou preferences when exporting to the EU

90
90 Tariffs The 3 types of tariffs may exist for the same commodity line. The bound should always be the highest tariff and the preferential the lowest one. The MFN applied should be somewhere in between: Bound MFN Applied Preferential ceiling 3 tariffs for a same product

99
99 Querying CTS WTO – CTS, view and export raw data returns bound tariffs for the whole tariff structure of one selected country, from chapter category to tariff line level. Data can be sorted for any field by clicking on column headings.

100
100 Querying Tariffs: Advanced queries Information in TRAINS and WTO IDB can also be retrieved and usual statistics produced using the Advanced query. For example: Tariffs for several years, partners and products can be retrieved with a single query; Tariffs and trade can be aggregated for groups of countries or products; Weighted averages of tariffs can be calculated

101
101 Advanced Query for Tariff Data The query definition for tariff data follows the same principles as for Trade data. Lets focus only on the differences and the Output Report. For detailed information about defining a query, look at the slides on Advanced Query Definition in TRADE.

102
102 Advanced Query Definition Choose the tariff database (TRAINS or WTO) you want to query in Data Source. Enter a Query Name and a Query Description. We select WTO IDB in this example.

103
103 Advanced Query Definition The parameters to be defined are the same as for a trade query except for the Trade Flow folder which is missing here since it is not useful in the context of querying tariffs. { Once the query is fully defined : Save it and Submit it

104
104 Advanced Query Submission Click on OK to send your query to the WITS server. 1. The General tab. Include non-traded products allows users to decide if they want tariff statistics like simple averages to be calculated using only effectively traded lines or the full tariff structure.

105
105 Advanced Query Submission 2. Click the Tariff/GSIM tab to display the corresponding panel. Check the Duty Types you want to be included in the report. Choose Protection Data as for the Tariff Data Request Type. Check Use the latest available year if you want WITS to overwrite your selection or click on Change Year Baskets to check year availability for each chosen reporter.

106
106 Advanced Query Submission WITS shows your selection as a column heading (2002) and displays data availability for each chosen reporter. 2002 tariff data are available for Indonesia in WTO IDB, but not for Colombia. When you click on Change Year Baskets the window below opens:

107
107 Advanced Query Submission Open the dropdown list and manually select a year in the list of available years for Colombia. Or click on Adjust NA to give WITS a rule for automatically selecting an available year.

108
108 The Query Status Panel Click on the Status button to open the Query Status window. when results are completed, click on the binocular to access the output report.

109
109 Advanced Query Results The output report displays a set of usual statistics for each type of tariff like simple average …

112
112 Advanced Query Results You can Save your report as it is or you can customize it by using the Alter View button

113
113 Output Report Customization The Alter View window allows users to choose what to display in a report and how it has to be organized. By default, WITS displays fields of information as separate columns in one table. Display can be customized to create one individual table for each distinct value of a field declared as Heading.

114
114 Output Report Customization Uncheck Reporter as a Column and check it as a Heading. Scroll down the list and make Duty Type a Heading. Fields to be removed from the report are unchecked (here Partner) and additional fields can be checked to be included. Click Ok to confirm modifications

115
115 Customized Output Report The Reporter and Duty Type fields are no more showed as columns, instead they appears as dropdown lists. As a result, the table shows information for one reporter and one duty type at a time.

116
116 Customized Output Report The Reporter and Duty Type fields are no more shown as columns, instead they appear as dropdown lists. As a result, the table shows information for one reporter and one duty type at a time.

117
117 Customized Output Report Shift from one duty type table to another one using the dropdown list …

121
121 Exercise 1: trade data availability Look at trade data availability in the COMTRADE, TRAINS and IDB catalogs for your focus country: What are the available databases, nomenclatures and years?

122
122 Exercise 2: main import and export products 1.Identify the main import products for your focus country apart from petroleum. 2.Identify the main export products for your focus country. Using COMTRADE, HS 1996 nomenclature at 2 digits (Chapter level), World as partner:

123
123 Exercise 2: main import and export products Hints: Use Comtrade by country/period World as partner Click column heading to rank values

125
125 Exercise 3: main trading partners Use Comtrade by product Total all products as product All partners as partner Click column heading to rank values Hints:

126
126 Exercise 4: main trading partners 1.Identify your focus countrys 3 main export products to its main export market ? 2.Identify your focus countrys 2 main competitors for each of these 3 products in its main export market ? Using the HS 1996 nomenclature at 2 digits (Chapter level):

127
127 Exercise 4: main trading partners 1.Use Comtrade – by country, period select exports, your country as reporter and choose the main export market as partner 2.Use Comtrade – by product, select imports and choose the main export market as reporter and the product you are interested in as product Hints:

128
128 Exercise 5: mirror statistics Compare what your focus country reports as exports to USA with whats reported by the USA as imports from your focus country.

130
130 Exercise 6: main exports to the EU 1.Using IDB, identify your focus countrys 10 main export products (defined at the line level) to the EU in 2001. 2.Using IDB, identify your countrys main competitors on the EU market for its main export product to the EU.

132
132 Exercise 7: evolution of trade Define and submit an advanced query using the proposed selections Do not use the breakdown features when submitting Open the Status window and display the Output Report when it is ready

140
140 Exercise 11 : Tariff statistics Define and submit a query using the selections proposed in the next slide Include non traded products when submitting Include all types of tariffs Open the Status window and display the Output Report when it is ready

180
180 SMART: Dataset Definition Choose the importing market on which a tariff cut will be applied Choose a year Choose the product categories on which simulation will be applied. Output report will display information at the most detailed level (6 digits or Tariff line level)

181
181 SMART: Dataset Definition Save the dataset. You can reuse it later to apply new cut parameters.

182
182 SMART: Dataset Definition Step 1 is now completed as indicated by the checked box We can now go for step 2 by clicking on this button

183
183 SMART: Simulation Parameters Here we are going to specify tariff cut, affected products as well as beneficiaries

184
184 SMART: Simulation Parameters Here we are going to specify tariff cut, affected products as well as beneficiaries Click on Specific countries to get access to the country selection panel and select beneficiary countries

185
185 SMART: Simulation Parameters Affected products can be either all previously selected products in the dataset or only part of them. Here we choose to apply the tariff cut to all. Finally, we specify the cut type from the Custom rate adjustment panel. Here, since we consider a FTA we fix the new rate at 0. We next click on Apply to confirm the adjustment. Click on Done when all parameters are set.

186
186 SMART: Simulation Parameters Step 2 is now completed as indicated by the checked box WITS acknowledges the parameter definition Click this button to display the data table (Step 3 is optional)

187
187 SMART: Review Simulation Data Table This window allows to control that the parameters are properly set. Here we can see that tariff for El Salvador is indeed cut to 0.

188
188 SMART: The Results Results of the simulation are displayed using the View Options panel.

191
191 WITS in a nutshell Enormously powerful instrument for retrieving and analyzing data much more data than weve ever had before Great care needed in interpreting the meaning of the data and the analysis These are complex areas Helpful to trade negotiators, particularly in developing countries, as well as analysts Further development to come New databases to be included, including AVEs More simulation tools to be released

192
192 More about WITS ? The WITS information web site at: http://wits.worldbank.org/witsweb/