Support Board
Date/Time: Sat, 10 May 2025 09:50:45 +0000
Post From: Lock a One Time Value in a spreadsheet
| [2015-08-06 18:01:10] |
| Sawtooth - Posts: 4214 |
|
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.
|