Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

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

 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: 260

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: 65,138

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)`

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

Gold Customer

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

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: 65,138

`(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: 260

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: 65,138

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: 260

Great Thank you

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

Gold Customer

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

Happy to help. Caffeine has its advantages. LOL.

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.