Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 05 May 2024 05:54:40 +0000
Cells K3,L3,M3,N3 True Ignored
View Count: 569
| [2019-11-02 03:52:09] |
| CMG - Posts: 179 |
|
Hi There, 1. On a Spreadsheet for trading when a formula signals TRUE on cells K3,L3,M3,N3 sometimes the buy or sell signal is ignored. No order is placed and no record registered on the trade service log or trade activity log and there is no mention of the missing order or why it was ignored. Found a post in this board regarding the same issue and how it was solved by unchecking "enabled" on alerts tabs but it seems later versions of SC do not have this option any more. 2. Is there a way to automate Spreadsheets>recalculate all formulas? Thanks Date Time Of Last Edit: 2019-11-02 03:54:09
|
| [2019-11-02 10:44:47] |
| |
|
1. This is very thoroughly covered here: Spreadsheet Systems, Alerts and Automated Trading: Ignored Signals With Spreadsheet Systems or Alerts 2. You should not need to do 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 |
| [2019-11-02 14:37:12] |
| Sawtooth - Posts: 3993 |
|
2. Use the Chart Recalculation - Periodic study.
|
| [2019-11-02 18:37:48] |
| CMG - Posts: 179 |
|
2. I do in the following case, please advise of any alternatives: I have a spreadsheet formula that references itself creating a circular reference and since new spreadsheets do not provide iterations the formula returns a #VALUE! error. However, if I manually select Spreadsheet>Recalculate all Formulas, the formula returns the correct calculation until ONLY ONE SPECIFIC variable in the formula is changed. Curiously, the formula only has to be "recalculated" when a variable in an IF statement within the formula returns a False result. 3. Are Array Formulas no longer supported by new spreadsheets? Thanks |
To post a message in this thread, you need to log in with your Sierra Chart account: