Support Board
Date/Time: Sun, 22 Dec 2024 11:39:55 +0000
Post From: Lock a One Time Value in a spreadsheet
| [2015-08-06 18:01:10] |
| Sawtooth - Posts: 4141 |
|
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.
|