Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 15:42:44 +0000

How to Post a Message for Support

Size bars

View Count: 730

[2019-03-22 08:53:54] #1 [Go To First Post]
2garin - Posts: 184
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?)


11.jpg / V - Attached On 2019-03-22 08:51:51 UTC - Size: 221.46 KB - 265 views 12.jpg / V - Attached On 2019-03-22 08:51:59 UTC - Size: 230.33 KB - 295 views 13.jpg / V - Attached On 2019-03-22 08:52:09 UTC - Size: 247.11 KB - 257 views

[2019-03-22 21:00:35] #2 [Go To First Post]
John - SC Support - Posts: 31146
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

[2019-03-23 09:06:49] #3 [Go To First Post]
2garin - Posts: 184
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


14.jpg / V - Attached On 2019-03-23 09:03:36 UTC - Size: 298.87 KB - 255 views

[2019-03-23 09:56:07] #4 [Go To First Post]
2garin - Posts: 184
?


21.jpg / V - Attached On 2019-03-23 09:55:26 UTC - Size: 210.01 KB - 291 views 22.jpg / V - Attached On 2019-03-23 09:55:44 UTC - Size: 213.64 KB - 255 views 23.jpg / V - Attached On 2019-03-23 09:55:55 UTC - Size: 222.59 KB - 252 views

[2019-03-25 13:22:01] #5 [Go To First Post]
John - SC Support - Posts: 31146
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

[2019-03-28 22:34:09] #6 [Go To First Post]
2garin - Posts: 184
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.


44.jpg / V - Attached On 2019-03-28 22:33:50 UTC - Size: 29.01 KB - 209 views

To post a message in this thread, you need to log in with your Sierra Chart account: