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