Login Page - Create Account

Support Board

Date/Time: Tue, 30 May 2023 05:36:50 +0000

Rounding a calculation to tick level

View Count: 1995

[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]
tomgilb - Posts: 3629
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