Support Board
Date/Time: Sat, 08 Feb 2025 03:11:36 +0000
Post From: Spreadsheet for Trading Executing Non-Existing Trade Signals
| [2020-06-18 17:46:48] |
| 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 - 214 views |