Support Board
Date/Time: Sat, 11 Jan 2025 14:39:13 +0000
spreadsheet for trading - blanks cell taken as 0 (Zero)
View Count: 706
| [2016-11-30 22:26:15] |
| User553714 - Posts: 184 |
|
Can you check on how blank cells are treated in the spreadsheet for trading study as last night I had a number of orders trigger incorrectly when a simple IF statement compared a blank cell to the value 0 (zero); as a result the IF statement turned true and triggered orders to be sent to my broker. This has also happened before to me where blank cells seem to be treated as value 0 and turn IF statement into being true. I don't think this should be the intended behaviour? I have used work arounds too date but a fix would be good.
|
| [2016-12-01 00:29:00] |
| |
|
Yes a blank cell is going to be considered 0 and will always be that way. This will not change and would have a serious consequence if it is. You can use this function to determine if it is actually blank: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#ISBLANK_Function Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2016-12-01 00:29:26
|
To post a message in this thread, you need to log in with your Sierra Chart account: