Stock prices in local currency

	A	B	C	D	E	F	G	H	I
1	Name	Ticker	Quantity	Price	Currency	Exchange rate	Price in local currency	Total in local Currency
2	Amazon	NASDAQ:AMZN	1	219.78	USD	0.85	187.81	187.81
3	JD.com	HKG:9618	100	132.5	HKD	0.11	14.49	1,449.31
4	Heineken	AMS:HEIA	30	65.98	EUR	1.00	65.98	1,979.40
5	L'Oreal	EPA:OR	7	366.9	EUR	1.00	366.90	2,568.30
6	Novo Nordisk	CPH:Novo-B	25	348.5	DKK	0.13	46.69	1,167.31
7	Investor AB	STO:INVE-B	130	288.1	SEK	0.09	26.16	3,400.34
8	Commonwealth bank	ASX:CBA	35	164.88	AUD	0.56	92.24	3,228.33
9	Barrick gold corp	TSE:ABX	110	48.06	CAD	0.61	29.46	3,240.33
10
11							Total:	17,221.12	EUR
12
13
14
15
16	Base currency:	EUR
17
18	Currencies	Rate
19	AUD	0.56
20	CAD	0.61
21	DKK	0.13
22	EUR	1.00
23	HKD	0.11
24	SEK	0.09
25	USD	0.85
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100