Need a PCF for

5-year annual revenue growth > 15%

1-year annual revenue growth > 12%

Thanks

There is no syntax in the Personal Criteria Formula Language for referencing fundamentals, so it is not possible to create PCFs for either of your requirements as your are limited to the built in fundamental system criteria.

Morningstar Fundamentals

Of these, there are two which might work for your needs even though the 5 year criteria is not an exact match.

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.

Revenue Growth Rate Last 4 Qtrs - The difference between the latest fiscal year revenue and the previous fiscal year revenue, expressed as a percentage.

You can add these criteria to an EasyScan to check for the desired levels.

Building a Scan with Multiple Conditions

Bruce, I need a scan for a stock that has lost more 50% of its value within the last 3 months and the 8 day SMA is currently moving thru the 21 day SMA in the weekly - Current price of the stock over $50.00 - thanks

You could try something similar to the following Weekly Condition Formula:

C <= .5 * MAXH13 AND SGN(AVGC8 - AVGC21) <> SGN(AVGC8.1 - AVGC21.1) AND C > 50

Make sure you use the Time Frame drop down when creating the Condition Formula to set the Time Frame to Weekly.

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

I need a pcf or easyscan to find the stocks that are % most up and most down on volume a bit like the RT option on TC7 . Can you help/

You could sort your WatchList using Volume Buzz, but you cannot use Volume Buzz as an EasyScan Condition.

You could use the following Indicator Formula as an EasyScan Condition however, as the Market Rank of the formula should be the same as the Market Rank of Volume Buzz.

100 * (V / AVGV100.1 - 1)

PCFs don't seem to work on tc12 . I tried the last one for David, and got nothing. Frustration is the name of the game

Personal Criteria Formulas definitely work in TC2000 version 12.3 (and for the most part in exactly the same ways as in TC2000 version 7). Please explain in detail why you think they do not so we can try to troubleshoot what is happening.

thx Bruce. How do I sync vol buzz as u said?

Besides whagt I have in mind is a bit more complex for most up and down on vol daily???

For instance I have copied and pasted the previous long pcfr and tried to scan us stocks with it.. got 0 or zilch

How would u install and use the pcf u sent to david for instance

The Personal Criteria Formula does not return any results because it is incredibly restrictive. There are 103 items in the US Common Stocks WatchList which are currently at least 50% below their highest value in the most recent 13-weeks but none of those stocks has shares that are currently valued above $50. If you eliminate that requirement, you get 5 stocks in the US Common Stocks WatchList which are done at least 50% from their high and where the 8-Week Simple Moving Average is crossing through the 21-Week Simple Moving Average in either direction: ABIO, DLGC, GPR, JAXB & ZOOM.

One way to add the PCF to TC2000 version 12.3 is to select Libary | Conditions | New Condition Formula. Set the Time Frame to Weekly, enter the formula in the big box (you can copy it from the forums and then use ctrl-v to paste it into TC2000), give the formula a name and select OK.

Once it is created, how to use it is up to you. You could add it to an EasyScan by selecting New | EasyScan, selecting Add Condition and then choosing the Condition from the list (there is a video on creating EasyScans in my first response in this very topic) or you could use it as a WatchList Column.

Adding & Editing WatchList Columns

While it would not involve using your saved Condition, you could also use the Condition Formula as the Boolean Formula in a Custom PCF % True Indicator by selecting Add Indicator, choosing Custom PCF % True Indicator from the list and then clicking on the Custom PCF % True to select Edit so you could enter the formula there instead of as a Condition Formula.

To sort by Volume Buzz, select Add Column at the top of the WatchList and choose Today's Volume Buzz from the list. Then click on the WatchList Column Header for that WatchList Column to use it as the sort for the WatchList.

In what way? If you describe specifically what you are trying to do, we might be able to help you, but we would need more details as to your intent.

 Bruce can I talk to you on the phone. Tc12 is driving me nuts. The silverlight app has disabled one of my computers. I dont think PCFs and easyscans are well explained at all. Thx? Or it could be me.

No, you cannot talk to me on the phone. Customer training is only offered in the forums or at our live training seminars. Customer training is not available by phone, chat or email.

Have you watched the Building a Scan with Multiple Conditions video referenced in my first post? In most cases, you do not have to use Personal Criteria Formulas at all. You can just click on an Indicator and select Create Scan Condition.

Create Conditions from Your Chart

If you are having technical issues, please contact technical support.

Thank you for your patience Bruce. What I am trying to do is find a scan the ranks all us stocks above

250 k vol daily and $2.45 in price lets say from highest % winners to biggest losers of the day.  How could I do that

I know how to enter price and daily vol parameters but the easyscan that would scan all noteworthy rising and falling stocks eludes me. My scans seem to miss a few noteworthy daily movers all too often.

You can create a Condition Formula for your two requirements.

- Select Library.
- Select Conditions.
- Select New Condition Formula.
- Give the Condition Formula a name.
- Set the Time Frame to Daily.
- Enter the following formula into the big box: V >= 250000 AND C >= 2.45
- Select OK.

This should save the Condition Formula. Now we can add it to an EasyScan as an EasyScan Condition.

- Select New.
- Select EasyScan.
- Change the List to Scan in the Edit tab if you want to base the EasyScan on a different WatchList.
- Select Add Indicator in the Edit tab of the EasyScan.
- Choose the Condition Formula you created earlier from the list.
- Select the Scan or Continuously tabs to view the results.

New we can sort the EasyScan from highest % winners to biggest losers of the day.

- Select Add Column (a + inside a circle).
- Choose Today's % from the list.
- Click on the WatchList Column Header for Today's % (it says % Change) to use it as a sort.

We actually wouldn't need to create Condition Formula in the first step. Alternately, you could start by creating the EasyScan and choosing PRICE and VOLUME as EasyScan Conditions.

- Select New.
- Select EasyScan.
- Change the List to Scan in the Edit tab if you want to base the EasyScan on a different WatchList.
- Select Add Condition in the Edit tab of the EasyScan.
- Choose PRICE from the list.
- Set Price History to Greater Than, Time Frame to Daily and Value to 2.45
- Select Add Condition in the Edit tab of the EasyScan.
- Choose VOLUME from the list.
- Set Volume to Greater Than, Time Frame to Daily and Value to 250000.00.

Then you add the WatchList Column and use it as a sort as described earlier.

A year is 52-weeks, so you would change the MAXH13 to a MAXH52:

C <= .5 * MAXH52 AND SGN(AVGC8 - AVGC21) <> SGN(AVGC8.1 - AVGC21.1) AND C > 50

I haven't checked this version of the formula, but the previous version was quite restrictive.

Bruce, I am looking for a PCF for the 8 day crossing the 21 day SMA in the weekly and the stock is under the 23.6 fibonacci level. thanks

The 8-Period Simple Moving Average crossing through the 21-Period Simple Moving Average in either direction can be written as:

SGN(AVGC8 - AVGC21) <> SGN(AVGC8.1 - AVGC21.1)

You need to set the Time Frame of the Condition Formula when you create it to Weekly for it to use Weekly bars.

Having the stock be under the 23.6 fibonacci level is a *lot* harder. The Condition Formula can't access the Fib Drawing Tools and trying to algorithmically determine the most recent high, low and direction of the line connecting the two quickly results in formulas which are too long to be practical for anything besides the shortest periods of time.

We could do something simple like determining that the current price was at or below 23.6% of the range over the most recent 13-bars by using a Stochstic.

Understanding Stochastics

If we add that to the above formula, we get:

SGN(AVGC8 - AVGC21) <> SGN(AVGC8.1 - AVGC21.1) AND STOC13 <= 23.6

Bruce, I only want to trade stocks that are above the 23.8 fib retracement and re testing it with a market cap over 500M and volume over 500,000. Any ideas? Thanks

I can't actually make the EasyScan for you, but we have explored how to do all of this above. You should be able to apply the same techniques to create the desired EasyScan on your own.

My Monday, April 22, 2013 10:14:55 AM ET post discussed the difficulties in actually using Fibonacci Retracements and suggested using Stochastics as a workaround. You would just need to check for the Stochastic of the desired period being > 23.8 instead of <= 23.8.

Adding Capitalization to an EasyScan is as simple as selecting Add Condition in the Edit tab of the EasyScan, choosing Capitalization from the list and adjusting the settings as desired.

Building a Scan with Multiple Conditions

My Friday, April 19, 2013 1:35:02 PM ET post has examples of using Volume in a Condition Formula and of adding Volume to an EasyScan by selecting Add Condition in the Edit tab of the EasyScan, choosing VOLUME from the list and adjusting the settings as desired.