Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

PCF Miscellaneous Questions Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
DavidBSchoon
Posted : Thursday, November 8, 2007 7:49:26 PM
Registered User
Joined: 10/7/2004
Posts: 45

I have reviewed many of your fine videos and done some searches but am not understanding some fairly simple issues despite the time investment; so am asking for some assistance:

1. I have a Watchllist of "63 Chinese stocks" that I manually entered from reading articles etc.
I have a Watchlist of "My Universe" based on an Easy Scan I developed.

How specifically do I use the sublist feature to remove some of the "63 Chinese stocks" on that Watchlist that do not meet the scan criteria from "My Universe"Watchlist?

1B. What are several other specific things I can do with the sublist feature?

2. What are the specific PCFs I need to do an Easy Scan for stocks with TTM sales >15% & TTM earnings per share > 20%?

3. What specific PCFs can I use to identify divergences between price and TSV? 

3A. How can I add a linear regression line of the stock price to the chart template upper window; and use it to visually compare ('eyeball') for divergences between TSV & stock price over 105 days?

4. What is the PCF formula & how can I add it to a chart window to calculate ROC of price over 21 days?

5. How do I add a custom sub-group relative strength line to the chart based on the past 21 days?

6. Is it correct that the only RT data is price, price % change & volume?  And the only 20 minute delayed data is marked with an '-H'?  And everything else is "end of day"?

7. What is the PCF for velocity based on 30 days (speed of RS)?

7B. What is the PCF for acceleration based on 30 days (this is derived from velocity I believe)?

Thanks a lot for your assistant with these questions.

David

DavidBSchoon
Posted : Thursday, November 8, 2007 7:54:45 PM
Registered User
Joined: 10/7/2004
Posts: 45
Btw, I should have stated this in the "PCF Miscellaneous Questions" I just posted minutes ago; I prefer math based (non-boolean) PCFs so I have more flexibility and can use the Range Selector, etc.

David
Bruce_L
Posted : Friday, November 9, 2007 4:10:19 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (DavidBSchoon)
1. I have a Watchllist of "63 Chinese stocks" that I manually entered from reading articles etc.
I have a Watchlist of "My Universe" based on an Easy Scan I developed.

How specifically do I use the sublist feature to remove some of the "63 Chinese stocks" on that Watchlist that do not meet the scan criteria from "My Universe"Watchlist?

Please try the following:

Choose 63 Chinese Stocks as the Active Watchlist.
Right-click on the name of the Active Watchlist (63 Chinese Stocks) and select Sub List.
Select Apply selected Sub List.
Left-click on the Watchlist listed underneath Apply selected Sub List.
Select your My Universe EasyScan.
Select OK.

QUOTE (DavidBSchoon)
1B. What are several other specific things I can do with the sublist feature?

The Sub List feature does only one thing. It ANDs the selected Sub List with the Active Watchlist to display only those symbols on both lists. Any other things you can do with Sub List feature are just different applications of the same technique. You may wish to review the following:

Techniques for using the Sublist feature

QUOTE (DavidBSchoon)
2. What are the specific PCFs I need to do an Easy Scan for stocks with TTM sales >15% & TTM earnings per share > 20%?

TeleChart's Personal Criteria Formula Language does not have syntax for referencing other symbols or fundamentals. This means fundamentals cannot currently be included in PCFs. It also means you are limited to the current values of the built in Fundamental System Criteria already included in the program. There are four built in Criteria directly related to Sales:

Earnings as a percent of Sales 1-Yr - This is an indication of profit margin. Weak profit margins are often a sign of hidden vulnerability in a stock that appears to have high earnings. Be careful of companies that pay high dividends while having low profit margins. Within industries, the companies with the highest profit margins are usually the leaders. It is a sign of good management. This reads in percentage.

Price to Sales Ratio - Determined by dividing current stock price by revenue per share (adjusted for stock splits). Revenue per share for the P/S ratio is determined by dividing revenue for past 12 months by number of shares outstanding.

Sales ($Millions) 1-Yr - This is the sum of revenues for the last 4 quarterly reports. This is an excellent gauge of company size.

Sales Growth Rate 5-Yr - This is the compound annual revenue per share growth over the last 5 years. This is an indication of growing market share (especially in issues with over 15.93% since the average compound inflation rate for five years in the USA is 15.93%). Never forget, it takes revenue to produce earnings.

There are eleven built in Criteria directly related to Earnings.

Earnings ($Millions) 1-Yr - This is the sum of the trailing 4 quarters of net income (profit) as taken from the quarterly report. This is not the earnings per share. This value will also provide some insight into company size. It reads in millions of dollars.

Earnings as a percent of Sales 1-Yr - This is an indication of profit margin. Weak profit margins are often a sign of hidden vulnerability in a stock that appears to have high earnings. Be careful of companies that pay high dividends while having low profit margins. Within industries, the companies with the highest profit margins are usually the leaders. It is a sign of good management. This reads in percentage.

Earnings Growth Rate 5-Yr - The compound annual earnings per share 5-year growth rate. In looking for quality companies, well established companies of good size, this criterion is indispensable. The units are in percentages.

EPS Latest Qtr - Fully Diluted earnings per share from Total Operations, as taken from the latest 3-month ending period.

EPS Percent Change (Latest Q) - The percentage change in earnings per share from the comparable quarter a year before. Timely stocks will usually have strong recent quarterly earnings to validate the annual earnings strength. This reads in percentage.

EPS Percent Change (2nd Q back) - The percentage change in earnings per share from the comparable quarter a year before.

EPS Percent Change (3rd Q back) - The percentage change in earnings per share from the comparable quarter a year before.

EPS Percent Change (4th Q back) - The percentage change in earnings per share from the comparable quarter a year before.

EPS Percent Change (Latest Yr) - The percentage change in earnings for the latest 4 quarters compared to the preceding 4 quarters. An appropriate criterion to include in many types of screens. Also a common criterion to sort by, with the best earners on top.

P/E Ratio - The price per share divided by the trailing 12 month's earnings per share. Companies with negative earnings are designated N/A. This well known criterion is a quick and dirty way of evaluating whether a stock is richly priced or reasonably priced. The P/E ratio must, however, always be evaluated in conjunction with growth rate. A high growth rate deserves a high P/E. Generally a low P/E would merit a long position.

P/E Ratio vs. 5-Yr-Average P/E - This is the current P/E ratio divided by the average of the last five year's P/E ratio. Expressed as a percentage: a value of 80, for instance, would mean that the current P/E is 80% of the five year average. This value shows whether a stock is reasonably priced relative to its own history.

None of the above seem to match your specific requirements. Sales ($Millions) 1-Yr is not listed as a percent although you could use it in an EasyScan as a Percentile Rank. A one year EPS figure is only available as a comparison to the previous year. You can use these built in Fundamental System Criteria as either EasyScan Conditions or Sorts. You may wish to review the following:

Definitions of all built in scanning and sorting criteria
Using EasyScan to find stocks that meet your own criteria
Create your own stock rankings using WatchLists and Sort conditions

QUOTE (DavidBSchoon)
3. What specific PCFs can I use to identify divergences between price and TSV?

The trainers can't give setting, interpretation or investment advice. That means I can't say what specific Personal Criteria Formulas to use to identify a divergence. What I can do is help you write PCFs based on your objective definition of what constitutes a divergence. For example, if you defined a divergance as (based loosely on 3A) as the 105-Period Linear Regression Slopes of Price and TSV (raw) having opposite signs, you could use the following (it is Boolean (True/False) since we haven't objectively defined any useful values):

SGN(52 * C + 51 * C1 + 50 * C2 + 49 * C3 + 48 * C4 + 47 * C5 + 46 * C6 + 45 * C7 + 44 * C8 + 43 * C9 + 42 * C10 + 41 * C11 + 40 * C12 + 39 * C13 + 38 * C14 + 37 * C15 + 36 * C16 + 35 * C17 + 34 * C18 + 33 * C19 + 32 * C20 + 31 * C21 + 30 * C22 + 29 * C23 + 28 * C24 + 27 * C25 + 26 * C26 + 25 * C27 + 24 * C28 + 23 * C29 + 22 * C30 + 21 * C31 + 20 * C32 + 19 * C33 + 18 * C34 + 17 * C35 + 16 * C36 + 15 * C37 + 14 * C38 + 13 * C39 + 12 * C40 + 11 * C41 + 10 * C42 + 9 * C43 + 8 * C44 + 7 * C45 + 6 * C46 + 5 * C47 + 4 * C48 + 3 * C49 + 2 * C50 + C51 - C53 - 2 * C54 - 3 * C55 - 4 * C56 - 5 * C57 - 6 * C58 - 7 * C59 - 8 * C60 - 9 * C61 - 10 * C62 - 11 * C63 - 12 * C64 - 13 * C65 - 14 * C66 - 15 * C67 - 16 * C68 - 17 * C69 - 18 * C70 - 19 * C71 - 20 * C72 - 21 * C73 - 22 * C74 - 23 * C75 - 24 * C76 - 25 * C77 - 26 * C78 - 27 * C79 - 28 * C80 - 29 * C81 - 30 * C82 - 31 * C83 - 32 * C84 - 33 * C85 - 34 * C86 - 35 * C87 - 36 * C88 - 37 * C89 - 38 * C90 - 39 * C91 - 40 * C92 - 41 * C93 - 42 * C94 - 43 * C95 - 44 * C96 - 45 * C97 - 46 * C98 - 47 * C99 - 48 * C100 - 49 * C101 - 50 * C102 - 51 * C103 - 52 * C104) <> SGN(52 * TSV + 51 * TSV1.1 + 50 * TSV1.2 + 49 * TSV1.3 + 48 * TSV1.4 + 47 * TSV1.5 + 46 * TSV1.6 + 45 * TSV1.7 + 44 * TSV1.8 + 43 * TSV1.9 + 42 * TSV1.10 + 41 * TSV1.11 + 40 * TSV1.12 + 39 * TSV1.13 + 38 * TSV1.14 + 37 * TSV1.15 + 36 * TSV1.16 + 35 * TSV1.17 + 34 * TSV1.18 + 33 * TSV1.19 + 32 * TSV1.20 + 31 * TSV1.21 + 30 * TSV1.22 + 29 * TSV1.23 + 28 * TSV1.24 + 27 * TSV1.25 + 26 * TSV1.26 + 25 * TSV1.27 + 24 * TSV1.28 + 23 * TSV1.29 + 22 * TSV1.30 + 21 * TSV1.31 + 20 * TSV1.32 + 19 * TSV1.33 + 18 * TSV1.34 + 17 * TSV1.35 + 16 * TSV1.36 + 15 * TSV1.37 + 14 * TSV1.38 + 13 * TSV1.39 + 12 * TSV1.40 + 11 * TSV1.41 + 10 * TSV1.42 + 9 * TSV1.43 + 8 * TSV1.44 + 7 * TSV1.45 + 6 * TSV1.46 + 5 * TSV1.47 + 4 * TSV1.48 + 3 * TSV1.49 + 2 * TSV1.50 + TSV1.51 - TSV1.53 - 2 * TSV1.54 - 3 * TSV1.55 - 4 * TSV1.56 - 5 * TSV1.57 - 6 * TSV1.58 - 7 * TSV1.59 - 8 * TSV1.60 - 9 * TSV1.61 - 10 * TSV1.62 - 11 * TSV1.63 - 12 * TSV1.64 - 13 * TSV1.65 - 14 * TSV1.66 - 15 * TSV1.67 - 16 * TSV1.68 - 17 * TSV1.69 - 18 * TSV1.70 - 19 * TSV1.71 - 20 * TSV1.72 - 21 * TSV1.73 - 22 * TSV1.74 - 23 * TSV1.75 - 24 * TSV1.76 - 25 * TSV1.77 - 26 * TSV1.78 - 27 * TSV1.79 - 28 * TSV1.80 - 29 * TSV1.81 - 30 * TSV1.82 - 31 * TSV1.83 - 32 * TSV1.84 - 33 * TSV1.85 - 34 * TSV1.86 - 35 * TSV1.87 - 36 * TSV1.88 - 37 * TSV1.89 - 38 * TSV1.90 - 39 * TSV1.91 - 40 * TSV1.92 - 41 * TSV1.93 - 42 * TSV1.94 - 43 * TSV1.95 - 44 * TSV1.96 - 45 * TSV1.97 - 46 * TSV1.98 - 47 * TSV1.99 - 48 * TSV1.100 - 49 * TSV1.101 - 50 * TSV1.102 - 51 * TSV1.103 - 52 * TSV1.104)

You may wish to review the following:

Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis
Useful Gradations for Divergence Evaluations

QUOTE (DavidBSchoon)
3A. How can I add a linear regression line of the stock price to the chart template upper window; and use it to visually compare ('eyeball') for divergences between TSV & stock price over 105 days?

Please try the following:

Select Chart Template | Add Indicator | Linear Regression | Price.
- Period: 105
- Extension: 0
- Width: 0
Select Chart Template | Add Indicator | Linear Regression | TSV.
- Period: 105
- Extension: 0
- Width: 0

You may wish to review the following:

Adding, removing and saving indicators to a chart template
Using Linear Regression Sorts to Help Spot Divergences

QUOTE (DavidBSchoon)
4. What is the PCF formula & how can I add it to a chart window to calculate ROC of price over 21 days?

The formula varies depending on if the ROC is Net or Percent based and if it is expressed over the entire period or as a Rate per Bar:

ROC (Net) over entire Period (this TeleChart's ROC Indicator):

C - C21

ROC (Percent) over entire Period:

100 * C / C21 - 100

ROC (Net) per Bar:

(C - C21) / 21

ROC (Percent) per Bar:

100 * ((C / C21) ^ (1 / 21)) - 100

You can plot any of the above as Custom Indicators as follows:

Select Chart Template | Add Indicator | Indicator.
- Visible: Checked
- Center Zero Line: Unchecked
- Plot using price scale: Checked
- Smoothing Average: 1
- Average Type: Doesn't matter (because the Smoothing Average is 1)
- Indicator Formula: One of the above formulas.

You may wish to review the following:

Plotting Custom Indicators with Examples
Handy PCF example formulas to help you learn the syntax of PCFs!
PCF Formula Descriptions

QUOTE (DavidBSchoon)
5. How do I add a custom sub-group relative strength line to the chart based on the past 21 days?

You can add a Relative Stregth Line for the Sub-Industry by doing the following:

Select Chart Template | Add Indicator | Relative Strength.
- Comparison Symbol: SUB-IND
- Visible: Checked

You could do the same thing by left-clicking on the Industry and Sub-Industry name on the charts and selecting Plot Relative Strength versus Sub-Industry. This is a comparison to the built in Hemscott Sub-Group. If you want something based on a Custom Watchlist, I do not know of a way to do so using TeleChart. You may wish to review the following:

Using the Industry Menu to analyze stocks relative to their industries and sub-industries
Use Comparison and Relative Strength graphs to compare a stock to the rest of its industry group

QUOTE (DavidBSchoon)
6. Is it correct that the only RT data is price, price % change & volume?  And the only 20 minute delayed data is marked with an '-H'?  And everything else is "end of day"?

I do not believe -H is currently used in TeleChart for Stocks. The following Real Time Criteria can be used in RT Sorts:

Real Time Criteria (Platinum only):

Per Share - RT - The current price per share updated every minute.

Percent Change – RT - The difference between the current price and the previous day’s close expressed as a percentage. This is updated every minute.

Volume – RT - The current day’s trading volume updated every minute.

The following Real Time Criteria can be displayed in Watchlist Columns but not used as streaming sorts:

Display Only Criteria (Platinum only):

% Change – RT - The difference between the last executed price of the stock and the previous day’s close expressed as a percentage.

Ask – RT - The lowest price the stock is currently offered for sale.

Ask – Vol - The number of shares (in hundreds) offered at the current Ask.

Bid – RT - The highest current bid to buy the stock.

Bid – Vol - The number of shares (in hundreds) wanted at the current Bid.

Exchange – RT - The exchange that processed the latest trade of the stock.

High – RT - The current high of the day.

Last – RT - The last executed price of the stock.

Last Time – RT - The time of the last trade.

Last Vol – RT - The size of the last trade.

Low – RT - The current low of the day.

Net – RT - The difference between the last executed price of the stock and the previous day’s close.

Volume – RT - The current volume of the day.

The following can be displayed in RT on your charts:

Data Bar Specific Criteria (not for use in Watchlist Columns or EasyScans):

Bar Open - Displays the opening price of the current bar

Bar High - Displays the highest price of the current bar

Bar Low - Displays the lowest price of the current bar

Bar Close - Displays the last price of the current bar

Bar Volume - Displays the total volume of the current bar (in 100’s)

Bar Net - Displays the net difference between the last price of the current bar and the previous bar.

Bar % Change - Displays the Bar Net as a percentage

Bar Date/Time - Displays the date of the last price of the current bar and the time if the bar’s time frame is less the one day.

Most other technical criteria are updated each minute. Any built in Criteria (and all PCFS) with a blue circle containing a lower case i is updated with each download (and can change each minute). Fundamentals are calculated each week on Saturday.

QUOTE (DavidBSchoon)
7. What is the PCF for velocity based on 30 days (speed of RS)?

If velocity is based on Relative Strength, I do not know of a practical automated method for creating it as a PCF. You may wish to review the following for a semi-automated method of including other symbols in a PCF:

Indexes in PCF's

QUOTE (DavidBSchoon)
7B. What is the PCF for acceleration based on 30 days (this is derived from velocity I believe)?

If it is based on velocity and we can't write a PCF for velocity, it seems doubtful that we will be able to write a PCF for acceleration either.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
DavidBSchoon
Posted : Friday, November 9, 2007 4:19:16 PM
Registered User
Joined: 10/7/2004
Posts: 45
Bruce,

You're the best, thank you so much.  I should buy you dinner for all this work!

I believe you have answered all the questions I raised very productivvely based on my review.

My wife is out of town for the weekend so now I have my work cut out for me too;
you guys are super, thanks again and kudos.

David
Bruce_L
Posted : Friday, November 9, 2007 4:22:40 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
As I mentioned in your other topic, I suspect you will have additional questions once you have reviewed and absorbed my answer and the referenced topics completely. If nothing else, we can probably come up with a better divergence Personal Criteria Formula with some additional feedback from you.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.