New version 18 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

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

Price between 2 MAs Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
hhphoto2006
Posted : Tuesday, June 12, 2018 12:43:31 PM
Registered User
Joined: 10/18/2008
Posts: 253

Hi Bruce

Would you help me With a PCF where price is between 2 EMA for example the 13 and 21.

Thank you

Bruce_L
Posted : Tuesday, June 12, 2018 12:45:50 PM


Worden Trainer

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

If you want this to be directional, this would just be an exponential MACD 13, 21.

MACD13.21

If you want the distance without giving an indication of which is above or below, you can take the absolute value of this.

ABS(MACD13.21)

MACD & MACD Histogram



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Al_Gorithm
Posted : Tuesday, June 12, 2018 12:57:08 PM

Gold Customer Gold Customer

Joined: 6/30/2017
Posts: 1,144

Never thought of it this way. Pretty cool.

Elder like to use two moving averages and calls the space in between them the "Value Zone". This can be used as a condition column to see which tickers meet his criteria.

Sweet.

Bruce_L
Posted : Tuesday, June 12, 2018 1:10:43 PM


Worden Trainer

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

And after reading Al_Gorithm's response, it is obvious I mis-read the question. Please try the following instead.

(XAVGC13 <= C AND C <= XAVGC21) OR (XAVGC21 <= C AND C <= XAVGC13)

Or the slight shorter:

ABS(XAVGC13 + XAVGC21 - 2 * C) <= ABS(MACD13.21)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
hhphoto2006
Posted : Tuesday, June 12, 2018 2:08:28 PM
Registered User
Joined: 10/18/2008
Posts: 253

Thank you Bruce

I am glad Al_Gorithm comented on the post since that is exacltly what I was thinking about. Just a quick follow up. Some times price just enters this zone but does not close inside, can I replace C in the formula for L that way I don't missed the stocks that ennter the zone and bounce closing higher?

Thanks again 

Bruce_L
Posted : Tuesday, June 12, 2018 2:17:56 PM


Worden Trainer

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

Yes you can, but if you want to check for any part of the bar being inside the moving average:

LEAST(XAVGC13, XAVGC21) <= H AND L <= GREATEST(XAVGC13, XAVGC21)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
hhphoto2006
Posted : Tuesday, June 12, 2018 2:40:33 PM
Registered User
Joined: 10/18/2008
Posts: 253

Great Thank you

Al_Gorithm
Posted : Tuesday, June 12, 2018 3:28:50 PM

Gold Customer Gold Customer

Joined: 6/30/2017
Posts: 1,144

Happy to help. Caffeine has its advantages. LOL.

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.