Nasdaqtrader,

You will benefit greatly from reading the MS Users Manual for the creation of your own explorations, then download the free Equis Formula Primer (from the files section) to hone your MetaStock Formula Language programming skills.

If you don't want to learn to do the basics yourself, please consider hiring a programmer to help you out: It is not the purpose of the forum to do all the work for you, the forum is to assist people who are having trouble implementing their ideas in MS.

In the mean time, try something along these lines...

Col A : RSI(C,2)

Col B : C

Col C : V

Col D : (VOLUME/(Mov(VOLUME,90,S))*100)

Filter: (ColA<10 OR ColA>90) AND C>5 AND Mov(V,100,S)>250000

wabbit [:D]

Hi All,

The RSI(C,2) function DOES work in the explorer, but only if you UNCHECK THE LOAD MINIMUM BARS and load the right amount of data!!!

You need to load at least 3 bars for the RSI(C,2) function to return a value, but the algorithm MS uses to compute the minimum bars required concludes you only 2 bars of data; this is why no results get returned.

Additionally, the canned version of the RSI uses Wilders smoothing, which is an exponential function. If you only load four bars of data in the exploration and load, say, 5000 bars of data on your charts, any plot of the RSI(C,2) on the chart will not be the same as the exploration result. You need to ensure you load enough data in the exploration to account for the exponential functionality of the RSI algorithm.

When using exponential functions, always load AT LEAST five times the longest period, i.e. for accurate results of the RSI(C,2) function in an exploration load AT LEAST 10 bars of data, for RSI(C,20) load AT LEAST 100 bars of data.

--

People often say "this doesn't work in the explorer", or, "the explorer doesn't show the same results as the chart". In about 99.99% of cases, this is because of the "load minimum bars" feature or the user is being "lazy" and loading some insufficient amount of data into the exploration (usually in an attempt to make the exploration faster)

I put it to you; what would you prefer:
an exploration that is blindingly fast but returns the wrong results, or
an exploration that takes a little longer but returns accurate results?

PLEASE, please do NOT ever use the "load minimum bars" feature of the explorer. Force yourself to make a conscious decision about how much data your exploration requires for accuracy EVERY time you run an exploration. After all, SISO ([censored]in, [censored]out) and it's your money that will be following the exploration down the drain!


Hope this helps.

wabbit [:D]