Help - Trade By Product (HS)

Main Panel

The Main Panel is used to specify the selections upon which reports are based.

The panel shown below is to specify the following:

Trade Type

Total Imports, Total Exports, Domestic Exports, Re-Exports or Trade Balance.

Definitions of trade types.

top of page

Trader

All Canada, Individual Provinces, Canadian Regions or United States.

Definitions of trader.

top of page

Value in

$ Canadian, $ U.S. or Percentage of total.

Information pertaining to values.

top of page

The panel shown below is to specify the following:

Time Period

Annual Trends: Latest 5 or 10 years, Specific Years; Year to Date (YTD) - Current Year vs. Previous Year; or Latest 24 Months.

Definitions of time periods.

top of page

Trading Partner

All Countries (Total or Detailed), Top 10 Countries, Individual Countries or Pre-defined Country Groupings (based on continents, regions or economic association).

Individual U.S States, U.S. regions and Distribution by U.S. State will appear in the list for Canadian trade (i.e. when the trader is Canada or a Canadian province). This is not available here for U.S. trade with other countries (i.e. when the trader is the U.S.).

Definitions of trading partners.

top of page

Product Search

Total - All Products, Top 25 Chapters (HS2 codes), Top 25 Product Groups (HS4 codes), Top 25 Products (HS6 codes) or Specific Products chosen by means of: Keyword Search, Code Search or Browse List.

Information pertaining to product selection(s).

top of page

Immediately below the panel is the button used to activate the operation described below:

Run Report

Generates reports that can be printed, bookmarked (for re-use) or for which data can be downloaded as a comma-delimited (CSV) file or an Excel Speadsheet file.

top of page

Products (HS) Sample Report Help

Report Header

Outlines the selections made in the Main Panel with respect to trade type, trader, trading partner, time period, and product.

The geographic selections will be expressed in terms of origin and destination for greater clarity.

Please note that units will reflect the choice of currency and that any rounding will be indicated, e.g. Value in Thousands of Canadian Dollars; Value in Millions of U.S. Dollars, etc.

Title	Canadian Total Exports
Products	Total for All Products
Origin	---- Nova Scotia
Destination	Portugal Spain
Period	Latest 5 Years
Units	Value in Thousands of Canadian Dollars

top of page

Report Body

The report body presents the requested data in tabular format.

The time periods (years or months) appear vertically in columns, while the geographic information appears horizontally in rows.

A sub-total is displayed for the selected geographic areas as well as the total for all countries. The balance for other geographic areas not selected will be shown as "others".

When a geographic group is selected, the countries in the group will be listed (even where there is no trade) in full in vertical fashion provided you have chosen the group (Detailed) selection. Choose the group (Total) if you only want to display the summed values for the countries in the group.

When more than one specific product is chosen, the data for each can be shown individually in sequential fashion.

The report body may contain hyperlinked geographic selections. Clicking on these displays detail for the U.S. states or for the countries in a pre-defined geographic group.

Caution:

1. When Top 10 Countries is selected with multiple product selections shown individually, the determination of the top countries is made on the combined totals for all the products together.
2. When "Distribution by Province" is selected as the trader, the report body will always show a provincial breakdown, no matter what the trading partner selection is. However, the numbers will reflect the choice of trading partner made. In this case only, the same results will be obtained for country groups whether the (Total) or (Detailed) selection is made.

An example of a simple report is shown below:

	2007	2008	2009	2010	2011
Germany	3,865	4,484	3,734	3,937	3,955
Hong Kong	1,551	1,771	1,494	1,880	2,967
SUB-TOTAL	407,683	432,905	320,604	358,026	401,455
OTHERS	42,638	50,583	39,150	41,274	46,046
TOTAL (ALL COUNTRIES)	450,321	483,488	359,754	399,300	447,501

top of page

Report Footer

Underneath the report body, the data source will be displayed.

Below this, the following action buttons and instructions will appear:

Save Data to File

The first function generates a comma-delimited (CSV) text file that can then be saved to your desktop for further manipulation in a spreadsheet or other desktop software. The second function will save the report as an Excel Spreadsheet file.

top of page

Share this Page

This feature allows the user to send their reports to their e-mails or a multitude of social media networks such as Facebook, Twitter, Blogger, Digg, LinkedIn, and Delicious.

top of page