Rounding up to the nearest tick

Hello-

I'm trying to figure our a way to roundup to the nearest tick (MinMove / PriceScale):

For example, if using the following example in ES:

round(average ((x - y),100)*z,2) = 1025.12

I would like this figure to round up to the next .25 increment, in this instance, 1025.25. I'm not sure how to do this in Multicharts.

Thank you for your help in advance.

masber2000,

there are multiple ways to accomplish what you have in mind. It depends a bit on what you want to do in case your value is already ending at the nearest tick i.e. would 1025.25 still be rounded up to 1025.50.

One way to always round up would be:
1. Dividing the value by one tick and adding one to the integer portion of the result
2. Multiplying the result of 1. by one tick again.

If you do not want to round values like 1025.50 (and you are only dealing with positive values) you could use "Ceiling" instead of "IntPortion" in 1. and not add one.

Regards,

ABC

Mathematics is Magical!

Thank you kindly for the solution ABC.