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	237.58	USD	0.86	204.22	204.22
3	JD.com	HKG:9618	100	118.4	HKD	0.11	13.10	1,309.83
4	Heineken	AMS:HEIA	30	70.86	EUR	1.00	70.86	2,125.80
5	L'Oreal	EPA:OR	7	359.1	EUR	1.00	359.10	2,513.70
6	Novo Nordisk	CPH:Novo-B	25	318.65	DKK	0.13	42.67	1,066.69
7	Investor AB	STO:INVE-B	130	320.6	SEK	0.09	29.33	3,812.34
8	Commonwealth bank	ASX:CBA	35	157.73	AUD	0.56	88.79	3,107.52
9	Barrick gold corp	TSE:ABX	110	51.11	CAD	0.61	31.33	3,446.66
10
11							Total:	17,586.76	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.86
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