Support Board

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

Date/Time: Thu, 30 Jan 2025 19:04:47 +0000

Size bars

View Count: 785

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

[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?)
0x Thank you
11.jpg / V - Attached On 2019-03-22 08:51:51 UTC - Size: 221.46 KB - 284 views 12.jpg / V - Attached On 2019-03-22 08:51:59 UTC - Size: 230.33 KB - 315 views 13.jpg / V - Attached On 2019-03-22 08:52:09 UTC - Size: 247.11 KB - 279 views

[2019-03-22 21:00:35] #2 [Go To First Post]
John - SC Support - Posts: 37613
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: 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
0x Thank you
14.jpg / V - Attached On 2019-03-23 09:03:36 UTC - Size: 298.87 KB - 277 views

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

[2019-03-25 13:22:01] #5 [Go To First Post]
John - SC Support - Posts: 37613
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: 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.
0x Thank you
44.jpg / V - Attached On 2019-03-28 22:33:50 UTC - Size: 29.01 KB - 230 views

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