Hello,

1) Can I filter out stocks where volume is greater than 100.000 per day and price perhaps
over 10 $ using explorer ?

2) Using explorer, what would be a formula for find out stocks which has come down from the top 50% ie. in 6 months period ?


Anyone can suggest any metastock book for learning formulas, formula primer have so few examples to give.

Thankx,


Vega

Vega,

This is a very basic filter that you should have been able to build after completing the Equis Formula Primer. The easiest way to handle any programming cahllenge is to break the requirement into its smallest components.

In this case yuo want an exploration that concentrates on volume and price actions. We will deal with the filter conditions later, but lets start by making a new exploration with column that will display the data for our equities.

{Column A - Volume}
VOLUME

{Column B - Close}
CLOSE

{Column C -HHV}
HHV(H,128);
{128 daily bars is representative of about 6 months}
{if you want precise calendar based lookback}
{Is uggest using Jose's calendar tools}


You could run this exploration with no filter condition to see the results given by all stocks in the search, but you dont want to see all of the stock, you only want to see a selection that meets a specified criteria, so in the filter we start building our conditons.

Build one filter condition at a time and run the exploration each time (on a small handful of stocks, no need to do the entire exchange whilst we are still testing)

Lets start with the volume condition:

{filter}
ColA>100000;

Notice I used ColA here to refer to the value of Column A, it is up to you to whether you use ColA or V>100000 which will produce the same results

Run the exploration. Are the results as expected by out condition? Do all of the stocks return have a value in column A, the volume column greater than 100000? Are there any errors?

Then we add to the criteria, using the AND condition (because you are looking for multiple criteria where each criteria must be met)

{flter}
ColA>100000 AND
ColB>10;

NOTE: this could also be written:

{flter}
V>100000 AND
C>10;

Run the exploration. Are the results as expected by the condition? Do all of the stocks return have a value in column A, the volume column greater than 100000 AND a closing price in column B greater then 10? Are there any errors?

Then we add to the criteria,

{filter}
ColA>100000 AND
ColB>10 AND
C<(HHV(H,128)*0.5)

for the retracement.


NOTE: There is a big difference between a stock having a price 50% of the recent high, and a stock that has retraced 50% of the HHV-LLV trading range. Make sure you understand exactly what you are asking for in the filter as MS will show you the results for the conditions you actually code, not for the conditions that you think you mean.



Hope this helps.

wabbit [:D]

Hello wappit,

A bit time to practise again formula&metastock.

1)

As you mentioned there´s big difference if price has retraced off it´s high ie. 50%, there´s big difference. Could I also pick up bars for example 360 (one year) and then take fibonacci retracement of it using same formula or similiar which would consider both, low and high point and then calcucalte 50% retracements ? I suppose this would require using both, LLV and HHV formulas.


Thankx in advance,


Vega

Cross (HHV(C,240)-LLV(C,240)*.382;

I suppose this would be the formula ie. plotting 240 days
.382 retracement. Weird thing is that when I plot it to my
chart, it´s not going to placed exactly in the same place
as metastock automatically added fibonacci lines.

What did you mean by using "valuenwhen" indicator,
I suppose to take out any timeframe fibonacci line
starting point should allways be very sharp bottom line.
Fib lines won´t work so well for the equities which has
had very narrow trading range, bottom and top should
be very clear&sharp to recognice, but I don´t have a clu
how to tell this for metastock. Perhaps fibstarting line (0%)
should be placed where powerfull ABC correction has ended.
To see such an example could be found from this link>

http://www.acrotec.com/ewt.htm

This site gives even more clear picture of different wave structures>

http://www.tradersedgeindia.com/elliott_wave_theory.htm

There seems to be very few issues in this forum about fibonacci´s,
which really surprize me as they are very powerfull in the market
when important retracement reversal appears.

1) Actually only formula I found from here is written by you I think
as following code. Btw. Would it be possible to change colours of
each line automatically of those lines to be more clearly recognable ?

2) Do you have anything similiar code for this to use it in explorer ?

b:=Input(".236",.01,2,.78);
bb:=Input("..382",.01,2,.382);
bbb:=Input(".50",.01,2,.50);
bbbb:=Input(".618",.01,2,.618);
bbbbb:=Input("when applying, always choose overlay without scale",0,0,0);
m:=1;
d:=3;
y:=2006;

a:=ValueWhen(1, Month()=m AND DayOfMonth()=d AND Year()=y,Ref(C,-1));
aa:=ValueWhen(1, Month()=m AND DayOfMonth()=d AND Year()=y,O);

aaa:=(b*(a-aa))+aa;
aaaa:=(bb*(a-aa))+aa;
aaaaa:=(bbb*(a-aa))+aa;
aaaaaa:=(bbbb*(a-aa))+aa;

a;aa;aaa;aaaa;aaaaa;aaaaaa;

Have you read the MS Users Manual and completed Formula Primer yet? If you have then you should be able to figure this one out.

There is something that the learning cannot help you with, and that is you.

You need to ensure the instructions you give MetaStock are the right instructions. Computers are dumb and will do whatever you tell them to do. Computers cannot read minds and cannot interpret yuor code as to what you think you want, it will plot whatever yuo tell it to.



Thats right. The canned Fib lines will be different to your code because you have not told MS to plot retracement! You have plotted a range!

If you start by getting the basics right first, the rest will follow in time.



wabbit [:D]

My computer crashed at 02:36 this morning! All my housekeeping is schedules to start at 03:00, so I had to do it all this morning when I got up and its thrown out my entire day [:(]

waBBit [:D]

How to create password to protect my explorer's formulas ? What are the detailed steps ?

After created the password, how to export it so that I can email to my friend ?

At my friend's PC, how he imports my protected explorer formula to his MetaStock ?