| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/27/2006
Posts: 9
|
I have made up the following pcf formulae, well I pasted it from an information sheet, but it does not give any results. I have pasted 10 other formulae from the same source and none give any results.What might be the problem, that the formula is incorrect or that pasting it does not register in the system - although everything seems to have been recorded ?
One of the formulae is:PCF : O >= C1 AND C > O AND O1 = C1 AND C1 <= C2 AND C > C2 AND C2 < O2 AND C2 < C3 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 =< C) OR (((AVGC30 - C) / C) => 0.058) OR (((AVGC30 - C) / C) =< 0.01)) AND ((C O) / O) => 0.009
Thanks David
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
The PCF
O >= C1 AND C > O AND O1 = C1 AND C1 <= C2 AND C > C2 AND C2 < O2 AND C2 < C3 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 =< C) OR (((AVGC30 - C) / C) => 0.058) OR (((AVGC30 - C) / C) =< 0.01)) AND ((C O) / O) => 0.009
Had no stocks today that returned TRUE for it.
You have, at the end, a typo
((C O) / O) => 0.009
You have
AVGC30 =< C
Which should be C>=AVGC30
I assume it is supposed to be ((C-O) / O) => 0.009. You also demand that C>O. These are essentially asking the same thing.
That all being the case, you are asking a lot from a stock to meet all of these conditions. I am not even sure what you are hoping to uncover with this PCF. Can you explain what you were looking for.
I recommend, in general, keeping your PCFs simple. You can always combing them in EasyScan. Example:
Instead of one LONG restrictive PCF, why not make 14 seperate PCFs? I've seperated them below. You can then add each of them, one at a time in an EasyScan, and see where and when you are left with zero stocks.
Open Greater/equal than Close Yest
O >= C1
Close above Open today
C > O
Open equals Close (yesterday)
O1 = C1
Closed Higher Yesterday
C1 <= C2
Closed above 2 days ago
C > C2
Close below open (2days ago)
C2 < O2
Closed down 2 days ago
C2 < C3
Higher Volume Today
V > V1
Stoc12.3 under 30
STOC12.3 <= 30
Closed over 10
C > 10
Closed in top half of body 2days ago
C >= (((O2 - C2) * 0.40) + C2)
STOC12.3 over 30 8days ago
STOC12.3.8 > 30
[I have no idea what you are trying to do here]
((AVGC30 =< C) OR (((AVGC30 - C) / C) => 0.058) OR (((AVGC30 - C) / C) =< 0.01))
Closed above Open
((C-O) / O) => 0.009
- Craig
Here to Help!
|
|
Registered User
Joined: 1/27/2006
Posts: 9
|
I am following a stock pisking system using PCFs, basically scanning for very specific morning and evening stars. I have copied and pasted the formulae onto the TC system but when I do the scan I get no signals. This would not be a problem as the formulae are fairly detailed and not expected to give many signals. However I have been in conversation with the system founder and when he pastes exactly the same formulae onto his TC gold he gets signals, for instance today 5, yesterday 3. Thousands of his members get his same signals but my system does not. I have tried breaking the formula down to see where exactly the formula generates and does not generate signals. However if I am copying and pasting then my formula should be the same as everyony elses so why do I not get signals?
Could it be anything to do with my software?
I know that I am doing the scan right as when I use just part of the formula I do get signals. If it were not for everyone else getting signals I would have thought that there were none but there are, I am just not producing them.
Could you suggest what I might do ?
Thanks
David
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The first thing I would check is that your Personal Criteria Formulas are updated and that you are updating them for All Items in System. To update your PCFs manually:
Select Databank | Personal Criteria Formulas and verify that Calculate For is set to All Items in System and that Include criteria which require more than 250 days of history (slower) is checked. Then select Update All Criteria.
You may also wish to update your update your PCFs automatically each time you update your data. To do this:
Select Databank | Update via Internet and verify that Update Personal Criteria following download and Include criteria which require more than 250 days of history (slower) are checked. Then select Update.
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/27/2006
Posts: 9
|
I have tried what you recommended and still I have had no success. The complete formula is:
(O >= C1 AND C > O AND O1 = C1 AND C1 <= C2 AND C > C2 AND C2 < O2 AND C2 < C3 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 =< C) OR (((AVGC30 - C) / C) => 0.058) OR (((AVGC30 - C) / C) =< 0.01)) AND ((C O) / O) => 0.009) OR (O2 > C2 AND O1 = C1 AND C1 > C2 AND O < C AND O < O1 AND C > C1 AND C2 < C3 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 =< C) OR (((AVGC30 - C) / C) => 0.058) OR (((AVGC30 - C) / C) =< 0.01)) AND ((C O) / O) => 0.009) OR (C2 < O2 AND O1 < C1 AND C > O AND O >= C1 AND C1 <= C2 AND C2 < C3 AND C > C2 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 =< C) OR (((AVGC30 - C) / C) => 0.058) OR (((AVGC30 - C) / C) =< 0.01)) AND ((C O) / O) => 0.009) OR (C2 < O2 AND O1 < C1 AND C > O AND O <= O1 AND C2 <= O1 AND C > C1 AND C1 > C2 AND C2 < C3 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 =< C) OR (((AVGC30 - C) / C) => 0.058) OR (((AVGC30 - C) / C) =< 0.01)) AND ((C O) / O) => 0.009) OR (C2 < O2 AND O1 =< C1 AND C > O AND O2 > C1 AND C > C1 AND C2 < C3 AND C > C2 AND O2 > O1 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 =< C) OR (((AVGC30 - C) / C) => 0.058) OR (((AVGC30 - C) / C) =< 0.01)) AND ((C O) / O) => 0.009) OR (C2 < O2 AND C > O AND O2 > C1 AND C > C1 AND C2 < C3 AND C > C2 AND O2 > O1 AND O < O1 AND O < C1 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 =< C) OR (((AVGC30 - C) / C) => 0.058) OR (((AVGC30 - C) / C) =< 0.01)) AND ((C O) / O) => 0.009) OR (C2 = O2 AND C > O AND O2 > C1 AND C > C1 AND C2 < C3 AND C > C2 AND O2 > O1 AND O2 => O1 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 =< C) OR (((AVGC30 - C) / C) => 0.058) OR (((AVGC30 - C) / C) =< 0.01)) AND ((C O) / O) => 0.009) OR (C2 < O2 AND O1 > C1 AND C > O AND C > O1 AND C1 <= O AND C1 <= C2 AND C > C2 AND C2 < C3 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 =< C) OR (((AVGC30 - C) / C) => 0.058) OR (((AVGC30 - C) / C) =< 0.01)) AND ((C O) / O) => 0.009) OR (C < O AND O1 = C1 AND C2 > O2 AND O <= C1 AND C1 >= C2 AND C < C2 AND C2 > C3 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 => C) OR (((C AVGC30) / C) => 0.058) OR (((C AVGC30) / C) =< 0.01)) AND ((O - C) / O) => 0.009) OR (O2 < C2 AND O1 = C1 AND O > C AND C1 < C2 AND O > O1 AND C < C1 AND C2 > C3 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 => C) OR (((C AVGC30) / C) => 0.058) OR (((C AVGC30) / C) =< 0.01)) AND ((O - C) / O) => 0.009) OR (C2 > O2 AND O1 > C1 AND C < O AND O <= C1 AND C1 >= C2 AND C2 > C3 AND C < C2 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 => C) OR (((C AVGC30) / C) => 0.058) OR (((C AVGC30) / C) =< 0.01)) AND ((O - C) / O) => 0.009) OR (C2 > O2 AND O1 > C1 AND C < O AND O >= O1 AND C < C1 AND C1 < C2 AND C2 > C3 AND C2 >= O1 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 => C) OR (((C AVGC30) / C) => 0.058) OR (((C AVGC30) / C) =< 0.01)) AND ((O - C) / O) => 0.009) OR (C2 > O2 AND O1 => C1 AND C < O AND O2 < C1 AND C < C1 AND C2 > C3 AND C < C2 AND O2 < O1 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 => C) OR (((C AVGC30) / C) => 0.058) OR (((C AVGC30) / C) =< 0.01)) AND ((O - C) / O) => 0.009) OR (C2 > O2 AND C < O AND O2 < C1 AND C < C1 AND C2 > C3 AND C < C2 AND O2 < O1 AND O > O1 AND O > C1 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 => C) OR (((C AVGC30) / C) => 0.058) OR (((C AVGC30) / C) =< 0.01)) AND ((O - C) / O) => 0.009) OR (C2 = O2 AND C < O AND O2 < C1 AND C < C1 AND C2 > C3 AND C < C2 AND O2 < O1 AND O2 <= O1 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 => C) OR (((C AVGC30) / C) => 0.058) OR (((C AVGC30) / C) =< 0.01)) AND ((O - C) / O) => 0.009) OR (C2 > O2 AND O1 < C1 AND C < O AND C < O1 AND C1 >= O AND C1 >= C2 AND C < C2 AND C2 > C3 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 => C) OR (((C AVGC30) / C) => 0.058) OR (((C AVGC30) / C) =< 0.01)) AND ((O - C) / O) => 0.009)
I have pasted this from the instructions I was given, which as I mentioned gives 5 signals for today. I know it is complicated but it basically scans for 8 different morning and evening star set ups. This exact formula gives 5 signals for thousands of memebers but not for me!
Perhaps you could paste and scan and let me know your results.
Thanks
David
|
|
Registered User
Joined: 1/27/2006
Posts: 9
|
I forget to mention that this is a scan for optionable stocks only.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I am updated through 10:06am today. I get no stocks meeting the conditions.
There are some typos, though
You have a few instances of:
(C AVGC30)
I believe these are supposed to be:
(C-AVGC30)
Here is the corrected version
(O >= C1 AND C > O AND O1 = C1 AND C1 <= C2 AND C > C2 AND C2 < O2 AND C2 < C3 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 <= C) OR (((AVGC30 - C) / C) >= 0.058) OR (((AVGC30 - C) / C) <= 0.01)) AND ((C O) / O) >= 0.009) OR (O2 > C2 AND O1 = C1 AND C1 > C2 AND O < C AND O < O1 AND C > C1 AND C2 < C3 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 <= C) OR (((AVGC30 - C) / C) >= 0.058) OR (((AVGC30 - C) / C) <= 0.01)) AND ((C O) / O) >= 0.009) OR (C2 < O2 AND O1 < C1 AND C > O AND O >= C1 AND C1 <= C2 AND C2 < C3 AND C > C2 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 <= C) OR (((AVGC30 - C) / C) >= 0.058) OR (((AVGC30 - C) / C) <= 0.01)) AND ((C O) / O) >= 0.009) OR (C2 < O2 AND O1 < C1 AND C > O AND O <= O1 AND C2 <= O1 AND C > C1 AND C1 > C2 AND C2 < C3 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 <= C) OR (((AVGC30 - C) / C) >= 0.058) OR (((AVGC30 - C) / C) <= 0.01)) AND ((C O) / O) >= 0.009) OR (C2 < O2 AND O1 <= C1 AND C > O AND O2 > C1 AND C > C1 AND C2 < C3 AND C > C2 AND O2 > O1 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 <= C) OR (((AVGC30 - C) / C) >= 0.058) OR (((AVGC30 - C) / C) <= 0.01)) AND ((C O) / O) >= 0.009) OR (C2 < O2 AND C > O AND O2 > C1 AND C > C1 AND C2 < C3 AND C > C2 AND O2 > O1 AND O < O1 AND O < C1 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 <= C) OR (((AVGC30 - C) / C) >= 0.058) OR (((AVGC30 - C) / C) <= 0.01)) AND ((C O) / O) >= 0.009) OR (C2 = O2 AND C > O AND O2 > C1 AND C > C1 AND C2 < C3 AND C > C2 AND O2 > O1 AND O2 >= O1 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 <= C) OR (((AVGC30 - C) / C) >= 0.058) OR (((AVGC30 - C) / C) <= 0.01)) AND ((C O) / O) >= 0.009) OR (C2 < O2 AND O1 > C1 AND C > O AND C > O1 AND C1 <= O AND C1 <= C2 AND C > C2 AND C2 < C3 AND V > V1 AND STOC12.3 <= 30 AND C > 10 AND C >= (((O2 - C2) * 0.40) + C2) AND STOC12.3.8 > 30 AND ((AVGC30 <= C) OR (((AVGC30 - C) / C) >= 0.058) OR (((AVGC30 - C) / C) <= 0.01)) AND ((C O) / O) >= 0.009) OR (C < O AND O1 = C1 AND C2 > O2 AND O <= C1 AND C1 >= C2 AND C < C2 AND C2 > C3 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 >= C) OR (((C-AVGC30) / C) >= 0.058) OR (((C-AVGC30) / C) <= 0.01)) AND ((O - C) / O) >= 0.009) OR (O2 < C2 AND O1 = C1 AND O > C AND C1 < C2 AND O > O1 AND C < C1 AND C2 > C3 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 >= C) OR (((C-AVGC30) / C) >= 0.058) OR (((C-AVGC30) / C) <= 0.01)) AND ((O - C) / O) >= 0.009) OR (C2 > O2 AND O1 > C1 AND C < O AND O <= C1 AND C1 >= C2 AND C2 > C3 AND C < C2 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 >= C) OR (((C-AVGC30) / C) >= 0.058) OR (((C-AVGC30) / C) <= 0.01)) AND ((O - C) / O) >= 0.009) OR (C2 > O2 AND O1 > C1 AND C < O AND O >= O1 AND C < C1 AND C1 < C2 AND C2 > C3 AND C2 >= O1 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 >= C) OR (((C AVGC30) / C) >= 0.058) OR (((C-AVGC30) / C) <= 0.01)) AND ((O - C) / O) >= 0.009) OR (C2 > O2 AND O1 >= C1 AND C < O AND O2 < C1 AND C < C1 AND C2 > C3 AND C < C2 AND O2 < O1 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 >= C) OR (((C-AVGC30) / C) >= 0.058) OR (((C-AVGC30) / C) <= 0.01)) AND ((O - C) / O) >= 0.009) OR (C2 > O2 AND C < O AND O2 < C1 AND C < C1 AND C2 > C3 AND C < C2 AND O2 < O1 AND O > O1 AND O > C1 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 >= C) OR (((C AVGC30) / C) >= 0.058) OR (((C-AVGC30) / C) <= 0.01)) AND ((O - C) / O) >= 0.009) OR (C2 = O2 AND C < O AND O2 < C1 AND C < C1 AND C2 > C3 AND C < C2 AND O2 < O1 AND O2 <= O1 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 >= C) OR (((C-AVGC30) / C) >= 0.058) OR (((C-AVGC30) / C) <= 0.01)) AND ((O - C) / O) >= 0.009) OR (C2 > O2 AND O1 < C1 AND C < O AND C < O1 AND C1 >= O AND C1 >= C2 AND C < C2 AND C2 > C3 AND V > V1 AND STOC12.3 >= 80 AND C > 10 AND C <= (C2 - ((C2 - O2) * 0.40)) AND STOC12.3.8 < 80 AND ((AVGC30 >= C) OR (((C-AVGC30) / C) >= 0.058) OR (((C-AVGC30) / C) <= 0.01)) AND ((O - C) / O) >= 0.009)
This still finds no stocks but it is likely an issue of the volume requirements you have in here...
As another aside, this PCF looks for A LOT more than candle patterns. It has VERY restrictive requirements for the close to be VERY close to a moving average.
- Craig
Here to Help!
|
|
Registered User
Joined: 1/27/2006
Posts: 9
|
Hi,
This is David again. I think I may have solved my problem as why my PCFs are not giving me signals when everyone else using them produces them daily. I have been breaking down the formula and there seems to be a problem with the part which identifies whether the present day close finishes more than 40% up the body from 2 days before. The PCF is: C>=(((O2-C2)* 0.40)+ C2)
This part does not produce any signals. I tested it with CEPH for data at 27 close and it produces a false signal. The calculation is written as follows:
52,00,91,00 >= (((53,00,35,00-51,00,63,00)* 40,00)+51,00,63,00)
Result: False.
Should it not be:
52,91>=(((53,35-51,63)* 0.40)+51,63
Which is true.
Why does the formula have all the 0s? Is this a problem with my set up?
Thanks
David
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
ddurrans,
Based on your posted results, I suspect you are not using standard English (US) Regional Settings. We do not officially support non-US English versions of Windows, but you might want to try clicking on Start | Settings | Control Panel | Regional Options. If it is not already selected, please switch to English (United States), click OK and then try TeleChart again. Currently the program is not 100% compatible with non-United States regional date settings and this error, or others, may occur.
Another thought is that if your current Regional Options Settings in Windows use the , as the Decimal Symbol and the . as the Digit Grouping Symbol, you could try changing the 0.40 in the above formula to use 0,40 instead (I have no idea if this will work or not, the first option is better).
You may wish to contact technical support for help with making such changes. All e-mail communication sent to support@worden.com during business hours (Monday through Friday 9AM-11PM and Saturday and Sunday 9AM-3PM ET) should be answered within 20 minutes of arrival. For an even quicker response to tech support questions, we recommend calling our voice line at (919) 408-0542 (there is no phone support on Sundays or after 9PM ET on weekdays).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/27/2006
Posts: 9
|
Craig, Bruce,
Thank you so much for your help. The problem was indeed the settings on windows, I had it on spanish.
Without your support I would have given up.
Once again thanks a lot, you were great!
Kind Regards
David
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Glad to hear its working for you now!
- Craig
Here to Help!
|
|
|
Guest-1 |