Support Board
Date/Time: Mon, 08 Sep 2025 16:22:05 +0000
Auto trading executed flatten on existing position, realizing large loss
View Count: 154
| [2025-08-06 10:53:48] |
| User312651 - Posts: 7 |
|
This morning I had a large position trade which gone heavily red. The spreadsheet had cell J28 set to 1 and logging messages were received showing it was attempting to execute a flatten, but not doing so due to that cell being set. The client was reloaded and the entire position was flattened. It has since almost recovered. option 3 mentions this as accepted - Enabling and Disabling Automated Trading I realized a 13,800 loss and would not even be able to enter with the same size. How do we proceed and what else can be done? Yesterday I logged in from one machine and disconnected after trading on laptop, when I connected with my desktop, 10 long positions were executed. All while that cell was set to TRUE. Please advise, the loss of 13.8k was an effective 71% loss, if the trade was on me, I would have no issues, but reloading the client and having the spreadsheet set, this is a software issue and not a trade that I issued. |
| [2025-08-06 14:05:47] |
| John - SC Support - Posts: 41659 |
|
There definitely is not an issue with the software. Things that we can think of to check on with your setup: - You mention using two different computers. Keep in mind that each computer is completely separate, so if cell J28 was TRUE on one, it does not mean this is the case on the other. - Make sure you are using the same Spreadsheet Columns I/J version the same on both computers. You have a choice on which way to layout the columns I and J. In Version 1 cell J28 controls "Disable Auto Trading". In version 2 this is in cell J92. - Depending on how you have that cell being controlled, it may have been FALSE at the time the orders were put in, but then TRUE when you looked at it later. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-08-06 15:02:32] |
| User312651 - Posts: 7 |
|
This was logging in and out of the same computer, it was an earlier session that I moved between computers while flat on the laptop and when I connected on the desktop, it routed 10 long orders. Not sure why we're not considering the software. The logs show they are automated orders too... Would you like to view the logs or do a session. I am stuck 13k, granted I would have taken a 2-4k loss on the trade based on where things settled, it's not really acceptable to me to put the blame on something I did when the documentation shows this particular method as supported. Let's at least look at the program closing timelines and update that was done to the software and reload and immediate flattening of the position with the assumption that it would have been impossible for me to have the cell enabled before closing the software or I would have needed to disconnect, change the cell to true and then load it up. If my intention was to flatten, I could have done that on my own before restarting.
|
| [2025-08-06 15:06:50] |
| User312651 - Posts: 7 |
|
As for the cell, I am controlling it manually at this point. I will see Spreadsheet 'Flatten & Cancel' cell has been ignored because auto trading is disable cell j28. in the logs when the condition is met. |
| [2025-08-06 15:40:18] |
| John - SC Support - Posts: 41659 |
|
It is not the software, as we test and ensure that these kind of things can not occur. If this could happen, we would have many reports of this being an issue, and you are the only one saying you had a problem. And we do not understand what you are referring to in terms of the documentation stating that this is supported. The documentation you reference is to disabling trading by setting the "Disable Auto Trading" to True. There is definitely something you were doing that created the situation. We do not know what it is and the logs will not give us any information related to it. You need to understand how your system is setup and how it functions, particularly if you are logging in and out and using multiple computers. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-08-06 16:19:04] |
| User312651 - Posts: 7 |
|
Wow, this is support? Could you escalate this please? I understand how my system is setup. How is your software flattening a position on a client reload? How can you not help me troubleshoot that in isolation?
|
| [2025-08-06 17:29:41] |
| Sierra_Chart Engineering - Posts: 20840 |
|
We have some questions: The client was reloaded and the entire position was flattened. It has since almost recovered.
What do you mean by client. What is the client?would not even be able to enter with the same size. We do not understand exactly what is meant by this, and the reason why. We generally are understanding you are referring to an order entry of a particular quantity. when I connected with my desktop, 10 long positions were executed. All while that cell was set to TRUE. You need to determine the origin of the order. Refer to:Trade Activity Log Analysis: Determining the Origin of a New/Modified Order This is what is most important. Determining the origin of that order. The problem is, the logging does not indicate the state of this cell: Spreadsheet Systems, Alerts and Automated Trading: Disable Auto Trading (read/write) [v1:J28, v2:J92] We have no way to verify what it was at the time. If the order of quantity 10 did not originate from that spreadsheet, the state of that cell is not going to be relevant though. 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2025-08-06 17:43:51
|
To post a message in this thread, you need to log in with your Sierra Chart account: