|
PureBytes Links
Trading Reference Links
|
Ok Norman, thanks. I felt kinda like I just walked into the middle of a
conversation. I am months behind reading this list, but as I said, a
search did not turn up an email with the scans you referenced.
I have no doubt Roy's newsletter is beneficial, and I 'm surprised I
haven't yet subscribed. It's just that I've been overwhelmed with
reading material for the last year or so and don't want to add anything
more at this point, even if it doesn't take long to read.
The subject of your email caught my eye because I wanted a 52 week high
exploration that worked on daily bars, and did not simply estimate the
number of trading days in a year by use of the HHV function. Not that
the HHV is a bad way to go. In fact the occasional miss by the HHV
would probably be very rare.
I checked here because I was hoping not to have to reinvent the wheel.
Probably in the time it took to conceive and write this exploration, I
could have read a couple of Roy's issues!
This morning I wrote the following scan. It uses the LastValue function
and seems to do what I want. I've run it and eyeballed several dozen
of the charts it picked up, and so far don't see any problems at this
point,. But I'd like to know if someone does. I have no idea if this
is similar to Roy's, or inferior in some way. But regardless, I don't
see any problem posting my work here.
I'm using the highs and lows, but some might prefer to use the close.
My apologies if the formatting of this email is bad when you receive it;
Firefox email client sometimes does a poor job.
- 52 WEEK HIGH / LOW SCAN -
-colA-
{New Highs)
date:=(Month()*1000000)+(DayOfMonth()*10000)+Year();
1YearAgo:=
Ref(date=LastValue(date-1) OR
date=LastValue(date-1)+10000 OR
date=LastValue(date-1)+11000 OR
date=LastValue(date-1)+12000 OR
date=LastValue(date-1)+13000 ,-1);
52WeekHigh:=HighestSince(1,1YearAgo=1 AND Ref(1YearAgo,-1)=0,H);
New52WeekHigh:= H>Ref(52WeekHigh,-1);
New52WeekHigh
---------------------
-colB-
{New Lows)
date:=(Month()*1000000)+(DayOfMonth()*10000)+Year();
1YearAgo:=
Ref(date=LastValue(date-1) OR
date=LastValue(date-1)+10000 OR
date=LastValue(date-1)+11000 OR
date=LastValue(date-1)+12000 OR
date=LastValue(date-1)+13000 ,-1);
52WeekLow:=LowestSince(1,1YearAgo=1 AND Ref(1YearAgo,-1)=0,L);
New52WeekLow:=L<Ref(52WeekLow,-1);
New52WeekLow
----------
-colC-
{ma >= trading days forces Explorer to use enough data for this scan}
Mov(C,260,S)
----------------
-Filter-
colA OR colB
====================================================
- END -
====================================================
ruagoodp wrote:
>Hi kaj,
>
>You would have to subscribe to his monthly newsletter which
>incidentally is well worth the money.
>
>Cheers
>
>Norman
>
>
>--- In Metastockusers@xxxxxxxxxxxxxxx, kaj444s <kaj444s@xxxx> wrote:
>
>
>>What scan(s) are you guys talking about? I can't find any emails from
>>Roy about a 52 week high scan or an advance decline scan.
>>
>>Thanks,
>>kaj
>>
>>
>>Roy Larsen wrote:
>>
>>
>>
>>>Hi Norman
>>>
>>>
>>>
>>>
>>>
>>>>Is it possible to set up this scan in the same vein as your advance
>>>>decline scan exploration?
>>>>
>>>>Cheers
>>>>
>>>>Norman
>>>>
>>>>
>>>>
>>>>
>>>Yes. Almost any exploration can could be acumulated in the same
>>>
>>>
>way. I've got one for Trade Equity
>
>
>>>that gives equity and number-of-trade totals without the report
>>>
>>>
>needing to be copied to Excel for
>
>
>>>summary.
>>>
>>>
>>>Kind regards
>>>
>>>Roy Larsen
>>>www.metastocktips.co.nz
>>>Free formulas and MS links
>>>
>>>
>>>
>>>
>>>
>>>
>>>Yahoo! Groups Links
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Metastockusers/
<*> To unsubscribe from this group, send an email to:
Metastockusers-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|