Login Page - Create Account

Support Board


Date/Time: Fri, 23 Feb 2024 16:18:35 +0000



v1199 spreadsheet system/alert: column k,l,m,n audible alerts AND Logging not functioning

View Count: 1425

[2014-10-22 13:56:15]
4646ed - Posts: 230
maybe I've missed a setting somewhere?
v1199 spreadsheet system/alert: column k,l,m,n audible alerts not functioning...also not showing in alert manager.
In the alerts setting of the general settings window I put in my own alert wave files, gave them names, then plugged them into the system/alert settings and inputs tab of my spreadsheet study. but nothing happens, even though the visual signals appear on the chart, just no audio and no mention in the alert manager.
[2014-10-22 14:21:45]
4646ed - Posts: 230
just upgraded to 1204, but no change.
[2014-10-22 19:34:36]
4646ed - Posts: 230
alright, since no quick answer is forthcoming, i have maybe a related question: if I download the latest version of SC from the what's new page, which I always do, am I not automatically downloading the NEW spreadsheet version? Is that related to this problem of the column K,L,M,N alerts not working in the "spreadsheet system/alert"?
The spreadsheet with which I am having the problem was just written this week using v1199.
Date Time Of Last Edit: 2014-10-22 19:39:47
[2014-10-23 05:25:49]
4646ed - Posts: 230
hello?
[2014-10-23 06:09:02]
Sierra Chart Engineering - Posts: 104368
Generally questions like this are next to impossible for us to answer unless we get your Chartbook and Spreadsheet.

Performing a simple test we do not see a problem with the Spreadsheet System/Alert study when using New Spreadsheets.

We will only accept a Chartbook that contains one chart and we need a simple Spreadsheet which demonstrates the problem.

The best approach to this kind of problem is to start off with a new Spreadsheet study and a new Spreadsheet and work with a simple formula like = 1 in one of the alert columns to trigger an alert. All alerts are logged. If this works, then you just need to go through everything with your existing Spreadsheet Alert set up to see where there might be a problem.
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
[2014-10-23 08:29:14]
4646ed - Posts: 230
So, once again, if I download the latest version from the what's new page, then I am getting the "new" spreadsheets?
Second of all, I did your test, same result: no sound, no alerts in alert manager. I've attached snaps of the alert manager, the chart, the settings, and the spreadsheet.
Is there something I'm missing?

Date Time Of Last Edit: 2014-10-23 08:45:54
imageAlert Manager Empty.JPG / V - Attached On 2014-10-23 08:45:17 UTC - Size: 87.04 KB - 293 views
imageChart Drawings OK.JPG / V - Attached On 2014-10-23 08:45:24 UTC - Size: 135.13 KB - 270 views
imageSpreadsheet Test 1.JPG / V - Attached On 2014-10-23 08:45:33 UTC - Size: 207.59 KB - 277 views
imageStudy Settings test.JPG / V - Attached On 2014-10-23 08:45:45 UTC - Size: 144.29 KB - 285 views
[2014-10-23 12:49:46]
4646ed - Posts: 230
Update: the only time I get the audible alerts and the alert manager log entries is when I replay one of the charts on standard - and this just started happening. But still nothing except the drawings during live. Attached is a snap of the alert manager with the replay alerts logged.
Date Time Of Last Edit: 2014-10-23 13:37:35
imageAlert MAnager, Replay, Alerts working.JPG / V - Attached On 2014-10-23 13:36:45 UTC - Size: 157.9 KB - 303 views
[2014-10-23 16:58:11]
4646ed - Posts: 230
Okay, even though your test (=1) also didn't get me the alerts and logging, I've redone my own spreadsheet from whence this all started. I've closed all other spreadsheets and chartbooks. The only things open are:
my main chart (the 1 min GBPUSD with the system/alert study on it) --which has overlays of studies from three other charts-->the 5m,15m,60m GBPUSDs),
and one spreadsheet (5-15-60_GBPUSD_Alert System)

...and it's still the same. The only things happening are the alert drawings -- no audible, no logging.

I've uploaded the chartbook (chartbook 92) and the spreadsheet (5-15-60_GBPUSD).

Last, I've uploaded a snap of the main 1m chart, where you can see the drawings are appearing correctly, and the three other charts from which the overlays are drawn.
Date Time Of Last Edit: 2014-10-23 17:22:01
attachmentChartbook92.cht - Attached On 2014-10-23 16:54:27 UTC - Size: 2.35 MB - 288 views
attachment5-15-60_GBPUSD_Alert_System.scwbf - Attached On 2014-10-23 16:56:47 UTC - Size: 949.4 KB - 297 views
imageGBPUSD Charts.JPG / V - Attached On 2014-10-23 17:20:28 UTC - Size: 307.1 KB - 301 views
[2014-10-24 06:41:39]
4646ed - Posts: 230
I'm assuming you guys are working on this? For your information, I tried downloading v1205 with the Old Spreadsheets to see if there was any difference. None. Same Problem. No audio. No alert logging. Just the drawings and the spreadsheet processes the formulas correctly.
[2014-10-24 09:32:08]
Sierra Chart Engineering - Posts: 104368
Analysis of your Alert setup is not within the scope of our support. We did specify that we would only accept 1 chart and a simple example.

We recommend referring to this section here:
http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#IgnoredSignals


We are also attaching a simple Alert Spreadsheet and Chartbook which demonstrates that the functionality does work properly. Test these files by saving them to the Sierra Chart Data Files Folder and opening the Chartbook and confirm you are getting alert sounds and messages.

The download links from the What is New page have been removed. Those for Old Spreadsheets only.
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: 2014-10-24 20:19:12
attachmentUpBarAlert.scwbf - Attached On 2014-10-24 09:31:42 UTC - Size: 31.13 KB - 303 views
attachmentUp Bar Alert Example.cht - Attached On 2014-10-24 09:31:48 UTC - Size: 29.04 KB - 291 views
[2014-10-24 11:47:29]
4646ed - Posts: 230
You have again missed the point. I just downloaded and installed 1192, and everything worked properly (except for the other bug where you cant delete files from the files to open dialogue box). This has nothing to do with my alert setup (which you don't want to look at anyway). In 1199 and in 1204 I tried your simple =1 test in the simplest 1 chart setup that you suggested, and still didn't get sounds or logging. There is a problem with the latest upgrades - but maybe it only surfaces in more complex chart setups...which really begs the question: if the only thing that works is a very simple setup and on your system, why offer all the complexities and ability to change so many details -- which by the way is what sets Sierra Charts so far above any of its competitors.
Anyway, my problem is solved, so thanks for the support....(even though you don't want us to say thanks!?)
[2014-10-24 11:47:45]
4646ed - Posts: 230

Date Time Of Last Edit: 2014-10-24 11:48:14
[2014-10-24 17:22:44]
Sierra Chart Engineering - Posts: 104368
If there is a genuine problem we will certainly go through the necessary work to analyze a more complex set up. However, that has not been established. And we cannot unnecessarily take time debugging users complex setups, when we do not believe the issue is on the Sierra Chart side.

We did not understand that you had a problem after updating to a newer version. A lot of times users make reference to a particular version and say there is a bug, when it has nothing to do that particular version and there is no bug.

Anyway, my problem is solved, so thanks for the support....(even though you don't want us to say thanks!?)
What was the problem?

And if there still is a problem, we want you to use the files we have given in post 10 to see if you get Alert messages and sounds. You should definitely get many alerts during real-time chart updating. Those files need to be saved to the Data Files Folder. The Chartbook can be opened through File >> Open Chartbook.


Also in regards to the problem like this, with the way that Alerts work from the Spreadsheet study, whether the set up a simple or complex, if there is a basic problem with Alert messages and sounds themselves, a simple set up is all that is needed to indicate that problem. Otherwise, the source of the problem is something else.

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: 2014-10-24 17:24:31
[2014-10-24 20:13:21]
Sierra Chart Engineering - Posts: 104368
We see you hid the previous post. This is fine.

We want to make it clear, that we did actually download all of your files. The problem is we needed to reproduce the problem quickly and in a reliable way and understand what is triggering the alerts. As a general rule, we will not involve ourselves with complex setups. It is simply unproductive and adds a whole layer of complexity which makes troubleshooting a problem more difficult.

Therefore, we determined that the best approach would be to create a simple example and then test it and see if we can reproduce the problem. We cannot reproduce the problem , so then we posted the files for you to test. We should have made it more clear that we wanted you to test those files and see if you still have the problem.

If you had a problem with alerts with those files, then we would go from there and have a logical way to solve the problem.

In regards to the version number, putting a version number does not indicate to us that a problem arises after an update. A lot of times as we said version numbers are given but there is not necessarily a problem with that particular version, a problem arising in that version or later, or necessarily a bug.

So if you are still having a problem in the latest version of Sierra Chart with Alert Sounds not playing and Alert Messages not being added to the Alerts Log, then we will determine why.
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
[2014-10-24 20:20:44]
Sierra Chart Engineering - Posts: 104368
Another thing that formed the basis of our response at post #10 was the fact that we saw that you are using the Signal Only on Bar Close option with the Spreadsheet Alert study. So this adds more complexity and you can have a scenario where a formula is not becoming TRUE at row 4 when it may seem like it is.
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: 2014-10-24 20:21:00

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

Login

Login Page - Create Account