Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

WStoc turning up Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Chagall
Posted : Saturday, February 16, 2019 10:13:18 AM
Registered User
Joined: 9/11/2012
Posts: 92

Bruce,

I would like to display a dot if and when that WStoc is turning up, with the dot at the actual value of that WStoc Line.

I tried this 

((WStoc12.3.0>WStoc12.3.1)
AND(WStoc12.3.1<WStoc12.3.2)) 
 
This results in 100 if true and 0 if false, but multiplicating it with the actual WStoc value doesn&acute;t work.
Please what I am doing wrong?
 
thank you,
 
Franz J.
Bruce_L
Posted : Tuesday, February 19, 2019 10:27:04 AM


Worden Trainer

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

Please try the following indicator formula. Make sure it is being ovelayed into the same pane and scale as the Worden Stochastic (choose & Scale With if you are moving the indicator into the pane).

IIF(TrueInRow(WSTOC12.3 > WSTOC12.3.1, 2) = 1, WSTOC12.3, 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chagall
Posted : Saturday, February 23, 2019 4:00:21 PM
Registered User
Joined: 9/11/2012
Posts: 92

Thank you Bruce, great.

Franz J.

PS:

Don&acute;t know this is of any interest:

Since long time for my DSS turning up I use your formula 

100 * XAVG((XAVG(STOC21, 3) - MIN(XAVG(STOC21, 3), 21)) / (MAX(XAVG(STOC21, 3), 21) - MIN(XAVG(STOC21, 3), 21)), 3) / ABS(XUP(XAVG((XAVG(STOC21, 3) - MIN(XAVG(STOC21, 3), 21)) / (MAX(XAVG(STOC21, 3), 21) - MIN(XAVG(STOC21, 3), 21)), 3), AVG(XAVG((XAVG(STOC21, 3) - MIN(XAVG(STOC21, 3), 21)) / (MAX(XAVG(STOC21, 3), 21) - MIN(XAVG(STOC21, 3), 21)), 3) ,2)))

which is working well and I don&acute;t see any need to change it. This said could it be using the TrueInRow function to smooth its calculating? 

Bruce_L
Posted : Monday, February 25, 2019 9:16:19 AM


Worden Trainer

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

I think it is actually going to be longer. I don't know if it would be more efficient or not (it might be since it isn't calculating as many moving averages).

IIF(TrueInRow(XAVG((XAVG(STOC21, 3) - MIN(XAVG(STOC21, 3), 21)) / (MAX(XAVG(STOC21, 3), 21) - MIN(XAVG(STOC21, 3), 21)), 3) > XAVG((XAVG(STOC21.1, 3) - MIN(XAVG(STOC21.1, 3), 21)) / (MAX(XAVG(STOC21.1, 3), 21) - MIN(XAVG(STOC21.1, 3), 21)), 3), 2) = 1, 100 * XAVG((XAVG(STOC21, 3) - MIN(XAVG(STOC21, 3), 21)) / (MAX(XAVG(STOC21, 3), 21) - MIN(XAVG(STOC21, 3), 21)), 3), 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chagall
Posted : Monday, March 25, 2019 5:30:57 PM
Registered User
Joined: 9/11/2012
Posts: 92

Bruce,

I take use of your formula

IIF(TrueInRow(WSTOC12.3 > WSTOC12.3.1, 2) = 1, WSTOC12.3, 1 / 0) (for the turning up case)

and I am glad I got it. But here I come with an additional question. That formula prints an up-dot not only after having an higher value before, but after having some unchanged bars before too. This is very helpful if and when the trend is changing against higher before the unchanged bars. But of course it also does print dots if and when there is no trend change (lower values before the unchanged bars). 
Is there a way to adopt that PCF for printing up dots after unchanged bars only in that cases when the trend did change?

thank you,

Franz J.

Bruce_L
Posted : Tuesday, March 26, 2019 10:10:20 AM


Worden Trainer

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

It doesn't make a difference for a lot of indicators because the odds of having the same value more than one bar in a row a pretty low. We can check for the previous direction being different however (the following looks back 10 bars).

IIF(TrueInRow(WSTOC12.3 > WSTOC12.3.1, 2) = 1 AND TrueInRow(NOT(WSTOC12.3.1 > WSTOC12.3.2), 10) > TrueInRow(NOT(WSTOC12.3.1 < WSTOC12.3.2), 10), WSTOC12.3, 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chagall
Posted : Tuesday, March 26, 2019 3:53:22 PM
Registered User
Joined: 9/11/2012
Posts: 92

Thank you very much, Bruce. Great help again. 

Of course you are right with the odds, but just with the WStoc it seems to happen more often than with other indicators. A lookback period of 5 bars is good enough for this.

 

Thanx again,

 

Franz J.

Bruce_L
Posted : Tuesday, March 26, 2019 3:58:14 PM


Worden Trainer

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

You're welcome.



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