|
PureBytes Links
Trading Reference Links
|
Hi,
If I had ranges 27, 28, 29, 30, 31, 32, 33, 34, 35
I'm looking to pick out the median of ranges above 30
So I'm looking for the number 33
I've tried setting ranges below 30 to 'Null' but that doesn't work as in
below.
Med_2 = IIf(Range > 30, Range,Null); // Knock out ranges less than 30
Per_Med2 = Median(Med_2,90);
Does anyone know how to do this easily in AB?
Thanks
Alan
firehorse888uk wrote:
>Hi,
>
>Does anyone know a way of how to find the median for the last 90 days
>for ranges 30 and above?
>
>I've tried something like
>
>Med_2 = IIf(Range > 30, Range,Null); // Knock out ranges less than 30
>Per_Med2 = Median(Med_2,90);
>
>But it doesn't give the desired result.
>
>Anyone have a better idea?
>
>Thanks
>Alan
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Try Online Currency Trading with GFT. Free 50K Demo. Trade
24 Hours. Commission-Free.
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/GHeqlB/TM
--------------------------------------------------------------------~->
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|