| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 4/15/2009
Posts: 10
|
I am looking for a formula for a Stochastic 5,3 crossing UP between the 10 and 20.....TNX
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Is the Stochastic Simple or Exponential?
What specifically is crossing up through what?
Is the %K just moving up while between 10 and 20?
Is the %K crossing up through the %D? If so, what is the %D Period?
Understanding Stochastics
Indicators, Sorting & Scanning
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/15/2009
Posts: 10
|
Hey Bruce...you don't make this easy.....LOL
Simple will do...
The stochastic, 5,3..or whatever value..is crossing up through a range from 10 to 30, not just one value, but the range.
Perhaps the Metastock formula might help.....
The Williams %R is plotted on a scale of -100 to 0. The Stochastic uses a scale of 0 to 100. The two indicators never cross. However, assuming you have overlaided the Williams %R in the same window as the Stochastic and then did not merge the scales, you could have the appearence of a cross, if not an actually one. The following formula simulates they appearance by add 100 to the normal value of the Williams %R so it will use the same scale as the Stochastic. You also said you wanted the cross to occur "arround the 20 level". The formula allows the Stochastic to be within 10 points of 20, (ie between 10 and 30):
Cross(WillR(14)+100, Stoch(5,3)) AND
Abs(Stoch(5,3)-20)<=10
I asked to speak with you on the phone, but apparently that does not seem to be possible....
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I don't "speak Metastock", but in your formula:
Cross(WillR(14)+100, Stoch(5,3)) AND Abs(Stoch(5,3)-20)<=10
It seems clear that a line representing the 14-Period Williams %R + 100 is crossing a 5-Period Stochastic with a 3-Period %K. So assuming Metastock isn't using a Slow Stochastic, this formula could be written in the Personal Criteria Formula Language as:
STOC14 > STOC5.3 AND STOC14.1.1 <= STOC5.3.1 AND ABS(STOC5.3 - 20) <= 10
But in original post, I still can't tell what is crossing what. Unlike your Williams %R and Stochastics example, there aren't two indicators or two lines. There is just one indicator and one line.
If the Simple Stochastic 5,3 %K needs to be crossing all the way up from 10 to 20 in a single bar, it could be written as:
STOC5.3 >= 20 AND STOC5.3.1 <= 10
If the Simple Stochastic 5,3 %K needs to be crossing all the awy up from 10 to 30 in a single, it could be written as:
STOC5.3 >= 30 AND STOC5.3.1 <= 10
But if the Simple Stochastic 5,3 %K is crossing up through something else such as the %D or a 14-Period Williams %R, I need to know what it is.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/15/2009
Posts: 10
|
Thank you, Bruce
STOC5.3 >= 30 AND STOC5.3.1 <= 10 sort of works..I need some time...
Cross(WillR(14)+100, Stoch(5,3)) AND Abs(Stoch(5,3)-20)<=10
says: Formula error....argument missing near plus
Comment??
Also, I presume that cut & Paste does not work in your formula section....
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Um, Cross(WillR(14)+100, Stoch(5,3)) AND Abs(Stoch(5,3)-20)<=10 is the Metastock formula you provided in your example. My guess at the equivalent formula in TC2000's Personal Criteria Formula Language was:
STOC14 > STOC5.3 AND STOC14.1.1 <= STOC5.3.1 AND ABS(STOC5.3 - 20) <= 10
You can use ctrl-v to paste a formula you have copied into TC2000.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/15/2009
Posts: 10
|
Bruce...You are AMAZING....OK..one more if you have time...Stochastic/Rsi 14 crossing UP through 5 to 20
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Unfortunately, RSI - Wilder's (which is used in calculating the Stochastics RSI) is not built into the Personal Criteria Formula Language. This means that any formula for this would end up being way too long to be practical. There is a workaround however that should be more efficient than creating a formula in any case.
Add a 1-Period Simple Moving Average with an Offset of 1 to the Stochastics RSI indicator (or just set the %D to a Period of 1 and an Offset of 1). Then you can click on the Stochastics RSI and its Moving Average to create two Conditions and add them to the same Scan.
Click on the Stochastics RSI and select Create Condition. Then click on the Condition drop-down menu and choose Greater Than so you can set the Greater Than setting to 20.
Click on the Offset Moving Average of Stochastics RSI and select Create Condition. Then click on the Condition drop-down menu and choose Less Than so you can set the Less Than setting to 5.
You should then be able to add both of the Conditions to the same Scan.
Indicators, Sorting & Scanning
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/15/2009
Posts: 10
|
Thanks, Bruce...I am old, but and am somewhat computer challenged....but, I will try to figure this out on the weekend....Unless... you might find a moment to rattle this out....TnxAEN
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I think you will find the technique outlined in my last post to be fairly straightforward once you give it a try. The explanation is long, but it is just a matter of adding the Stochastics RSI and a Moving Average to the chart, adjusting their settings and then clicking on the indicators to create some Conditions which can be added to a Scan. The video referenced in the post gives a demonstration of the basic method.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |