SAMPLE FILE - Thailand Imports of Virgin Olive Oil

SAMPLE FILE - Thailand Imports of Virgin Olive Oil
The purpose of this paper is to show what sort of typical analytical tables and charts are available in a standard
TradeData Excel file for any product imported into Thailand. The product chosen was Virgin Olive Oil. Similar
information is available for any product. The information is supplied in Excel file format and the file is designed to
enable efficient analysis of the underlying statistics. At the end of this paper there is listed two typical imports
transactions to demonstrate the underlying imports information that is available in TradeData’s standard Excel file.
Table – Top Ten Origin Countries
The following table comes directly out of our standard excel file and shows – monthly –the top ten supply countries
in terms of volumes per month as well as average prices by country per month. This table provides a convenient
summary of month to month movements in imports. TradeData will normally supply the current year and five years
of back data in its data files. However if more data is required, in most cases, we can supply at no extra charge.
Quantity
Apr-13 CIF per (All)
Quantity
$3.31
53,225.0
$3.32
106,400.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
$3.45
9,000.0
$3.44
6,000.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
$5.19
17,436.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
Belgium
Japan
Un Arab
Emir
Greece
France
Australia
U.K.
Turkey
$6.95
9,099.0
$6.38
20,368.0
$6.80
19,480.0
$5.71
22,384.0
$6.58
505.0
$6.92
387.0
$6.32
1,512.0
$5.63
785.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
#DIV/0!
0.0
Total
Quantity
Mar-13 CIF per (All)
$4.09
67,167.0
$3.99
8,440.0
$4.58
120,856.0
$4.43
110,953.0
Others
Quantity
Spain
Jan-13 CIF per (All)
Feb-13 CIF per (All)
Italy
Top 10 Origin Countries for Thailand Imports
$4.14
233.0
$4.00
0.0
$4.60
1,666.0
$4.45
1,600.0
$4.01
130,229.0
$3.83
135,595.0
$4.83
152,514.0
$4.68
159,158.0
Details
There is a worksheet in the excel file that lists origin country and average prices each month. A small sample is
below.
Date
Data
Sum of Quantity1
Sum of Value_CIF
11,404
$54,203.19
10,620
$36,936.02
15
$90.25
0
$31.09
7,209
$36,155.19
6,552
$26,345.83
630
$5,133.35
Partner_Country_strd
Apr-13 Spain
Italy
U.K.
Turkey
Mar-13 Italy
Turkey
Australia
$US
Unit Price
$4.75
$3.48
$6.02
$5.02
$4.02
$8.15
Price and Quantity
The next chart show monthly movement in imports volumes (the blue shaded area of the chart), and in average
prices (the red line).
$US per KG
$30.00
China Imports of Olive oil and its fractions; whether or not refined; but not
chemically modified: virgin : in packing of net weight not exceeding 30 kg
KGM
45,000
40,000
$25.00
35,000
$20.00
30,000
25,000
$15.00
20,000
15,000
$10.00
10,000
$5.00
5,000
$0.00
8
0
n
aJ
8 8 8 8 8 8 8 8 9 9 9 9
8 8
8 0
0
0
0
0 0 0 0 0 0
0
- 0
- 0
- 0
- 0
l- - - t-c v- c- n
r- -r y- n
r- rb
a u Ju gu p
eF a p
e o e a b
e a p
A S O N D J F MA
MA M J
Quantity - KGs
9 9 9 9 9 9 9 9 0 0 0 0
0
0
0 0
0 0 1
1
- 0
- 0
- 1
- 1
l- -g p
t- v- c- n
r- ry-a n
e c oe a b
e a p
u Ju u
A S O N D J F MA
MJ
0 0 0 0 0 0 0
1
1
1 1
1
- 1
- 1
l- -g p
t- vy-a n
e c o
u Ju u
A S ON
MJ
1
0 1
1
c-e n
a
DJ
1 1 1 1 1 1 1
1 1
1 1
1
1
1
1 1 1 1
- 1
- 1
l- - - t-c vr- -r y- n
b
a u Ju gu p
eF a p
e o
A S ON
MA MJ
2
1 1
1
c-e n
a
DJ
2 2 2 2 2 2 2
2 2
2 1
1
1
1
1 1 1 1
- 1
- 1
l- - - t-c vr- -r y- n
b
a u Ju gu p
eF a p
e o
AS ON
MA MJ
3
2 1
1
c-e n
a
DJ
3 3
3
1
1
- 1
r- -r
b
eF a p
MA
-
CIF Unit Price - $US per KGM
TradeData International Pty Ltd – see www.tradedata.net for more details or ring +613 9785 7977
The excel file enables the user to select a particular supply country and then redraw this Price&Quantity chart only
including imports from the selected country. The chart below lists Price and Quantity where imports only from
Australia are selected.
Average Prices – Top Six Supply Countries over Time
The following chart list average prices over time for the Top 6 supply countries to Thailand.
Average Prices - Top 6 Origin Countries - Olive oil and its fractions; whether or not refined;
$USD per KG
but not chemically modified: virgin : in packing of
net weight not exceeding 30 kg
$25.00
$20.00
$15.00
$10.00
$5.00
$0.00
8
-0
n
Ja
8 8 8
0
-0 0
b r-a -rp
Fe M A
Italy
8 8 8 8
0
0
-0
- 0
l- gy n
a Ju u
J u
A
M
8 8 8 8 9
-0 0
-0 0 -0
p ct- vo c-e n
Se O N D Ja
Spain
9 9 9
0
-0 0
b r-a -rp
Fe M A
Turkey
9 9 9 9
0
0
-0
- 0
l- gy n
a Ju u
J u
A
M
9
-0
p
Se
U.K.
9
0
ct
O
9 9 0
0 1
-0
v c- -n
o e a
N D J
0 0 0
1
-1 1
b r-a -rp
Fe M A
Australia
0 0
1
-1
y n
a Ju
M
0 0 0
0
1
1 1 1
l- g- -p tu
J u Se cO
A
France
0 0 1 1
1 1 1
-1
v c- -n -b
o e a e
N D J F
1 1 1
1
1
1 1 1
r- r- -y n
a p a u
M A M J
1 1 1
1
1
1 1 1
l- g- -p tu
J u Se cO
A
1 1 2 2
1 1 1
-1
v c- -n -b
o e a e
N D J F
Total
Major Supply Countries
The following two charts list annually the top ten supply countries to Thailand both in volume and value terms. This
chart draws the major supply countries market shares over time.
Thailand Imports of Olive oil and its fractions; whether or not refined; but not
chemically modified: virgin : in packing of net weight not exceeding 30 kg by
Quantity
KGM
300,000
250,000
200,000
150,000
100,000
50,000
-
2008
2009
2010
2011
Italy
Spain
Turkey
U.K.
Australia
France
2012
2013
Up to
Apr-13
TradeData International Pty Ltd – see www.tradedata.net for more details or ring +613 9785 7977
Thailand Imports of Olive oil and its fractions; whether or not refined;
but not chemically modified: virgin : in packing of net weight not
$USD
exceeding 30 kg by Value
1,600,000
1,400,000
1,200,000
1,000,000
800,000
600,000
400,000
200,000
2008
2009
2010
2011
Italy
Spain
Turkey
Australia
France
Greece
Japan
Others
2012
2013
Up to Apr-13
U.K.
Market Segments
The following chart lists a Price Histogram by Country. This shows that during 2012 the volumes imported at
different price points and which major supply country supplied at these price points. Spain and Italy are the two
largest export countries to Thailand. Italy tends to supply larger volumes usually at higher prices than Spain. The
Excel file enables the user to select different years and to the chart will redraw itself accordingly.
KGM
Price Histrogram - (All) Imports of Olive oil and its fractions; whether or not refined; but not
chemically modified: virgin : in packing of net weight not exceeding 30 kg
100,000
90,000
2012
80,000
70,000
60,000
50,000
40,000
30,000
20,000
10,000
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
$USD per Kilogram
Italy
Australia
Spain
U.K.
Greece
Grand Total
TradeData International Pty Ltd – see www.tradedata.net for more details or ring +613 9785 7977
Two Typical Transactions
The following table list two typical data transactions as found in the Thailand Imports data set.
Code
TradeType
Year
Month
Description
15091010000
Import
2013
04
Olive oil and its fractions;
whether or not refined; but
not chemically modified:
virgin : in packing of net
weight not exceeding 30 kg
15091010000
Import
2013
04
Olive oil and its fractions;
whether or not refined; but
not chemically modified:
virgin : in packing of net
weight not exceeding 30 kg
Reporting_Country
Reporting_Country_Strd
Partner_Country
Partner_Country_Strd
Value Unit
Value
Value_AUD
Value_EURO
Value_USD
Quantity1 Unit
Quantity1
Quantity2 Unit
Quantity2
Thailand
Thailand
ITALY
Italy
Baht
Thailand
Thailand
SPAIN
Spain
Baht
1,073,900
$35,595
28,356
$36,936
KGM
1,575,936
$52,236
41,612
$54,203
KGM
10,620
0
11,404
0
TradeData International Pty Ltd – see www.tradedata.net for more details or ring +613 9785 7977