Help with formula

[martindelica]

Hi there, I was hoping somebody could help me a formula:
I want MS explorer to use the following parameters;
RSI(14) is greater than 70
Average daily volume over last 5 days is decreasing.
and
RSI(14) is less than 30
Average daily volume over last 5 days is decreasing.

Kindest Regards,
Martin.

 

[zambuck]

I am simpleton so I do it in my sort of way.....Others may have better way of doing it.

When you create Explorations select following in both the cases.
Click OPTIONS box and choose MOST RECENT DATE
In Explorer Periodicity choose DAILY
And click FILTER tab at the bottom
Under SECURITIES select the Securities you want to EXPLORE
In options choose following:
Load 8000 records - This is important.


Create an Explorer and call it following:
RSI>70 and 5MA VOL is dcreasing


In ColA
Type following:
RSI(14)

On ColB
Type following
VOLUME

In ColC
Type following
Mov(VOLUME,5,EXPONENTIAL)

In Filter
Type following
colA>70 AND colB>colC


Create another Explorer and call it following:
RSI<30 and 5MA VOL is increasing
(I am assuming that you wanted the volume INCREASING this time)

In ColA
Type following:
RSI(14)

On ColB
Type following
VOLUME

In ColC
Type following
Mov(VOLUME,5,EXPONENTIAL)

In Filter
Type following
colA<30 AND colC>colB


In options choose following:
Load 8000 records