[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] EXPLORATION



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