Login Page - Create Account

Support Board


Date/Time: Thu, 16 May 2024 00:07:14 +0000



[User Discussion] - Alert when crossing extension line

View Count: 1174

[2021-02-01 20:25:16]
Matt NL - Posts: 91
Hi all
Anyone know how to set alert query for crossing over a previous extension line?
So previously in the chart I use the "colour candle based on alert" and set the extension line until end of day.
Then if a candle crosses that extension line later in the day I'd like an alert.

But the extension line subgraph value is always 0.

Any help appreciated.

Thanks
Matt
[2022-09-09 14:09:59]
User192715 - Posts: 3
Any help on the above?.
[2022-09-09 16:30:51]
John - SC Support - Posts: 31666
As you noted, the extension line itself is not accessible. As such, you would need to access the last data point from which that extension line comes from. The easiest way to do this would be to use the Spreadsheet Study and use the MOSTRECENTNONZEROVALUE(Range) on the Color Bar Based on Alert Condition data. This way, you can "shift" the information to the current bar and then test against that.

Refer to the following for this spreadsheet function:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MOSTRECENTNONZEROVALUE_Function
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-08-01 10:20:51]
4LifeNeo - Posts: 36
Does SC plan on making these extensions accessible? I was going to implement the solution mentioned by John above, but, in my case, there seems to be a couple of issues when I was reading up on it.

First, I have a few charts with different timeframes and therefore, would need to have a few spreadsheets open. Besides clusters being an issue, I am not sure if it would affect the performance as well. Especially with a lot of studies per chart.

Second, since it's only accessing the most recent non-zero value, it wouldn't know when it reaches the next level of the extension, right? Let's use a 20-period high as an example. The chart could make a 20-period high and draw the extension (1). The Price then goes down a lot and comes back up and makes a new 20-period high (2), but this 20-period high is lower than the previous one (1). The MOSTRECENTNONZEROVALUE(Range) would only know about the extension at (2) then, right?

With that, if there's a way, it would be really great if SC could make the extensions accessible. It would be much appreciated.

Thanks.
[2023-08-01 14:25:32]
John - SC Support - Posts: 31666
For what you are wanting to do, you would be best served to create a custom study. Refer to the information starting here:
Advanced Custom Study Interface and Language (ACSIL)
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-08-25 19:39:26]
4LifeNeo - Posts: 36
Hi John,

I tried to read up on it, but I think it's too advanced for me. Especially when the extension line is derived from checking the conditions using a few other studies. Instead of trying to get someone else to code it (first I have to find a trustworthy person who knows how to code and second, as mentioned, it checks on a few studies to get that extension, therefore it could be quite complicated to incorporate the codes from those studies as well), I was wondering if SC could charge a small fee to take the time to update the extension to make it accessible by simply using "ID#.SG2". To be specific, I only need the Extension Lines (SG2) from the study "Color Bar Based On Alert Condition" - not for all the other studies.

This way, we know it's coming from a source we can trust, and it would be available for other SC users to use as well. It's a win-win.

Thanks.
[2023-08-25 20:28:24]
John - SC Support - Posts: 31666
Turning extension lines into subgraphs is much harder than it sounds. In addition, it is simply not something we have time to do at the moment.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-03-05 19:54:12]
moe1up - Posts: 20
@OP

Did you ever find a solution for this? I am in the same boat and would like to get this done. Thanks.

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

Login

Login Page - Create Account