Login Page - Create Account

Support Board


Date/Time: Wed, 29 Jun 2022 01:14:07 +0000



Desaparece la hoja de cálculo Half gap

View Count: 101

[2022-05-13 16:35:39]
Hopeman - Posts: 46
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]
John - SC Support - Posts: 17012
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:
https://www.sierrachart.com/index.php?page=doc/StudiesReference/TimePriceOpportunityCharts.html#UsingOtherStudies
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]
Hopeman - Posts: 46
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)
imagemove to.png / V - Attached On 2022-05-13 18:26:36 UTC - Size: 31.73 KB - 14 views
image¿?.png / V - Attached On 2022-05-13 18:26:50 UTC - Size: 54.05 KB - 16 views
imageWhere you going?.png / V - Attached On 2022-05-13 18:27:08 UTC - Size: 39.53 KB - 15 views
[2022-05-13 20:57:29]
John - SC Support - Posts: 17012
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]
Hopeman - Posts: 46
I have these formulas that have always worked for me until recently (attached photos)

Thanks
imageoPEN.png / V - Attached On 2022-05-16 16:42:25 UTC - Size: 35.27 KB - 15 views
imageGAP.png / V - Attached On 2022-05-16 16:42:31 UTC - Size: 27.52 KB - 21 views
imageHalf Gap2.png / V - Attached On 2022-05-16 16:42:37 UTC - Size: 32.63 KB - 18 views
[2022-05-17 14:59:28]
Hopeman - Posts: 46
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
imageHalf Gap fail .png / V - Attached On 2022-05-17 14:59:19 UTC - Size: 58.14 KB - 14 views
Attachment Deleted.
[2022-05-17 16:01:43]
John - SC Support - Posts: 17012
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:

Login

Login Page - Create Account