Support Board
Date/Time: Sun, 16 Mar 2025 08:00:31 +0000
Post From: Auto flatten and cancel cell triggered when condition was not true
[2022-07-16 05:27:05] |
dk90 - Posts: 33 |
Hello. I'm trying to figure out why my position got flattened when the condition I have in flatten and cancel cell J29 could not have possibly been true. Here is what happened last night. Around 11 pm PST, my system (SC/Teton/VPS/Dorman) got disconnected. This is a problem with ISP connections which is random and very frustrating. At any rate, when my system reconnected with Teton order routing a few seconds later, the log says that my automated spreadsheet system initiated a flatten and cancel action with source: Flatten & Cancel cell. The condition I have in cell J29 basically says if the loss is greater than a certain threshold amount, flatten and cancel. Until then, my P&L was positive. Even if there was a small loss the threshold loss amount is very large. So there is no way that the condition was true for the flatten and cancel cell to be true and initiate the action. A couple of months ago, I actually saw a flatten and cancel initiated by the system during the day and the condition in J29 was not true. Maybe there is something else going on here when the service disconnects and reconnects. The flatten and cancel action is not always initiated when connections to the routing server are dropped. This has happened a couple of times only while my connections have dropped many times. I'm going to get rid of the condition in the cell J29 and place a 0 until we figure out why this is happening. I also have cell J88 (flatten at set time) set to false. Will this be sufficient to prevent an unwanted automated flatten and cancel? Please advise. Thanks. |