Support Board
Date/Time: Wed, 14 May 2025 06:31:17 +0000
Post From: Any help with spreadsheet logical functions?
| [2017-01-26 17:58:12] |
| JRA - Posts: 97 |
|
I am Defining the start of a new trend when there is a close above the Prior Bollinger Band on Column K With IF (blabla,1,0). On the second Column L I define the start of a downtrend when there is a close below the lower Bollinger band with IF (blabla, 1,0). So Column K will be full of Zeros and at some point it will print 1,then Zero again. The same with Column L. What I want to define in another column is when the K column printed the first 1 to track the L Column until it prints 1. Any Ideas how can I define this with Logical functions. I am giving a screenshot for reference. Thank you in Advance |
Sprd.png