Support Board

Date/Time: Fri, 19 Apr 2024 23:20:06 +0000

Post From: spreadsheet syntax error

[2019-03-13 00:26:49] Link To Thread - Link To Post [Go To First Post]
Chad - Posts: 231
Need a nudge here to get going...in the default Spreadsheet System for Trading Study, I'm placing a conditional in cell J106 that I want to return '1' (True) if the range of the prior candle/bar's High price, minus the prior Low price, is less than or equal to 4TICKSIZE (where TICKSIZE is listed by-default in cell J21); else '0' (False). This is what I've input, but it throws a syntax error, whether as-shown or adding spaces between the math operators: =IF((ID0.SG2[-1]-ID0.SG3[-1])<=(J214),1,0) I also tried this, to same result: =IF((ID0.SG2[-1]-ID0.SG3[-1])<=(TICKSIZE4),1,0) Any suggestion? Date Time Of Last Edit: 2019-03-13 00:28:30*