[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] trading range & other


  • Date: Sat, 20 Feb 2010 08:44:11 -0800 (PST)
  • From: Mr Distinque <distinque@xxxxxxxxx>
  • Subject: Re: [EquisMetaStock Group] trading range & other

PureBytes Links

Trading Reference Links



You can now add in the extra blank column the your short/exit strategy.  Make for quick sort going the other way.  Once I have things the way I want them, I create an exploration for stocks, indexes, ETFs and current positions.  I also have one more group of the specific ETFs that I follow for each ETF sector. i.e. Indexes, metals, currencies, etc.  This way I have a specific report for what ever group is moving.  Each report has 4 levels.  Most restrictive selection long/short and less restrictive long/short.  In theory the most restrictive has the best risk/reward ratio. 
 
With these report I can sort each column for an instant overview of what is happening in each area/sector.  More "1"s with the bullish ETF = bullish trend.  More "1"s with the bearish ETFs  bearish trend.  Same with the long/short short signals on the indexes and stocks.

All  have to do for ETFs is sort the report based on the long/short signals followed by the sub directories (I keep my securities in specific sub directories based on sector.) and I know who is running the show and what direction they are going.  KISS at it's best.
 
Use the date function to create a report that only shows the last date, I call mine LastDate, that scans everything.  Filter for everything that is earlier than the last update date.  This creates a report you can use to update/delete invalid symbols.
 
D
EGO Sum Qua EGO Sum
Sempre Avanti
 
He Who Sits In A Well To Look At The Sky Can See But Little


--- On Fri, 2/19/10, fib1618 <fib1618@xxxxxxxxxxxx> wrote:

From: fib1618 <fib1618@xxxxxxxxxxxx>
Subject: Re: [EquisMetaStock Group] trading range & other
To: equismetastock@xxxxxxxxxxxxxxx
Date: Friday, February 19, 2010, 7:28 PM

 
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
 
 

Sent: Friday, February 19, 2010 9:09 PM
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/subdirect ories 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@xxxxxx net.au> wrote:

From: fib1618 <fib1618@xxxxxx net.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

__,_._,___