logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Rookie11  
#1 Posted : Wednesday, April 7, 2010 7:15:04 AM(UTC)
Rookie11

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 4/7/2010(UTC)
Posts: 4

Hello all,

since a couple of weeks I'm seeking for a formula of a real gap scanner, so I hope to find some help here...

The output should be the number of days within the last 3 months, where the opening price is out of the trading range of the previous day (upgaps as well as downgaps).

for example:

(within the last 3 months) if the opening price was 15 times above the previous day-high, and 10 times below the previous day-low, the result of the exploration should be 25.

Thanks in advance and greetings from germany.

Rookie.

wabbit  
#2 Posted : Wednesday, April 7, 2010 7:30:08 AM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Views messages in topic : 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
Hi Rookie,

Welcome to the Forum.

I would try reading through some of these posts : http://forum.equis.com/search/SearchResults.aspx?q=stuck&u=75&o=DateDescending>

Rookie11  
#3 Posted : Wednesday, April 7, 2010 10:36:21 AM(UTC)
Rookie11

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 4/7/2010(UTC)
Posts: 4

Hi Wabbit, and pardon me, took a little bit to find out what "stuck" means.... "stock" I knew but not "stuck" :-) Anyway, I found a lot of threads here regarding gaps, but not the kind I explained above... pitty, I would even pay for this kind of formula ;-) I the german metastock forum no one could help me...
v.trader  
#4 Posted : Wednesday, April 7, 2010 3:07:49 PM(UTC)
v.trader

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/26/2009(UTC)
Posts: 76
Location: Toronto, Canada

Hi, maybe you want to try something like this: x:= GapUp(); y:= GapDown(); a1:= Sum(x,60); a2:= Sum(y,60); a1+a2 Thats for the indicator builder. As for the explorer, Just write in column A the same formula, when you do the scan it will display the number of gaps for the stocks scanned Cheers, VT
Rookie11  
#5 Posted : Wednesday, April 7, 2010 3:32:22 PM(UTC)
Rookie11

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 4/7/2010(UTC)
Posts: 4

Hi v.trader and thank you very very much! Thats fantastic! Its exactly what I was looking for! Looks so easy but you can believe me, here in germany it is quite a big deal... thanks again!!!
Users browsing this topic
Guest (Hidden)
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.