|
PureBytes Links
Trading Reference Links
|
mc,
Not sure what Michael's ultimate goal is but as I started thinking
more about the idea of considering quarterly data I realized that
there may be some real value in using something like this as a
screening tool. With just a few changes the QROC could be used to
look for stocks just starting to move although those moves are
primarily in a southward direction right now. Still I see a great
number of uses regardless of the markets direction.
Oh and the version 2 of the Quarterly Period Indicator was a K.I.S.S.
idea that my son had. His idea shows the quarter without
consideration for the year.
There are tons of ways to simplify these codes. Unless space is a
priority I usually stay with a code that works and that is easily
understood. The reason is that quite often the request coming in are
something like "I'm new to metastock and would like some help coding
this".
I also love the eloquence of code which is short and sweet. Hopefully
these type of contributions will stimulate our new friends into
digging deeper into the nuances of the metastock coding lanquage and
find out for themselves how much fun it can be.
Thanks for the valued contributions!
Preston
--- In equismetastock@xxxxxxxxxxxxxxx, "p_panther_73" <mchantzi@xxx>
wrote:
>
> If I get it right, then adding one-two lines to Preston's code
should
> do the trick:
>
> qstart:=Frac(Month()/3)<>0 AND Ref(Frac(Month()/3),-1)=0;
> a:=ValueWhen(1,qstart,C);
> QROC:=100*(c/a-1);
> lsq:=LowestSince(1,qstart,qroc);
> lsq<=-50;
>
> This will plot a "1" whenever we have a more than 50% fall at any
> point during the current quarter.
>
> It can also be used to indicate max fall during the quarter, if the
> last line is replaced by simply plotting lsq.
>
> Regards,
>
> mc
>
> --- In equismetastock@xxxxxxxxxxxxxxx, "mdtmn" <mdtmn@> wrote:
> >
> > Hi Preston,
> > Thanks again for the reply
> > cheers
> > Michael B
> >
> >
> >
> > --- In equismetastock@xxxxxxxxxxxxxxx, pumrysh <no_reply@> wrote:
> > >
> > > Michael,
> > >
> > > What I gave you was a Quarterly ROC. It begins calculating a
new ROC
> > > at the beginning of each quarter. I don't think you will find
> > > anything like it in a web search.
> > >
> > > The formula for a ROC is today's Close minus a close in the
past. So
> > > is "close to close" today's close minus yesterday's close?
> > >
> > > If that is the case then why not use the gapdown function. A
gap down
> > > occurs if yesterday's low is greater than today's high. True it
> > > measures lows to highs but a daily move on the magnatude of 50%
is
> > > going to be a gap down day.
> > >
> > >
> > > If you decide to use the indicator that I gave you, its a
simple
> > > matter of putting the indicators that I gave you together in
order to
> > > do a search. The indicator would look like this:
> > >
> > >
> > > {Quarterly ROC %}
> > > qstart:=Frac(Month()/3)<>0 AND Ref(Frac(Month()/3),-1)=0;
> > > a:=ValueWhen(1,qstart,C);
> > > QROC:=((C-A)/A)*100; {Percentage}
> > > Quarter:=If(Month()=1 OR Month()=2 OR Month()=3,1,
> > > If(Month()=4 OR Month()=5 OR Month()=6,2,
> > > If(Month()=7 OR Month()=8 OR Month()=9,3,4))); {end}
> > >
> > > x:=Quarter=3 AND (Qroc < -50);
> > > Alert(x,90)
> > >
> > >
> > > The X variable will give a binary signal of one if the Qroc
drops
> > > below minus 50 during the 3rd quarter. The alert function holds
the
> > > value true for the next 90 days.
> > >
> > >
> > > Preston
> > >
> > >
> > >
> > > --- In equismetastock@xxxxxxxxxxxxxxx, "mdtmn" <mdtmn@> wrote:
> > > >
> > > > Hi Preston,
> > > > Thanks again for such a detailed reply.All the ROC
code
> > > > thus far and those I have found on web sites , calculate the
ROC of
> > > > a stock at the end of a nominated period of time , in this
case , a
> > > > quarter.
> > > > From the beginning , I should have been more specific.
> > > >
> > > > I am looking for stocks, that at any time, during the
quarter, have
> > > > had a price movement ( ROC ) of 50% or more, close to close
> > > >
> > > > As an example , the last quarter was 1st of July thru to the
30th of
> > > > September
> > > >
> > > > If at anytime, during that quarter , a stock had a price
movement
> > > > (ROC ) of 50% or more , this is a stock I am looking for , by
the
> > > end
> > > > of the quarter it may well have retraced back some or all of
that
> > > > price movement. The main point being that at anytime during
that
> > > > quarter the stock price had a ROC of 50% or more
> > > >
> > > > Thanks for your effort thus far
> > > > Michael B
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > --- In equismetastock@xxxxxxxxxxxxxxx, pumrysh <no_reply@>
wrote:
> > > > >
> > > > > Michael,
> > > > >
> > > > > I went back and rethought your question and my answer. Here
are a
> > > > > couple of indicators for you. Basically, the process is
still the
> > > > > same. You can use either of the Quarter identifiers to help
with
> > > the
> > > > > timeframe.
> > > > >
> > > > > Hope these will help,
> > > > >
> > > > > Preston
> > > > >
> > > > >
> > > > >
> > > > > {Quarterly ROC}
> > > > > {Calculates the ROC for each Quarter
> > > > > in either Points or Percentage}
> > > > > type:=Input("Points[1] or Percent[2]",1,2,2);
> > > > > qstart:=frac(month()/3)<>0 and ref(frac(month()/3),-1)=0;
> > > > > a:=ValueWhen(1,qstart,C);
> > > > > Pt:= C-A ; {Points}
> > > > > Pn:=((C-A)/A)*100; {Percentage}
> > > > > If(type=2,Pn,Pt);
> > > > >
> > > > >
> > > > > {Quarterly Period}
> > > > > {Identifies which Quarter
> > > > > of the year you are in}
> > > > > qstart:=(Frac(Month()/3)<>0 AND
> > > > > Ref(Frac(Month()/3),-1)=0);
> > > > > ystart:=Year()<>Ref(Year(),-1);
> > > > > (Cum(qstart)+1)-ValueWhen(1,ystart,Cum(qstart));{end}
> > > > >
> > > > > {Quarterly Period v2.0}
> > > > > {Identifies the Yearly Quarter}
> > > > > If(Month()=1 OR Month()=2 OR Month()=3,1,
> > > > > If(Month()=4 OR Month()=5 OR Month()=6,2,
> > > > > If(Month()=7 OR Month()=8 OR Month()=9,3,4))); {end}
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --- In equismetastock@xxxxxxxxxxxxxxx, pumrysh <no_reply@>
wrote:
> > > > > >
> > > > > > Michael,
> > > > > >
> > > > > > In order to get the exploration to pick up the stocks you
are
> > > > > looking
> > > > > > for you will need the indicator to have a value.
> > > > > >
> > > > > > So how to find out if there was a 50% drop?
> > > > > >
> > > > > > Look for the LLV(Your Indicator, 66) <= -50
> > > > > >
> > > > > > You will need to change the 66 periods to reflect the
number of
> > > > > days
> > > > > > you are away from the beginning of the last quarter.
> > > > > >
> > > > > >
> > > > > > Hope this helps,
> > > > > >
> > > > > > Preston
> > > > > >
> > > > > >
> > > > > >
> > > > > > --- In equismetastock@xxxxxxxxxxxxxxx, "mdtmn" <mdtmn@>
wrote:
> > > > > > >
> > > > > > > Hi Preston,
> > > > > > > Thanks for your reply and as per an earlier
post
> > > > > > > "1. The Yahoo groups search feature
> > > > > > > 2. The Yahoo groups links
> > > > > > > 3. The Equis Forum "
> > > > > > >
> > > > > > > I have been using your earlier suggestions, in
my
> > > > > search. I
> > > > > > > must apologise for not being more specific.
> > > > > > > I am looking to find stocks that have moved
50%
> > > > > > > or more in that quarter downwards ( close to
close).The last
> > > > > > quarter
> > > > > > > being 1st of July to 30th of September.
> > > > > > > The ROC since date indicater " plots a percent
rate
> > > of
> > > > > > change
> > > > > > > between a specific date and today. The user is prompted
for
> > > the
> > > > > > > specific date." So this indicater is very dependant on
the
> > > day
> > > > > that
> > > > > > > you run the indicater, where as I am looking for any
stocks
> > > that
> > > > > at
> > > > > > > any time during the quarter have a ROC of 50% or more
not at
> > > the
> > > > > end
> > > > > > > of the quarter
> > > > > > > Thanks agian for your reply
> > > > > > > Michael B
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --- In equismetastock@xxxxxxxxxxxxxxx, pumrysh
<no_reply@>
> > > wrote:
> > > > > > > >
> > > > > > > > Michael,
> > > > > > > >
> > > > > > > > Several points:
> > > > > > > >
> > > > > > > > 1. The ROC will give you that information as a
percent. You
> > > > > would
> > > > > > > > still need to filter for those less than 50%.
> > > > > > > >
> > > > > > > > 2. Yahoo Groups has a search feature which allows you
to
> > > search
> > > > > > > > through old messages. That's what I did and I came up
with
> > > a
> > > > > > > > discussion in message 26524 on December 8, 2007 that
was
> > > about
> > > > > a
> > > > > > ROC
> > > > > > > > Since Date indicator. I believe it will work for you.
> > > > > > > >
> > > > > > > > NAME: ROC Since a Date
> > > > > > > >
> > > > > > > > FORMULA:
> > > > > > > >
> > > > > > > > Day1 := Input("Day",1,31,4);
> > > > > > > > Month1 := Input("Month",1,12,1);
> > > > > > > > Year1 := Input("Year",1900,2400,1999);
> > > > > > > >
> > > > > > > > 100 * (CLOSE - ValueWhen(1,DayOfMonth() = Day1 AND
Month()
> > > =
> > > > > > Month1
> > > > > > > > AND Year() = Year1, CLOSE))/ ValueWhen(1,DayOfMonth()
=
> > > Day1 AND
> > > > > > > > Month() = Month1 AND Year() = Year1,CLOSE)
> > > > > > > >
> > > > > > > >
> > > > > > > > Hope this helps,
> > > > > > > >
> > > > > > > > Preston
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > --- In equismetastock@xxxxxxxxxxxxxxx, "mdtmn"
<mdtmn@>
> > > wrote:
> > > > > > > > >
> > > > > > > > > Hi All,
> > > > > > > > > This is a scan that I use to find stocks that
have
> > > > > moved
> > > > > > 50%
> > > > > > > > or
> > > > > > > > > more per quarter downwards ( close to close)
> > > > > > > > >
> > > > > > > > > Filter days:=60;
> > > > > > > > > C<=Ref(C,-days)-(Ref(C,-days)*0.5)
> > > > > > > > >
> > > > > > > > > as you can see it is approx ( and rough)and very
> > > dependent on
> > > > > > what
> > > > > > > > day
> > > > > > > > > near the end of the quarter you run the scan
> > > > > > > > >
> > > > > > > > > Example , this last quarter was 1st July to 30th
Sep ,was
> > > 66
> > > > > > days
> > > > > > > > > and running the scan on the 24th , 25th, 26th,
29th and
> > > 30th
> > > > > > of
> > > > > > > > > September will give slightly different results
> > > > > > > > >
> > > > > > > > > Would someone be able to offer code that will scan
for
> > > stocks
> > > > > > in the
> > > > > > > > > quarter that at any time during that time period
moved
> > > down
> > > > > in
> > > > > > value
> > > > > > > > > by 50% or more, close to close ?
> > > > > > > > > Thanks in advance
> > > > > > > > > Michael B
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/equismetastock/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:equismetastock-digest@xxxxxxxxxxxxxxx
mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|