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

[amibroker] Re: Percentile for Up Bar array not returning correct value.



PureBytes Links

Trading Reference Links

I'm not sure of the answer to your question, but note that there are
different ways of calculating percentile. See:

http://www.itl.nist.gov/div898/handbook/prc/section2/prc252.htm

That document specifically mentions how Excel does it.

Regards,
GP


--- In amibroker@xxxxxxxxxxxxxxx, ChrisB <kris45mar@xxx> wrote:
>
> Hi Group
> 
> When I do an exploration for the High Range of Up Bars, I cannot get
the 
> Percentile function in AB to return the same value as in Excel. How can 
> I achieve this?
> 
> 
> Here is what I am doing.
> // this is exploration for EOD forex data.
> 
> Factor = Iif(StrRight(Name(),3)=="JPY",100,10000);// converts price
to Pips
> 
> upBar = C > O; // bars closing up from the open
> HR = factor * (H - O);// fills array with the high range of all bars.
> 
> UBHR = Iif(upBar,HR,0);// fills array with High Range for Up Days, and 
> zero for all other days.
> UpTh = UP threshold = Param("Up Threshold",10,10,200,1);
> n = Param("N bars back", 100, 1, Barcount -1, 1);
> 
> Addcolumn( Percentile ( HR, 20, 80), "80th centile of HR", 3.2, 16,
47,60);
> 	// this matches my Excel value
> 
> Addcolumn( Percentile ( UBHR, 20, 80), "80th centile of UBHR", 3.2, 16, 
> 47, 60);
> 	// this does not match my Excel value
> 
> How can I get the Percentile array to look only at the Up bars' High
ranges?
> 
> I need to know what the High Range value is which contains 80% of High 
> Ranges on Up Bars only.
> 
> Any ideas?
> 
> ChrisB
>




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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

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/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> 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/