Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 11/20/2006 Posts: 98
|
Bruce could you please help me with an easyscan formaula that does the following
It finds any stock that makes a new 250 day high then closes in the bottom 10 % of the weekly bar.(i.e., the bar that has the 250 day high somwhere in it.) Could we exclude stocks below $12.00
thanks kyle5
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I cannot think of a way to do what you want in TC2000 version 12.3 because there is no way to tell if a particular daily bar is part of any particular weekly bar in the Personal Criteria Formula Language.
If we were using the 5 trading day rolling weekly bars from TC2000 version 7 instead, we could create a daily Condition Formula for this as:
(H > MAXH249.1 OR H1 > MAXH249.2 OR H2 > MAXH249.3 OR H3 > MAXH249.4 OR H4 > MAXH249.5) AND STOC5 <= 10 AND C >= 12
If we are not as restrictive about the highs (it is not the same thing, but it is close), we could shorten it a bit to:
MAXH5 > MAXH245.5 AND STOC5 <= 10 AND C >= 12
PCF Formula Descriptions
Understanding Stochastics
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/20/2006 Posts: 98
|
Thanks Bruce
thats excellent & I will use that in TC2000
I actually meant to post this in the stockfinder section( my bad) as I am trying to set it up in stockfinder5.
Is there an easyscan that can achieve this is stockfinder 5 ?
Thanks kyle5
|
|
Registered User Joined: 5/27/2013 Posts: 1
|
Hello...what the hell happened to the chart? Its not updating and no one responding on the live chat suppport.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
emiljona,
The charts are not updating currently. The wait to get through to technical support is currently quite long as a result. We are working to get the issue resolved as soon as possible. Thank you for your patience.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
kyle5,
StockFinder doesn't have EasyScans (although it does have Filters which are similar). What you would need to do is create a condition for this. You could then use the condition as a WatchList Column and sort or as a Filter Condition to limit the stocks appearing in the WatchList.
Creating Conditions
Writing Conditions in RealCode
Scanning with Conditions
Filtering Lists
A RealCode Condition for what I think you want could be written as:
'|*****************************************************************|
'|*** StockFinder RealCode Condition - Version 5.0 www.worden.com
'|*** Copy and paste this header and code into StockFinder *********
'|*** Condition:kyle5_60384
'|******************************************************************
Static WeekHigh As Single
Static WeekLow As Single
Static WeekTest As Boolean
If isFirstBar Then
WeekHigh = Single.NaN
WeekLow = Single.NaN
WeekTest = False
Else If Price.DateValue.DayOfWeek < Price.DateValue(1).DayOfWeek Then
WeekHigh = Price.High
WeekLow = Price.Low
WeekTest = False
Else
WeekHigh = System.Math.Max(WeekHigh, Price.High)
WeekLow = System.Math.Min(WeekLow, Price.Low)
End If
If CurrentIndex > 250 Then
If Price.High > Price.MaxHigh(249, 1) Then
WeekTest = True
End If
End If
If CurrentIndex > 255 Then
If WeekTest = True AndAlso _
Price.Last >= 12 AndAlso _
WeekHigh > WeekLow AndAlso _
Price.Last - WeekLow <= .1 * (WeekHigh - WeekLow) Then
Pass
End If
Else
SetIndexInvalid
End If
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/20/2006 Posts: 98
|
Thank You Bruce, I have set that up in sf5 as a market indicator and its exactly what i wanted. Could you please give me one more, but in the opposite direction. i.e.That finds any stock that makes a new 250 day low then closes in the top 10 % of the weekly bar.(i.e., the bar that has the 250 day low somwhere in it.) Could we exclude stocks below $12.00 again.
thanks kyle5
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following RealCode Condition:
'|*****************************************************************|
'|*** StockFinder RealCode Condition - Version 5.0 www.worden.com
'|*** Copy and paste this header and code into StockFinder *********
'|*** Condition:kyle5_60384_Reversed
'|******************************************************************
Static WeekHigh As Single
Static WeekLow As Single
Static WeekTest As Boolean
If isFirstBar Then
WeekHigh = Single.NaN
WeekLow = Single.NaN
WeekTest = False
Else If Price.DateValue.DayOfWeek < Price.DateValue(1).DayOfWeek Then
WeekHigh = Price.High
WeekLow = Price.Low
WeekTest = False
Else
WeekHigh = System.Math.Max(WeekHigh, Price.High)
WeekLow = System.Math.Min(WeekLow, Price.Low)
End If
If CurrentIndex > 250 Then
If Price.Low < Price.MinLow(249, 1) Then
WeekTest = True
End If
End If
If CurrentIndex > 255 Then
If WeekTest = True AndAlso _
Price.Last >= 12 AndAlso _
WeekHigh > WeekLow AndAlso _
WeekHigh - Price.Last <= .1 * (WeekHigh - WeekLow) Then
Pass
End If
Else
SetIndexInvalid
End If
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/20/2006 Posts: 98
|
Cheers & Thank You very much Bruce
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |