Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 27 Sep 2024 03:55:31 +0000
Post From: Using Spreadsheet System for Trading Study
| [2019-04-05 00:05:40] |
| TechTrader - Posts: 116 |
|
User 94606 No, because the spreadsheet rows step down with the start of every new bar. So the formulas are only true if row 4 is not true and row 3 is true. The formula prints 1(true). The next bar causes row 4 to be true but row 3 is not true in relation to row 4 so the formula prints 0(not true). The rows will continue to print 0 until the true condition occurs again. ie row 4 not true, row 3 true. SC has extensive documentation on spreadsheets and lists many formula examples. |