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

help with easyscan Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
kyle5
Posted : Sunday, November 3, 2013 1:21:34 AM
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
Bruce_L
Posted : Monday, November 4, 2013 8:38:42 AM


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
kyle5
Posted : Monday, November 4, 2013 8:52:18 AM
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

emiljona
Posted : Monday, November 4, 2013 10:09:27 AM
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.

Bruce_L
Posted : Monday, November 4, 2013 10:22:29 AM


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
Bruce_L
Posted : Monday, November 4, 2013 11:55:25 AM


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
kyle5
Posted : Monday, November 4, 2013 12:36:44 PM
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
Bruce_L
Posted : Monday, November 4, 2013 12:44:27 PM


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
kyle5
Posted : Monday, November 4, 2013 1:02:08 PM
Registered User
Joined: 11/20/2006
Posts: 98

Cheers & Thank You very much Bruce

Bruce_L
Posted : Monday, November 4, 2013 1:03:04 PM


Worden Trainer

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

You're welcome.



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