RE: [amibroker] rounding

["David Smith" <david.smith5@xxxxxxxxxxxxxxx>]

As per Graham’s note, rounding to 1 cent is something like

 

Floor(Price*100)/100.

 

Rounding to 0.5 cent is Floor(Price*200)/200

 

Rounding to 0.1 cent is floor(Price*1000)/1000.

 

Try a few of these in excel to see how it works & get the rounding you want.  Round, ceil & floor all do similar functions except ceil rounds up & floor rounds down.

 

Cheer, Dave

 

-----Original Message-----
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of holygrail168
Sent: Sunday, 28 October 2007 6:27 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] rounding

 

Hi,

my buyprice functions are calculating values which go something like

7.395678

since these are in dollars, I want it to round to 3 significant figures
so i get a value like 7.40

however, the AFL language only has round, ceil, floor which only
performs rounding to the nearest integer.

so how do u guys do it then? it seems like a pretty basic function and
i'm sure amibroker should have it but i've trawled thru the formula
reference and can't find anything,

thanks

__._,_.___

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

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___