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

Ichimuko test in progress Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Chris55
Posted : Friday, July 06, 2018 10:30:44 AM
Registered User
Joined: 6/14/2016
Posts: 235

Yes, absolutely correct, sorry. But in one case I wantr to have an indicator the a new low and in the other cased one for a new high. Each checking the most recent 5 bars.

Not sure how to differentiate the New High from the New Low formula.

Thanks much,

Chris

Bruce_L
Posted : Friday, July 06, 2018 10:37:22 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

Change the MIN in the formula template to a MAX to convert it from checking for a low to checking for a high.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
Posted : Friday, July 06, 2018 10:48:47 AM
Registered User
Joined: 6/14/2016
Posts: 235

Thanks a lot Bruce. Kind regards, Chris 

Chris55
Posted : Friday, July 06, 2018 12:39:34 PM
Registered User
Joined: 6/14/2016
Posts: 235

Hi Bruce,

I just created a new indicator PCF with the MIN formula checking the lows. No error messages.

When I wanted to save it, it says Boolean result - do I want to save this as a condition.

I cancelled because, I need to create an indicator from it. Do I need to chang anything to

make your formla into an indicator?

Thanks,

Chris 

Bruce_L
Posted : Friday, July 06, 2018 1:04:49 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

If you are following the template in my Thursday, July 05, 2018 10:46:58 AM ET post, you would get rid of the > 0 at the end to get a count.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
Posted : Friday, July 06, 2018 1:22:11 PM
Registered User
Joined: 6/14/2016
Posts: 235

Thanks Bruce - that did it. Have a good weekend. Chris 

Chris55
Posted : Monday, July 09, 2018 7:30:56 AM
Registered User
Joined: 6/14/2016
Posts: 235

Good Monring,

I was wondering how to write two Scan Conditions which would define that:

1) the last bar has its Close in the upper half of the bar range?

2) the last bar has its close in the upper range of the bar range AND has a higher high than the bar before it? 

Thanks and kind regards,

Chris 

Bruce_L
Posted : Monday, July 09, 2018 10:32:17 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

Please try the following.

STOC1 >= 50 AND H > L AND H > H1



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
Posted : Monday, July 09, 2018 10:45:21 AM
Registered User
Joined: 6/14/2016
Posts: 235

Thanks very much -  din't know about the STOC1 function, might be able to use it, e.g. for Close

in upper third of range or something similar.

Kind regards,

Chris 

Chris55
Posted : Thursday, July 19, 2018 10:20:58 AM
Registered User
Joined: 6/14/2016
Posts: 235

Hi Bruce,

I made a custom indicator for the spread between BBBOT(.1;20) an the XAVC13:

(BBBOT(.1;20) - XAVGC13)

 

However, instead of using the Bottom Band, I would like to use the Bollinger Center Line

for this spread.

How wote you formulate that in a PCF Indicator?

Kind regards,

Chris 

Bruce_L
Posted : Thursday, July 19, 2018 10:23:54 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

The centerline is just the following (assuming the Bollinger Bands are simple).

AVGC20

So:

AVGC20 - XAVGC13



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
Posted : Thursday, July 19, 2018 10:39:11 AM
Registered User
Joined: 6/14/2016
Posts: 235

Hi Bruce,

Does the AVGC20 take into account that my Bollinger Bands have a bandwidth of 0.1 and a period of 20 (exponential) ?

Bruce_L
Posted : Thursday, July 19, 2018 10:58:39 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

The bandwidth makes no difference as to the value of the centerline. If the BBs are exponential, then the centerline would be the following instead however.

XAVGC20

So:

XAVGC20 - XAVGC13

Note that the built in BBTOP() and BBBOT() functions are based on simple Bollinger Bands. If you want to write formulas for the top and bottom bands of other types of Bollinger Bands, you may want to review the following.

Bollinger Bands



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
Posted : Thursday, July 19, 2018 12:43:56 PM
Registered User
Joined: 6/14/2016
Posts: 235

Thanks, Bruce. Now I understand. Kind regards, Chris

Chris55
Posted : Sunday, July 22, 2018 6:29:36 AM
Registered User
Joined: 6/14/2016
Posts: 235

Hello Bruce,

Today I wanted ask ask your help with a more difficult (two part) scan formula. Perhaps you can give me the generic structure on #1:

1. The BBOT is below the lower of T3-6-1.272 and T-3-36-1.272;

2. The price ihas been moving down to the BBTOP. and the price Low is below the BBTOP now.

BBTOP = (0.2; 20), BBBOT = (0.2. 20)

Many thanks and kind regards,

Chris 

 

Chris55
Posted : Thursday, July 26, 2018 4:06:40 PM
Registered User
Joined: 6/14/2016
Posts: 235

Hi Bruce,

Don't worry about the questions I posed above. I think I got them squared away on my own.

For #1 I used:  BBBOT(.2, 20) < GREATEST(...T3-6-1.272.., T3-36-1.272)

and it seems to work.

I have a new question however as follows:

- I would like to scan for the (first) Close Price Bar  crossing up through the HIGHER (Greater) of the EMA50 or the BBTOP(0.2, 20).

- Inversely, I would like to scan for the first Close Price Bar crossing up the LOWER (Least) of the EMA50 or the EMA89 or the BBTOP(0.2, 20). 

Thanks for your help,

Chris 

Bruce_L
Posted : Thursday, July 26, 2018 4:10:06 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

The crossup would be:

XUP(C, GREATEST(XAVGC50, BBTOP(.2, 20))

And the crossdown would be:

XDOWN(C, LEAST(XAVGC50, BBBOT(.2, 20))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
Posted : Friday, July 27, 2018 7:33:17 AM
Registered User
Joined: 6/14/2016
Posts: 235

Hi Bruce,

Something happened to my reply just now when I posted, so I'll try again:

If I were to add a third indicators to the formulas above, would this be the correct way for doing that, e.g. as an example with an additional EMA89?:

XDOWN(C, LEAST(XAVGC50, XAVGC89, BBBOT (.2, 20))

Kind regards,

Chris 

Bruce_L
Posted : Friday, July 27, 2018 10:28:02 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

Yes, that is how you would do it. The GREATEST() and LEAST() functions can have as many arguments as you want.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
Posted : Friday, July 27, 2018 10:38:23 AM
Registered User
Joined: 6/14/2016
Posts: 235

Thanks Bruce. Appreciate your help, as always.

Chris55
Posted : Thursday, August 02, 2018 6:45:32 AM
Registered User
Joined: 6/14/2016
Posts: 235

Hi Bruce,

I'm having problems with 2 slope formulas:

1) I need to find the 20 bar slope of the BBTOP(0.2, 20) and this isn't working for me:

6 * (FAVG(BBTOP(0.20, 20) - BBTOP(0.20, 20)) / 20 > 0

2) I also need to find the 20 bar slope of the EMA89

Thanks for your help. Kind regards,

Chris 

 

Chris55
Posted : Thursday, August 02, 2018 7:09:53 AM
Registered User
Joined: 6/14/2016
Posts: 235

Hi Bruce,

Just to clarify, I want to use the 20 period Linear Regression.

I thought this would work, but I get an error flag

 

(6 * ((FAVG((BBTOP(0.2, 20), 21)) - AVG(BBTOP(0.2, 20), 21))) / 20) > 0

Bruce_L
Posted : Thursday, August 02, 2018 10:47:42 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

You really have to be careful about parentheses. Your 20 bar slope of the 20 bar BB top should be:

6 * (FAVG(BBTOP(.2, 20), 20) - AVG(BBTOP(.2, 20), 20)) / (20 - 1)

This simplifies down to the following however.

FAVG(BBTOP(.2, 20), 20) > AVG(BBTOP(.2, 20), 20)

Which would be the following for a 21 period BB.

FAVG(BBTOP(.2, 21), 20) > AVG(BBTOP(.2, 21), 20)

The 20 bar slope of EMA89 would be the following.

6 * (FAVG(XAVGC89, 20) - AVG(XAVGC89, 20)) / 19



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
Posted : Thursday, August 02, 2018 10:51:19 AM
Registered User
Joined: 6/14/2016
Posts: 235

Thanks very much - I'll study the way you are setting the parentheses. Chris 

Chris55
Posted : Thursday, August 02, 2018 3:19:29 PM
Registered User
Joined: 6/14/2016
Posts: 235

Hi Bruce,

I ran into another problem just now:

1) Wanted to find a decreasing Bollinger Bandwidth (using 0.2, 20) for at least 3 out of the last 5 bars. And wanted this condition to be True, so the scan only returns stocks with this criteria:

CountTrue(ABS(BBTOP(.2, 20)) < MIN(ABS(BBTOP(.2, 20.1), 5) AND (ABS(BBBOT(.2, 20)) < MIN(ABS(BBBOT(.2, 20.1), 5)) >= 3

I get a "mising period" argument at Position 113 when I try to save the PCF Condition.

 

2) Also, the 20-bar slope of the EMA89 you helped me with this morning seems different from the

   20 bar slope of the BBTOP(.2, 20). Says the latter is an indicator and saves it like that.  I was wanted 

    to specify in the 2 formulas above that they are conditions and are True, not sure how to adapt this?

Thanks a lot. Kind regards,

Chris 

 

 
Bruce_L
Posted : Thursday, August 02, 2018 3:29:24 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

I don't understand the structure of your first formula at all, but if you are actually looking for the width of the Bollinger Bands decreasing for at least 3 out of the most recent 5 bars, please try the following.

CountTrue(STDDEV20 < STDDEV20.1, 5) >= 3

Yes, they are different. You didn't ask for the slope being greater than zero, you asked for the slope (which is a numeric value). If you want the slope to just be positive, then the formula is quite a bit simpler than calculating the actual slope.

FAVG(XAVGC89, 20) > AVG(XAVGC89, 20)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris55
Posted : Thursday, August 02, 2018 3:57:46 PM
Registered User
Joined: 6/14/2016
Posts: 235

Thank you Bruce,

I'm assuming the the CountTrue formula for the Bollinger Bands takes the 20 StDev into account und the

0.20 Parameter doesn't matter here. Kind regards, Chris 

Bruce_L
Posted : Thursday, August 02, 2018 4:02:17 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

The .2 parameter shouldn't matter at all if you are just looking at if the bands are getting narrower because the factor would be applied to both the before and after width calculations.



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