Support Board
Date/Time: Tue, 16 Dec 2025 16:24:42 +0000
Post From: Lock a One Time Value in a spreadsheet
| [2015-08-06 18:01:10] |
| Sawtooth - Posts: 4299 |
|
If the value is in the array, you could use a double IF formula, or an INDEX...(MATCH...)) formula, to bring the value from the row it occurred up to row 3. Since there are so many possible scenarios, I would not be able to offer any specific examples. However, as I said in post#8, the value captured would be at the close of the bar, and the time of the occurrence would not be any more precise than the bar's timestamp.
|