Login Page - Create Account

Support Board


Date/Time: Mon, 16 Jul 2018 04:54:35 +0000



Number of Trades

Support Request:
[2018-01-02 22:46:48]
Crtfyd - Posts: 200
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]
Sierra Chart Engineering - Posts: 61794
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]
Crtfyd - Posts: 200
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]
Crtfyd - Posts: 200
I tried: =AND ( TIME[-1] < (L<L[-1]) < TIME[1] )

...but it doesn't work either
[2018-01-05 02:23:19]
Sierra Chart Engineering - Posts: 61794
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]
Crtfyd - Posts: 200
Is the last response by you supported yet?
Thx
[2018-01-10 17:21:21]
Sierra Chart Engineering - Posts: 61794
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]
tomgilb - Posts: 1873
This works:
=FLOOR(BARTIME,1/86400)=FLOOR(BARTIME[-1],1/86400)
[2018-01-25 17:19:31]
Crtfyd - Posts: 200
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]
tomgilb - Posts: 1873
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]
Sierra Chart Engineering - Posts: 61794
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

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

Login


Login Page - Create Account