How to find the macro trade data of each trading country?

Release time 2020-05-21 09:33:43 84 times viewed
To do market research and analysis, we need to analyze from a macro and micro perspective. From a macro perspective, the more important part is the trade data. In the trade data section, this article introduces you a very useful database that our foreign traders need to use, called the UN Commodity Trade Statistics Database (UN Commodity Trade Statistics Database), referred to as UN Comtrade Database. This is a more authoritative data platform launched by the United Nations.

Here is a brief introduction to the UN Comtrade Database. It was created by the United Nations Statistics Department and provides more than 200 countries and regions each year to provide the United Nations Statistics Office with the official annual commodity trade data of the local countries, which covers 99% of global commodity transactions, collecting more than 6,000 commodities, about 1.7 billion Data records. In other words, it is the world's most authoritative commodity data resource with the largest amount of commodity data. Its characteristic is that it truly reflects the trend of international commodity flows and conforms to standardization. The data reported by countries and regions are converted to a standardized format by the United Nations statistics office, all the values of goods are converted to dollars, and the quantities of goods are converted to metric units.

So how should we find this commodity trade statistics database?Enter UN Comtrade Database in Google, then you can find its official website.



The home page of this website is like this, showing various statistics. Let's take a look that there is a Dashboard (control panel) on the right. Then we first look at Data Availability (available data).

Data Availability 


You can see that the left side is equivalent to a quick lookup list, a quick view of the target country. 

Just to give you a brief introduction. Let's look at the categories in the list first. One column is Merchandise, and the other column is Services. Below A represents Annual and M represents Month. The leftmost column is the name of the country or region. This table mainly tells us the type of data each country has submitted and the date of update. (Most of our foreign trade have contacted are mainly commodity trade. Of course, let alone there are some technical services import and export.)



Argentina, for example, has updated its annual data to 2018 and its monthly data to June 2019, which means that once its data for the second half of the year, from July to December, has completed, it will be ready to submit data for the whole of 2019. At this point, Argentina's 2019 data will be available.

 

Another example is China, which has submitted its annual statistics to 2018 (it is now 2020). China has not yet submitted its statistics for 2019 to the UN statistics office. The statistics for 2019 are usually submitted at the end of 2020. Therefore, the annual statistics of China we see now only go to 2018, and the monthly report is only submitted to December 2017.

After briefly explaining the list on the left, let's look at the right. Check the Country/Area to check the Country data that you want to query. The page will screen the corresponding Country data, and the list on the left will also screen the corresponding Country information.



Next, I will talk about another query tool, UN Comtrade Analytics.

UN Comtrade Analytics
Also from the Dashboard into the data analysis page, we can see the statistics showing the exports/imports of different countries.


As you can see here, the data analysis tool quickly presents the corresponding country data in the form of various charts. From the macro data, we can see China's goods and exports to other countries in 2017.



From Destination of exports, we can see the top ten Destination countries for exports. According to the statistics of trading countries, the top ten trading partners of China's exports in 2016 can be analyzed.


Then from Main export flows, we can see China's export volume and what kind of products account for the large proportion of exports, the ranking of products mainly exported, etc., such as Elec MCH apparpartsnes, mainly exported to Eastern Asia... 



The trade data from the macro perspective can truly reflect the trend of international commodity flows, and provide data sources and reference values for us when we analyze the import and export data of each trading country and do market research.