EUROSTAT

Retrieve one monthly bilateral goods-trade series from Eurostat Comext: a reporting area, a partner, a product, a trade direction, and a value or quantity measure.

Syntax

series=EUROSTAT(reporter.partner.product.flow.measure.firstMonth.lastMonth)

Enter the seven fields as one dotted argument, without spaces or quoted strings. Month bounds use YYYYMM; both endpoints are included. The first month must precede or equal the last, and the last cannot be in the future.

FieldAccepted valueMeaning
reporterEurostat geographic code, such as DECountry or reporting area whose trade is recorded.
partnerEurostat geographic code, such as KZTrading partner. Use the Eurostat code, not a numeric Comtrade code.
productExact 2-, 4-, 6-, or 8-digit product codeHS or Combined Nomenclature product level supported by the selected dataset and period. Eight-digit codes are CN codes.
flowEXPORT or IMPORTExports by the reporter to the partner, or imports by the reporter from the partner.
measureVALUE or WEIGHTVALUE is in euros; WEIGHT is in units of 100 kg.
firstMonth, lastMonthYYYYMMRequested inclusive monthly window.

Worked example: Germany to Kazakhstan

Plot Germany's reported exports of product 854231 to Kazakhstan from January 2021 through December 2025.

deKz=EUROSTAT(DE.KZ.854231.EXPORT.VALUE.202101.202512)
deKz=SET_NAME(deKz,"Germany exports to Kazakhstan: product 854231")
chart=SET_TITLE(LINE_CHART(deKz),"Monthly exports to Kazakhstan (EUR)")
chart
Read the direction literally. DE.KZ...EXPORT measures exports reported by Germany to Kazakhstan. It does not measure Kazakhstan's onward exports to another country.

Result and availability

Use the series in a trade study

Start by inspecting monthly coverage, product definitions, and the country that reports each flow. For a difference-in-differences design, compare a treated route with a credible control using consistent product codes, direction, units, and reporting practices. Inspect pretreatment trends before interpreting the estimate. A rise in exports to a transit country is a trade pattern, not proof that an individual shipment violated sanctions.

Do not overlay raw currency values as though they were the same unit. This command reports VALUE in EUR; COMTRADE reports VALUE in USD. Likewise, Eurostat WEIGHT is in 100 kg while Comtrade weight is in kg. Align units and investigate reporting differences before comparing levels.

Common checks

SymptomWhat to check
Invalid trade codeUse a Eurostat geographic reporter and partner, an allowed product-code length, and EXPORT/IMPORT with VALUE/WEIGHT.
No observationsVerify that the reporter, partner, product and months are available. An absent month is not a measured zero.
COMTRADE failed: Invalid trade code: DEThe command dispatcher is routing EUROSTAT to COMTRADE; rebuild the module that contains OperatorOperationTool.

Source

Eurostat, International Trade in Goods (Comext) database and information on data, release timing, and revisions. Check Eurostat's product and country metadata when a definition matters to the research question.