Support Board

Date/Time: Sun, 12 Jan 2025 04:17:49 +0000

Post From: Any help with spreadsheet logical functions?

[2017-01-26 17:58:12] Link To Thread - Link To Post [Go To First Post]
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 / V - Attached On 2017-01-26 17:56:58 UTC - Size: 14.29 KB - 255 views