Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 27 Apr 2024 14:29:10 +0000
Spreadsheet - Countdown Timer reference
View Count: 1592
| [2017-11-28 03:22:51] |
| absorrel4 - Posts: 92 |
|
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] |
| |
|
In what particular Sheet Cell is that formula located?
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: 2017-11-28 04:31:50
|
| [2017-12-03 16:59:18] |
| absorrel4 - Posts: 92 |
|
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] |
| |
|
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. 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: