PureBytes Links
Trading Reference Links
|
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@xxxxxxxxxxxxxxx,
"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@xxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxx,
"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@xxxxxxxxxxxxxxx
> > 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@xxxxxxxxxxxxxxx,
"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
|
|