Home >> Support Board

Support Board

Date/Time: Thu, 18 Apr 2024 13:53:48 +0000

How to Post a Message for Support

Desaparece la hoja de cálculo Half gap

View Count: 394

[2022-05-13 16:35:39] #1 [Go To First Post]
Hopeman - Posts: 156
Hello ! I have configured the spreadsheet to mark the session gap, the half gap and the open, the problem is that when I have half a session in the work graph the half gap disappears while the others continue to show the gap indicator. I have all the same spreadsheet settings, could you help me so that it doesn't disappear? I've already tried, I've rewritten the formula and I can't find a solution. thank you

[2022-05-13 17:26:20] #2 [Go To First Post]
John - SC Support - Posts: 30927
What is the value in your spreadsheet when it "disappears"? There is no reason for it to disappear unless the value is 0. What kind of chart is this being used with? Is it a TPO chart, as the TPO chart does not work well with most studies - you really need to have a bar chart and then overlay the information to the TPO chart. Refer to the information here: Time Price Opportunity (TPO) Profile Charts: Using Other Studies on a TPO Chart For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-05-13 18:27:18] #3 [Go To First Post]
Hopeman - Posts: 156
I have it configured with the spreadsheet study and with the spreadsheet the gap if it marks it well and it does not disappear (attached photo) the open also although I have it as text the problem is with the half gap (attached photo)


move to.png / V - Attached On 2022-05-13 18:26:36 UTC - Size: 31.73 KB - 93 views ¿?.png / V - Attached On 2022-05-13 18:26:50 UTC - Size: 54.05 KB - 92 views Where you going?.png / V - Attached On 2022-05-13 18:27:08 UTC - Size: 39.53 KB - 93 views

[2022-05-13 20:57:29] #4 [Go To First Post]
John - SC Support - Posts: 30927
Again, what is the value of row 3 for that particular calculation when it disappears? Is it Zero? That would explain why it is not showing. Then you need to figure out why it is calculating a zero value at that point. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2022-05-16 16:42:44] #5 [Go To First Post]
Hopeman - Posts: 156
I have these formulas that have always worked for me until recently (attached photos) Thanks


oPEN.png / V - Attached On 2022-05-16 16:42:25 UTC - Size: 35.27 KB - 87 views GAP.png / V - Attached On 2022-05-16 16:42:31 UTC - Size: 27.52 KB - 100 views Half Gap2.png / V - Attached On 2022-05-16 16:42:37 UTC - Size: 32.63 KB - 99 views

[2022-05-17 14:59:28] #7 [Go To First Post]
Hopeman - Posts: 156
Hello good afternoon I thought that yesterday I solved the problem and unfortunately when opening the program the error persists! I come to you to help me solve the problem! Thanks in advance


Half Gap fail .png / V - Attached On 2022-05-17 14:59:19 UTC - Size: 58.14 KB - 93 views Attachment Deleted.

[2022-05-17 16:01:43] #8 [Go To First Post]
John - SC Support - Posts: 30927
In general, you are using an IF statement and returning a 0 value when the IF is negative. If this is not what you want, then you need to figure out what formula you need. For the most reliable, advanced, and zero cost futures order routing, use 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: