Re: [EquisMetaStock Group] trading range & other

["fib1618" <fib1618@xxxxxxxxxxxx>]

I got rid of the .mws charts as suggested and the result was good-- never realised they could be such a nuisense  - I think I remember seeing  somewhere to turn them off.

I've been using the standard " use today's date " for scan options  -- not any more -- there were a few older charts there-- another thing that doesn't work  

I ran your If   statement  and got a 95.8% rejection on the ASX -- pretty good as a start

I'll tighten it up more with a volume filter  etc

I'd never have thought of using an IF statement in a scan -- generally the ones I've seen/made/used stick to putting different tests in in  colA, B, C  etc then sortof combining them with a filter =1 type of thing . I'm really surprised at the vast improvement --  same tests, but all in one  IF statement   -- a vast improvement.

I'm now heading in the right direction , thanks to your advice

 

 

From: Mr Distinque

Sent: Friday, February 19, 2010 9:09 PM

To: equismetastock@xxxxxxxxxxxxxxx

Subject: Re: [EquisMetaStock Group] trading range & other

 

I would make a couple of changes.

 

First as to the mish/mash of charts, I would create a default template of what you want to see.  I would also save it under another name in case you step on it some time and want to return to it.  I would then do a search for *.mws files under the directory/subdirectories and delete them.  That will eliminate all your previously saved chart layouts.  Anything displayed from there will be in the new defaul format.  Beats doing them one-by-one

 

I have found MS will sometimes get a little weird on exploring with naked formulas.  I wrap mine in an if statement that = 1 if it what I want and 0 if it is not.  I also put DayOfMonth() in ColA to make sure I have the latest pricing.  And I have CLOSE in ColB for sorting.  From there it would be:

 

ColC

if ( H<=Ref(H,-1) AND H<=Ref(H,-2) AND L>=Ref(L,-1) AND L>=Ref(L,-2) AND Mov(C,20,S)<= L ,1,0)

 

Filter: colC=1 

I ran it on 4000 stocks, had a 96.7 rejection rate.  Open a random selection of them and was not really impressed with anything I saw.  But that is me and I might be blind..........

D

EGO Sum Qua EGO Sum

Sempre Avanti

 

He Who Sits In A Well To Look At The Sky Can See But Little

--- On Thu, 2/18/10, fib1618 <fib1618@xxxxxxnet.au> wrote:

From: fib1618 <fib1618@xxxxxxnet.au>
Subject: [EquisMetaStock Group] trading range & other
To: "Equismetastock" <equismetastock@yahoogroups.com>
Date: Thursday, February 18, 2010, 8:34 PM

 

hello, I've been away from Metastock for some time and now returning

 

1/   i'd like to make an Explorer to find trading ranges  and appreciate this may take a while

 

my initial try was     Col A - H<=Ref(H,-1) AND H<=Ref(H,-2)   ( I was going to try  H<= (Ref(H, -1)*1.1)    etc , maybe later )

                                 ColB -- L>=Ref(L,-1) AND L>=Ref(L,-2)                                 

                                ColC -- Mov(C,20,S)<= L       (-- for good measure, I put in a rising MA )

 

    so  I put ColA =1  AND ColB=1 AND ColC=1  in the filter and got only a 5.5%  rejection  -- far too many

I was surprised, I thought the rising MA & the Col=1 filter would trim it down a lot

 

2/  when i want to look at the results of a scan, click  Open  Charts, and all the scanned charts are opened -- what a mish-mash of charts

 there was a mixture of Candlesticks, Line , Bar  etc  -- no set type as i thought it should be.

so I put in a new  Default template, opened the default chart and ran the scan , expecting all charts would be the same  as the opened chart-- sadly no-- they were exactly the same, a mish-mash

 

so without giving away any "secrets", 

1/    I'd appreciate some  advice on how to tighten up my scan   

2/    how to have the "result" charts showing at least all the same, preferably  in line with a template of the scan

 

thanks  Keith

__._,_.___

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___