Support Board
Date/Time: Sun, 11 May 2025 20:05:50 +0000
Decimals in the new spreadsheets
View Count: 1277
| [2014-11-07 13:30:20] |
| Outlander - Posts: 91 |
|
The decimals in the sheet is not right? The picture shows the CL. Regards Outlander
|
| Attachment Deleted. |
CL.png| [2014-11-08 00:49:19] |
| |
|
You can control this through the Spreadsheet >> Number Format setting. Here is the documentation: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetMenu.html#NumberFormat 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 Date Time Of Last Edit: 2015-01-01 18:55:43
|
| [2014-11-08 08:39:21] |
| Outlander - Posts: 91 |
|
That makes it only look ok, but it still uses all decimals for the calculations as you can see in the picture. Regards Outlander
|
| [2014-11-08 19:13:42] |
| Sawtooth - Posts: 4214 |
|
This is what I do to round the price to tick size: First, round the J21 Tick Size, with this in cell H21: =1/ROUND(1/J21,0) This will correct any floating point errors that may exist even if the value displayed appears to be precise. Then round the OHLC to the tick size, referencing the OHLC columns like this: =MROUND(E3,$H$21) Date Time Of Last Edit: 2014-11-08 23:21:15
|
| [2014-11-09 07:01:59] |
| Outlander - Posts: 91 |
|
Ok,thanks Tom, I pasted the formulas into the sheet. The formula for cell H21 worked but the =MROUND(E3,$H$21) gave me this error: #VALUE! Regards Outlander |
| [2014-11-09 15:14:48] |
| Sawtooth - Posts: 4214 |
|
It works for me in both New and Old versions. If H21 is empty, it will give that error. Verify that H21 has a value. |
| [2014-11-09 15:55:23] |
| Outlander - Posts: 91 |
|
Ok, I got it to work now, thank you very much. Regards Outlander
|
| [2014-11-09 22:23:44] |
| |
|
We have prepared documentation for this particular issue here: https://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#FloatingPointValues It is at the bottom of the page. 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: