Support Board
Date/Time: Wed, 15 Jan 2025 13:00:51 +0000
Spreadsheet Rounding to Tick Size
View Count: 1069
| [2017-08-13 09:25:19] |
| User787778 - Posts: 142 |
|
In a spreadsheet, how does one round, a calculated value, in the Bond(ZB), to a tick size of 1/32. Thanks in advance. |
| [2017-08-13 13:48:45] |
| Sawtooth - Posts: 4151 |
|
This is how I do it: 1) Round the ticksize to remove any floating point errors, e.g. in H21: =1/ROUND(1/J21,0) 2) Reference H21 using the MROUND function: =MROUND(calculatedvalue,$H$21) |
| [2017-08-13 17:46:54] |
| |
|
We will add this to the documentation.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-08-13 19:04:24] |
| User787778 - Posts: 142 |
|
Thank you Tom
|
To post a message in this thread, you need to log in with your Sierra Chart account: