| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 3/20/2005
Posts: 78
|
How can I easily locate and delete erroneous charts from old watchlists?
Sometimes when I revisit an old watchlist I find charts with prices that
do not match the watchlist tracking report. For example, ABCO appears in
a watchlist that I created on 9/17/01 while trying to focus on stable or
otherwise attractive stocks for Roth IRA investing. But ABCO does not
have price data dating back to 9/17/01. I assume that this is because
the Original stock quit trading for some reason since then, and the chart
number got reassigned to ABCO. When that happens, you end up tracking
stocks that you have never heard of, and that do not fit the purpose of
that watchlist. So these charts must somehow be weeded out of the
watchlist. How can this be done?
I thought of one way to do it for watchlists in which ALL of the charts
have the same tracking date: Use Watchlist Custom Date Sort to sort from
the original tracking date given in the watchlist, then flag and delete
the charts that do not have any Sort Value for percent change.
But using Watchlist Custom Date Sort does not work for Watchlists in
which stocks have individual tracking dates, such as a 'Buy Watch' or
'Good Looking Stocks' watchlist. How can I find, flag, and delete stocks
that do not have price data going all the way back to the Watchlist
Tracking date?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The best technique I've found since reading your question so far still requires scrolling through the Watchlist.
Add a Watchlist Column: Tracking Days In List.
Select Chart Template | Add Indicator | Cumulative | Choose a Blank Chart Section.
-Smoothing Average: 1
-Up Condition: C>0
-Down Condition: C=C+1
-Value to Add/Subtract: 1
You will want to be in Daily Mode and zoom out at least to the oldest Watchlist Tracking Date (which limits this technique somewhat as well) and scroll through the charts in your Personal Watchlist looking for symbols where the Tracking Days In List is greater than the value of the Custom Cumulative Indicator. The following sections of the Online Help Files should help you set this up:
WatchList Tabs
Custom Cumulative
Obviously, there may be a better technique. I'll keep thinking about it. Maybe somebody else will post a superior solution.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/20/2005
Posts: 78
|
Thanks for the quick response, Bruce.
I don't understand the custom cumulative indicator that
you proposed, but the idea to "Add a Watchlist Column:
Tracking Days In List" is a good one. I had no idea that
I could do that. That will help in the weeding process,
because I could then sort the watchlist by that column,
descending and zoom out to include the tracking date.
Scrolling through the watchlist will reveal the weeds by
the sudden changing of the zoom, or the absence of the
watchlist tracking pointer. Those can be flagged for
later deletion (with 'delete all flagged'), so I could
continue to scroll through, watching for the orderly
movement of the tracking pointer from left to right.
I am going to log off from the internet now, and play
with it a bit. But I also had another question that I
will 'Watch This Topic' for:
What does your custom cumulative indicator summarize?
Is it an attempt to count days in which the price went
up, or down? If so, what about days in which the price
was unchanged?
What I need is a way to compare the watchlist tracking
date against the date of the oldest price data for any
given chart. If the watchlist tracking date is less than
the date of the oldest price data, then the chart is a
weed and needs to be pulled from the watchlist.
Is there any easy way to find the first date with price
information for a given chart?
"All Stocks"
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The Custom Cumulative indicator above is designed to count the number of periods a stock has traded within the timeframe of the current zoom. In daily mode, it counts the number of trading days, which can be compared directly with Tracking Days In List as long is the number of days on the chart equals or exceeds the maximum number of days a stock could be in your Personal Watchlist.
C>0 is always True for a common stock actively trading on the NYSE, Amex or Nasdaq.
C=C+1 is never True.
So the Custom Cumulative adds 1 for every day where Price is greater than zero, but starts counting at the left edge of the chart.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/20/2005
Posts: 78
|
Thanks, Bruce
That will help for tracking dates as far back as about
January 2000. I'll figure out something else for the
really old ones (2/97-12/99). I probably shouldn't care
about those anymore, anyhow, but I occasionally like to
review old "what if's" and look for signs that I should
have seen just before moves that I missed, or drops that
I did not miss (Ouch!). Over the years I have added a
lot of stocks to a lot of lists.
MOHTC
|
|
Registered User
Joined: 3/20/2005
Posts: 78
|
Bruce, I accidently found out that if I add a 'Watchlist
Tracking Price' column to a watchlist tab, the price is
zero for a 'weed' chart that has replaced a retired one.
I don't yet know if this is always the case; I was
playing around with sorting by 'Symbol' first and by
'Watchlist Tracking Date' second, and got off onto a
sidetrack of finding that sometimes the chart Symbols
get randomized by the second sort. See my Watchlist
Sort... bug report, earlier tonight. Anyhow, I ended up
seeing only one case of 'WTP' being zero, because I got
distracted by the neat bug I saw, and forgot that I was
trying to pull weeds.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
That certainly makes things easier if it as always the case!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |