No. of Recommendations: 2
Using a spreadsheet watchlist, I'm finding out whether it is worth it to set up limits ahead. A stock goes on or off the spreadsheet by the fundamentals & technical as best they can be handled. But at the top, there are some numerical entries that apply to the overall situation, such as how much the SPY is above its average trend (courtesy of using the list stock feature, several ratios, etc. There is also a variable for buy and for sale. The latter is adjusted a small amount toward the current price if nothing happens, and a larger amount away if there is a buy or sale. The list is ranked according to a column that takes various entries into account from most likely to be a good buy to most likely to be a good sale. According to the ranking, a little is added or subtracted to the suggested buy/sell price to make a new buy/sell price. Entries are updated weekly.

The primary use is to make it harder to panic, or to follow a fad. By carefully setting up the ranking column, it does a pretty good job of suggesting what is probably reasonable on price.

I think of it as the filter and trapline method. You find out how the beast acts, and set out your traps where they might catch something.
Print the post  


What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.