Home >> Support Board

Support Board

Date/Time: Sat, 27 Apr 2024 15:29:48 +0000

How to Post a Message for Support

Number of Trades

View Count: 1442

[2018-01-02 22:46:48] #1 [Go To First Post]
Crtfyd - Posts: 277
I am using a Number of Trades Chart set to 100 For a Simple Alert, how would I reference the bars within one second? In other words, There are two bars for 9:34:07 (9:34:07.006 & 9:34:07.019). If I wanted a simple alert to alert me when 2 bars are within the 9:34:07 time frame, what Simple alert would I use since its dealing with a fraction of a second? Thanks

[2018-01-03 04:44:34] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We need to spend some time to look into this. Probably we should create some Spreadsheet comparison functions to compare to the nearest millisecond, second, minute and hour. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2018-01-04 20:50:44] #3 [Go To First Post]
Crtfyd - Posts: 277
I'm thinking something like: BARTIME[-1] < (L < L[-1]) < BARTIME[1] to represent 2 bars with the same "seconds" time (ie:2 bars 9:45:06.004 & 9:45:06.102 ) where the Low of the .004 bar is lower than the .102 bar. But I don't know how to address the BARTIME

[2018-01-04 21:22:58] #4 [Go To First Post]
Crtfyd - Posts: 277
I tried: =AND ( TIME[-1] < (L<L[-1]) < TIME[1] ) ...but it doesn't work either

[2018-01-05 02:23:19] #5 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
This is what you will need to use but it is not yet supported: =ISSAMETIMETOSECOND(BARTIME[-1]), (BARTIME[0]) Allow a few days for this. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2018-01-10 16:14:03] #6 [Go To First Post]
Crtfyd - Posts: 277
Is the last response by you supported yet? Thx

[2018-01-10 17:21:21] #7 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
No not yet. Probably not for another week. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2018-01-10 17:34:09] #8 [Go To First Post]
Sawtooth - Posts: 3978
This works: =FLOOR(BARTIME,1/86400)=FLOOR(BARTIME[-1],1/86400)

[2018-01-25 17:19:31] #9 [Go To First Post]
Crtfyd - Posts: 277
What does "FLOOR" mean? Thx, but that doesn't seem to do it. I think bc its referencing time, because some bars take longer to develop. For instance, with your suggestion, I get an alert when there is only one bar for the second, but it took a long time to get to the 100 trades, therefore triggering your over 86,400 (milliseconds?) It worked on some, but gave false alerts. I would image somehow need to reference over 100 trades within one second.

[2018-01-25 17:47:31] #10 [Go To First Post]
Sawtooth - Posts: 3978
The FLOOR function rounds down to a multiple, in this case, a multiple of one second. One second in Serial Date Time format is equal to 1/86400 because there are 86400 seconds in 24 hours. So this formula would strip any millisecond increments from the current and previous bar's time stamps, and alert when they were both the same time to the second. Set the alert to occur at bar close. Date Time Of Last Edit: 2018-01-25 17:48:56

[2018-01-25 18:11:34] #11 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Here are the new ISSAMETIMETO* functions: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#ISSAMETIMETOHOUR_Function Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2018-01-25 18:11:51

To post a message in this thread, you need to log in with your Sierra Chart account: