Support Board

Date/Time: Sun, 12 May 2024 23:27:18 +0000

Post From: Lock a One Time Value in a spreadsheet

[2015-08-06 18:01:10] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3995
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.