|
this is untested but try it
....
a1:=
if(ref(H,-1)<H,1,0);
b1:=sum(a1,{periods});
Dusant
----- Original Message -----
Sent: Saturday, April 30, 2005 4:35
PM
Subject: Re: [EquisMetaStock Group]
EXPLORATION
In excel - the COUNTIF() function is used to
count the number of previous days when the high was lower than the high of the
current day.
is there a way to program this in ms easily pls
?
regards
sharad lohia
----- Original Message -----
Sent: Saturday, April 23, 2005 10:31
PM
Subject: Re: [EquisMetaStock Group]
EXPLORATION
Maybe post some of the Excel code. I understand
you count the number
of days that a new high has been attained - or that
the day's high has
been higher than the previous one, and build the
system around that.
But the Excel code will maybe help, so give some
formulas and I am
sure somebody here may be able to help with the
translation. MS is
not that difficult, especially if you are
comfortable 'programming' in
Excel, then you should not have too many
problems.
Regards
MG Ferreira
TsaTsa EOD Programmer and trading
model builder
http://www.ferra4models.com
http://fun.ferra4models.com
--- In equismetastock@xxxxxxxxxxxxxxxx,
"Sharad Lohia"
<sharadlohia@x...> wrote:
> I am
currently using a system which goes long stocks which move up
with
volumes and make new highs. I have programmed this system in
excel and
now i want to program it in metastock. The setup is that if
a stock is
making new highs - going long will give a good return over
the next few
days provided volume is confirming. The key is when to
exit. Now in
bull markets several stocks fulfil this criteria and my
experience has
shown that the more the stock is in new highs (ie. the
more the number of
previous days whose highs have been crossed), the
greater the profits. So
the best way is to sort out the list on that
basis.
>
>
Unfortunately - i am unable to program it in metastock.
>
>
Using the formula given - and thanks once more for that to J -
it
gives 0 as the answer since the current day has made the new
high.
Changing 1 to 2 gives the number of days since the last swing high
-
which is lower than the current high in my case and thus of no use.
I
have tried changing the formula and breaking my head on a solution
-
but to no avail.
>
> What am i missing here. How can i use
bars since function and value
when function and compare previous highs
with current high to mark
that day out
>
> Any clues
?
>
> Regards
> ----- Original Message -----
> From: MG Ferreira
> To: equismetastock@xxxxxxxxxxxxxxxx
> Sent: Saturday, April 23, 2005 1:12
AM
> Subject: Re: [EquisMetaStock Group]
EXPLORATION
>
>
>
>
> > The
assumption being that the more the number of previous
days'
> highs the stock has crossed today - the stronger
the trend.
>
> If this value returns a high value,
then the trend is not strong, the
> spike is huge!
Think about it - if you have a falling market, and
>
suddenly a spike, then this will be a sudden high value. In a
rising
> market, this value will be smallish as you have
an upward trend, and
> the high keeps on getting
higher.
>
> Regards
> MG
Ferreira
> TsaTsa EOD Programmer and trading model
builder
> http://www.ferra4models.com
>
http://fun.ferra4models.com
>
>
>
> --- In equismetastock@xxxxxxxxxxxxxxxx,
"Sharad Lohia \(G\)"
> <sharadlohia@x...>
wrote:
> > Thanks for the reply - but this is not what
i was looking for.
> >
> > I
think i was not clear enough.
> >
>
> What i want to do is to run an exploration at the end of each
day
> which will list all stocks and rank them on the
basis of -
> > TODAY'S HIGH IS HIGHER THAN THE HIGH OF
"X" NUMBER OF PREVIOUS DAYS
> >
>
> This "X" should be a column in the exploration and i can then
sort
> on that basis.
> >
> > Eg. If today one stock has made a 8 day high, X =
8 for that stock.
> >
> > The
formula below is for - Bars since the last high. But what i
want
> is stocks crossing highs of last several
days.
> >
> > The assumption
being that the more the number of previous days'
> highs
the stock has crossed today - the stronger the trend.
>
>
> > Could you kindly help
>
>
> > Regards
> >
----- Original Message -----
> > From:
Jose Silva
> > To: equismetastock@xxxxxxxxxxxxxxxx
> > Sent: Thursday, April 21, 2005 3:32
AM
> > Subject: Re: [EquisMetaStock Group]
EXPLORATION
> >
> >
> >
> >
>
> Sharad, try this MS indicator/exploration
code:
> >
> >
---8<-------------
> >
Hi:=ValueWhen(1,H>Ref(H,-1),H);
> >
BarsSince(H=Hi)
> >
---8<-------------
> >
> >
> > jose '-)
>
> http://www.metastocktools.com
>
>
> >
> >
> > --- In equismetastock@xxxxxxxxxxxxxxxx,
"Sharad Lohia"
<sharadlohia@x..
>
> .> wrote:
> > > I
want to rank the stocks at the end of each day - on the
basis
of
> > > the number of days high it has
made. Thus the exploration result
> > >
should give the number of days which have passed since
that
day's
> > > high was more than
today's high. I can then sort it on that
basis
>
> >
> > > Is it
possible. Am unable to find the right function or
formula.
> > >
>
> > Kinldy help.
> > >
> > > Regards
> >
> >
> >
>
>
> >
> >
> >
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
> Yahoo!
Groups Links
------------------------ Yahoo! Groups
Sponsor --------------------~-->
What would our lives be like without
music, dance, and theater?
Donate or volunteer in the arts today at
Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/BefplB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group
on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*>
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/
Yahoo! Groups Links
Yahoo! India Matrimony: Find your life partner
online. |