Login Page - Create Account

Support Board

Date/Time: Sun, 01 Oct 2023 23:09:49 +0000

Rounding a calculation to tick level

View Count: 2087

[2013-06-24 16:41:00]
RPinCAR - Posts: 27
Is there a function that will allow me to round a calculation in a spreadsheet to the nearest tick value. For example, instead of 1557.40, I would get 1557.50 in the ES.
[2013-06-24 17:22:12]
Sawtooth - Posts: 3778
Use MROUND function.

[2013-06-24 17:25:46]
RPinCAR - Posts: 27
Thank you sir, perfect as: =MROUND((Sheet1!BE3+Sheet1!BF3)/2,0.25)

To post a message in this thread, you need to log in with your Sierra Chart account:


Login Page - Create Account