just-dividends banner

Watchlist

google-sheets-logo
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%
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 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 KMB Kimberly Clark Corp Consumer Staples 19.85 $135.94 $149.23 8.91% $110.66 22.84%
TSE PBH Premium Brands Holdings Corp Consumer Staples 37.04 $87.52 $102.68 14.76% $62.79 39.39%
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%
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 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 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%
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%
NYSE ED Consolidated Edison, Inc. Utilities 19.39 $75.38 $95.10 20.74% $62.03 21.52%
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%