Thanks Tomasz, the Ceil function worked perfect! Best, Steve
--- In [email protected], "Tomasz Janeczko" <[EMAIL PROTECTED]> wrote: > > Hello, > > Just for the reference, as far as integers are considered: > there is nicer method (single function call) to round UP to nearest integer: > > ceil( number ) http://www.amibroker.com/f?ceil > > and round DOWN to nearest integer: > > floor( number ) http://www.amibroker.com/f?floor > > Best regards, > Tomasz Janeczko > amibroker.com > ----- Original Message ----- > From: "gp_sydney" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Saturday, July 21, 2007 9:57 AM > Subject: [amibroker] Re: Rounding up the BuyPrice to the nearest 0.25 point > > > > Where you're rounding up to the nearest integer: > > > > roundedNo = Int(number) + (FRAC(number) != 0); > > > > Int always rounds down (ie. truncates) so the last conditional will > > add one if there's any fractional component (if you always just add > > one then a round integer will always be incremented by one as well). > > > > If you want rounding to some other decimal place, then you can do the > > multiply first divide later thing as Dingo mentioned below. Or if you > > want to do it Tomasz's way, then: > > > > frp = number % 0.25; > > roundedNo = number - frp + (frp != 0)*0.25; > > > > In this, frp is the same as the FRAC part above for integers, and > > "number - frp" is the same as the Int part for integers. Since a > > conditional test gives one if true, and we only want to add 0.25, this > > can be achieved by multiplying the conditional result by 0.25 (haven't > > tried this, but it should work). > > > > GP > > > > > > --- In [email protected], "sslack88" <jzzpiano88@> wrote: > >> > >> Is there a way to always force Amibroker to round Up? It seems the > >> round function will round down to the integer 1265.20 would round > >> down to 1265. I want it to round up to 1266. > >> > >> Is this possible? > >> > >> -Steve > >> > >> --- In [email protected], "dingo" <dingo@> wrote: > >> > > >> > You write the AFL: > >> > > >> > Multiply your number by 4. > >> > > >> > Round it to an integer > >> > > >> > Divide it by 4 to a decimal. > >> > > >> > d > >> > > >> > > -----Original Message----- > >> > > From: [email protected] > >> > > [mailto:[EMAIL PROTECTED] On Behalf Of dingo > >> > > Sent: Friday, July 20, 2007 12:00 PM > >> > > To: [email protected] > >> > > Subject: RE: [amibroker] Rounding up the BuyPrice to the > >> > > nearest 0.25 point > >> > > > >> > > Oops = that was less than helpful.. I didn't see the .25... > >> > > I'll look into > >> > > my math magic resources.. > >> > > > >> > > d > >> > > > >> > > > -----Original Message----- > >> > > > From: [email protected] > >> > > > [mailto:[EMAIL PROTECTED] On Behalf Of dingo > >> > > > Sent: Friday, July 20, 2007 11:56 AM > >> > > > To: [email protected] > >> > > > Subject: RE: [amibroker] Rounding up the BuyPrice to the > >> > > > nearest 0.25 point > >> > > > > >> > > > Multiply by 100 and use the round function then divide by 100. > >> > > > > >> > > > d > >> > > > > >> > > > > -----Original Message----- > >> > > > > From: [email protected] > >> > > > > [mailto:[EMAIL PROTECTED] On Behalf Of sslack88 > >> > > > > Sent: Friday, July 20, 2007 10:05 AM > >> > > > > To: [email protected] > >> > > > > Subject: [amibroker] Rounding up the BuyPrice to the nearest > >> > > > > 0.25 point > >> > > > > > >> > > > > How do you round your BuyPrice up to the nearest 0.25 point? > >> For > >> > > > > example: > >> > > > > > >> > > > > I want to buy (intraday) when the price breaks the (Open+Some > >> > > > > Value) so > >> > > > > my formula states to buy when the price is 1280.53 or higher. > >> > > > > However, > >> > > > > I am trading the ES so I can only buy at 1280.75. > >> > > > > > >> > > > > How do I set the BuyPrice to 1280.75? Right now the BuyPrice > >> > > > > is being > >> > > > > set to the (Open+Some Value) price (1280.53) which is not > >> > > > possible in > >> > > > > real trading. > >> > > > > > >> > > > > Thanks, > >> > > > > Steve > >> > > > > > >> > > > > > >> > > > > > >> > > > > 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 > >> > > > > > >> > > > > > >> > > > > > >> > > > > > >> > > > > >> > > > > >> > > > > >> > > > 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 > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > >> > > > >> > > > >> > > 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 > >> > > > >> > > > >> > > > >> > > > >> > > >> > > > > > > > > > > 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 > > > > > > > > > > >
