Stock watchlist: how to keep it short and useful
A useful stock watchlist: for each line, the reason, the criterion and the threshold that would change your decision, a reread at every release and rules for pruning the list.
A stock watchlist stays useful when each line says two things: why the company interests you, and which precise figure would change your decision. Reread it at every earnings release, remove the lines that no longer have a clear condition, and keep it short enough to reread in full in one sitting.
Why does a watchlist become useless?
Because names get added and never removed. A company spotted in an article, another whose share price just dropped, a third one a friend owns: after a year, the list has forty names, and you no longer know why half of them are there.
The second trap is quieter. “I’m watching” turns into a polite way of not deciding. A line without a written condition will never tell you when to act, since nothing can make it change.
What should you note for each stock you watch?
Five items, one line each:
- The reason. Why this company interests you, with a figure: “ROIC above 18% for five years”.
- What is blocking. The criterion not met and its threshold, or the valuation above your maximum.
- The condition. The precise value that would change your decision: “P/E of 25 or less”, “net debt / EBITDA below 2”.
- The next reread. The release where that value will be known: half-yearly report, annual report.
- The removal condition. What would make you strike the line: “ROIC below 12%”, “two years without progress”.
Wording you can copy as is:
“I’m watching [company] because [reason with a figure]. What is blocking: [criterion] at [value], against a threshold of [threshold]. I come back to it if [condition]. I remove it if [removal condition]. Next reread: [release].”
The condition must rest on a figure you can read in a report or calculate at today’s share price. “When the market calms down” cannot be checked.
How do you turn a valuation condition into a share price?
A condition on the P/E becomes a price ceiling: maximum share price = maximum P/E × earnings per share. With a maximum P/E of 25 and earnings per share of $2.40, the maximum share price is $60.
Write that price ceiling on the line. You no longer need to recalculate the P/E every week: a glance at the share price is enough. Recalculate the ceiling at each release, since earnings per share change. The same calculation works with a price to free cash flow or a minimum yield.
Worked example: a watchlist of four fictitious companies
All four companies are fictitious. Each line has its reason and its condition.
| Company | Reason | Condition |
|---|---|---|
| A, invoicing software | Fewer than 6% of customers lost per year | P/E of 25 or less (31 today) |
| B, electrical equipment distribution | ROIC of 18% over five years | Net debt / EBITDA below 2 (2.9 after an acquisition) |
| C, food ingredients | Dividend up for twelve years | Payout ratio below 75% (95% today) |
| D, veterinary clinics | Growth of 14% a year | FCF conversion of at least 80% (55%) |
Company A is the one from the investment thesis template: all its criteria are met, and only the price is blocking. With earnings per share of $2.40, its price ceiling is $60.
At the next release, the reread takes ten minutes:
- Company A. The P/E moves to 27. The condition is not met, and the line stays.
- Company B. Net debt / EBITDA falls to 2.1. Close: the line stays, with the next reread at the annual report.
- Company C. The payout ratio climbs to 98%, and free cash flow no longer covers the dividend. The original reason is shaking: you switch the line to “I’m passing”, with that sentence as the reason.
- Company D. FCF conversion stays at 55%, for the third fiscal year in a row. Your removal condition said “two years without progress”: the line leaves the list.
The list goes from four lines to two. Each of the two remaining lines has a condition in figures and a reread date.
How often should you reread your watchlist?
Reread a line at each earnings release of the company: that is when the figures of your condition change. The routine in the article on how to review stocks after earnings applies as is.
Once every six months, reread the whole list in one go. This overall reread is for pruning. For each line: is the condition still the right one, and does the reason still stand?
Between two releases, only the valuation conditions can change, with the share price. The price ceiling written on each line is enough to track them.
How many lines should you keep, and when should you remove one?
A rule of thumb: as many lines as you can reread in half an hour, often 10 to 20. Beyond that, the overall reread stops happening.
| Reason to remove a line | Sign to look for |
|---|---|
| The original reason is gone | The criterion behind your interest turns red |
| The condition is met | You have decided: “I’m buying” or “I’m passing” |
| Nothing moves | Four releases without getting closer to the condition |
| You no longer know why it is there | No written reason or condition |
| Another line does better | Same reason, better figures or a better price |
Removing a line does not mean deleting it. Switch it to “I’m passing” with the reason: a year from now, you can check whether that removal was right.
How does ruly help you keep your watchlist?
In ruly, each sheet carries your decision: “I’m buying as a priority”, “I’m buying”, “I’m watching”, “I’m waiting for a better price”, “I’m passing” or “Not decided yet”. It also carries a status (“Candidate”, “Watching”, “In portfolio”, “Set aside”), your fair value and a comment. The My decisions page groups all your sheets by decision, one row per decision: drag a sheet to another row to change its decision.
The dashboard shows all your sheets, one section per strategy, one row per sheet: the company, the status, the score, one dot per criterion, your fair value, your decision and your comment. The buttons at the top filter by status, with the number of sheets in each, and a click on the Decision column header sorts the sheets by decision. You edit the comment directly in the table: it is the place for your condition and your price ceiling, visible at a glance.
Frequently asked questions
What is the difference between “I’m watching” and “Not decided yet”?
“Not decided yet” fits while the analysis is unfinished. “I’m watching” says you have finished the analysis and that a precise condition, which you have written down, is missing. If you cannot write that condition, the sheet is still at “Not decided yet”.
Should I follow the share price every day?
No. Only the valuation conditions depend on the share price, and the price ceiling sums them up. The other conditions only change when results are published.
Can a company come back onto the list?
Yes, if a new fact answers the reason for its removal. Write a new reason and a new condition then, rather than reusing the old line as is.
What should I do when a condition is finally met?
Reread the whole sheet with the latest report before deciding. While you waited for the right price or the right debt level, the other criteria may have moved.
Build your strategy, score each stock against your own criteria and note your decision next to the figures.
Free for up to 3 sheets, with no time limit. An email address is all you need, and your sheets stay private.