Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

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

 5 pages: 1 2 3 4 [5]
 Ichimuko test in progress Topic Rating:
 Previous Topic · Next Topic Watch this topic · Print this topic ·
Chris55
 Posted : Friday, November 23, 2018 10:03:24 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Hello Bruce.

I made an indicator using "Create Condition" which is:

- The Fisher Transform (5 period) from the source below:

-  The SMI Ergodic Oscillator (7, 13, 5) which itself is sourced from:

-  The StochRSI (7, 7, 3)

I drew the 0 line for the Fisher but would like to create a histogram (+1 to -1) in order to be able to chart (a) when the Fisher crosses the 0 Line up (= +1 histo bar), and (b) when the Fisher crosses the 0 line down (-1), with no values in between. So this histogram is either at +1, 0 (if no cross) or -1.

Could you help me with the formula for charting this histogram for the existing (compound) indicator (Fisher, SMI Ergo, StochRSI)?

Thanks very much and kind regards,

Chris

Bruce_L
 Posted : Friday, November 23, 2018 10:58:24 AM

Worden Trainer

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

I cannot think of a way to write the formula which is not too long and slow to be practical or post in the forums.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
 Posted : Friday, November 23, 2018 11:14:42 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

OK, thanks,

Would it be possible to have the same type of histogramm indicator just for the 7-period Aroon Oscillator, whereby a +1 histo bar would symbolize an oscillator reading >+70 and a -1 histo bar would mean <-70.? In this case only these two states +1 and -1.

Kind regards,

Chris

Bruce_L
 Posted : Friday, November 23, 2018 11:34:53 AM

Worden Trainer

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

Please try the following indicator formula.

`IIF(AROONUP7 - AROONDOWN7 > 70, 1, IIF(AROONUP7 - AROONDOWN7 < -70, -1, 0))`

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
 Posted : Friday, November 23, 2018 11:41:28 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Many thanks Bruce - I'll give it a try.

I'm not sure about this, but wasn't there a way to make a condition (like the compound condition I created with the Fisher/SMI/StochRSI) into an indicator without re-writing it?

Kind regards,

Chris

Bruce_L
 Posted : Friday, November 23, 2018 12:03:22 PM

Worden Trainer

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

You can make a condition just by clicking on the indicator and selecting Create Condition. What you can't do is create an indicator which plots +1, 0, or -1 based on those conditions.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
 Posted : Friday, November 23, 2018 12:14:55 PM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Thanks Bruce, for clariying. Have a nice weekend. Chris

Chris55
 Posted : Thursday, December 20, 2018 10:31:30 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Hi Bruce,

I couldn't get this to work with "Create a Condition" on the chart. I would like to create Condition PCFs for:

1) The PMO(21,13,7) crossing up the PMO(35,20,10)

and another Condition PCF for:

2) The PMO(21,13,7) crossing down the PMO(35,20,10)

- I'm not using the EMA's (3rd parameter) here, just these formulas:

1000 * XAVG(XAVG(C / C1 - 1, 20), 12)

1000 * XAVG(XAVG(C / C1 - 1, 34), 19)

- Lastly, how could I write these formulas with a Hull MA instead of an EMA?

Many thanks,
Chris

Bruce_L
 Posted : Thursday, December 20, 2018 11:08:57 AM

Worden Trainer

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

If I am understanding correctly, the crossup would be:

`XUP(XAVG(XAVG(C / C1 - 1, 20), 12), XAVG(XAVG(C / C1 - 1, 34), 19))`

And the crossdown would be:

`XDOWN(XAVG(XAVG(C / C1 - 1, 20), 12), XAVG(XAVG(C / C1 - 1, 34), 19))`

You would just replace all instances of `X` in the formulas with `H` instead to switch the moving averages from exponential to Hull.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
 Posted : Thursday, December 20, 2018 11:14:58 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Thanks very much, Bruce.

Wish you really good holidays.

Chris55
 Posted : Thursday, January 31, 2019 9:22:56 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Hello Bruce,

I'm writing a Condition PCF and would like to add this filter:

- The scan results should not include stocks which have made 5 or more consecutive daily highs.

It would be good if I could change the number of daily highs myself later on.

Many thanks,

Chris

Bruce_L
 Posted : Thursday, January 31, 2019 9:40:34 AM

Worden Trainer

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

Please try the following condition formula.

`NOT(TrueInRow(H > H1, 5) = 5)`

This could be shortened to the following.

`TrueInRow(H > H1, 5) < 5`

But if you want something to be not true, the easiest way is to just use the NOT() function.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
 Posted : Thursday, January 31, 2019 10:22:34 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Thanks very much Bruce - I appreciate your help.

Chris55
 Posted : Monday, February 25, 2019 11:33:28 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Hi Bruce,

I have a PCF condition for checking whether two T3 Noving Averages have crossed (down) within the last 3 bars, as follows:

CountTrue(XDOWN(-4.235801 * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4), 4) + 20.561175096* XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4) - 33.268947 * XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4) + 17.943573032* XAVG(XAVG(XAVGC4, 4), 4), -2.0580756 * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6), 6) + 11.028179 * XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6) - 19.698131 * XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6) + 11.728028 * XAVG(XAVG(XAVGC6, 6), 6)), 3) >0

I would like to have a PCF condition that shows the exact opposite, namely that the T3-4-1.618 has NOT cross the T3-6-1.272 down within the last 3 bars.

Is there an easy way to adapt the existing formula? Many thanks !

Chris

Chris55
 Posted : Monday, February 25, 2019 12:25:51 PM
Platinum Customer

Joined: 6/14/2016
Posts: 285

I didn't notive this ealier, but maybe if I change the " >0" at the end to " =0", that might do it.

Bruce_L
 Posted : Monday, February 25, 2019 12:26:58 PM

Worden Trainer

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

Well in general, the easiest way to check for something not being true is to just put it inside of a NOT() function.

That said, in this case, I suspect changing the > 0 at the end to = 0 instead would work just as well.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
 Posted : Monday, February 25, 2019 12:49:32 PM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Thanks very much Bruce. I tried it out on several samples, and it seems to work.. Kind regards, Chris

Chris55
 Posted : Wednesday, February 27, 2019 9:56:03 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Hi Bruce,

I have used this condition PCF for quite some time which filters one T3 Moving Average (T3-4-1.618) crossing down on another T3 (T3-6-1.272):

XDOWN(-4.235801 * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4), 4) + 20.561175096* XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4) - 33.268947 * XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4) + 17.943573032* XAVG(XAVG(XAVGC4, 4), 4), -2.0580756 * AVG(XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6), 6) + 11.028179 * XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6) - 19.698131 * XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6) + 11.728028 * XAVG(XAVG(XAVGC6, 6), 6))

What I would really like to do, is to have TC2000 draw a down arrow when this instance occurs.If that would not be possible, I could also use a histogram indicator panel which would only show the (sell) signals in this case.

Thanks much for your help. Kind regards,

Chris

Bruce_L
 Posted : Friday, March 01, 2019 10:08:37 AM

Worden Trainer

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

There isn't a way to plot arrows on the chart.

The easiest thing to do would just be to add a Custom PCF % True Indicator to the chart and use your condition formula as the Boolean Formula setting in the Custom PCF % True Indicator. This would normally plot spikes on teh chart when the Boolean Formula is true, but you can change the Plot Style to Histogram instead.

Another option if you want to plot something at a specific numeric value would be to use the IIF() function as part of the Formula in a Custom PCF Indicator (not the same as a Custom PCF % True Indicator). The first argument would be your condition formula, the second argument wolud be the value you want when the condition formula is true, and the third argument would be the value you want to return when the condition formula is false.

If you use the Dots Plot Style in your Custom PCF % True Indicator and 1 / 0 as the value to plot when the Boolean Formula is false, you will get dots plotted at the desired value when true and nothing plotted on the chart when the value is false.

So let's say you want to plot at dot at the closing price when true. You would use the following Boolean Formula in your Custom PCF Indicator with the Plot Styles set to Dots.

`IIF(XDOWN(-4.235801 * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4), 4) + 20.561175096* XAVG(XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4), 4) - 33.268947 * XAVG(XAVG(XAVG(XAVGC4, 4), 4), 4) + 17.943573032* XAVG(XAVG(XAVGC4, 4), 4), -2.0580756 * AVG(XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6), 6) + 11.028179 * XAVG(XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6), 6) - 19.698131 * XAVG(XAVG(XAVG(XAVGC6, 6), 6), 6) + 11.728028 * XAVG(XAVG(XAVGC6, 6), 6)), C, 1 / 0)`

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
 Posted : Friday, March 01, 2019 10:44:34 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Thanks so much for your detailed help, Bruce. I'll study this at length. Chris

Chris55
 Posted : Tuesday, March 19, 2019 12:45:19 PM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Hi Bruce,

For a scan, I'm looking to add some conditions which specify:

- 3 or more of the last 5 bars have lower highs (than the bar before respectively);

- The 10-bar EMA or the 20-bar EMA is crossing the current bar range (H-L) anywhere;

and also a volume related one:

- the current bar volume is less than the average volume of the last 10 bars.

Thanks for helping me out.

Chris

Bruce_L
 Posted : Tuesday, March 19, 2019 12:57:03 PM

Worden Trainer

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

Pleaes try the following condition formula.

`CountTrue(L < L1, 5) >= 3 AND (ABS(H + L - 2 * XAVGC10) <= H - L OR ABS(H + L - 2 * XAVGC20) <= H - L) AND V < AVGV10.1`

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
 Posted : Tuesday, March 19, 2019 1:40:10 PM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Thanks very much for your quick reply. Presumably, I could split this up into 3 segments, so as to be able to use combinations:

CountTrue(L < L1, 5) >= 3
(ABS(H + L - 2 * XAVGC10) <= H - L OR ABS(H + L - 2 * XAVGC20) <= H - L)
V < AVGV10.1

Best regards,
Chris
Bruce_L
 Posted : Tuesday, March 19, 2019 1:59:19 PM

Worden Trainer

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

Yes you could. If you split it up, you don't need the parantheses around the second segment.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
 Posted : Wednesday, April 03, 2019 10:19:31 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Hi Bruce,

How would I write a scan criteria that would include (both):

C > BBTOP(0.25, 20)

OR

C is in the upper half of this Bollinger Band?

Chris

Bruce_L
 Posted : Wednesday, April 03, 2019 10:40:25 AM

Worden Trainer

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

I may be misunderstanding the question, but I think it is just:

`C >= AVGC20`

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
 Posted : Wednesday, April 03, 2019 10:46:19 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Oh, of course - you're absolutely right. It was an easy one. Thanks much!

Chris55
 Posted : Wednesday, April 03, 2019 10:48:06 AM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Using the EMA20, would I just write it like this?

C >= XAVGC20

(I ususally plot my Bollinger Bands using an EMA....)

Bruce_L
 Posted : Wednesday, April 03, 2019 11:02:08 AM

Worden Trainer

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

Exactly. Just keep in mind you can't use the built in BBTOP() and BBBOT() functions if the centerline is exponential.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
 Posted : Wednesday, April 03, 2019 12:12:20 PM
Platinum Customer

Joined: 6/14/2016
Posts: 285

Thanks, Bruce. I appreciate your help as always. Chris

Bruce_L
 Posted : Wednesday, April 03, 2019 12:38:40 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
 5 pages: 1 2 3 4 [5]

 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.