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
|
|