Stock selection is hard.
When I look at data, what do I see? How does it compare to how many other stocks did the same thing last year?
Many times this is a good way, but I think the true answer is a combination of a few factors including your personal preference, the specific time you want to do this (i.e., a year when they are most active and are still being evaluated, or a year when the value is not necessarily higher)
I’ve done a lot of these types of analyses before, but never as many as I’ve had the pleasure of doing this spring. It takes a lot of practice to find the right stock (especially a big, cheap stock), but it’s worth it. After all: the goal in stock market analysis is to find the best tradeable stock for a given situation.
One thing I do have a few more suggestions than you do:
Get some people to do it for you. This doesn’t necessarily have to be in a formalized way. Just get a big group of people, and invite them to use the spreadsheet, and ask them to provide their own thoughts. Make suggestions on how to add or change columns and such and give a brief description of the method so other people can figure out what to do. Make sure you get people who can trade. I’ve had people try and explain that they are great in the short term but really haven’t been as good in the longer term. I think this is more the fault of the “futures traders” I talked about earlier, but it still happens. For a short-term investment, I don’t think that is a valid excuse if you are trying to sell a stock. The point is to find stocks that your gut tells you are good enough to use, but it’s not necessarily the worst stocks for long term purposes. (In the meantime, we are in the new world of quant finance so you need to think about how to get those long term returns anyway).
A lot of it is about trial and error and trying things.
Some of it is based on the advice of others. Like with the time frame for analysis, I look at a lot of stuff from my research but a lot of stocks I try and use that someone gives me. It’s not like I’m picking companies to make a profit, I mean I’m trying to find good stocks that will pay dividends for a long time. I’m trying to find companies
stocks to watch for swing trading, swing trading stock options, short swing trading definition financial accounting, swing trading stock picks newsletters for kids, top swing trade stocks today