Support Board
Date/Time: Sat, 19 Apr 2025 14:38:52 +0000
Post From: Spreadsheet System for Trading - trouble triggering trade
| [2017-05-01 16:26:44] |
| User930315 - Posts: 55 |
|
I've set this up as suggested but the problem was not resolved so I started from scratch with a new spreadsheet and spent a few hours again inputting all formulas. After clearing all trades and positions K3 & M3 are zero. In this case when M3 toggles to 1 a short trade arrow is shown on the screen but the trade does not trigger. The Trade Service Log shows: Spreadsheet System - Replay 5.0X: YM-201706-ECBOT [CBV] 20 Min #5 | Spreadsheet: AutotradingV2.0 | Buy Entry | Signal ignored because current Alert Condition is FALSE | Bar start date-time: 2017-05-01 08:40:00 | 2017-05-01 10:23:42 Spreadsheet System - Replay 5.0X: YM-201706-ECBOT [CBV] 20 Min #5 | Spreadsheet: AutotradingV2.0 | Buy Exit (Sell) | Signal ignored because current Alert Condition is FALSE | Bar start date-time: 2017-05-01 08:40:00 | 2017-05-01 10:23:42 Spreadsheet System - Replay 5.0X: YM-201706-ECBOT [CBV] 20 Min #5 | Spreadsheet: AutotradingV2.0 | Sell Entry | Signal ignored because current Alert Condition is TRUE | Bar start date-time: 2017-05-01 08:40:00 | 2017-05-01 10:23:42 Spreadsheet System - Replay 5.0X: YM-201706-ECBOT [CBV] 20 Min #5 | Spreadsheet: AutotradingV2.0 | Sell Exit (Buy) | Signal ignored because current Alert Condition is FALSE | Bar start date-time: 2017-05-01 08:40:00 | 2017-05-01 10:23:42 You can see the Alert condition toggles from FALSE to TRUE in the log so this trade should be triggering unless there is something not shown in the log that is set wrong. Auto Trading Enabled - Checked Reset Condition on New Bar - No Signal Only Once Per Bar - Yes Send Orders to Trade Service - No Signal Only on Bar Close - No for all settings Enhanced System Signal Related Logging - Yes Trade Simulation Mode On Connected to Data Feed - Chart updated - Yes What else can I check to find this problem? Thanks you. |