Support Board
Date/Time: Mon, 13 Jan 2025 07:42:44 +0000
Wrong tick size in spreadsheet study
View Count: 1321
| [2017-04-13 13:43:14] |
| User379080 - Posts: 4 |
|
Hi, Tick size is set to 0.01 under chart settings, yet the spreadsheet study shows 0.0099999998 as tick size. The cell is read-only so I can't change it. Instrument is Bund futures. So how do I adjust the tick size? Regards |
| [2017-04-13 16:43:35] |
| |
|
That is still the correct value. That is equivalent to .01. Refer to: http://www.sierrachart.com/index.php?page=doc/UsingTheSpreadsheetStudy.php#ImprecisionOfFloatingPointNumbers 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-04-13 22:01:54] |
| Sawtooth - Posts: 4149 |
|
If you are referencing J21 in formulas but want to remove the floating point imprecision, put this in cell H21: =1/ROUND(1/J21,0) then reverence H21 instead. |
To post a message in this thread, you need to log in with your Sierra Chart account: