 Platinum Customer
Joined: 10/7/2004
Posts: 14
|
i currently use a pcf using stochastics to identify stocks on a daily chart crossing up through the 20 line.......the pcf is "stoc 12.5.1<20 AND stoc 12.5>=20.........it works well......my question is can i get help writing a pcf that will identify stocks on weekly chart crossing up through the 20 line as well? ......my goal is to identify stocks that are crossing up thru the 20 line on both a weekly and a daily chart......i appreciate your response.......
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
seanyboy:
I've fooled around with this one and think I may have come up with something that works. Try this:
STOC60.25.1 < 20 AND STOC60.25 < 20
After you update the PCF, use it to sort All Stocks. Make sure you're looking at a weekly chart, and that your Stochastics parameters are set to 12, 5, and 1.
Based on Market close 12/23/04 data, I found 6 stocks where Stochastics was just crossing up through 20.
You can also set your chart to weekly, and then sort by the Actual Value of Stochastics. Results will range from 1 - 100. If you spacebar through the stocks that returned values just above 20, your eyes will easily spot the ones that were below 20 last week.
If you're not familiar with the Actual Value indicator sorts, click on the following link to view a video that will show you how.
http://www.worden.com/training/default.aspx?g=posts&t=169
- Doug
Teaching Online!
|
|
Platinum Customer
Joined: 10/7/2004
Posts: 14
|
thanks doug........i will go to wor on your suggestions........i appreciate your help!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
seanyboy:
A typo in the above formula was just pointed out to me. The second "less than" should be a "greater than". The formula should actually be:
STOC60.25.1 < 20 AND STOC60.25 > 20
- Doug
Teaching Online!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
seanyboy,
Doug’s PCF is an excellent approximation of your formula on a weekly chart that I wouldn’t hesitate to use. In a very real sense, it is a more accurate representation of your stochastic during that timeframe than the weekly chart itself. Doug’s formula does its calculations for each of the last 25 days instead of just the last day of each of the last five weeks. But, if you need your PCF to match the charts exactly, you might want to try the following:
100* ((C5-MINL60.5)/ (MAXH60.5-MINL60.5)+ (C10-MINL60.10)/ (MAXH60.10-MINL60.10)+ (C15-MINL60.15)/ (MAXH60.15-MINL60.15)+ (C20-MINL60.20)/ (MAXH60.20-MINL60.20)+ (C25-MINL60.25)/(MAXH60.25-MINL60.25))/5<20 AND 100*((C-MINL60)/ (MAXH60-MINL60)+(C5-MINL60.5)/ (MAXH60.5-MINL60.5)+ (C10-MINL60.10)/ (MAXH60.10-MINL60.10)+ (C15-MINL60.15)/ (MAXH60.15-MINL60.15)+ (C20-MINL60.20)/ (MAXH60.20-MINL60.20))/5>=20
The same caveats apply. When comparing your results to a chart, make sure you're looking at a weekly timeframe, and that your Stochastics parameters are set to 12, 5, 1, and simple.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
Hello,
How would you write this for Stochastics 39,2,1 ? Thanks -amberpax.
100*((C5-MINL60.5)/(MAXH60.5-MINL60.5)+ (C10-MINL60.10)/ (MAXH60.10-MINL60.10)+ (C15-MINL60.15)/(MAXH60.15-MINL60.15)+ (C20-MINL60.20)/ (MAXH60.20-MINL60.20)+ (C25-MINL60.25)/(MAXH60.25-MINL60.25))/5<20 AND 100*((C-MINL60)/(MAXH60-MINL60)+(C5-MINL60.5)/ (MAXH60.5-MINL60.5)+(C10-MINL60.10)/ (MAXH60.10-MINL60.10)+ (C15-MINL60.15)/(MAXH60.15-MINL60.15)+ (C20-MINL60.20)/(MAXH60.20-MINL60.20))/5>=20
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
amberpax,
Assuming you want the Simple Stochastic used in the formula give but for different periods, please try the following:
Weekly Simple Stochastic SK 39,2 xUp 20:
(STOC195.1.5 + STOC195.1.10) / 2 <= 20 AND (STOC195 + STOC195.1.5) / 2 > 20
You may wish to review the following:
Understanding Stochastics
Handy PCF example formulas to help you learn the syntax of PCFs!
How to create a Personal Criteria Forumula (PCF)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
Thank you Bruce.
-amberpax
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
amberpax,
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
Bruce,
After creating an easy scan the result is 0 for All Stocks. What gives?
Thanks,
-amberpax
(STOC195.1.5 + STOC195.1.10) / 2 <= 20 AND (STOC195 + STOC195.1.5) / 2 > 20
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
Bruce,
Never mind! I guess you cannot create on easy scan. I've just created a sort and sorted by on a weekly and it gives excellent results.
Thank you,
-amberpax
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
Hello,
I was wrong. When I use this formula:
(STOC195.1.5 + STOC195.1.10) / 2 <= 20 AND (STOC195 + STOC195.1.5) / 2 > 20
my 39,2,1 weekly stockastics are all over the place.
Also I would like to have this in exponential.
Thanks,
-amberpax
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
amberpax,
Please try the following:
.666971637694419 * (STOC195.1.5 + 1 / 3 * (STOC195.1.10 + 1 / 3 * (STOC195.1.15 + 1 / 3 * (STOC195.1.20 + 1 / 3 * (STOC195.1.25 + 1 / 3 * (STOC195.1.30 + 1 / 3 * (STOC195.1.35))))))) <= 20 AND .666971637694419 * (STOC195 + 1 / 3 * (STOC195.1.5 + 1 / 3 * (STOC195.1.10 + 1 / 3 * (STOC195.1.15 + 1 / 3 * (STOC195.1.20 + 1 / 3 * (STOC195.1.25 + 1 / 3 * (STOC195.1.30))))))) > 20
I've also corrected the Simple version provided above.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
Thank you Bruce!!
-amberpax
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
amberpax,
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/24/2005
Posts: 40
|
Hi Bruce & Doug,
Can you please post the formula for a weekly PCF of stochastics 12.3 and 12.3.1? Thanks.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
dmk112,
The raw Weekly Stochastic 12 would be:
STOC60
The same for the previous Bar would be:
STOC60.1.5
The Simple Stochastic SK 12,3 would be:
(STOC60 + STOC60.1.5 + STOC60.1.10) / 3
The same for the previous Bar would be:
(STOC60.1.5 + STOC60.1.10 + STOC60.1.15) / 3
The Exponential Stochastic SK 12,3 would be:
.500488758553275 * (STOC60 + .5 * (STOC60.1.5 + .5 * (STOC60.1.10 + .5 * (STOC60.1.15 + .5 * (STOC60.1.20 + .5 * (STOC60.1.25 + .5 * (STOC60.1.30 + .5 * (STOC60.1.35 + .5 * (STOC60.1.40 + .5 * (STOC60.1.45))))))))))
The same for the previous Bar would be:
.500488758553275 * (STOC60.1.5 + .5 * (STOC60.1.10 + .5 * (STOC60.1.15 + .5 * (STOC60.1.20 + .5 * (STOC60.1.25 + .5 * (STOC60.1.30 + .5 * (STOC60.1.35 + .5 * (STOC60.1.40 + .5 * (STOC60.1.45 + .5 * (STOC60.1.50))))))))))
You may wish to review the following:
Understanding Stochastics
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
Cascades of Moving Averages
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/24/2005
Posts: 40
|
Bruce, if I use 14.3 stochastics will I just change the 60 to 70? or does that initial factor need to be changed?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
dmk112,
As long as you don't change the SK or SD Periods, you can just change the 60 to a 70 when switching from a 12-Period Weekly Stochastic to a 14-Period Weekly Stochastic. Everything else is just there to calculate the 3-Period Moving Average or reference the value for a previous period.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/24/2005
Posts: 40
|
Thanks!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
dmk112,
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |