Login Page - Create Account

Support Board

Date/Time: Wed, 24 Jul 2024 01:09:36 +0000

Rounding a calculation to tick level

View Count: 2275

[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: 4050
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