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

Notification

Icon
Error

Options
Go to last post Go to first unread
nasdaqtrader  
#1 Posted : Friday, January 26, 2007 10:55:18 AM(UTC)
nasdaqtrader

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 2/2/2005(UTC)
Posts: 307

Thanks: 7 times
Was thanked: 3 time(s) in 3 post(s)

What I have been trying to do is create a filter to scan everyday, I need help and if it would be possible to have a filter as follows.

Filter:

(RSI(c,4)<10) Or (RSI(c,4)>90)

Then filter out further and apply a price and liquidty filter that requires all stocks to be priced above $5.00 and have a 100 day moving averag of volume greater than 250,000 shares.

Any body can help me with this formula and your feedback .

nasdaqtrader

Regards, Frank Koenig Trade Like a Pro Trend is your Friend
hayseed  
#2 Posted : Friday, January 26, 2007 8:57:05 PM(UTC)
hayseed

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/7/2005(UTC)
Posts: 1,346

hey nasdaq..... you can put your conditions in a column and then add that column letter in the filter.... such as below....

note the if statements in each column... using then allows for us to filter but at the same time return the value if true , not just 1 or 0....

column a and b return the rsi value when they fit your ' < or >' conditions....

column c the 'if' statement.... if the close is > than 5 bucks it lists the closing price....

also column d reports the volume if it's greater than 2500 , remember many data suppliers report volume in hundreds.... so i multiplied the returned volume by 100 so its reflects true value.....h

rsi
Exploration notes

Col A: rsi<10 ..... if(RSI(C ,5 ) < 10 , rsi(c,5),0)
Col B: rsi>90 ..... if(RSI(C ,5 ) > 90 , rsi(c,5),0)
Col C: close ..... If(C>5,C,0)
Col D: vol ..... If(Mov(V,100,E)>2500,V*100,0)
Filter ..... (colA OR colB) AND colC AND colD

Filter enabled Yes
Periodicity Daily
Records required 500

Users browsing this topic
Guest (Hidden)
Similar Topics
Exploration Filter Help (Formula Assistance)
by nasdaqtrader 4/27/2007 11:18:14 AM(UTC)
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.