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

Re: [EquisMetaStock Group] EXPLORATION



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/