Login Page - Create Account

Support Board


Date/Time: Wed, 24 Apr 2024 23:52:41 +0000



[User Discussion] - Calculating time between tick bars

View Count: 1223

[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: 3976
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:

Login

Login Page - Create Account