TC2000.com• Download software • Tutorial videos • Subscription & data-feed pricing • Class schedule
TC2000Brokerage.com• New account application • Trading resources • Margin rates • Stock & option commissions
Worden Discussion Forum
No, there is not a way to create this as a formula because there is no syntax in the Personal Criteria Formula Language for referencing fundamentals.
In MAXH3.1 the 3 is the number of bars over which you are returning the maximum high and the 1 is how many bars ago the last of these 3 bars happened.
So MAXH3.1 is the highest high of the 3 bars ending 1 bar ago.
C > MAXH3.1 says the current price is higher than the highest high of the 3 bars ending 1 bar ago.
The measurements are in bars. So if the time frame is daily, then each bar is equal to 1 day, if the time frame is hourly then each bar is equal to one hour and if the time frame is weekly then the time frame is equal to one calendar week.
R17 Beta PCF Capabilities
I am somewhat confused and I think I may have misunderstood the first request. I thought you were trying to convert a formula written for a daily time frame into a formula for a weekly (5 day) time frame.
The original formula in this topic is designed for a daily time frame and checks for the current price to be above the high of the previous 251 trading days. This 252 trading day span is meant as an approxiation for 52 calendar weeks with weekends and market holidays taken out.
The conversion had already been successfully done with the only possible issue being the volume being checked over 5 days was only double the volume being checked for a single day.
So converting from a daily time frame to a weekly time frame meant multiplying the volume by 5 in order to get the scan to return similar stocks with similar average volume.
If you are just checking for price to be above the high of the previous trading day, 3 trading days or 5 trading days however, there is no need to adjust volume.
C > H1 AND V > 200000 AND .01 <= C AND C <= 10
C > MAXH3.1 AND V > 200000 AND .01 <= C AND C <= 10
C > MAXH5.1 AND V > 200000 AND .01 <= C AND C <= 10
Yes, the last 10 in the code stands for $10 if the symbol is a stock.
That is exactly what you would do if you are trying to keep the same scan but use a weekly time frame instead of a daily time frame..
If you wanted the volume for the week to be 5 * the 200,000 shares used above though, you would want to use 1000000 instead of 500000.
I have made some changes to the Thursday, January 26, 2017 9:29:15 AM ET post. Please see if it works better for you.
Click on the RS indicator and select Create Scan Condition. Choose New High and set the period as desired.