http://forums.worden.com/default.aspx?g=posts&t=23816

I have searched through the info on the above thread link but could not find a rounding function or operand. I also did a search on round / rounding but didn't come up with anything.

Is there one available that I am missing? 

Thanks

A little more information on what I am trying to do.

I would like to find stocks that are trading within a few cents +/- or the whole dollar or half dollar price.

Example:  price at 101.02 or 100.96 or  52.53 or 51.45

Using the round function I could find the whole dollar figure then subtract the price from the rounded number and determine if the remainder was within the paramerter/s wanted.

Thanks

The Personal Criteria Formula Language does not have a built in rounding function. I think you can use a combination of division, integer division and multiplication to do what you want however. For example, the following should only return true when price is within five cents of a fifty cent boundary.

ABS((C - (C / .5) \ 1 * .5)) < .055

Hello Bruce,

Thanks for the reply.

I will see how it plays.

You're welcome.