Home >> Support Board

Support Board

Date/Time: Thu, 02 May 2024 16:33:05 +0000

How to Post a Message for Support

[Programming Help] - Spreadsheet for Trading Executing Non-Existing Trade Signals

View Count: 664

[2020-06-18 17:46:48] #1 [Go To First Post]
CMG - Posts: 179
Hello, A spreadsheet for trading is opening positions with no TRUE signal from columns K and M. The formulas at K3 and M3 are not even close to signal a TRUE I have set the spreadsheet input "Enhanced Auto Trade Signals Related Logging..." set to YES for better analysis. However, the Trade Service Log does not show any information in respect to the wrong signal and fills. The Trade Activity Log does show the fills. Below is the section from the message log for the times of one of the wrong fills and its information from the trade activity log. Attached is the trade activity log. Thanks, Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Buy Entry \| Signal ignored because current Alert Condition formula is FALSE \| Cell: K3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:12.577 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Buy Exit (Sell) \| Signal ignored because current Alert Condition formula is FALSE \| Cell: L3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:12.577 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Sell Entry \| Signal ignored because current Alert Condition formula is FALSE \| Cell: M3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:12.577 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Buy Entry \| Signal ignored because current Alert Condition formula is FALSE \| Cell: K3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:13.274 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Buy Exit (Sell) \| Signal ignored because current Alert Condition formula is FALSE \| Cell: L3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:13.274 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Sell Exit (Buy) \| Signal ignored because current Alert Condition formula is FALSE \| Cell: N3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:13.277 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Buy Entry \| Signal ignored because current Alert Condition formula is FALSE \| Cell: K3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:13.903 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Buy Exit (Sell) \| Signal ignored because current Alert Condition formula is FALSE \| Cell: L3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:13.903 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Sell Entry \| Signal ignored because current Alert Condition formula is FALSE \| Cell: M3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:13.903 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Sell Exit (Buy) \| Signal ignored because current Alert Condition formula is FALSE \| Cell: N3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:13.903 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Buy Entry \| Signal ignored because current Alert Condition formula is FALSE \| Cell: K3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:14.657 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Buy Exit (Sell) \| Signal ignored because current Alert Condition formula is FALSE \| Cell: L3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:14.657 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Sell Entry \| Signal ignored because current Alert Condition formula is FALSE \| Cell: M3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:14.657 Spreadsheet System - YMU20[M] 1 Min #2 \| Spreadsheet: P1 Trad \| Sell Exit (Buy) \| Signal ignored because current Alert Condition formula is FALSE \| Cell: N3 \| Bar start date-time: 2020-06-18 12:39:00 \| 2020-06-18 12:39:14.657 (information shown in trade activity log) ActivityType DateTime Symbol OrderActionSource InternalOrderID ServiceOrderID OrderType Quantity BuySell Price Price2 OrderStatus FillPrice FilledQuantity TradeAccount OpenClose ParentInternalOrderID PositionQuantity FillExecutionServiceID HighDuringPosition LowDuringPosition Note AccountBalance ExchangeOrderID ClientOrderID Orders 2020-06-18 12:39:13.274 [Sim]YMU20 Auto-trade: YMU20[M] 1 Min #2 \| P1 Trad \| SellEntry \| Formula: Sell Entry at row 3 is TRUE. \| Bar start date-time: 2020-06-18 12:39:00.000 \| Last: 25882 \| AO=0 747 Market 1 Sell Order Sent Sim1 Open Orders 2020-06-18 12:39:13.277 [Sim]YMU20 Simulated order accepted 747 747 Market 1 Sell Open Sim1 Open Orders 2020-06-18 12:39:13.278 [Sim]YMU20 Trade simulation fill. Bid: 25882 Ask: 25884 Last: 25882 747 747 Market 1 Sell Filled 25882 1 Sim1 Open


Private File Trade Error.png / V - Attached On 2020-06-18 17:43:01 UTC - Size: 42.22 KB - 190 views

[2020-06-20 09:11:48] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Refer to: Automated Trading Management: Troubleshooting Automated Trading System Behavior Spreadsheet Systems, Alerts and Automated Trading: Disappearing Arrows or Signals 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 Date Time Of Last Edit: 2020-06-20 09:15:16

To post a message in this thread, you need to log in with your Sierra Chart account: