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

Notification

Icon
Error

Options
Go to last post Go to first unread
Slartybardfast  
#1 Posted : Wednesday, January 16, 2019 1:16:15 AM(UTC)
Slartybardfast

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 1/15/2019(UTC)
Posts: 2
Location: TWEED HEADS

Hello 

Am a newby

was just wondering if it is possible to scan the ASX

Using these criteria

MACD below 0 rising

RSI 30 to 70 band rising

SO 20 to 80 band rising

Thanks in advance.

Slartybardfast

MS Support  
#2 Posted : Thursday, January 17, 2019 5:11:45 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Originally Posted by: Slartybardfast Go to Quoted Post

Hello 

Am a newby

was just wondering if it is possible to scan the ASX

Using these criteria

MACD below 0 rising

RSI 30 to 70 band rising

SO 20 to 80 band rising

Thanks in advance.

Slartybardfast

Hello,

This should be possible and can be constructed in different ways, i.e. having all 3 criteria in a single filter, or having each criterion display within its own results column, and then use the Filter column as needed (i.e. making all column criteria required or some combination of column criteria required).

I am not familiar with the formula for Stochastic Oscillator Bands, although I would expect it to be possible to code.

Using the pre-defined MACD and a modified version of RSI Bands found here, you could write Column formulas as follows:

Column A: MACD Ris

Code:
MACD() < 0 AND ROC(MACD(),1,$)>0

Column B: RSIB Ris

Code:
topv:=70;
botv:=30;
tp:=14;
change:= ROC(C,1,$);
Z:=Wilders(If(change>0,change,0),tp);
Y:=Wilders(If(change<0,Abs(change),0),tp);
tx:=(tp-1)*(Y*topv/(100-topv)-Z);
bx:=(tp-1)*(Y*botv/(100-botv)-Z);
tband:=If(tx>0,C+tx,C+tx*(100-topv)/topv);
bband:=If(bx>0,C+bx,C+bx*(100-botv)/botv);
ROC(tband,1,$)>0 AND ROC(bband,1,$)>0

You could then have a Filter column to restrict your exploration results to only those instruments that meet the criteria desired, such as:

Filter:

Code:
ColA AND ColB

Slartybardfast  
#3 Posted : Friday, January 18, 2019 4:02:29 AM(UTC)
Slartybardfast

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 1/15/2019(UTC)
Posts: 2
Location: TWEED HEADS

Thanks for the reply it is very helpful

I was hope to scan with all three if possible

Slartbardfast

MS Support  
#4 Posted : Friday, January 18, 2019 3:34:47 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Originally Posted by: Slartybardfast Go to Quoted Post

Thanks for the reply it is very helpful

I was hope to scan with all three if possible

Slartbardfast

The Explorer has the capacity to scan by a large number of criteria, but we would need to know what the mathematical criteria are for the indicator. Stochastic Oscillator is a standard/built-in formula function that can be used, but I am unfamiliar with SO Bands.

Users browsing this topic
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.