Support Board
Date/Time: Sun, 06 Jul 2025 11:14:26 +0000
Spreadsheet Systems for Trading
View Count: 155
| [2025-06-19 15:09:01] |
| Eranox - Posts: 34 |
|
Hi. I have the following problem: when the conditione in cell K3 (Buy Entry) or M3 (Sell Entry) gives 1, no order run in the chart. When I manually write 1 in K3 or M3, then the order run in the chart. How can I solve? |
| [2025-06-19 16:54:29] |
| John - SC Support - Posts: 40745 |
|
When you have this occur look in the "Trade >> Trade Service Log" and see what if there is any statement about why an order was not generated. You can post the information from the log to this thread if you like by following these instructions: Support Board Posting Information: Providing Lines From Trade Service Log For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-06-20 09:51:18] |
| Eranox - Posts: 34 |
|
2025-06-20 11:35:19.944 | TradeActivity files query time: 0.243822 seconds. Entries: 0. Current queries: 2 2025-06-20 11:35:19.945 | TradeActivity files query time: 0.000914 seconds. Entries: 192. Current queries: 1 2025-06-20 11:35:25.153 | Rithmic Direct - DTC | Requesting trade accounts from server. 2025-06-20 11:35:25.330 | Rithmic Direct - DTC | Performing query for most recent account balances Date-Time for Trade Account: PP-F50K-012803-000005. 2025-06-20 11:35:25.330 | Rithmic Direct - DTC | Performing query for most recent account balances Date-Time for Trade Account: PP-F50K-012803-000004. 2025-06-20 11:35:25.330 | Rithmic Direct - DTC | Performing query for most recent account balances Date-Time for Trade Account: PP-F50K-012803-000003. 2025-06-20 11:35:25.330 | Rithmic Direct - DTC | Performing query for most recent account balances Date-Time for Trade Account: PP-F50K-012803-000002. 2025-06-20 11:35:25.330 | Rithmic Direct - DTC | Performing query for most recent account balances Date-Time for Trade Account: PP-F50K-012803-000001. 2025-06-20 11:35:25.330 | Rithmic Direct - DTC | Received 5 accounts from service. 2025-06-20 11:35:25.356 | TradeActivity files query time: 0.026097 seconds. Entries: 0. Current queries: 5 2025-06-20 11:35:25.356 | Rithmic Direct - DTC | Requesting historical account balances for account PP-F50K-012803-000005. Start date-time UTC: 2025-02-16 09:35:25 2025-06-20 11:35:25.373 | TradeActivity files query time: 0.016940 seconds. Entries: 0. Current queries: 4 2025-06-20 11:35:25.373 | Rithmic Direct - DTC | Requesting historical account balances for account PP-F50K-012803-000004. Start date-time UTC: 2025-02-16 09:35:25 2025-06-20 11:35:25.389 | TradeActivity files query time: 0.016086 seconds. Entries: 0. Current queries: 3 2025-06-20 11:35:25.389 | Rithmic Direct - DTC | Requesting historical account balances for account PP-F50K-012803-000003. Start date-time UTC: 2025-02-16 09:35:25 2025-06-20 11:35:25.406 | Rithmic Direct - DTC | Requesting Trade Positions data. 2025-06-20 11:35:25.407 | TradeActivity files query time: 0.018149 seconds. Entries: 0. Current queries: 2 2025-06-20 11:35:25.407 | Rithmic Direct - DTC | Requesting historical account balances for account PP-F50K-012803-000002. Start date-time UTC: 2025-02-16 09:35:25 2025-06-20 11:35:25.429 | TradeActivity files query time: 0.022642 seconds. Entries: 0. Current queries: 1 2025-06-20 11:35:25.430 | Rithmic Direct - DTC | Requesting historical account balances for account PP-F50K-012803-000001. Start date-time UTC: 2025-02-16 09:35:25 2025-06-20 11:35:49.392 | TradeActivity files query time: 0.003056 seconds. Entries: 0. Current queries: 2 2025-06-20 11:35:49.392 | TradeActivity files query time: 0.000003 seconds. Entries: 0. Current queries: 2 2025-06-20 11:35:49.413 | TradeActivity files query time: 0.009773 seconds. Entries: 1. Current queries: 3 2025-06-20 11:35:49.415 | TradeActivity files query time: 0.002118 seconds. Entries: 0. Current queries: 2 2025-06-20 11:35:49.425 | TradeActivity files query time: 0.009050 seconds. Entries: 3. Current queries: 4 2025-06-20 11:35:49.427 | TradeActivity files query time: 0.002742 seconds. Entries: 0. Current queries: 4 2025-06-20 11:35:49.437 | TradeActivity files query time: 0.009821 seconds. Entries: 5. Current queries: 5 2025-06-20 11:35:49.442 | TradeActivity files query time: 0.005340 seconds. Entries: 0. Current queries: 4 2025-06-20 11:35:49.456 | TradeActivity files query time: 0.013202 seconds. Entries: 4. Current queries: 3 2025-06-20 11:35:49.459 | TradeActivity files query time: 0.002941 seconds. Entries: 0. Current queries: 2 2025-06-20 11:35:49.459 | TradeActivity files query time: 0.000510 seconds. Entries: 1. Current queries: 1 2025-06-20 11:35:49.489 | TradeActivity files query time: 0.000594 seconds. Entries: 0. Current queries: 1 2025-06-20 11:35:49.644 | TradeActivity files query time: 0.000903 seconds. Entries: 16. Current queries: 1 2025-06-20 11:35:49.644 | Trade Activity query complete for requested trades list. Sending Position to DTC clients. Symbol: MNQU5.CME. Trade Account: Sim1 2025-06-20 11:35:52.209 | TradeActivity files query time: 0.000025 seconds. Entries: 0. Current queries: 1 2025-06-20 11:35:52.216 | TradeActivity files query time: 0.000070 seconds. Entries: 0. Current queries: 1 2025-06-20 11:35:52.230 | TradeActivity files query time: 0.002257 seconds. Entries: 1. Current queries: 1 2025-06-20 11:35:52.239 | TradeActivity files query time: 0.002337 seconds. Entries: 0. Current queries: 2 2025-06-20 11:35:52.241 | TradeActivity files query time: 0.002250 seconds. Entries: 3. Current queries: 1 2025-06-20 11:35:52.250 | TradeActivity files query time: 0.002479 seconds. Entries: 0. Current queries: 2 2025-06-20 11:35:52.251 | TradeActivity files query time: 0.001321 seconds. Entries: 5. Current queries: 1 2025-06-20 11:35:52.264 | TradeActivity files query time: 0.004877 seconds. Entries: 0. Current queries: 2 2025-06-20 11:35:52.265 | TradeActivity files query time: 0.001017 seconds. Entries: 4. Current queries: 1 2025-06-20 11:35:52.273 | TradeActivity files query time: 0.002994 seconds. Entries: 0. Current queries: 2 2025-06-20 11:35:52.273 | TradeActivity files query time: 0.000543 seconds. Entries: 1. Current queries: 1 2025-06-20 11:35:52.400 | TradeActivity files query time: 0.000622 seconds. Entries: 0. Current queries: 1 2025-06-20 11:35:54.990 | Denali Data Feed | MaxConnectionsDifferentDevices = 1, NumCurrentConnectionsDifferentDevices = 1 2025-06-20 11:35:54.990 | Denali Data Feed | MaxConnectionsForSameDevice = 3, NumCurrentConnectionsForSameDevice = 1 2025-06-20 11:36:06.966 | TradeActivity files query time: 0.000725 seconds. Entries: 16. Current queries: 1 2025-06-20 11:36:07.204 | TradeActivity files query time: 0.000556 seconds. Entries: 0. Current queries: 1 2025-06-20 11:36:09.009 | TradeActivity files query time: 0.001173 seconds. Entries: 0. Current queries: 1 2025-06-20 11:36:10.025 | TradeActivity files query time: 0.000870 seconds. Entries: 16. Current queries: 1 2025-06-20 11:38:10.694 | TradeActivity files query time: 0.002197 seconds. Entries: 16. Current queries: 1 2025-06-20 11:38:12.583 | TradeActivity files query time: 0.000022 seconds. Entries: 0. Current queries: 1 2025-06-20 11:38:12.591 | TradeActivity files query time: 0.000048 seconds. Entries: 0. Current queries: 1 2025-06-20 11:38:12.603 | TradeActivity files query time: 0.003385 seconds. Entries: 1. Current queries: 1 2025-06-20 11:38:12.615 | TradeActivity files query time: 0.003324 seconds. Entries: 0. Current queries: 2 2025-06-20 11:38:12.618 | TradeActivity files query time: 0.003606 seconds. Entries: 3. Current queries: 1 2025-06-20 11:38:12.630 | TradeActivity files query time: 0.003382 seconds. Entries: 0. Current queries: 2 2025-06-20 11:38:12.631 | TradeActivity files query time: 0.001589 seconds. Entries: 5. Current queries: 1 2025-06-20 11:38:12.655 | TradeActivity files query time: 0.008437 seconds. Entries: 0. Current queries: 2 2025-06-20 11:38:12.657 | TradeActivity files query time: 0.002427 seconds. Entries: 4. Current queries: 1 2025-06-20 11:38:12.665 | TradeActivity files query time: 0.005293 seconds. Entries: 0. Current queries: 2 2025-06-20 11:38:12.666 | TradeActivity files query time: 0.000935 seconds. Entries: 1. Current queries: 1 2025-06-20 11:38:12.809 | TradeActivity files query time: 0.001001 seconds. Entries: 0. Current queries: 1 2025-06-20 11:38:13.082 | TradeActivity files query time: 0.001063 seconds. Entries: 0. Current queries: 1 2025-06-20 11:38:13.501 | TradeActivity files query time: 0.000805 seconds. Entries: 16. Current queries: 1 2025-06-20 11:38:33.407 | Auto-trade: NQU5.CME/MNQU5.CME[M] 1 Sec #2 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:38:32.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:38:33.434 | Auto-trade: ESU5.CME/MESU5.CME[M] 1 Sec #1 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:38:32.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:39:10.492 | Auto-trade: ESU5.CME/MESU5.CME[M] 1 Sec #1 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:39:09.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:39:23.221 | Auto-trade: ESU5.CME/MESU5.CME[M] 1 Sec #1 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:39:22.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:39:45.542 | Auto-trade: ESU5.CME/MESU5.CME[M] 1 Sec #1 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:39:44.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:40:05.748 | Auto-trade: ESU5.CME/MESU5.CME[M] 1 Sec #1 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:40:05.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:40:44.076 | Auto-trade: NQU5.CME/MNQU5.CME[M] 1 Sec #2 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:40:43.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:40:53.354 | Auto-trade: NQU5.CME/MNQU5.CME[M] 1 Sec #2 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:40:52.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:42:34.797 | Auto-trade: ESU5.CME/MESU5.CME[M] 1 Sec #1 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:42:34.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:42:48.270 | Auto-trade: ESU5.CME/MESU5.CME[M] 1 Sec #1 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:42:47.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:44:05.355 | Auto-trade: NQU5.CME/MNQU5.CME[M] 1 Sec #2 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:44:04.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:45:04.344 | Auto-trade: NQU5.CME/MNQU5.CME[M] 1 Sec #2 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:45:03.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:45:07.073 | Auto-trade: ESU5.CME/MESU5.CME[M] 1 Sec #1 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:45:06.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 2025-06-20 11:47:05.663 | Auto-trade: NQU5.CME/MNQU5.CME[M] 1 Sec #2 | AutoTrading1Sec | BuyExit | Bar start date-time: 2025-06-20 11:47:05.000 | BuyExit signal is ignored. Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position with working exit orders: 0. Current Position: 0. Current Position with exit market orders: 0 |
| [2025-06-20 09:54:47] |
| Eranox - Posts: 34 |
|
As you can see above no Buy entry is reported in the log but I have several true value in the spreadsheet
|
Attachment Deleted.  Screenshot 2025-06-20 115234.png / V - Attached On 2025-06-20 09:54:26 UTC - Size: 37.4 KB - 13 views |
| [2025-06-20 15:00:07] |
| John - SC Support - Posts: 40745 |
|
The log file shows that you are having an issue with the "Buy Exit" cell. In particular, either the cell is becoming true when you do not have a position, so there is nothing to exit, or the position already has working orders to close it out. There is nothing in the log related to the Buy Entry or Sell Entry. Is the issue with these Entry cells or the Exit cells? For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-06-20 16:15:05] |
| Eranox - Posts: 34 |
|
The problem is not Buy Exit cell. Infact if I enter a buy position manually, when the buy exit cell becomes true it close the position buy. The real problem is Buy Entery. When this cell becomes true, no entry happens in the chart. But if I manually insert 1 in the Buy Entry cell then an order buy entry happen in the chart. So it works if I write 1 manually in the cell but not if 1 is the result of the condition in buy entry cell. I hope I managed to explain |
| [2025-06-20 17:27:35] |
| John - SC Support - Posts: 40745 |
|
We understand the situation, but we are confused by the entries in the Trade Service Log. That is why we asked if this was definitely related to the Entry cells or the Exit cells. Given what you have stated, there should be something in the log that gives the reason for this not working. On the Spreadsheet Study for Trading, what are the following Inputs set to: - Reset Condition on New Bar - Allow Multiple Entries in Same Direction - Signal Only Once per Bar - Signal Only on Bar Close (Columns K, M) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-06-20 17:37:22] |
| Eranox - Posts: 34 |
|
here is the screenshot of the settings you have asked me.. I remind you that the problems are for Buy Entry and Sell Entry.. Date Time Of Last Edit: 2025-06-20 17:38:30
|
| Screenshot 2025-06-20 193626.png / V - Attached On 2025-06-20 17:37:07 UTC - Size: 24.72 KB - 7 views |
| [2025-06-20 17:46:22] |
| John - SC Support - Posts: 40745 |
|
Please get us the chart and spreadsheet so we can see what is occurring in your setup. Follow these instructions to get us the chart: Support Board Posting Information: Providing Chartbook with Only a Single Chart And follow these instructions to also attach the spreadsheet: Support Board Posting Information: Attaching a File (Optional) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-06-20 18:29:18] |
| Eranox - Posts: 34 |
|
here it is
|
Private File Private File |
| [2025-06-20 19:24:45] |
| John - SC Support - Posts: 40745 |
|
It looks to us like your signals are getting lost due to the short timeframe of the chart in relation to the Chart Update Interval. We do not know what your Global Chart Update Interval is set to, but for us it is 500. With it this way, we were having issues with the Buy Entry and sometimes with the Sell Entry, although most of the time the Sell Entry did work. When we set the "Chart Update Interval" to 10 milliseconds, then everything was working as expected. We do not necessarily recommend 10 milliseconds for the Chart Update Interval for this chart, as you have a lot of calculations occurring. You will need to look at what value will work best for your situation. For the most reliable, advanced, and zero cost futures order routing, use 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: