Registered User
Joined: 10/7/2004
Posts: 30
|
Please let me know whether it is possible for me to rank the Hemscott Industry Groups
by their Price % Change 1-Month as at a *past* date (Say Jan/18/2008).
Then, after I select a graph from that list, can I scroll forward from that date (using the ] bracket key)
to see the walk forward results ?
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I think these videos will give you an idea or two:
Sorting Stocks by their Absolute or Relative Performance
Uncover the stocks driving the strongest industry groups
Industries With Consistent Performance over Specific Time Periods
- Craig
Here to Help!
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
emthree,
The basic formula for Price Percent Change 1-Month is:
100 * (C / C21 - 1)
There are two distinct ways to use historical data with Personal Criteria Formulas.
Any criteria can be used to scan X number of days back by adding '.XX' where XX is equal to the number of market days past to calculate for. An example of this is (AVGC21.21), which is a 21 day moving average 21 of close, 21 days ago. This use of historical data always refers to the market day XX number of days ago (in this case, 21). If you wish to use a specific date’s data, use the option detailed below.
The other method of using historical data is by specifying a precise date in history to use. For example, (AVGC21.'12/31/97') will provide a 21 day moving average of close for December 31, 1997 (the period should be used in cases where the first method requires a period and not used when the first method does not use a period). In this particular case, December 31 is the last trading day of that specific year. This will not always be the case. Always confirm that the date you wish to use using this parameter was a market day.
You can use PCFs as Sorts and view Watchlist Columns using either Value or Rank.
How to create a Personal Criteria Forumula (PCF)
Create your own stock rankings using WatchLists and Sort conditions
Customize the Information Displayed in the WatchList
If you want to see historical values by scrolling on the charts, you would probably be better of using the same formula as a Custom Indicator however:
Select Chart Template | Add Indicator | Indicator.
- Visible: Checked
- Center Zero Line: Checked
- Plot using price scale: Unchecked
- Smoothing Average: 1
- Smoothing Type: Doesn't matter (because the Smoothing Average is 1)
- Indicator Formula: 100 * (C / C21 - 1)
Plotting Custom Indicators with Examples
If it is in the top section of the charts, you can view the values using the Data Box in Pointer Mode (you can bring this up by selecting the period key (.) twice). You may wish to review the following:
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|