Support Board

Date/Time: Tue, 26 Nov 2024 20:28:12 +0000

Post From: Spreadsheet formula randomly returns 0 - Why?

[2023-10-29 06:21:26] Link To Thread - Link To Post [Go To First Post]
User61168 - Posts: 403
Hello John / Tom, Here's another example of funky business with spreadsheet formula study that I am unable to decipher. Alert study ID6 draws point on high/low and two spreadsheet formula studies (ID30 and ID31) draws a continuous line at H[-1] or L[-1] of the signal bar until the next signal bar is generated. Why is it leaving a gap of 2 ticks at High and 1 tick at Low??? Please see attached image. Chart type for ES is price changes per bar = 300. ID30 formula.....=IF(ID6.SG1[-1]=1,H[-1],ID30.SG1[-1]) ID31 formula.....=IF(ID6.SG1[-1]=1,L[-1],ID31.SG1[-1]) Edit: The immediate bar next to the signal bar is accurate but second bar onward, it is creating a gap. sub graph style is dash. And alert study generates signal only at candle close Edit1: The gap is there on a M1 time chart also. Date Time Of Last Edit: 2023-10-29 06:45:17


Screenshot 2023-10-28 231109-spreadsheet formula.png / V - Attached On 2023-10-29 06:19:55 UTC - Size: 26.91 KB - 82 views