Login Page - Create Account

Support Board

Date/Time: Thu, 18 Jul 2024 09:09:11 +0000

Rounding a calculation to tick level

View Count: 2272

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