Login Page - Create Account

Support Board


Date/Time: Sun, 29 Dec 2024 15:59:00 +0000



Confusion over found stocks on Chart Alert

View Count: 1014

[2016-04-13 20:24:42]
CarlRostron - Posts: 80
I am confused about what is being returned TRUE for the Stock scanning Alert formula I have:

=OR(C<=(C[-1]*0.98),C<=(C[-2]*0.98))

I want the list of stocks (in Associated Watchlist) to download the latest prices (I do this towards the end of the day), and get a list of stocks where the "last" price (on download ie TODAYS Last price) is 2% lower than previous day close or 2% lower than previous-previous day close.

When the scan run and it detects where the condition is true, for some reason, it selects stocks where it is true but not for the latest price. do i need to have something selected so that it only runs the condition for the last bar?

"Subscribe RT data & Download historical data during Scan" is selected in settings.
imageError.png / V - Attached On 2016-04-13 20:20:51 UTC - Size: 200.83 KB - 260 views
[2016-04-14 05:05:49]
Sierra Chart Engineering - Posts: 104368
For a particular symbol where you do not get the expected result, is the chart up-to-date to the current date?

The evaluation of the Alert Formula is always on the last bar. Although if a data download has to be done for the chart, and the new bar has not yet been added for the current date, the evaluation may be done on what was the last bar in the chart before the download finishes.

Although we would have to check on 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
Date Time Of Last Edit: 2016-04-14 05:06:02
[2016-04-14 05:14:39]
CarlRostron - Posts: 80
No, I was under the impression that with

"Subscribe RT data & Download historical data during Scan" is selected in settings.

Turned on, the data would download before doing the check?

Nonetheless, even after the data was downloaded (as I tried this a few times), I still got the unexpected results. The screenshot showed this.

I also tried the
Download Data For All Historical Charts

Before running scan but that didn't return expected results either.
[2016-04-14 05:22:38]
Sierra Chart Engineering - Posts: 104368
We do not provide alert formula troubleshooting help. The particular alert formula is not important to us.

It appears as though the scanning and data downloading is not relevant to the problem. Unless we are misunderstanding this.

If you do not get the expected result from the formula, based on the data you currently see in the chart, then you will have to determine the cause of that.
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: 2016-04-14 05:23:46
[2016-04-14 05:24:05]
Sierra Chart Engineering - Posts: 104368
After the scan is done and you look at a particular symbol, is it up-to-date to the current date?

If not, that would be the only thing that would be of concern to us.
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
[2016-04-14 06:02:00]
CarlRostron - Posts: 80
After the scan is done and you look at a particular symbol, is it up-to-date to the current date?

Yes it is up to date

But, even
C<=(C[-1]*0.98)
returns true for the attcahed chart.

Alert - Chart: AA [M] Daily #2 | Formula: =C<=(C[-1]*0.98) is TRUE. | Last Price: 9.48 | Bar Start Time: 2016-04-12 00:00:00 | Alert: AlertSound (1)

I fail to see how this isn't a bug at the moment if the Alert is based on the last price in the chart.

I am happy to address any mis-logic in my alert but I am struggling to see that right now and the logic should be trivial.

The evaluation of the Alert Formula is always on the last bar.
In the Alerts Window when I double click the record to take me to the chart it takes me to the time period when the condition is true so doenst appear to work from the "last" bar in th chart
imageError detail.png / V - Attached On 2016-04-14 05:57:08 UTC - Size: 197.59 KB - 282 views
imageError detail 2.png / V - Attached On 2016-04-14 06:01:55 UTC - Size: 188.73 KB - 288 views
[2016-04-14 06:07:00]
CarlRostron - Posts: 80
Just tested this:

C<=C[-1]

and this does the same. It is not working off the latest bar i have downloaded so returns true unexpectedly.
[2016-04-14 06:16:33]
CarlRostron - Posts: 80
Also
C<O


is only true for the data for the penultimate bar, not the last bar in the chart as I would have expected.
[2016-04-14 08:08:22]
Sierra Chart Engineering - Posts: 104368
We do not think there is a problem here. And also apparently you did not take note of all of the information in post #2. Maybe when you read that post all of the information was not there.

We need some time to prepare documentation to explain how all of this works. There is one potential problem that we do need to address but it does not appear to be relevant in this particular case.

This is what we want you to do:

-Restart Sierra Chart.
-Run the scan for all your symbols on a Historical Daily chart.
-Select Window >> Alerts Manager >> Alerts Log >> Clear Log.
-Run the scan again.

At this point in time, the scan will only be on the most recent bar since no download will have occurred during the second scan.

When a download occurs, there will be two evaluations: On what is the last bar in the chart before the download, and the new last bar after the download.
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: 2016-04-14 08:30:38
[2016-04-14 19:27:32]
CarlRostron - Posts: 80
For post 2 you mention i did read this and take into acount:
Although if a data download has to be done for the chart, and the new bar has not yet been added for the current date, the evaluation may be done on what was the last bar in the chart before the download finishes.
I made sure all the data had been downloaded in the first place before running the Scan I had checked this.

This is what we want you to do:

-Restart Sierra Chart.
-Run the scan for all your symbols on a Historical Daily chart.
-Select Window >> Alerts Manager >> Alerts Log >> Clear Log.
-Run the scan again
I have now done this and appears to be working. I will however monitor this as last night's Scan I can assure you was not functioning as I would have expected and I did run the scan a few times and checked all the data had been downloaded already.

Just for reference the Alert Logic hasn't been changed so I know this is fine now also.

We need some time to prepare documentation to explain how all of this works.
This of course will help.

Thanks for your time and support it is appreciated. I will reopen this same thread if the problem comes back.
[2016-04-14 19:39:06]
Sierra Chart Engineering - Posts: 104368
I can assure you was not functioning as I would have expected and I did run the scan a few times and checked all the data had been downloaded already.
This could not have been the case because if you see a Bar Start Date-Time for the prior day in the Alert Message, then the evaluation was also on the old last bar before the download completed.

In addition to documentation updates, what we are going to do is add a new command to download historical data for the symbols in the Associated Watch List. This will be part of the procedure for performing a scan on historical Daily charts.
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
[2016-04-15 05:12:51]
CarlRostron - Posts: 80
This could not have been the case because if you see a Bar Start Date-Time for the prior day in the Alert Message, then the evaluation was also on the old last bar before the download completed.
Agree that the alert message Bar Start Date Time did evaluate on the incorrect day isn't that the problem? But you can easily see in the two images in Post #6 that the following days data was already downloaded.

The new command sounds like a good idea. Do you think that will be done on the next release?
[2016-04-15 05:14:23]
Sierra Chart Engineering - Posts: 104368
Well, unless we were actually seeing what was happening on your side it is hard for us to explain this definitely.

In any case we do expect this will be solved with a new command. It should be out in a couple of weeks.
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
[2016-04-15 05:15:43]
CarlRostron - Posts: 80
Thanks for your support.

Great Software btw.

Thanks.
[2016-05-17 09:35:15]
Sierra Chart Engineering - Posts: 104368
Related to this, here is the relevant documentation:
https://www.sierrachart.com/index.php?page=doc/doc_StudyChartAlertsAndScanning.php#UnderstandingScanningHistoricalDailyCharts

Make sure you are running version 1414 for the new feature.
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

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

Login

Login Page - Create Account