Support Board
Date/Time: Tue, 26 Nov 2024 20:19:10 +0000
Post From: sort of a statete machine in a spreadsheet
| [2014-06-05 14:00:13] |
| Sawtooth - Posts: 4120 |
|
There are two ways to do this: 1) In a single non-repeating cell, e.g. H3 (not in the array): http://www.sawtoothtrade.com/example-9.html 2) In row 3 of a Formula Column, e.g. O3 (in the array): =IF(StartBuyModeCondition,TRUE,IF(EndBuyModeCondition,FALSE,O4)) The idea is to latch a persistent TRUE with the first IF and release it with the second IF. There are many variations of this and you may need to experiment with the idea. Date Time Of Last Edit: 2015-08-14 02:02:55
|