ABCDEFGHIJKLMNOPQRS
1
Hot-Accounts Personal Finance
To import prices into Hot-Accounts:
2
100% free software
Select Ticker and Price Columns
3
https://www.hot-accounts.comand Press Ctrl+C
4
EXAMPLE Google Finance sheet
5
Adapt this workbook for your own use via File, Make a Copy
Note: you have to be logged on with a Google Account to get the 'Make a copy' option! Also keep your version private.
6
CompanySectorEPSP/EEXCHANGE:TICKERPRICEPrevClose%Chg52w low52w high200DMA%200DMA1Wk1Month3MonthsYTD1Yr3Yr5Yr
7
--- BEL-20 stocks
8
Ackermans & van Haaren
Construction & Engineering (NEC)
18.10 15.47 EBR:ACKB 280.00 269.60 3.86% 208.20 300.20 248.23 11.35%5.58%-2.30%4.63%20.38%26.01%80.18%108.49%
9
AedificaHealthcare REITs 11.49 6.16 EBR:AED 70.80 69.55 1.80% 59.50 80.05 68.86 2.74%4.27%3.36%-3.67%4.27%8.17%9.39%-34.83%
10
AgeasInsurance 9.09 7.32 EBR:AGS 66.60 65.85 1.14% 55.85 69.50 61.23 8.07%4.47%-2.99%10.72%9.45%17.77%74.53%34.93%
11
Anheuser Busch Inbev SABrewers 3.08 23.13 EBR:ABI 71.28 71.08 0.28% 48.87 72.48 59.13 17.05%5.01%2.30%11.97%31.03%15.04%36.24%10.32%
12
AperamIron, Steel Mills & Foundries 0.12 419.34 AMS:APAM 51.65 50.20 2.89% 24.32 53.85 36.78 28.78%0.29%6.76%53.90%38.55%89.61%54.92%9.04%
13
argenx SEBio Therapeutic Drugs 19.44 40.31 EBR:ARGX 783.60 775.60 1.03% 456.60 810.00 693.75 11.47%2.67%12.88%27.04%8.26%55.91%115.16%197.49%
14
Barco NVDisplay Screens 0.85 10.12 EBR:BAR 8.57 8.46 1.24% 8.44 15.08 11.33 -32.15%-0.58%-4.67%-14.98%-28.40%-33.31%-65.61%-64.32%
15
Cofinimmo BHealthcare REITs 5.32 15.61 EBR:COFB 83.10 81.75 1.65% 69.60 94.70 80.83 2.74%3.23%-1.60%-2.52%3.68%8.20%10.07%-36.52%
16
D'Ieteren NV
Auto Vehicles, Parts & Service Retailers
7.97 21.28 EBR:DIE 169.50 165.30 2.54% 143.60 199.90 166.84 1.57%5.34%-2.92%-1.45%9.64%-4.18%-2.02%66.67%
17
EliaElectric Utilities 5.51 24.68 EBR:ELI 135.90 134.90 0.74% 92.20 143.10 118.02 13.16%1.95%0.74%2.33%21.12%46.44%24.97%54.12%
18
Galapagos NV
Biotechnology & Medical Research
#N/A#N/AAMS:GLPG#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
19
GBLInvestment Holding Companies(5.33)#N/AEBR:GBLB 80.40 79.45 1.20% 70.25 85.65 78.23 2.69%-0.19%3.81%2.75%5.44%11.67%9.57%-14.72%
20
KBC GroepBanks 8.70 13.17 EBR:KBC 114.60 110.85 3.38% 83.58 125.30 109.34 4.59%2.28%0.70%8.06%0.97%36.14%80.08%68.48%
21
MelexisSemiconductors 2.75 29.28 EBR:MELE 80.60 81.15 -0.68% 48.60 86.70 62.95 21.90%-1.59%-0.12%50.65%37.19%22.31%-11.04%-10.54%
22
ProximusTelecom 1.23 5.30 EBR:PROX 6.53 6.54 -0.08% 6.13 8.77 7.21 -10.37%0.46%-1.36%-8.42%-8.67%-17.55%-9.31%-62.41%
23
SofinaInvestment Holding Companies 3.26 66.56 EBR:SOF 216.80 212.00 2.26% 203.60 283.03 237.65 -9.62%1.12%-0.73%-3.56%-12.30%-13.78%6.56%-37.88%
24
SolvayDiversified Chemicals(0.24)#N/AEBR:SOLB 26.80 26.28 1.98% 23.54 30.56 26.90 -0.39%3.47%-1.83%1.90%-1.98%-9.40%24.59%19.96%
25
UCB S.A.Biopharmaceuticals 8.02 34.26 EBR:UCB 274.90 271.00 1.44% 153.65 289.50 244.24 11.15%5.33%14.40%7.85%17.38%68.19%227.50%229.46%
26
Umicore SASpecialty Chemicals 1.60 14.16 EBR:UMI 22.64 21.84 3.66% 11.39 26.98 17.88 21.02%-1.82%-12.11%39.24%21.79%98.08%-18.94%-54.26%
27
WDPIndustrial REITs 1.63 13.56 EBR:WDP 22.16 21.74 1.93% 20.12 26.18 22.61 -2.03%4.04%-0.09%-6.26%0.54%6.95%-16.00%-31.60%
28
29
--- Other Stocks
30
Adidas AGConsumer Cyclical 7.79 22.65 ETR:ADS 176.35 173.30 1.76% 129.95 214.90 159.50 9.55%7.17%20.13%25.03%5.35%-11.83%0.94%-39.81%
31
AIRBUSIndustrial 6.34 28.28 EPA:AIR 179.28 175.26 2.29% 157.42 221.30 189.51 -5.71%1.31%3.79%5.48%-11.99%10.95%38.42%59.50%
32
Ahold Delhaize Retail 2.52 14.42 AMS:AD 36.37 36.20 0.47% 32.13 42.54 36.74 -1.03%2.83%-0.38%-13.92%4.30%1.45%22.54%46.65%
33
ABN AmroFinancials 2.55 13.58 AMS:ABN 34.67 33.60 3.18% 22.29 35.15 28.82 16.86%4.59%5.41%26.03%14.65%52.33%146.76%223.41%
34
VGPReal Estate 10.64 7.69 EBR:VGP 81.80 79.20 3.28% 76.60 111.20 95.92 -17.26%4.47%1.49%-12.61%-15.93%1.11%-13.07%-49.10%
35
ASMLIT Hardware 26.26 62.05 AMS:ASML 1,629.60 1,576.00 3.40% 587.80 1,629.60 1,068.83 34.41%7.59%19.21%36.09%65.22%145.20%139.05%182.08%
36
BASF SEChemicals 1.97 25.18 ETR:BAS 49.50 48.88 1.28% 40.97 55.05 46.97 5.10%1.33%-7.29%2.48%10.54%17.52%5.68%-26.38%
37
Bayer AGChemicals(2.19)#N/AETR:BAYN 36.19 35.79 1.12% 24.81 49.78 35.51 1.87%1.40%-5.21%-9.73%-4.76%31.70%-30.14%-31.99%
38
UnileverConsumer Goods#N/A#N/AAMS:UNA 50.80 50.44 0.71% 46.97 63.39 55.63 -9.51%4.79%4.10%-10.37%-8.42%-17.36%-2.83%-9.62%
39
VolkswagenAuto's en onderdelen 12.23 7.23 ETR:VOW3 88.42 85.42 3.51% 82.66 109.15 95.17 -7.64%0.59%-0.47%0.39%-16.94%-0.47%-32.88%-61.57%
40
41
--- US STOCKS
42
APPLETech 8.27 35.22 NASDAQ:AAPL 291.13 295.63 -1.52% 195.07 317.40 266.87 8.33%-3.45%-2.37%15.15%7.42%48.20%58.27%123.12%
43
Berkshire Hathaway Inc -B-Holding 50,389.75 0.01 NYSE:BRK.B 489.25 485.79 -1.52% 455.19 516.85 490.39 -0.23%0.46%1.07%-0.60%-1.53%0.35%45.65%72.56%
44
MICROSOFTTech 16.79 23.27 NASDAQ:MSFT 390.74 390.34 0.10% 356.28 555.45 453.73 -16.12%-5.10%-4.56%-2.30%-17.38%-17.73%15.83%50.35%
45
AMAZONTech 8.37 28.51 NASDAQ:AMZN 238.55 241.51 -1.23% 196.00 278.56 232.51 2.53%-2.72%-10.73%12.66%5.32%12.47%88.70%41.00%
46
Netflix incTech 3.09 25.96 NASDAQ:NFLX 80.34 81.27 -1.14% 75.01 134.12 99.21 -23.49%-2.78%-7.59%-15.61%-11.70%-33.72%82.22%60.71%
47
TESLATech 1.09 371.39 NASDAQ:TSLA 406.43 399.15 1.82% 288.77 498.82 415.69 -2.28%-0.62%-8.32%2.75%-7.22%24.94%58.27%97.39%
48
NVIDIA CorpIT Hardware 6.53 31.42 NASDAQ:NVDA 205.19 204.87 0.16% 140.85 236.54 189.26 7.76%-1.65%-12.96%11.99%8.65%44.53%377.19%1038.68%
49
ALPHABETIT Software en Diensten 13.11 27.44 NASDAQ:GOOGL 359.68 357.77 0.53% 162.07 408.61 307.94 14.38%-1.00%-10.32%17.71%14.13%105.92%190.84%193.74%
50
Eli Lilly & Co. Farma & Biotech 28.15 40.25 NYSE:LLY 1,133.00 1,160.95 -2.41% 623.78 1,182.73 958.45 15.41%-1.41%12.55%14.55%4.87%38.28%153.06%401.11%
51
CITIGROUPFinancial 8.07 17.33 NYSE:C 139.83 138.07 1.27% 76.11 141.12 112.39 19.63%4.91%12.03%30.26%17.80%83.12%189.86%86.04%
52
IBMIT Hardware & Software 11.31 24.08 NYSE:IBM 272.24 274.85 -0.95% 212.34 332.46 273.07 -0.31%-3.06%24.67%9.22%-6.61%-1.80%98.43%89.98%
53
JP Morgan Chase & CoFinancial 20.88 15.36 NYSE:JPM 320.72 313.49 2.31% 262.71 337.25 306.56 4.41%3.09%6.94%12.08%-1.46%21.05%126.67%103.54%
54
Johnson & Johnson IncPharma & Biotech 8.65 27.86 NYSE:JNJ 240.87 238.33 1.07% 149.04 251.71 214.61 10.90%3.75%4.36%-0.95%16.17%53.32%49.09%45.66%
55
Pfizer Inc Pharma & Biotech 1.31 20.03 NYSE:PFE 26.21 26.17 0.15% 23.11 28.75 25.86 1.34%2.30%1.79%-1.50%4.09%6.81%-33.41%-33.86%
56
Procter & Gamble CoGrocery 6.84 21.88 NYSE:PG 149.61 148.34 0.86% 137.62 167.25 149.09 0.35%3.11%4.83%-1.65%5.52%-6.66%2.18%10.90%
57
Salesforce IncSoftware (cloud) 8.64 19.19 NYSE:CRM 165.89 166.45 -0.34% 161.40 276.80 218.28 -31.58%-9.13%-1.01%-16.36%-34.59%-35.80%-20.78%-32.64%
58
59
---ETF's
60
iShares Core MSCI World UCITS ETFGlobal ETF stocks AC- - AMS:IWDA 122.81 120.89 1.59% 98.04 124.61 112.56 8.34%0.13%0.67%9.51%10.30%23.74%59.12%80.07%
61
iShares MSCI World EUR Hedged Global ETF stocks AC- - AMS:IWDE 116.18 113.80 2.09% 93.95 118.16 107.92 7.11%0.36%0.02%9.93%8.15%22.10%60.78%62.24%
62
iShares Core S&P 500 UCITS ETFS&P500 ETF stocks AC- - AMS:CSPX 691.34 680.78 1.55% 549.03 705.18 632.07 8.57%-0.31%0.02%10.58%10.70%24.76%64.15%94.94%
63
iShares S&P 500 EUR Hedged UCITS ETF (Acc) (EUR)S&P500 ETF stocks AC- - AMS:IUES 152.96 149.79 2.12% 123.76 156.73 142.44 6.88%0.03%-0.96%10.76%7.76%21.74%64.05%65.63%
64
65
SPDR S&P 500 ETF (SPY, USD)S&P500 ETF stocks AC- - NYSEARCA:SPY 741.75 737.76 0.54% 591.90 760.40 686.30 7.48%0.34%-0.86%10.87%8.57%24.25%69.67%74.42%
66
iShares Core S&P 500 ETF (IVV,USD)S&P500 ETF stocks AC- - NYSEARCA:IVV 745.14 741.05 0.55% 594.79 764.00 689.46 7.47%0.33%-0.85%10.90%8.59%24.23%70.20%75.01%
67
Vanguard S&P 500 ETF (VOO, USD)S&P500 ETF stocks AC- - NYSEARCA:VOO 681.95 678.23 0.55% 545.75 699.15 631.12 7.45%0.33%-0.84%10.85%8.54%24.27%69.81%74.38%
68
69
iShares Euro Aggregate Bond UCITS ETFBonds ETF DI- - AMS:IEAG 107.78 107.55 0.21% 105.71 110.46 108.19 -0.38%0.40%0.48%0.56%-0.60%-1.74%2.55%-15.23%
70
iShares Core Euro Corporate Bond Bonds ETF DI- - AMS:IEAC 119.94 119.64 0.25% 117.05 122.43 120.19 -0.21%0.33%0.55%1.15%-0.81%-1.21%3.57%-11.31%
71
Think iBoxx Corporate Bond UCITS ETFBonds ETF DI- - AMS:TCBT 16.86 16.83 0.20% 16.60 17.51 17.14 -1.67%0.36%-0.94%-0.47%-1.40%-1.06%4.85%-10.51%
72
ISHS EO H.YIELD CORP BD U.ETFHY Bonds ETF DI- - LON:IHYG 92.00 91.64 0.40% 88.19 95.04 92.38 -0.41%0.41%0.59%0.20%-1.22%-1.49%0.73%-11.17%
73
Shares Core U.S. Aggregate Bond ETF Bonds ETF DI- - NYSEARCA:AGG 98.76 98.88 -0.12% 97.52 101.46 99.87 -1.12%0.60%0.12%-0.84%-1.09%0.82%1.01%-14.08%
74
75
iShares MSCI Brazil UCITS ETF Brazil ETF DI- - AMS:IBZL 24.50 23.61 3.79% 18.51 28.80 23.88 2.54%4.57%-4.33%-5.37%9.96%27.14%0.25%-7.55%
76
iShares MSCI Emerging Markets UCITS ETF (Acc)EM ETF AC- - AMS:IEMA 56.20 54.46 3.20% 37.62 58.23 47.28 15.88%2.86%1.59%16.33%23.41%47.93%70.51%48.21%
77
iShares MSCI Turkey UCITS ETFTurkey ETF DI- - AMS:ITKY 18.96 18.84 0.63% 14.43 21.16 17.98 5.19%0.90%-8.05%-1.25%15.26%27.85%32.22%81.44%
78
ISHARES CORE DAX UCITS ETF Germany ETF AC- - BIT:EXS1 203.05 199.82 1.62% 181.06 211.30 200.12 1.44%-0.07%0.67%4.14%-0.05%4.26%48.47%52.42%
79
iShares EuroStoxx 50 UCITS ETFEurostoxx50 DI- - AMS:EUEA 63.43 62.09 2.16% 53.08 63.57 58.91 7.13%1.99%3.58%8.63%6.39%16.71%41.05%50.20%
80
Lyxor Stoxx Europe 600 (DR) - UCITS ETFEurostoxx600 AC- - EPA:MEUD 311.05 305.15 1.93% 254.25 312.25 286.55 7.88%1.87%2.91%7.51%8.26%19.45%48.37%59.41%
81
iShares Core MSCI Emerging Markets IMI UCITS ETFEM ETF AC- - AMS:EMIM 47.87 46.45 3.06% 32.69 49.50 40.62 15.15%3.03%1.44%15.91%22.34%44.93%67.67%49.55%
82
Lyxor UCITS ETF PEA MSCI World -C- SWITZERLAND ETF AC- - EPA:EWLD 39.61 38.98 1.61% 32.25 40.21 36.49 7.88%0.08%0.64%9.51%10.09%21.84%54.79%74.11%
83
LYXOR BEL 20 TR DR UCITS ETFBEL20 DI- - EBR:BEL 86.08 84.97 1.31% 65.75 86.37 77.27 10.23%3.10%4.30%13.31%13.40%28.23%57.80%36.70%
84
iShares STOXX Europe 50 UCITS ETFEUROPE 50 ETF DI- - AMS:EUNA#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
85
WT PHYSICAL SILVER (USD)SILVER ETF- - LON:PHAG#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A
86
87
---INDICES
88
Euro Stoxx 50Eurozone stocks- - INDEXSTOXX:SX5E 6,187.63 6,056.96 2.16% 5,154.83 6,202.40 5,774.40 6.68%2.07%4.26%7.82%5.76%16.96%41.40%49.72%
89
Dow Jones Industrial AverageDOW (US 30 largest)- - INDEXDJX:.DJI 51,202.26 50,848.75 0.70% 41,981.14 51,660.40 48,029.83 6.20%0.82%2.27%9.07%5.83%21.34%50.69%48.87%
90
S&P 500 IndexUS 500 largest- - INDEXSP:.INX 7,431.46 7,394.30 0.50% 5,943.23 7,620.90 6,877.17 7.46%0.35%-0.93%10.93%8.35%24.33%69.96%74.65%
91
NASDAQ-100US- non-financial- - INDEXNASDAQ:NDX 29,635.95 29,446.18 0.64% 21,532.32 30,762.20 25,698.49 13.29%0.75%0.19%20.20%17.57%37.01%97.50%109.76%
92
DAX40Germany, 30 largest- - INDEXDB:DAX 24,635.30 24,209.71 1.76% 21,863.81 25,507.79 24,181.75 1.84%0.08%0.73%4.55%0.39%4.76%51.04%57.18%
93
BEL-20Belgium 20 largest- - INDEXEURO:BEL20 5,737.19 5,646.87 1.60% 4,383.99 5,738.75 5,187.52 9.58%3.39%3.70%11.86%12.22%28.17%56.50%35.93%
94
AEXNetherlands, 30 largest- - INDEXEURO:AEX 1,081.18 1,063.08 1.70% 882.42 1,081.18 979.41 9.41%3.46%5.84%7.28%11.74%17.19%40.16%48.09%
95
CAC40France 40 largest- - INDEXEURO:PX1 8,350.87 8,200.79 1.83% 7,505.27 8,642.23 8,095.40 3.06%1.85%3.32%5.23%1.90%8.67%13.95%26.22%
96
FTSE100UK, 100 largest- - INDEXFTSE:UKX 10,471.72 10,303.88 1.63% 8,707.65 10,934.94 9,985.69 4.64%0.95%0.95%1.49%5.23%18.32%37.74%46.53%
97
98
---US MUTAL FUNDS
99
Vanguard Total Stock Market Index Fund Investor Shares Vanguard- - MUTF:VTSMX 177.48 - 1.88%- - 164.25 7.45%0.05%-0.74%10.70%8.41%24.23%67.75%64.84%
100
Fidelity® Contrafund®Fidelity- - MUTF:FCNTX 25.87 - 1.81%- - 24.64 4.77%0.15%-1.15%8.93%6.16%16.43%76.83%40.75%