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