1600-1700 stocks watchlist in Google Sheets. Global. : stocks


Hello everyone,

I’ve been working on my stock watchlist for quite some time now. Sharing an access to it through Google Sheets:

Here are a few things before you click on the link:

· It’s a huge watchlist created in Google Sheets with lots of formulas. It takes time and RAMs to load. (I am personally using 11th Gen Intel i7-11800h with 16GB of RAM with 34” monitor. My browser takes few minutes to load the whole watchlist)

· You’ll find there around 1600-1700 stocks from whole world sorted into 11 Stock Market Sectors.

· On the very top you’ll find daily gainers (top 5) and decliners (top 5)

· On every company you’ll find following information:

  1. Logo

  2. Company’s name. A lot of companies have notes included (my personal notes; notes on which money manager bought/sold this stock, when and how much he paid for it; etc.). I am updating this information on a daily basis.

  3. Dividend yield with notes on historical payments. Yield changes daily based on stock price change.

  4. My SUBJECTIVE PE based on average few years income. I left “-” symbol where I have no idea what PE to designate for a specific company at the moment. This the most controversial part of the whole watchlist. Lots of you will think that some of my designated PE’s are too high while others – too low. But I want to emphasize this – this is MY subjective view. Of course it will differ from yours. 😊

  5. % of up from yearly low

  6. % of down from yearly high

  7. Stock price

  8. Graph of historical price changes (2y)

  9. Graph of historical price changes (7y – to have a bigger perspective)

  10. Market Capitalization in billions USD (need to make some minor changes for companies that are not from USA)

  11. Daily price changes

But that’s not all.

In addition to that, please go to the right side of the sheet where you’ll be able to find several tables. Those are:

  1. Companies sorted by dividend yield. Top 199 companies picked from whole watchlist.

  2. Companies sorted by my SUBJECTIVE PE from lowest to highest. Top 500

  3. Companies sorted by my SUBJECTIVE PE from highest to lowest. Up to 50.

  4. Daily price changes. DECLINERS. Top 50.

  5. Daily price changes GAINERS. Top 50.

  6. Companies sorted by market capitalization. Top 30.

  7. Companies sorted by biggest stock price declines during the last 52 weeks. Top 100.

  8. Companies sorted by smallest stock price declines during the last 52 weeks. Top 100.

Feel free to contact me for an additional information.

Have a nice day,

Radoslaw



Source link

Related articles

Cash Movement Index Multi-Timeframe Indicator for MT5 – Buying and selling Methods – 13 August 2025

The Cash Movement Index Multi-Timeframe (MFI_MTF) Indicator for MetaTrader 5 calculates and scans the Cash Movement Index (MFI) on all 21 commonplace MT5...

Watch UEFA Tremendous Cup 2025 for Free: Livestream PSG vs. Tottenham From Anyplace

61% off with 2yr plan (+4 free months) See extra particulars ...

Ethereum 30-Day Netflow Common Deepens Unfavourable: Consumers Dominate Market

Ethereum has surged to multi-year highs round $4,700, marking its strongest degree since November 2021 and placing it inside hanging distance of its all-time excessive close to $4,860. The rally has positioned ETH...

The Well being of the Healthcare System

We will take a look at this subject from two views. If we take into account the therapies which were developed...

Bitcoin: Double High Above $120K Raises Questions however Base Case Stays Bullish

In current days, consumers within the crypto market aimed to push costs to new all-time highs. That try has failed for now. For Bitcoin, a double peak is forming, which doesn't affirm an...
spot_img

Latest articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

WP2Social Auto Publish Powered By : XYZScripts.com