Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Sun, 06 Jul 2025 18:37:45 +0000

Size bars

View Count: 840

[Page 1 of 1] First Page -- 1 -- Last Page

[2019-03-22 08:53:54] #1 [Go To First Post]
2garin - Posts: 188
Good day. On the Japanese yen chart added a table. In the table I created an alert (B +) highlighting bars of 1 tick size. About Removing Floating Point Imprecision read. Question: why does the alert not work on all bars? (where is the mistake?)
0x Thank you
11.jpg / V - Attached On 2019-03-22 08:51:51 UTC - Size: 221.46 KB - 302 views 12.jpg / V - Attached On 2019-03-22 08:51:59 UTC - Size: 230.33 KB - 333 views 13.jpg / V - Attached On 2019-03-22 08:52:09 UTC - Size: 247.11 KB - 297 views

[2019-03-22 21:00:35] #2 [Go To First Post]
John - SC Support - Posts: 40745
You need to change how you are handling the final check of the values. How to do this is described here: Using the Spreadsheet Study: Imprecision of Floating-Point Numbers and Comparisons For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing
0x Thank you

[2019-03-23 09:06:49] #3 [Go To First Post]
2garin - Posts: 188
The format in the table is set to maximum. Problem still exists. How to select all the bars with a size of 1 tick? Date Time Of Last Edit: 2019-03-23 09:08:17
0x Thank you
14.jpg / V - Attached On 2019-03-23 09:03:36 UTC - Size: 298.87 KB - 293 views

[2019-03-23 09:56:07] #4 [Go To First Post]
2garin - Posts: 188
?
0x Thank you
21.jpg / V - Attached On 2019-03-23 09:55:26 UTC - Size: 210.01 KB - 329 views 22.jpg / V - Attached On 2019-03-23 09:55:44 UTC - Size: 213.64 KB - 295 views 23.jpg / V - Attached On 2019-03-23 09:55:55 UTC - Size: 222.59 KB - 291 views

[2019-03-25 13:22:01] #5 [Go To First Post]
John - SC Support - Posts: 40745
You need to change the formula that currently reads MROUND(C14, $H$21) - MROUND(D14, $H$21) = 0.00000050 to state something like the following (you will need to determine the appropriate value to be used): ABS(C14 - D14) < 0.0000001 Needing to do this is described in the documentation here: Using the Spreadsheet Study: Imprecision of Floating-Point Numbers and Comparisons For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing
0x Thank you

[2019-03-28 22:34:09] #6 [Go To First Post]
2garin - Posts: 188
The option you offer does not work. May be useful to other users: The task to select the bars (screen) with a height of 1 tick was decided by the expression: =AND (MROUND (C3, $H$21)- MROUND (D3, $H$21)>0.0000004, MROUND (C3, $H$21)- MROUND (D3, $H$21)<0.0000006) The expression helps to select a bar with a height of 2 ticks: =MROUND (C3, $H$21)- MROUND (D3, $H$21)=0.000001 The expression is written to the Japanese Yen futures.
0x Thank you
44.jpg / V - Attached On 2019-03-28 22:33:50 UTC - Size: 29.01 KB - 247 views

[Page 1 of 1] First Page -- 1 -- Last Page