Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.

 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 Customer Training & Support - Ask a Trainer - TC2000 version 12/18 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 18 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos 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.