Login Page - Create Account

Support Board


Date/Time: Thu, 18 Oct 2018 10:42:15 +0000



Spreadsheet - Countdown Timer reference

Support Request:
[2017-11-28 03:22:51]
absorrel4 - Posts: 38
I have a cell in my spreadsheet that references the Countdown timer column. The formula is a simple one... e.g., =if(aa3<5,1,0) My formula works fine and gives me a "1" when the countdown timer is < 5 seconds remaining....but my associated alert sound never goes off. I have tried all the different settings for the column within my spreadsheet study (i.e., "Alert Only Once Per Bar" yes/no..."Signal On Bar Close" yes/no...etc.). However, no alert sound. I think I remember that the if statement reference has to be in a different format to match the Countdown Timer??....but I tried all the different possible combinations within the statement with no success (i.e., I tried "hh:mm:ss" formats, etc.). How can I get this to work? I did this years ago and made it work, but I sure can not remember what I did....any help is appreciated. Thanks...
[2017-11-28 04:31:39]
Sierra Chart Engineering - Posts: 64945
In what particular Sheet Cell is that formula located?
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: 2017-11-28 04:31:50
[2017-12-03 16:59:18]
absorrel4 - Posts: 38
Tried formula in columns U V W X Y Z....referenced the Countdown Timer info which is in column AA. Each column does provide a positive result when the Countdown Timer gets to 5 seconds remaining....but no alert sound. I tried different alert sounds and different settings within the spreadsheet study...but no success. As I noted, I was able to get this to work a number of years ago, but I can not remember how...I think? it has to do with the Countdown Timer unique formula format in column AA? But I tried changing the AA column format and that did not help.
[2017-12-14 22:24:19]
Sierra Chart Engineering - Posts: 64945
Make sure this particular study Input is set to Yes:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#ColumnKLMNAlert
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.

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

Login


Login Page - Create Account