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

Price Range Scanning Condition Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
ACCIDUZZU
Posted : Tuesday, September 17, 2013 8:50:29 PM
Registered User
Joined: 6/20/2011
Posts: 22
Please help with a scanning condition that finds stocks who's prices have been ranging during a particular timeframe at the  (highest high + lowest low)/2 calculated over last 62 time periods level.
 
So, if price touched that particular range during the current session that would be the timeframe used on chart, I want to find the stocks that did that, display on my scanner.
 
Thank you in advance.
Bruce_L
Posted : Wednesday, September 18, 2013 10:17:37 AM


Worden Trainer

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

I do not understand the request. The (highest high + lowest low) / 2 over the most recent 62 bars is:

(MAXH62 + MINL62) / 2

But what this defines is the center of the range over those 62 bars, it doesn't define the range itself.

A Condition Formula for the current bar touching the center of the range could be written as:

2 * L <= MAXH62 + MINL62 AND MAXH62 + MINL62 <= 2 * H

A Condition Formula for every bar during the most recent 62 bars touching the center of the range could be written as:

2 * MAXL62 <= MAXH62 + MINL62 AND MAXH62 + MINL62 <= 2 * MINH62

That said, I do not know if any of the above gives you the information required to do what you want. If it does not do so, I will need additional clarification from you as to your actual intent.

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
ACCIDUZZU
Posted : Wednesday, September 18, 2013 9:45:42 PM
Registered User
Joined: 6/20/2011
Posts: 22

I want to run the scanner and have only the stocks dislplay that have touched that level today for Daily time frame, this week for weekly timeframe and so forth, or are currently at that level, (highest high + lowest low)/2 calculated over last 62 time periods.

So, if that value, the (highest high + lowest low)/2 calculated over last 62 time periods happened to have been reflecting the price for a stock during a session, or even be the closing value for that instrument, I would like the stock to show up in my scanner.

 

Bruce_L
Posted : Thursday, September 19, 2013 7:39:18 AM


Worden Trainer

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

Then you would need to use the second formula in my post. You can set the time frame of the post when it is edited or created. You can also set the time frame of a WatchList Column or EasyScan Condition if you want to have the same formula use different time frames in different locations.



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