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

Re: [EquisMetaStock Group] How to count the number of occurences?



PureBytes Links

Trading Reference Links



Hi Roy,

Yes absolutely :)
Your code works fine ! (as usual). Thank you very much.

What I would like to do now is a litte bit more tricky : I want to take 
the average of the ADX for each RSI interval.

Let's imagine :

R:=RSI(C,14);
Cum(R<20 and R>=10) returns 3 occurrences.

In other words, Th RSI was 3 times within the 10 - 20 interval.

For each occurrence, the corresponding values of the ADX were :

- First occurrence of the RSI within the interval (R<20 and R>=10) : the 
ADX value was 50.
- Second occurrence of the RSI within the interval (R<20 and R>=10) : 
the ADX value was 30.
- Third occurrence of the RSI within the interval (R<20 and R>=10) : the 
ADX value was 25.

So, the final result is :

- Average of the ADX for the RSI interval (R<20 and R>=10) = (50+30+25)/3.

Your help would be greatly appreciated.

Thanks in advance,

Marco





Roy Larsen wrote :

Hi Marco
 >>
 >>Is this what you mean?
 >>
 >>R:=RSI(C,14);
 >>Cum(R<10);
 >>Cum(R<20 and R>=10);
 >>Cum(R<30 and R>=20);
 >>Cum(R<40 and R>=30);
 >>Cum(R<50 and R>=40);
 >>Cum(R<60 and R>=50);
 >>Cum(R<70 and R>=60);
 >>Cum(R<80 and R>=70);
 >>Cum(R<90 and R>=80);
 >>Cum(R>=90);
 >>
 >>
 >>Kind regards
 >>
 >>Roy
 >>www.metastocktips.co.nz









Jose a écrit :
> 
> Easier said than done.
> 
> Difficulties involved:
> 
> 1) Restrict peaks/troughs lookback to last 6 calendar months;
> 2) Find highest / 2nd highest / third highest/lowest peaks/troughs;
> 3) Get it coded into MetaStock without using the professional services 
> of a competent programmer. ;)
> 
> Try this:
> 
> ====================
> Peak/Trough averages
> ====================
> ---8<---------------------
> 
> { Average of three highest peaks / lowest
>   troughs in an oscillator over last 6 months }
> 
> { ©Copyright 2005 Jose Silva
>   For personal use only
>   http://www.metastocktools.com }
> 
> { Oscillator/Indicator }
> x:=MACD();
> 
> { User input }
> lbMth:=Input("Lookback months",1,12,6);
> 
> { Restrict search to lookback period }
> StMnth:=LastValue(Month())-lbMth;
> StYear:=If(StMnth<1,
>  LastValue(Year())-1,LastValue(Year()));
> StMnth:=If(StMnth<1,StMnth+12,StMnth);
> lookback:=Year()>StYear
>  OR (Year()=StYear AND (Month()>StMnth
>   OR Month()=StMnth
>    AND DayOfMonth()>=LastValue(DayOfMonth())));
> 
> { Highest/2nd/3rd peak values }
> pk:=If(lookback,Peak(1,x,.001),Lowest(x));
> pk1:=LastValue(Highest(pk));
> pk2:=LastValue(Highest(If(pk=pk1,0,pk)));
> pk3:=LastValue(Highest(
>  If(pk=pk1 OR pk=pk2,0,pk)));
> 
> { Lowest/2nd/3rd trough values }
> tr:=If(lookback,Trough(1,x,.001),Highest(x));
> tr1:=LastValue(Lowest(tr));
> tr2:=LastValue(Lowest(If(tr=tr1,0,tr)));
> tr3:=LastValue(
>  Lowest(If(tr=tr1 OR tr=tr2,0,tr)));
> 
> { Average of last 3 peak/trough values }
> avgPk:=(pk1+pk2+pk3)/3;
> avgTr:=(tr1+tr2+tr3)/3;
> 
> { Plot in own window }
> x;avgPk;avgTr
> 
> ---8<---------------------
> 
> 
> jose '-)
> http://www.metastocktools.com
> 
> 
> 
> --- In equismetastock@xxxxxxxxxxxxxxx, "Andrew Tomlinson" 
> <andrew_tomlinson@xxxx> wrote:
> 
>>That was too easy. How about this one - I want to take the average
>>of the three highest peaks in an unbounded oscillator over the last
>>6 months (also the three lowest, but I'm assuming that will flow
>>from the first answer). 
>>
>>Any takers?
>>
>>Best
>>Andrew
>>
>>
>>
>>
>>-----Original Message-----
>>From: Roy Larsen [mailto:rlarsen@x...] 
>>Sent: Thursday, March 10, 2005 6:18 PM
>>To: equismetastock@xxxxxxxxxxxxxxx
>>Subject: Re: [EquisMetaStock Group] How to count the number of
>>occurences ?
>>
>>
>>Hi Marco
>>
>>Is this what you mean?
>>
>>R:=RSI(C,14);
>>Cum(R<10);
>>Cum(R<20 and R>=10);
>>Cum(R<30 and R>=20);
>>Cum(R<40 and R>=30);
>>Cum(R<50 and R>=40);
>>Cum(R<60 and R>=50);
>>Cum(R<70 and R>=60);
>>Cum(R<80 and R>=70);
>>Cum(R<90 and R>=80);
>>Cum(R>=90);
>>
>>
>>Kind regards
>>
>>Roy
>>www.metastocktips.co.nz
>>
>>
>>
>>----- Original Message ----- 
>>From: "khamsina11" <Khamsina11@xxxx>
>>To: <equismetastock@xxxxxxxxxxxxxxx>
>>Sent: Friday, March 11, 2005 10:48 AM
>>Subject: [EquisMetaStock Group] How to count the number of
>>occurences ?
>>
>>
>>Hi,
>>
>>I would like to know (for all the data available) the number of
>>times an indicator has been within an interval.
>>
>>For example, with a RSI : 0-9, 10-19, 20-29..... until 100.
>>
>>Thanks for your help,
>>
>>Marco
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  
> 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/