Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 14:45:48 +0000



Color Bar alerts

View Count: 390

[2023-07-18 14:46:56]
User397996 - Posts: 18
Hi. Is there any chance we can refer to a specific candle in time, for example, price is higher than the 9.30 candle
I'd use something like H>H[TIME(9,30,0)] or H>ID0.SG2[TIME(9,30,0]) but it doesn't work.
Do I need to use some study like High/Low for Time Period and contineu from there?
[2023-07-18 17:03:59]
John - SC Support - Posts: 36315
It would be easiest to use the "Spreadsheet System/Alert" study, where you can then reference a particular bar by the time. Refer to the following:
Spreadsheet Systems, Alerts and Automated Trading

And also refer to the following, along with the other time-related functions on this page:
Spreadsheet Functions: Serial DateTime Values

--

If you want to use the functionality from the "Color Bar Based on Alert Condition" study, then create a True/False result for the Spreadsheet System/Alert and then use that in the Color Bar Based on Alert condition.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-07-19 01:11:58]
Sawtooth - Posts: 4120
Is there any chance we can refer to a specific candle in time, for example, price is higher than the 9.30 candle
You could do it by creating a persistent value of the 9:30 candle High, using the Spreadsheet Formula study, with a formula like this:
=IF(BARTIME=TIME(9,30,0),H,ID1.SG1[-1])
where ID1 is the Spreadsheet Formula study.

Then reference the Spreadsheet Formula study in a Color Bar Based On Alert Condition study formula, like this:
=H>ID1.SG1
[2023-08-01 00:39:14]
User397996 - Posts: 18
I appreciate your help.
Another question please:
Can you explain or confirm why the MIN() function doesn't work on color bar study.
If I try H>MAX(H[-1:-12]) it works but L<MIN(L[-1:-12]) does not.
Thanks once again in advance
[2023-08-01 01:02:29]
Sawtooth - Posts: 4120
It works for me.

It returns 1 when TRUE and 0 when FALSE.
[2023-08-24 14:59:52]
User397996 - Posts: 18
I appreciate your help, clearly my mistake.
I'd like your help on another issue:
in order to keep the current conditions for market data, every time (monthly) I switch on Data/Trade Services from Rithmic to CQG for a few minutes and then back to Rithmic, several settings like Session Start Time, Use Evening Session, Symbol Settings (on Global Settings) go back to Default and mess up my chart and studies. Is there any way it can not do this?

Thanks
[2023-08-24 16:04:36]
John - SC Support - Posts: 36315
When you make the change from Rithmic to CQG, do not change the symbols (and vice versa). You are prompted when you make the change to change symbols, but since you are only connecting in order to verify your "Non-Professional" standing for the CME Group, you do not need to change symbols.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing

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

Login

Login Page - Create Account