Support Board
Date/Time: Tue, 26 Nov 2024 11:35:13 +0000
[User Discussion] - Calculating time between tick bars
View Count: 1325
[2014-05-01 08:30:33] |
djcurcio - Posts: 236 |
I want to calculate the elapsed time between tick bars on a spreadsheet. Simply subtracting the time of ro3 and row 4 does not seem to give accurate results. How can I correctly calculate the elapsed time of tick bars? Thanks |
[2014-05-04 19:59:58] |
djcurcio - Posts: 236 |
no response from sierra?
|
[2014-05-04 21:15:06] |
Sawtooth - Posts: 4120 |
Since the bar timestamp is at the bar open, subtracting A3 from A4 will give you the time difference between the open of the current bar and the open of the previous bar. If you want the difference between the current chart time and the open of the current bar, subtract A3 from J41.
Date Time Of Last Edit: 2014-05-04 21:29:51
|
[2014-05-04 22:53:52] |
djcurcio - Posts: 236 |
Thanks for the response.
|
To post a message in this thread, you need to log in with your Sierra Chart account: