Hey everybody,
I have been engaged on my inventory watchlist for fairly a while now. Sharing an entry to it via Google Sheets:
Right here are some things earlier than you click on on the hyperlink:
· It is an enormous watchlist created in Google Sheets with numerous formulation. It takes time and RAMs to load. (I’m personally utilizing eleventh Gen Intel i7-11800h with 16GB of RAM with 34” monitor. My browser takes couple of minutes to load the entire watchlist)
· You will discover there round 1600-1700 shares from entire world sorted into 11 Inventory Market Sectors.
· On the very high you will discover every day gainers (high 5) and decliners (high 5)
· On each firm you will discover following info:
Brand
Firm’s identify. A number of firms have notes included (my private notes; notes on which cash supervisor purchased/bought this inventory, when and the way a lot he paid for it; and so forth.). I’m updating this info each day.
Dividend yield with notes on historic funds. Yield adjustments every day based mostly on inventory worth change.
My SUBJECTIVE PE based mostly on common few years revenue. I left “-” image the place I don’t know what PE to designate for a particular firm in the meanwhile. This probably the most controversial a part of the entire watchlist. Plenty of you’ll assume that a few of my designated PE’s are too excessive whereas others – too low. However I need to emphasize this – that is MY subjective view. After all it would differ from yours. ?
% of up from yearly low
% of down from yearly excessive
Inventory worth
Graph of historic worth adjustments (2y)
Graph of historic worth adjustments (7y – to have a much bigger perspective)
Market Capitalization in billions USD (have to make some minor adjustments for firms that aren’t from USA)
Day by day worth adjustments
However that’s not all.
Along with that, please go to the proper aspect of the sheet the place you’ll be capable of discover a number of tables. These are:
Corporations sorted by dividend yield. Prime 199 firms picked from entire watchlist.
Corporations sorted by my SUBJECTIVE PE from lowest to highest. Prime 500
Corporations sorted by my SUBJECTIVE PE from highest to lowest. As much as 50.
Day by day worth adjustments. DECLINERS. Prime 50.
Day by day worth adjustments GAINERS. Prime 50.
Corporations sorted by market capitalization. Prime 30.
Corporations sorted by largest inventory worth declines over the last 52 weeks. Prime 100.
Corporations sorted by smallest inventory worth declines over the last 52 weeks. Prime 100.
Be at liberty to contact me for an extra info.
Have a pleasant day,
Radoslaw
