Registered User
Joined: 2/21/2009
Posts: 13
|
Today I attended the Durham event and spoke to Chris, Julia and Michael. They all suggested I post here to get my answers.I need help in creating 3 uptrend PCF's and 3 downtrend PCF's. They are all similar but with different MA's. Trying to find stocks either trading up or down to a MA and is straddling the MA.Please provide the most simple instructions as possible on how I get these PCF's into my Telechart. I'm not very technical when it comes to computers. Once the PCF is provided, I'm guessing that I will be able to copy and paste it into my Telechart? If there is something easier, let me know. Thank you very much in advance.1. First uptrend PCF -Simple 20 MA of today is greater than Simple 20 of yesterday and -High of today is greater than 20 simple MA of today -Low of today is less than 20 simple MA of today-Stochastics(8,3,3) %K is greater than 40%-Market needs 1 day trading above 20 simple ma and then trades down to 20 simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars________________________________________________2. Second Uptrend PCF -Simple 50 simple MA of today is greater than 50 simple MA of yesterday and-High of today is greater than simple 50 MA of today-Low of today is less than 50 simple MA of today-Stochastics(8,3,3) %K is less than 40%-Market needs 1 trading day above 50 simple MA and then trades down to 50 simple MA-At least 1 million shares traded per day for last 50 trading days -Price range of stocks between 15-60 dollars_________________________________________________3. Third Uptrend PCF-Simple 200 of today is greater than simple 200 MA of yesterday and-High of today is greater than simple 200 MA of today and -Low of today is is than simple 200 MA of today-Stochastics(8,3,3) %K is less than 40%-Market needs at least 1 trading day above 200 Simple 200 MA and then trades down to 200 Simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars____________________________________________________1. First downtrend PCF-20 simple MA is less than the simple 20 MA of yesterday and-High of today is greater than simple 20 MA of today -Low of today is less than simple 20 MA of today-Stochastics(8,3,3) %K is greater than 60%-Market needs at least 1 trading day below simple 20 MA and then trades up to 20 Simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars_____________________________________________________2. Second downtrend PCF-50 simple MA is less than the simple 50 MA of yesterday and-High of today is greater than 50 simple MA of today-Low of today is less than 50 simple MA of today-Stochastics(8,3,3) %K is greater than 60%-Market needs at least 1 trading day below simple 50 MA and then trades up to 50 simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars________________________________________________________3. Third downtrend PCF-200 simple MA is less than the 200 simple MA of yesterday and-High of today is greater than the 200 simple MA of today-Low of today is less than the 200 simple MA of today-Stochastics(8,3,3) %K is greater than 60%-Market needs at least 1 trading day below simple 200 MA and then trades up to 200 simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars
|
|
Registered User
Joined: 2/21/2009
Posts: 13
|
Not sure what happened to the formatting, this is not how it looked when I clicked on the post button.
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
"Once the PCF is provided, I'm guessing that I will be able to copy and paste it into my Telechart? "
=====================================================
Yes you will be able to copy and paste.
You may be interested in this:
Thanks
diceman
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Wickcity) 1. First uptrend PCF -Simple 20 MA of today is greater than Simple 20 of yesterday and -High of today is greater than 20 simple MA of today -Low of today is less than 20 simple MA of today-Stochastics(8,3,3) %K is greater than 40%-Market needs 1 day trading above 20 simple ma and then trades down to 20 simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC20 > AVGC20.1 AND H > AVGC20 AND L < AVGC20 AND STOC8.3 > 40 AND C1 > AVGC20.1 AND C <= AVGC20 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC20 > AVGC20.1 AND H > AVGC20 AND L < AVGC20 AND XAVG(STOC8,3) > 40 AND C1 > AVGC20.1 AND C <= AVGC20 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
QUOTE (Wickcity) 2. Second Uptrend PCF -Simple 50 simple MA of today is greater than 50 simple MA of yesterday and-High of today is greater than simple 50 MA of today-Low of today is less than 50 simple MA of today-Stochastics(8,3,3) %K is less than 40%-Market needs 1 trading day above 50 simple MA and then trades down to 50 simple MA-At least 1 million shares traded per day for last 50 trading days -Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC50 > AVGC50.1 AND H > AVGC50 AND L < AVGC50 AND STOC8.3 < 40 AND C1 > AVGC50.1 AND C <= AVGC50 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC50 > AVGC50.1 AND H > AVGC50 AND L < AVGC50 AND XAVG(STOC8,3) < 40 AND C1 > AVGC50.1 AND C <= AVGC50 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
QUOTE (Wickcity) 3. Third Uptrend PCF-Simple 200 of today is greater than simple 200 MA of yesterday and-High of today is greater than simple 200 MA of today and -Low of today is is than simple 200 MA of today-Stochastics(8,3,3) %K is less than 40%-Market needs at least 1 trading day above 200 Simple 200 MA and then trades down to 200 Simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC200 > AVGC200.1 AND H > AVGC200 AND L < AVGC200 AND STOC8.3 < 40 AND C1 > AVGC200.1 AND C <= AVGC200 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC200 > AVGC200.1 AND H > AVGC200 AND L < AVGC200 AND XAVG(STOC8,3) < 40 AND C1 > AVGC200.1 AND C <= AVGC200 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
QUOTE (Wickcity) 1. First downtrend PCF-20 simple MA is less than the simple 20 MA of yesterday and-High of today is greater than simple 20 MA of today -Low of today is less than simple 20 MA of today-Stochastics(8,3,3) %K is greater than 60%-Market needs at least 1 trading day below simple 20 MA and then trades up to 20 Simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC20 < AVGC20.1 AND H > AVGC20 AND L < AVGC20 AND STOC8.3 > 60 AND C1 < AVGC20.1 AND C >= AVGC20 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC20 < AVGC20.1 AND H > AVGC20 AND L < AVGC20 AND XAVG(STOC8,3) > 60 AND C1 < AVGC20.1 AND C >= AVGC20 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
QUOTE (Wickcity) 2. Second downtrend PCF-50 simple MA is less than the simple 50 MA of yesterday and-High of today is greater than 50 simple MA of today-Low of today is less than 50 simple MA of today-Stochastics(8,3,3) %K is greater than 60%-Market needs at least 1 trading day below simple 50 MA and then trades up to 50 simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC50 < AVGC50.1 AND H > AVGC50 AND L < AVGC50 AND STOC8.3 > 60 AND C1 < AVGC50.1 AND C >= AVGC50 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC50 < AVGC50.1 AND H > AVGC50 AND L < AVGC50 AND XAVG(STOC8,3) > 60 AND C1 < AVGC50.1 AND C >= AVGC50 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
QUOTE (Wickcity) 3. Third downtrend PCF-200 simple MA is less than the 200 simple MA of yesterday and-High of today is greater than the 200 simple MA of today-Low of today is less than the 200 simple MA of today-Stochastics(8,3,3) %K is greater than 60%-Market needs at least 1 trading day below simple 200 MA and then trades up to 200 simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC200 < AVGC200.1 AND H > AVGC200 AND L < AVGC200 AND STOC8.3 > 60 AND C1 < AVGC200.1 AND C >= AVGC200 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC200 < AVGC200.1 AND H > AVGC200 AND L < AVGC200 AND XAVG(STOC8,3) > 60 AND C1 < AVGC200.1 AND C >= AVGC200 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
Understanding Stochastics
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/21/2009
Posts: 13
|
Bruce, I GREATLY appreciate your help, trying to decipher the code, I'm still confused. I do have a question for you. Take a look at what you wrote for the very first scan. I have a question about this part...........C1 > AVGC20.1 AND C <= AVGC20 I'm not sure if this part is tied into exactly ONE day only above the 20MA and then down to the 20MA?
Does this say....Close of yesterday is > than yesterdays 20 MA and Close of today is < = than todays close of todays 20MA? I'm not sure if I need this part or not? See below.
Here is the reason I"m asking. I believe you correctly wrote the code as I wrote it, but here is the part I may have made a mistake on. In my original post, I wrote that the market needs 1 day trading above the 20 MA and then trades down to the 20 MA.
What I meant to write is that the market needs AT LEAST one day above the 20MA. Another words, the market could trade one OR 8 days(any number) of above the 20 MA and eventually come down to the 20 MA.
And what I really need when it comes down to the 20MA, I want the bar to be straddling the 20MA.
This is what I need.
-price falls to the 20MA and price is straddling the 20 MA
-all things were correct like the stochastics, price and volume
Hopefully I've explained myself well enough now for you to understand exactly what I need. I'm still confused if I need your code that you wrote or does it need to be altered?
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Wickcity) Take a look at what you wrote for the very first scan. I have a question about this part...........C1 > AVGC20.1 AND C <= AVGC20 I'm not sure if this part is tied into exactly ONE day only above the 20MA and then down to the 20MA? Does this say....Close of yesterday is > than yesterdays 20 MA and Close of today is < = than todays close of todays 20MA?
You have exactly interpreted what this portion of the Personal Criteria Formula means.
QUOTE (Wickcity) What I meant to write is that the market needs AT LEAST one day above the 20MA. Another words, the market could trade one OR 8 days(any number) of above the 20 MA and eventually come down to the 20 MA.
If we are only testing for one day, it isn't going to mean exactly one day because nothing about the previous days is being tested. This means there could be one or any number of days above the Moving Average.
QUOTE (Wickcity) And what I really need when it comes down to the 20MA, I want the bar to be straddling the 20MA.
You are already explicitly testing for the straddle earlier in the PCF. This means can eliminate the test for the current Bar being at or below the Moving Average (C <= AVGC20). In addition, I suspect this also means you want the previous Bar (and possibly more Bars) to be entirely above the Moving Average. This means would would need to change C1 > AVGC20.1 to L1 > AVGC20.1.
QUOTE (Wickcity) 1. First uptrend PCF -Simple 20 MA of today is greater than Simple 20 of yesterday and -High of today is greater than 20 simple MA of today -Low of today is less than 20 simple MA of today-Stochastics(8,3,3) %K is greater than 40%-Market needs 1 day trading above 20 simple ma and then trades down to 20 simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC20 > AVGC20.1 AND H > AVGC20 AND L < AVGC20 AND STOC8.3 > 40 AND L1 > AVGC20.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC20 > AVGC20.1 AND H > AVGC20 AND L < AVGC20 AND XAVG(STOC8,3) > 40 AND L1 > AVGC20.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
QUOTE (Wickcity) 2. Second Uptrend PCF -Simple 50 simple MA of today is greater than 50 simple MA of yesterday and-High of today is greater than simple 50 MA of today-Low of today is less than 50 simple MA of today-Stochastics(8,3,3) %K is less than 40%-Market needs 1 trading day above 50 simple MA and then trades down to 50 simple MA-At least 1 million shares traded per day for last 50 trading days -Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC50 > AVGC50.1 AND H > AVGC50 AND L < AVGC50 AND STOC8.3 < 40 AND L1 > AVGC50.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC50 > AVGC50.1 AND H > AVGC50 AND L < AVGC50 AND XAVG(STOC8,3) < 40 AND L1 > AVGC50.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
QUOTE (Wickcity) 3. Third Uptrend PCF-Simple 200 of today is greater than simple 200 MA of yesterday and-High of today is greater than simple 200 MA of today and -Low of today is is than simple 200 MA of today-Stochastics(8,3,3) %K is less than 40%-Market needs at least 1 trading day above 200 Simple 200 MA and then trades down to 200 Simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC200 > AVGC200.1 AND H > AVGC200 AND L < AVGC200 AND STOC8.3 < 40 AND L1 > AVGC200.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC200 > AVGC200.1 AND H > AVGC200 AND L < AVGC200 AND XAVG(STOC8,3) < 40 AND L1 > AVGC200.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
QUOTE (Wickcity) 1. First downtrend PCF-20 simple MA is less than the simple 20 MA of yesterday and-High of today is greater than simple 20 MA of today -Low of today is less than simple 20 MA of today-Stochastics(8,3,3) %K is greater than 60%-Market needs at least 1 trading day below simple 20 MA and then trades up to 20 Simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC20 < AVGC20.1 AND H > AVGC20 AND L < AVGC20 AND STOC8.3 > 60 AND H1 < AVGC20.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC20 < AVGC20.1 AND H > AVGC20 AND L < AVGC20 AND XAVG(STOC8,3) > 60 AND H1 < AVGC20.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
QUOTE (Wickcity) 2. Second downtrend PCF-50 simple MA is less than the simple 50 MA of yesterday and-High of today is greater than 50 simple MA of today-Low of today is less than 50 simple MA of today-Stochastics(8,3,3) %K is greater than 60%-Market needs at least 1 trading day below simple 50 MA and then trades up to 50 simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC50 < AVGC50.1 AND H > AVGC50 AND L < AVGC50 AND STOC8.3 > 60 AND H1 < AVGC50.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC50 < AVGC50.1 AND H > AVGC50 AND L < AVGC50 AND XAVG(STOC8,3) > 60 AND H1 < AVGC50.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
QUOTE (Wickcity) 3. Third downtrend PCF-200 simple MA is less than the 200 simple MA of yesterday and-High of today is greater than the 200 simple MA of today-Low of today is less than the 200 simple MA of today-Stochastics(8,3,3) %K is greater than 60%-Market needs at least 1 trading day below simple 200 MA and then trades up to 200 simple MA-At least 1 million shares traded per day for last 50 trading days-Price range of stocks between 15-60 dollars
If the Stochastic is Simple:
AVGC200 < AVGC200.1 AND H > AVGC200 AND L < AVGC200 AND STOC8.3 > 60 AND H1 < AVGC200.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
If the Stochastic is Exponential:
AVGC200 < AVGC200.1 AND H > AVGC200 AND L < AVGC200 AND XAVG(STOC8,3) > 60 AND H1 < AVGC200.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/21/2009
Posts: 13
|
I hope you can bare with me on this. I'm having a difficult time wrapping my brain around this. If I add in the last part you added on...L1 > AVGC200.1 In addition, I suspect this also means you want the previous Bar (and possibly more Bars) to be entirely above the Moving Average. This means would would need to change C1 > AVGC20.1 to L1 > AVGC20.1. Doesn't this contradict the earlier part of the PCF and the straddle part because the L1 > AVGC20.1 because this is saying that the low of yesterday is > than the 20ma close of yesterday which would no longer give me a straddle on the MA?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Wickcity) Doesn't this contradict the earlier part of the PCF and the straddle part because the L1 > AVGC20.1 because this is saying that the low of yesterday is > than the 20ma close of yesterday which would no longer give me a straddle on the MA?
No, the straddle is for today, not yesterday:
H > AVGC20 AND L < AVGC20
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/21/2009
Posts: 13
|
This is the code I copied and pasted.
AVGC20 > AVGC20.1 AND H > AVGC20 AND L < AVGC20 AND STOC8.3 > 40 AND L1 > AVGC20.1 AND MINV50.1 >= 10000 AND 15 <= C AND C <= 60
This did not give me the desired results at all, not even close. The last bar is supposed to be straddling the 20MA. I have some far above the 20, some far below the 20.
This is driving me nuts. I've spend about 10 hours so far on this and its not working....
|
|
Registered User
Joined: 2/21/2009
Posts: 13
|
I've been messing around with this since the market closed today. I've finally gotten somewhere with the scans by doing them by hand(inputting) and not copying and pasting the scans above.But now I've having another issue on Telechart. For my 50 SMA scans its coming up with DOW, ORLY, PNC, TMX, INTC AND AVY. When I started using the space bar down, I was noticing that these stocks are not sitting on their 50ma. I thought something was wrong with my scan criteria(checking for the last 3 hours). As it turns out, the 200 simple ma on my(at least) Telechart is wrong, its placing the 200ma in the wrong location. I confirmed this by checking freestockcharts and two other platforms I have. What is interesting is that 13 stocks met my criteria for the 50ma scan. If you count the stocks listed above that gives you a total of 6. So that means the other 7 are correct with the 200 placement and 6 are wrong. I've checked to make sure my telechart is a simple 200ma. Could it be anything else? If somebody could type in these tickers and see if the close of 12/15 that DOW, ORLY, PNC, TMX, INTC AND AVY are sitting on their 200ma I would appreciate it.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The most likely reasons for the "wrong" location for the Moving Average is that the Plotted Moving is Exponential or that the Plotted Moving Average is of another Moving Average instead of being of Price. The following topic (referenced earlier) should help you explore this and other possibilities to determine what is wrong:
Things to check if your moving averages don't "seem right" or "seem to match"
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/21/2009
Posts: 13
|
Bruce, you were correct about the MA's. It was plotted separately from price.I do have a question for you on my volume criteria of >= 1 million shares for the last 50 days.I have tried this one.....AVGV50 >= 10000I have also tried this one......MINV50.1 >= 10000I'm still having stocks show up with volume less than 1 million shares and this was yesterdays close, so it fall outside of the last 50 days. Just two of the top of my head were DOX and CGA, they traded around 450,000 shares yesterday. Any thoughts on this?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
AVGC50 is the current 50-Period Simple Moving Average of Volume.
MINV50.1 is the Minimum 1-Bar Volume over the 50-Bars ending 1-Bar Ago.
You might want to try using MINV50 instead of MINV50.1. I used MINV50.1 to allow you the possibility of using the scan early in the day before the Volume condition might be met for the current day (as long as it was met for the last 50-days).
On another note, while DOX and CGA both return True for AVGV50 >= 10000 (many days could be below the tested Volume when testing the Average), neither returns True for MINV50.1 >= 10000 on my computer. What method are you using to determine if the PCF is True for a particular symbol? Are you using the PCF as an EasyScan Condition, Sort or Watchlist Column or something else?
Using EasyScan to find stocks that meet your own criteria
Create your own stock rankings using WatchLists and Sort conditions
Customize the Information Displayed in the WatchList
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/21/2009
Posts: 13
|
Yes, I'm using PCF as an Easyscan condition.
|
|
|
Guest-1 |