Support Board
Date/Time: Sat, 11 Jan 2025 06:55:11 +0000
SPREADSHEET FOR TRADING, CELL $J$29, FLATTEN AND CANCEL ORDERS
View Count: 947
[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] |
Sierra Chart Engineering - Posts: 104368 |
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] |
Sierra Chart Engineering - Posts: 104368 |
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: 4147 |
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] |
Sierra Chart Engineering - Posts: 104368 |
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: