Support Board
Date/Time: Sun, 25 May 2025 13:26:02 +0000
Spreadsheet for Trading doesn't fill Order
View Count: 337
| [2023-06-05 17:59:49] |
| Nicolas Leclercq - Posts: 22 |
|
Hi I want to automate my spreadsheet alert with "Spreadsheet for Trading"...my Buy/Sell Entry works with the good syntax in K3 and M3, and want to exit out with the Trade Window (with stop and BE strategy) But when I replay, the order doesnt fill in the Trade window (but in my spreadsheet Trading: I see K3=1 or M3=1). How to trigger the trade when K3=1 or M3=1 ? see screenshot Thanks for your help Nico |
 TradeWindow.png / V - Attached On 2023-06-05 17:58:06 UTC - Size: 150.35 KB - 79 views |
| [2023-06-05 18:04:25] |
| John - SC Support - Posts: 40015 |
|
Keep in mind that in any situation (including replays), the order is only going to be entered for the current bar. What you show in your image are values of 1 for previous bars. So those are situations where an order could have occurred, but if the spreadsheet system was not running at that time, then that would not generate a live order (again, only on the current bar will an actual order be sent to the trading service (or simulated)). If the issue is that you are not getting those same results during a replay, then you would need to look at the type of replay (or backtesting) you are running. Refer to the following: Auto Trade System Back Testing: Differences Between Back Testing and Real-Time Auto Trade System Evaluation There are other items on the page above that might be helpful as well, so take a look. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-05 18:34:22] |
| Nicolas Leclercq - Posts: 22 |
|
OK but its the same in simulation mode, my subgraph display right on the chart + K3=1 : so all is good (for me), but it doesnt trigger a long trade
|
| [2023-06-05 19:40:35] |
| j4ytr4der_ - Posts: 947 |
|
Hake sure: 1. Trading is enabled for the chart, and globally (Trade menu) 2. You are set NOT to send orders to your trading service (since then it will bypass the sim) Those are where I would look first. |
| [2023-06-06 13:41:22] |
| John - SC Support - Posts: 40015 |
|
With regards to "Trading is Enabled" there is the "Trading Locked" option in the Trade Menu along with the "Auto Trading Enabled - Chart" and "Auto Trading Enabled - Global". Refer to the following: Trade Menu: Auto Trading Enabled - Global (Trade menu) 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: