Watchlist
Creating a Watchlist in Google Sheets
Regardless of your investment strategy, you may want to track and watch
potential investment opportunities using a watchlist. A watchlist will help you to make informed
and
faster decisions when you are able to deploy your money in the market.
This article will
guide you on how to set up a watchlist covering multiple international exchanges and introduce
you to basic formulas to track your investments in Google Sheets using the Google Finance API.
| Exchange | Ticker | Name | Sector | PE-Ratio | Price | 52-Week-High | From High | 52-Week-Low | From Low |
|---|---|---|---|---|---|---|---|---|---|
| TSE | ATD.B | Alimentation Couche-Tard Inc Class B | Consumer Discretionary | 16.7 | $41.77 | $46.10 | 9.39% | $30.40 | 37.40% |
| NYSE | CHD | Church & Dwight Co., Inc. | Consumer Discretionary | 27.42 | $73.08 | $80.99 | 9.77% | $47.98 | 52.31% |
| NYSE | DPZ | Domino's Pizza, Inc. | Consumer Discretionary | 36.2 | $378.15 | $394.99 | 4.26% | $220.90 | 71.19% |
| NASDAQ | HAS | Hasbro, Inc. | Consumer Discretionary | 22.65 | $74.30 | $126.87 | 41.44% | $41.33 | 79.77% |
| NYSE | MCD | Mcdonald's Corp | Consumer Discretionary | 24.78 | $189.17 | $221.93 | 14.76% | $124.23 | 52.27% |
| TSE | MRU | Metro, Inc. | Consumer Discretionary | 19.94 | $57.41 | $61.74 | 7.01% | $48.60 | 18.13% |
| NYSE | PM | Philip Morris International Inc. | Consumer Discretionary | 14.35 | $70.42 | $90.17 | 21.90% | $56.01 | 25.73% |
| NYSE | VFC | VF Corp | Consumer Discretionary | 45.74 | $61.25 | $100.25 | 38.90% | $45.07 | 35.90% |
| NYSE | BF.B | Brown-Forman Corporation Class B | Consumer Staples | 37.9 | $65.25 | $72.85 | 10.43% | $44.68 | 46.04% |
| NYSE | CPB | Campbell Soup Company | Consumer Staples | 9.33 | $47.07 | $57.54 | 18.20% | $39.24 | 19.95% |
| NYSE | CLX | Clorox Co | Consumer Staples | 30.08 | $205.12 | $214.26 | 4.27% | $144.12 | 42.33% |
| NYSE | CL | Colgate-Palmolive Company | Consumer Staples | 24.81 | $72.79 | $77.41 | 5.97% | $58.49 | 24.45% |
| NYSE | HRL | Hormel Foods Corp | Consumer Staples | 27.46 | $46.67 | $51.53 | 9.43% | $39.01 | 19.64% |
| NYSE | KMB | Kimberly Clark Corp | Consumer Staples | 19.85 | $135.94 | $149.23 | 8.91% | $110.66 | 22.84% |
| OTHER | LRLCY | L OREAL S A/ADR | Consumer Staples | 0 | $59.59 | $61.25 | 2.71% | $43.46 | 37.11% |
| TSE | MFI | Maple Leaf Foods Inc | Consumer Staples | 170.2 | $28.21 | $35.82 | 21.25% | $17.04 | 65.55% |
| NYSE | MKC | McCormick & Company, Incorporated | Consumer Staples | 31.96 | $166.54 | $180.38 | 7.67% | $112.23 | 48.39% |
| TSE | PBH | Premium Brands Holdings Corp | Consumer Staples | 37.04 | $87.52 | $102.68 | 14.76% | $62.79 | 39.39% |
| NYSE | TSN | Tyson Foods, Inc. | Consumer Staples | 11.48 | $62.20 | $94.24 | 34.00% | $42.57 | 46.11% |
| NYSE | AXP | American Express Company | Financials | 15.4 | $101.68 | $138.13 | 26.39% | $67.00 | 51.76% |
| TSE | GWO | Great-West Lifeco Inc | Financials | 10.85 | $23.80 | $35.60 | 33.15% | $18.88 | 26.06% |
| NYSE | MSCI | Msci Inc | Financials | 51.44 | $320.95 | $356.66 | 10.01% | $206.82 | 55.18% |
| NASDAQ | NDAQ | Nasdaq Inc | Financials | 26.33 | $115.15 | $121.61 | 5.31% | $71.66 | 60.69% |
| TSE | NA | National Bank of Canada | Financials | 10.15 | $60.99 | $75.01 | 18.69% | $38.67 | 57.72% |
| TSE | POW | Power Corporation of Canada | Financials | 10.56 | $23.86 | $35.15 | 32.12% | $17.47 | 36.58% |
| TSE | RY | Royal Bank of Canada | Financials | 11.7 | $91.35 | $109.68 | 16.71% | $72.00 | 26.88% |
| OTHER | SKVKY | SKANDINAVISKA E/S ADR | Financials | 0 | $8.39 | $10.65 | 21.22% | $5.86 | 43.17% |
| TSE | X | TMX Group Ltd | Financials | 28.49 | $128.93 | $141.20 | 8.69% | $84.50 | 52.58% |
| NYSE | BDX | Becton Dickinson and Co | Healthcare | 68.73 | $230.88 | $286.72 | 19.48% | $197.75 | 16.75% |
| OTHER | CLPBY | COLOPLAST A S/S ADR | Healthcare | 0 | $15.71 | $17.22 | 8.77% | $11.13 | 41.15% |
| NYSE | DHR | Danaher Corporation | Healthcare | 38 | $168.38 | $174.52 | 3.52% | $119.60 | 40.79% |
| NYSE | FMS | Fresenius Medical Care AG & Co. | Healthcare | 18.41 | $41.94 | $44.30 | 5.33% | $29.17 | 43.78% |
| NYSE | GSK | GlaxoSmithKline plc | Healthcare | 14.96 | $40.42 | $48.25 | 16.23% | $31.43 | 28.60% |
| NYSE | PHG | Koninklijke Philips NV | Healthcare | 34.92 | $45.22 | $50.78 | 10.95% | $30.50 | 48.26% |
| NYSE | MDT | Medtronic PLC | Healthcare | 26.3 | $93.21 | $122.15 | 23.69% | $72.13 | 29.23% |
| NYSE | NVS | Novartis AG | Healthcare | 16.1 | $84.35 | $99.84 | 15.51% | $69.18 | 21.93% |
| NYSE | NVO | Novo Nordisk A/S | Healthcare | 24.98 | $64.61 | $66.96 | 3.51% | $47.25 | 36.74% |
| OTHER | RHHBY | Roche Holdings AG Basel ADR Common Stock | Healthcare | 24.93 | $42.79 | $46.00 | 6.98% | $25.10 | 70.48% |
| NYSE | SYK | Stryker Corporation | Healthcare | 32.97 | $187.79 | $226.30 | 17.02% | $124.54 | 50.79% |
| NASDAQ | GRMN | Garmin Ltd. | IT | 18 | $91.67 | $105.58 | 13.17% | $61.04 | 50.18% |
| NASDAQ | NVDA | NVIDIA Corporation | IT | 66.7 | $357.30 | $380.00 | 5.97% | $142.84 | 150.14% |
| NYSE | ORCL | Oracle Corporation | IT | 16.33 | $51.86 | $60.50 | 14.28% | $39.71 | 30.60% |
| NYSE | SAP | SAP SE | IT | 32.36 | $130.14 | $140.67 | 7.49% | $90.90 | 43.17% |
| NYSE | SNE | Sony Corp | IT | 15.82 | $68.29 | $73.86 | 7.54% | $49.39 | 38.27% |
| NYSE | APD | Air Products & Chemicals, Inc. | Industrials | 26.85 | $235.04 | $257.01 | 8.55% | $167.43 | 40.38% |
| NYSE | CSL | Carlisle Companies, Inc. | Industrials | 15.59 | $123.91 | $169.86 | 27.05% | $97.55 | 27.02% |
| NYSE | CAT | Caterpillar Inc. | Industrials | 13.05 | $123.15 | $150.55 | 18.20% | $87.50 | 40.74% |
| NASDAQ | CTAS | Cintas Corporation | Industrials | 30.23 | $266.20 | $304.81 | 12.67% | $154.33 | 72.49% |
| NYSE | DE | Deere & Company | Industrials | 17.57 | $154.97 | $181.99 | 14.85% | $106.14 | 46.01% |
| NYSE | ETN | Eaton Corporation PLC | Industrials | 16.89 | $86.01 | $105.78 | 18.69% | $56.42 | 52.45% |
| NASDAQ | FAST | Fastenal Company | Industrials | 28.72 | $40.06 | $43.20 | 7.27% | $26.72 | 49.93% |
| NYSE | FDX | FedEx Corporation | Industrials | 0 | $132.72 | $178.50 | 25.65% | $88.69 | 49.64% |
| TSE | FTT | Finning International Inc. | Industrials | 11.42 | $18.75 | $25.85 | 27.47% | $10.59 | 77.05% |
| TSE | GFL | GFL Environmental Inc | Industrials | 0 | $24.50 | $28.56 | 14.22% | $16.85 | 45.40% |
| NASDAQ | GNTX | Gentex Corporation | Industrials | 16.51 | $26.71 | $31.27 | 14.58% | $19.48 | 37.11% |
| NYSE | LHX | L3Harris Technologies Inc | Industrials | 27.93 | $193.15 | $230.99 | 16.38% | $142.01 | 36.01% |
| NYSE | LEG | Leggett & Platt, Inc. | Industrials | 13.98 | $32.82 | $55.42 | 40.78% | $22.03 | 48.98% |
| NYSE | RSG | Republic Services, Inc. | Industrials | 24.19 | $81.73 | $100.91 | 19.01% | $65.37 | 25.03% |
| TSE | SIS | Savaria Corporation | Industrials | 23.36 | $12.70 | $14.92 | 14.88% | $7.31 | 73.73% |
| OTHER | SIEGY | Siemens AG | Industrials | 19.68 | $55.66 | $66.74 | 16.60% | $31.62 | 76.03% |
| NYSE | SWK | Stanley Black & Decker, Inc. | Industrials | 21.45 | $131.09 | $173.67 | 24.52% | $70.00 | 87.27% |
| NYSE | WM | Waste Management, Inc. | Industrials | 26.34 | $103.89 | $126.79 | 18.06% | $85.34 | 21.74% |
| NYSE | LYB | LyondellBasell Industries NV | Materials | 8.5 | $66.61 | $98.91 | 32.66% | $33.71 | 97.60% |
| NYSE | AMT | American Tower Corp | REITs | 60.38 | $258.08 | $269.25 | 4.15% | $174.32 | 48.05% |
| NYSE | DLR | Digital Realty Trust, Inc. | REITs | 48.68 | $136.00 | $158.36 | 14.12% | $105.00 | 29.52% |
| TSE | NWH.UN | NorthWest Health Prop Real Est Inv Trust | REITs | 11.1 | $10.95 | $13.35 | 17.98% | $6.27 | 74.64% |
| NYSE | OHI | Omega Healthcare Investors Inc | REITs | 19.06 | $30.29 | $45.22 | 33.02% | $13.33 | 127.23% |
| NYSE | PSTL | Postal Realty Trust Inc | REITs | 0 | $15.95 | $19.48 | 18.12% | $10.84 | 47.14% |
| NYSE | PSA | Public Storage | REITs | 26.71 | $196.47 | $266.76 | 26.35% | $155.37 | 26.45% |
| NYSE | STAG | Stag Industrial Inc | REITs | 38.79 | $27.67 | $33.48 | 17.35% | $17.54 | 57.75% |
| NYSE | AWK | American Water Works Company Inc | Utilities | 36.45 | $127.29 | $141.70 | 10.17% | $92.00 | 38.36% |
| TSE | BIP.UN | Brookfield Infrastructure Partners L.P. | Utilities | 68.24 | $54.66 | $74.66 | 26.79% | $37.45 | 45.95% |
| NYSE | ED | Consolidated Edison, Inc. | Utilities | 19.39 | $75.38 | $95.10 | 20.74% | $62.03 | 21.52% |
| NYSE | D | Dominion Energy Inc | Utilities | 38.75 | $83.15 | $90.89 | 8.52% | $57.79 | 43.88% |
| NYSE | DUK | Duke Energy Corp | Utilities | 17.11 | $86.74 | $103.79 | 16.43% | $62.13 | 39.61% |
| NYSE | PPL | PPL Corp | Utilities | 10.81 | $26.55 | $36.83 | 27.91% | $18.12 | 46.52% |