Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 21:09:48 +0000
SPREADSHEET FOR TRADING, CELL $J$29, FLATTEN AND CANCEL ORDERS
View Count: 879
| [2016-11-13 04:51:17] |
| User63769 - Posts: 35 |
|
I am using a SPREADSHEET FOR TRADING. CELL $J$29, FLATTEN AND CANCEL ORDERS, is not executing even when true. I am using the following formula: = AND ( $J$8<>0, $J$28 ) I want to flatten any position at the same time that I DISABLE AUTO TRADING with cell $J$28. Is this a valid formula to achieve this, or does a TRUE value in $J$28 prevent $J$29 from executing? Thank you Date Time Of Last Edit: 2016-11-13 05:42:15
|
| [2016-11-13 08:31:43] |
| |
|
We are going to test this and get back to you.
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-11-14 19:22:07] |
| |
|
We tested this by setting the cell to Disable Auto Trading and the cell to Flatten Positions and Cancel Orders to TRUE at the same time and the Position was flattened. We verified this does work properly. So not sure why you are having a problem. Make sure you are running the current version of Sierra Chart. or does a TRUE value in $J$28 prevent $J$29 from executing? No not initially. Only subsequently after the Flatten cell has been evaluated.
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-11-14 19:55:48] |
| Sawtooth - Posts: 3993 |
|
Support: If J29 evaluates before J28, then J29's reliance on J28 would only see J28's FALSE. Then when J28 goes TRUE, J29 is already disabled. User63769: Try using the same formula in both J28 and J29. |
| [2016-11-14 20:01:57] |
| |
|
All spreadsheet cells are calculated before they are read from the spreadsheet and processed. So there should not be a problem with what they are doing. Before auto trading is disabled, all the other operations are performed first. 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: