Support Board

Date/Time: Mon, 13 May 2024 12:02:28 +0000

Post From: Lock a One Time Value in a spreadsheet

[2014-02-08 15:23:19] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3995
I don't know of any way in a Sierra Chart spreadsheet study to capture the value of a dynamic cell, like the chart time in J41, at the occurrence of another dynamic event that is not in the array. The historical time of any event is solely in column A, so the dynamic event must somehow be recorded in the array. Even so, if the bar duration is lengthy, the time of the event cannot be more precise than the bar's timestamp.