Worden Discussion Forum

Welcome Guest, please sign in to participate in a discussion.

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » PCFs

PCFs	Rate this Topic:

Previous Topic · Next Topic

Watch this topic · Print this topic ·

chato

Posted : Saturday, July 3, 2010 12:19:15 PM

Registered User
Joined: 8/4/2008
Posts: 12

I am having trouble with my PCFs picking up non-conforming stocks. Today my 3 day 1.034 PCF listed 8 stocks including RDCM and SRTY which did not go up 1.034 over the open for the last 3 days. Also my 2 day 1.034 PCF listed about 24 stocks and about 12 stocks should not be there. GYRO CIZN HOOK CBPO JGBO CBPO SYPR MXC PLA CYD TLF CRZO ECHO RDCM - do not fit the PCF. Am I doing something wrong?

3 day 1.034 PCF
H > O * 1.034 AND H1 > O1 * 1.034 AND H2 > O2 * 1.034 AND H3 > O3 * 1.034 AND AVGV5 > 800 AND C > 3.6 AND C < 200

2 day 1.034
H > O * 1.0258 AND H1 > O1 * 1.0258 AND H2 > O2 * 1.0258 AND AVGV5 > 800 AND C > 3.6 AND C < 200

Thanks - Chato

diceman

Posted : Sunday, July 4, 2010 12:32:46 AM

Registered User
Joined: 1/28/2005
Posts: 6,049

"about 12 stocks should not be there. GYRO CIZN HOOK CBPO JGBO CBPO SYPR MXC PLA CYD TLF CRZO ECHO RDCM - do not fit the PCF. Am I doing something wrong?"
====================================================

I only get true for PLA, CYD, RDCM, CRZO.

The others are false (on the 2 day pattern)

Thanks
diceman

chato

Posted : Tuesday, July 6, 2010 1:02:49 PM

Registered User
Joined: 8/4/2008
Posts: 12

Thanks for the note- as of 7/3/10, the historicals show that , PLA got up 1.034 (not closed) over the open for one day only (Friday), Cyd was up 0 days, RDCM was up one day and again Crzo never reached 1.034 over the open price either Thursday or Friday.

As a result none of the four stocks should have come up true as they did not satisfy the conditions for either the 3 day or 2 day scan.

Why are my scans not working? Do I have to re-write the formulas? I certainly would appreciate some insight on this - CHATO

Bruce_L

Posted : Tuesday, July 6, 2010 1:27:22 PM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

chato,
I get the following symbols when updated through July 2, 2010 Market Close for All Items in System (which you call a 3-Day formula but which I would consider a 4-Day formula):

H > O * 1.034 AND H1 > O1 * 1.034 AND H2 > O2 * 1.034 AND H3 > O3 * 1.034 AND AVGV5 > 800 AND C > 3.6 AND C < 200

$TICKA, DRV, FAZ, IDT, RDCM, SMN, SQQQ, SRTY, SSG & TYP

The formula would not be applicable to a symbol such as $TICKA which crosses through zero, but all of the other symbols were up more than 3.4% above the Open during the most recent 4-Market Days at that time (which is what the formula specifies).

When you originally asked about these formulas you seemed to understand that using multiplication was the correct thing to do for percent changes (even though there is some confusion as to what you should be using for particular percent changes).

Cusstom Scan
PCF
Syntax Errors

You now seem to want something where the price is at least $1.034 above the Open during the day. If that is the case, you need to use addition instead of multiplication:

H >= O + 1.034 AND H1 >= O1 + 1.034 AND H2 >= O2 + 1.034 AND H3 >= O3 + 1.034 AND AVGV5 > 800 AND C > 3.6 AND C < 200

Your "2-Day" formula (which I would consider a 3-Day formula):

H > O * 1.0258 AND H1 > O1 * 1.0258 AND H2 > O2 * 1.0258 AND AVGV5 > 800 AND C > 3.6 AND C < 200

Is testing for Price to have been more than 2.58% above the Open at some point during the day for the most recent 3-Trading Days. When updated through July 2, 2010 Market Close, I get the following symbols (which I typed by hand, so there could be a typo):

$AMXA, $TICKA, AGYS, AHC, APC, BGZ, BZQ, CCRT, CF, CRZO, CYD, DAC, DRV, DTO, DWSN, ERY, FAZ, FDML, GAP, IDT, IO, JASO, KITD, LDK, LTBR, MAPP, MTRX, MWN, NANO, NR, PDFS, PGNX, PLA, PRS, PWRD, QID, RDCM, RLRN, SCO, SDD, SDOW, SGMO, SKF, SMN, SOL, SPWRA, SQQQ, SRS, SRTY, SSG, STP, TSL, TYP, TZA, UNIS, UPI, VHC, YGE & ZINC

All of these symbols seem to fit the criteria (keeping in mind that percentages are not applicable to symbols that can cross through zero). If you want to change it to being at least $1.0258 above the Open, you would need to use addition instead of multiplication:

H >= O + 1.0258 AND H1 >= O1 + 1.0258 AND H2 >= O2 + 1.0258 AND AVGV5 > 800 AND C > 3.6 AND C < 200

How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

diceman

Posted : Tuesday, July 6, 2010 1:28:03 PM

Registered User
Joined: 1/28/2005
Posts: 6,049

" Cyd was up 0 days,"
================

Wasnt the high greater than the open on 6/30, 7/1, and 7/2?

Are you sure you are looking at a daily chart? (moved all the way to the left)

Thanks
diceman

Bruce_L

Posted : Thursday, July 8, 2010 10:44:58 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

QUOTE (chato)

Thank you Bruce for your comments to “chato” on 7/06/10. I do want the multiplication option (a minimum high of 1.034 or 1.0258 times the open price for the designated number of days). I use stock historicals to easily see the daily records of opens and highs. On your first list beginning with $ticka , RDCM disqualified on 7/1 and SRTY on 6/30.

RDCM and SRTY both clearly passed using 7/02/2010 Market Close data.

RDCM
7/02/2010: 5.25 / 5.02 = 1.045816733067729
7/01/2010: 5.05 / 4.84 = 1.043388429752066
6/30/2010: 5.42 / 5.15 = 1.052427184466019
6/29/2010: 5.27 / 5.01 = 1.05189620758483

SRTY
7/02/2010: 64.57 / 60.44 = 1.068332230311052
7/01/2010: 65.95 / 59.97 = 1.099716524929131
6/30/2010: 60.57 / 58.54 = 1.034677143833276
6/29/2010: 59.20 / 54.78 = 1.080686381891201

QUOTE (chato)

On the second stock list for the 1.0258 formula beginning with $AMAX, I did not check them all but RDCM, PLA, & CY flunked the conditions on one day and should not be listed as TRUE.

The math for RDCM is already supplied above. Since CY is not on the list, I'm going to assume you meant CYD. Both of these clearly passed using 7/02/2010 Market Close data as well.

PLA
7/02/2010: 4.25 / 4.05 = 1.049382716049383
7/01/2010: 4.25 / 4.05 = 1.049382716049383
6/30/2010: 4.40 / 4.09 = 1.075794621026895

CYD
7/02/2010: 16.79 / 16.19 = 1.037059913526868
7/01/2010: 16.49 / 15.48 = 1.065245478036176
6/30/2010: 15.85 / 15.20 = 1.042763157894737

QUOTE (chato)

I was using another firm for these scans, I switched to Worden and was very pleased with the results with just an occasional error. Recently, I seem to getting 10 to 35% errors and find that some qualifying stocks listed yesterday are not picked up again today. I cannot expect 100% perfection but if I have to individually re-check a significant percentage of the results then it defeats the purpose of the scan.

Is there some reason for what I perceive as a change or is there something I can do to minimize the problem. I would appreciate your comments - CHATO

Since the Personal Criteria Formulas still appear to be producing the correct results, I'm not sure what problem there is that would need to be minimized.

If you can provide some examples that actually should be identified that aren't or that actually shouldn't be identified that are, we will do our best to troubleshoot the issue.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

chato

Posted : Wednesday, July 14, 2010 1:12:48 AM

Registered User
Joined: 8/4/2008
Posts: 12

Thank you Bruce, we seem to be comming to different conclusions. I suggest that I review what I want and the formula with you to see if we are on the same page.

I want a scan that shows all stocks that go up at least 1.034 times the open price during the day trading session for successive days, 2 , 3, 4, etc. depending on the PCF. If a stock opens at $5.00 it must reach at least 5.17 to qualify (5.00 times 1.034) and it must do this on the number of last consecutive days that the the PCF calls for. The same would apply for a 1.0258 scan. So the first question is - do the formulas noted in my 7/3 post give these results?

If the formulas are correct then we have to address the differences in results. To check past results I go to the historical tables found on my E trade, Google or Yahoo sites. For the 1.0340 scan all three sites show RDCM on 7/01 opening at 5.02 with a high of 5.05 and SRTY on 6/30 opening at 58.66 with a high of 60.57. Neither of these highs are 1.0340 times the open price so they should be eliminated form the results.

On the 1.0258 scan, PLA is listed on 7/1 with a 4.24 open and a high of 4.25 and CYD on 7/2 with an open of 16.43 and a high of 16.79 neither are 1.0258 times their open.

Tonight, 7/13 I did a 3 day 1.034 scan resulting in FBP.E - GOK - NOG - PSUN - and SNBC. NOG on 7/12 is listed as opening at 13.57 with a high of 13.97 which is less that the open times 1.0340.

Your comments please -

Bruce_L

Posted : Wednesday, July 14, 2010 12:12:04 PM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

QUOTE (chato)

I want a scan that shows all stocks that go up at least 1.034 times the open price during the day trading session for successive days, 2 , 3, 4, etc. depending on the PCF. If a stock opens at $5.00 it must reach at least 5.17 to qualify (5.00 times 1.034) and it must do this on the number of last consecutive days that the the PCF calls for. The same would apply for a 1.0258 scan. So the first question is - do the formulas noted in my 7/3 post give these results?

The first Personal Criteria Formula looks for the High to be more than 1.034 times the Open over a period of four days while the second PCF looks for the High to be more than 1.0258 times the Open over a period of three days. If you want these comparisons to be "at least", you should change the > to >= for the comparisons. Both formulas add the additional conditions that the average volume over the last five days be at least 80000 shares and the Closing Price of the most recent Bar be greater than $3.60 and less than $200.00.

QUOTE (chato)

If the formulas are correct then we have to address the differences in results. To check past results I go to the historical tables found on my E trade, Google or Yahoo sites. For the 1.0340 scan all three sites show RDCM on 7/01 opening at 5.02 with a high of 5.05 and SRTY on 6/30 opening at 58.66 with a high of 60.57. Neither of these highs are 1.0340 times the open price so they should be eliminated form the results.

On the 1.0258 scan, PLA is listed on 7/1 with a 4.24 open and a high of 4.25 and CYD on 7/2 with an open of 16.43 and a high of 16.79 neither are 1.0258 times their open.

TeleChart has no magical method of reading the data from other sites. It uses the data within TeleChart for its calculations.

For RDCM, TeleChart shows a High of 5.05 and an Open of 4.84 on 07/01/2010.

For SRTY, TeleChart shows a High of 60.57 and an Open of 58.54 on 06/30/2010.

For PLA, TeleChart shows a High of 4.25 and an Open of 4.05 on 07/01/2010.

For CYD, TeleChart shows a High of 16.79 and an Open of 16.19 on 07/02/2010.

Using this data, both symbols met the criteria. If you think the data in TeleChart is incorrect, you should report it to the attention of our data department at:

support@worden.com

QUOTE (chato)

Tonight, 7/13 I did a 3 day 1.034 scan resulting in FBP.E - GOK - NOG - PSUN - and SNBC. NOG on 7/12 is listed as opening at 13.57 with a high of 13.97 which is less that the open times 1.0340.

I get $AMAD, $AMXD, $TICKA, FBP.E, GOK, NOG, PSUN & SNBC as results for the first Personal Criteria Formula when tested against All Items in System, so if you are using a stock based WatchList, our results would appear to be consistent.

NOG
7/13/2010: 14.72 / 13.90 = 1.058992805755396
7/12/2010: 13.97 / 13.29 = 1.051166290443943
7/09/2010: 13.67 / 13.07 = 1.045906656465187
7/08/2010: 13.32 / 12.87 = 1.034965034965035

-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.