Login Page - Create Account

Support Board


Date/Time: Fri, 29 Nov 2024 14:36:31 +0000



Post From: Cannot get Live “Spreadsheet System for Trading” trade to occur in Simulation Mode Replay

[2023-02-06 19:19:01]
PeaceFrog - Posts: 105
Hi John,

Glad to have you looking at this.

I reran it twice;
once in Simulation Mode with Spreadsheet Study for Trading Input for Send Orders to Trade Service set to No and
once in Simulation Mode with Spreadsheet Study for Trading Input for Send Orders to Trade Service set to Yes and in neither case were the orders sent.


Here are the Trade Service Logs for in Simulation Mode with Spreadsheet Study for Trading Input for Send Orders to Trade Service set to No:

Cleared global profit/loss management data for Sim1. | 2023-02-06 11:07:18.704
TradeActivity files query time: 0.013069 seconds. Entries: 0. Current queries: 1 | 2023-02-06 11:07:18.717
Cleared trade data | Symbol: [Sim]F.US.CA6H23 | TradeAccount: Sim1 | 2023-02-06 11:07:18.728
Flagging to reload Trades list in charts | Symbol: [Sim]F.US.CA6H23 | TradeAccount: Sim1 | 2023-02-06 11:07:18.743
TradeActivity files query time: 0.070833 seconds. Entries: 0. Current queries: 12 | 2023-02-06 11:07:18.814
TradeActivity files query time: 0.000039 seconds. Entries: 0. Current queries: 12 | 2023-02-06 11:07:18.814
TradeActivity files query time: 0.000021 seconds. Entries: 0. Current queries: 12 | 2023-02-06 11:07:18.814
TradeActivity files query time: 0.003744 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:07:18.818
TradeActivity files query time: 0.000365 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:07:18.818
TradeActivity files query time: 0.000298 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:07:18.819
TradeActivity files query time: 0.000279 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:07:18.819
TradeActivity files query time: 0.000029 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:07:18.819
TradeActivity files query time: 0.000024 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:07:18.819
TradeActivity files query time: 0.000259 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:07:18.819
TradeActivity files query time: 0.000027 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:07:18.819
TradeActivity files query time: 0.000253 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:07:18.820
TradeActivity files query time: 0.000064 seconds. Entries: 0. Current queries: 1 | 2023-02-06 11:07:18.972



Here are the Trade Service Logs for in Simulation Mode with Spreadsheet Study for Trading Input for Send Orders to Trade Service set to Yes:

TradeActivity files query time: 0.000063 seconds. Entries: 0. Current queries: 1 | 2023-02-06 11:08:37.745
Cleared global profit/loss management data for Sim1. | 2023-02-06 11:09:07.643
TradeActivity files query time: 0.013340 seconds. Entries: 0. Current queries: 1 | 2023-02-06 11:09:07.657
Cleared trade data | Symbol: [Sim]F.US.CA6H23 | TradeAccount: Sim1 | 2023-02-06 11:09:07.678
Flagging to reload Trades list in charts | Symbol: [Sim]F.US.CA6H23 | TradeAccount: Sim1 | 2023-02-06 11:09:07.693
TradeActivity files query time: 0.069919 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:09:07.763
TradeActivity files query time: 0.000351 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:09:07.763
TradeActivity files query time: 0.000030 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:09:07.763
TradeActivity files query time: 0.000256 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:09:07.763
TradeActivity files query time: 0.000027 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:09:07.763
TradeActivity files query time: 0.000021 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:09:07.763
TradeActivity files query time: 0.000245 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:09:07.764
TradeActivity files query time: 0.000241 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:09:07.764
TradeActivity files query time: 0.000257 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:09:07.764
TradeActivity files query time: 0.000238 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:09:07.764
TradeActivity files query time: 0.000025 seconds. Entries: 0. Current queries: 11 | 2023-02-06 11:09:07.764
TradeActivity files query time: 0.000071 seconds. Entries: 0. Current queries: 1 | 2023-02-06 11:09:07.855
TradeActivity files query time: 0.000069 seconds. Entries: 0. Current queries: 1 | 2023-02-06 11:09:07.923


I agree with you that there should be a line or two in the Trade Service Log at the time the transactions happened, but there isn't anything. It skips right over it. This is what there is:

SC Data - All Services | MaxConnectionsForSameDevice = 3, NumCurrentConnectionsForSameDevice = 1 | 2023-02-02 06:20:35.147
Buy Entry | Signal ignored because 'Signal Only Once Per Bar' is enabled and a signal was already given from formula column for bar. | Cell: K3 | Bar start date-time: 2023-02-02 08:10:00 | 2023-02-02 08:10:03.255
Buy Exit (Sell) | Signal ignored because 'Signal Only Once Per Bar' is enabled and a signal was already given from formula column for bar. | Cell: L3 | Bar start date-time: 2023-02-02 08:10:00 | 2023-02-02 08:10:03.255
Buy Entry | Signal ignored because 'Signal Only Once Per Bar' is enabled and a signal was already given from formula column for bar. | Cell: K3 | Bar start date-time: 2023-02-02 08:10:00 | 2023-02-02 08:11:37.869
Buy Exit (Sell) | Signal ignored because 'Signal Only Once Per Bar' is enabled and a signal was already given from formula column for bar. | Cell: L3 | Bar start date-time: 2023-02-02 08:10:00 | 2023-02-02 08:11:37.869
Buy Entry | Signal ignored because 'Signal Only Once Per Bar' is enabled and a signal was already given from formula column for bar. | Cell: K3 | Bar start date-time: 2023-02-02 08:10:00 | 2023-02-02 08:11:46.920
Buy Exit (Sell) | Signal ignored because 'Signal Only Once Per Bar' is enabled and a signal was already given from formula column for bar. | Cell: L3 | Bar start date-time: 2023-02-02 08:10:00 | 2023-02-02 08:11:46.920
Buy Entry | Signal ignored because 'Signal Only Once Per Bar' is enabled and a signal was already given from formula column for bar. | Cell: K3 | Bar start date-time: 2023-02-02 08:10:00 | 2023-02-02 08:14:27.838
Buy Exit (Sell) | Signal ignored because 'Signal Only Once Per Bar' is enabled and a signal was already given from formula column for bar. | Cell: L3 | Bar start date-time: 2023-02-02 08:10:00 | 2023-02-02 08:14:27.838
Buy Entry | Signal ignored because 'Signal Only Once Per Bar' is enabled and a signal was already given from formula column for bar. | Cell: K3 | Bar start date-time: 2023-02-02 08:10:00 | 2023-02-02 08:14:57.440
Buy Exit (Sell) | Signal ignored because 'Signal Only Once Per Bar' is enabled and a signal was already given from formula column for bar. | Cell: L3 | Bar start date-time: 2023-02-02 08:10:00 | 2023-02-02 08:14:57.440


The only information I have about the transactions comes from the Trade Activity Log and on my statement from that day.