Home >> Support Board

Support Board

Date/Time: Sun, 05 May 2024 09:14:25 +0000

How to Post a Message for Support

Decimals in the new spreadsheets

View Count: 1150

[2014-11-07 13:30:20] #1 [Go To First Post]
Outlander - Posts: 91
The decimals in the sheet is not right? The picture shows the CL. Regards Outlander


CL.png / V - Attached On 2014-11-07 13:27:55 UTC - Size: 13.18 KB - 337 views Attachment Deleted.

[2014-11-08 00:49:19] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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] #3 [Go To First Post]
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


GC.png / V - Attached On 2014-11-08 08:36:45 UTC - Size: 65.48 KB - 365 views

[2014-11-08 19:13:42] #4 [Go To First Post]
Sawtooth - Posts: 3993
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] #5 [Go To First Post]
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] #6 [Go To First Post]
Sawtooth - Posts: 3993
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] #7 [Go To First Post]
Outlander - Posts: 91
Ok, I got it to work now, thank you very much. Regards Outlander

[2014-11-09 22:23:44] #8 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
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: