Support Board

Date/Time: Tue, 23 Oct 2018 08:45:49 +0000

Support Request:
 [2018-01-02 22:46:48] #1 Crtfyd - Posts: 208 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 Sierra Chart Engineering - Posts: 65120 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. If possible please keep your questions brief and to the point. Please be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
 [2018-01-04 20:50:44] #3 Crtfyd - Posts: 208 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 Crtfyd - Posts: 208 I tried: =AND ( TIME[-1] < (L
 [2018-01-05 02:23:19] #5 Sierra Chart Engineering - Posts: 65120 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. If possible please keep your questions brief and to the point. Please be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
 [2018-01-10 16:14:03] #6 Crtfyd - Posts: 208 Is the last response by you supported yet? Thx
 [2018-01-10 17:21:21] #7 Sierra Chart Engineering - Posts: 65120 No not yet. Probably not for another week. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
 [2018-01-10 17:34:09] #8 tomgilb - Posts: 1975 This works: =FLOOR(BARTIME,1/86400)=FLOOR(BARTIME[-1],1/86400)
 [2018-01-25 17:19:31] #9 Crtfyd - Posts: 208 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 tomgilb - Posts: 1975 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 Sierra Chart Engineering - Posts: 65120 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. If possible please keep your questions brief and to the point. Please be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you. Date Time Of Last Edit: 2018-01-25 18:11:51