in Search

Using explorer

Last post 12-09-2007, 20:34 by Chin. 12 replies.
Sort Posts: Previous Next
  •  04-19-2007, 16:24 23808

    Using explorer

    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
  •  04-19-2007, 18:07 23810 in reply to 23808

    Re: Using explorer

    1) v>100000 and c>10

    2) c<=hhv(c,180)/2

    3) Vega your question denote that u did not read metastock help. U should do it

    cheers 

     

  •  04-19-2007, 18:24 23811 in reply to 23808

    Re: Using explorer

    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 Big Smile [:D]


    MS: 6.52 EOD, 7.x EOD, 8.0 PRO, 9.2 PRO w/QC, 10 PRO w/QC & MDK
    For custom MetaStock programming : http://www.wabbit.com.au
    My SkyPE status : wabbit.com.au SkyPE online status
    My SkyPE account : wabbit.com.au

  •  04-25-2007, 16:45 23860 in reply to 23808

    Wappit!

    Thank for you very mucho, your feedback&help in this forum is asthoning!

    Vega

     

  •  05-05-2007, 19:22 23937 in reply to 23860

    Re: Wappit!

    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






  •  05-06-2007, 0:15 23939 in reply to 23937

    Re: Wappit!

    Coding Fib retracements in MS can be a little tricky sometimes, but if you can get your head around some of the basic issues then it actually becomes quite easy.

    Look to use the HHV and LLV, also the ValueWhen() or BarsSince() functions to find when these events occurred.


    wabbit Big Smile [:D]

    MS: 6.52 EOD, 7.x EOD, 8.0 PRO, 9.2 PRO w/QC, 10 PRO w/QC & MDK
    For custom MetaStock programming : http://www.wabbit.com.au
    My SkyPE status : wabbit.com.au SkyPE online status
    My SkyPE account : wabbit.com.au

  •  05-09-2007, 6:41 23969 in reply to 23939

    Re: Wappit!

    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;






  •  05-09-2007, 7:04 23970 in reply to 23969

    Re: Wappit!

    Vega:
    a;aa;aaa;aaaa;aaaaa;aaaaaa;

    Check your keyboard, Vega - something tells me that one of the keys is jammed.


    jose '-)
    MetaStockTools.com
  •  05-09-2007, 18:59 23977 in reply to 23969

    Re: Wappit!

    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.

    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.


    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 Big Smile [:D]


    MS: 6.52 EOD, 7.x EOD, 8.0 PRO, 9.2 PRO w/QC, 10 PRO w/QC & MDK
    For custom MetaStock programming : http://www.wabbit.com.au
    My SkyPE status : wabbit.com.au SkyPE online status
    My SkyPE account : wabbit.com.au

  •  05-09-2007, 19:17 23978 in reply to 23977

    Re: Wappit!

    wabbit:
    Computers are dumb and will do whatever you tell them to do.  Computers cannot read minds...
    Don't count on it, Wappit - computers are evil creatures constantly monitoring the urgency of the situation, waiting to pounce (crash) on you when you least expect it. ;)


    jose '-)
    MetaStockTools.com
  •  05-09-2007, 19:28 23979 in reply to 23978

    Re: Wappit!

    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 Sad [:(]

    waBBit Big Smile [:D]


    MS: 6.52 EOD, 7.x EOD, 8.0 PRO, 9.2 PRO w/QC, 10 PRO w/QC & MDK
    For custom MetaStock programming : http://www.wabbit.com.au
    My SkyPE status : wabbit.com.au SkyPE online status
    My SkyPE account : wabbit.com.au

  •  05-09-2007, 20:32 23980 in reply to 23979

    Re: Wappit!

    There you go, WaBBit... now you know who is really in charge, eh!?. :)


    jose '-)
    MetaStockTools.com
  •  12-09-2007, 20:34 26003 in reply to 23811

    explorer formula protection

    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 ?

View as RSS news feed in XML