PureBytes Links
Trading Reference Links
|
Check the load records option in exploration and charts, both should
be same, for using the bars since function. And then try Jose
Siva formula.
Regards.
--- In equismetastock@xxxxxxxxxxxxxxx, "Sharad Lohia"
<sharadlohia@xxxx> wrote:
> Thanks but does not work.
>
> Any other suggestions ?
>
> Regards
> Sharad Lohia
> ----- Original Message -----
> From: Dusant
> To: equismetastock@xxxxxxxxxxxxxxx
> Sent: Sunday, May 01, 2005 9:28 AM
> Subject: Re: [EquisMetaStock Group] EXPLORATION
>
>
> this is untested but try it ....
>
> a1:= if(ref(H,-1)<H,1,0);
> b1:=sum(a1,{periods});
>
> Dusant
> ----- Original Message -----
> From: Sharad Lohia
> To: equismetastock@xxxx
> 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 -----
> From: MG Ferreira
> To: equismetastock@xxxx
> 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@xxxx, "Sharad Lohia"
> <sharadlohia@xxxx> 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@xxxx
> > 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@xxxx, "Sharad Lohia \(G\)"
> > <sharadlohia@xxxx> 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@xxxx
> > > 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@xxxx, "Sharad Lohia"
> <sharadlohia@xxx
> > > .> 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 Links
>
>
>
>
>
>
>
>
>
> --------------------------------------------------------------------
--------
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/equismetastock/
>
> b.. To unsubscribe from this group, send an email to:
> equismetastock-unsubscribe@xxxxxxxxxxxxxxx
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.
>
>
> Yahoo! India Matrimony: Find your life partner online.
------------------------ Yahoo! Groups Sponsor --------------------~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/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/
|