Support Board
Date/Time: Thu, 28 Nov 2024 22:38:26 +0000
Post From: Spreadsheet System for Trading sending Entry and Exit orders without proper Signal
| [2023-03-13 23:28:17] |
| PeaceFrog - Posts: 105 |
|
Hi John. Thank you for responding so quickly. First, thank you for clarifying that the “Trade Service Log” only gives information when there is an issue – Got it. Thanks. Second, the Replay I’m running is “Calculate At Every Tick/Trade (High CPU Usage)”. I figure this is the most accurate Replay to use to replicate Real-Time, is it not? The cell itself isn’t showing “(not evaluated)”. I see “(not evaluated)” when I have the Replay paused and when I “Jump” “By Number of Trades” Unit “1” from “2023-03-13 04:08:10” (this takes 4 click) to "2023-03-13 04:08:11", then I go to cell O3 where I have an “IF Statement” formula and click on the “Details” button which brings up a window with the formula tree in it, and I see “(not evaluated)” at one of the formula variables/parameters, which means the conditions to signal Yes are not met. (I have a formula in K3, that says, if O3=1,1……. And I have this because I have formulas in P3 and Q3). As I mentioned, later in day the Trade Service Log shows another “Auto-Trade” entry but there are 2 more “Auto-trade” entries: The one I posted about previously: Auto-trade: F.US.CA6M23[M] 15 Min #2 | CA6 - H11-Z22 - 1545ADX-2 Cont | BuyEntry | Bar start date-time: 2023-03-13 05:00:00.000 | BuyEntry signal is ignored because maximum Long Position quantity allowed has been reached or would be exceeded with new order. Max. Position allowed: 1. Resulting Position without working orders: 2. Resulting Position with all working orders except exits: 2. Resulting Position with Market working orders: 2 | 2023-03-13 05:00:35.284 And the other two: Auto-trade: F.US.CA6M23[M] 15 Min #2 | CA6 - H11-Z22 - 1545ADX-2 Cont | BuyEntry | Bar start date-time: 2023-03-13 05:15:00.000 | BuyEntry signal is ignored because maximum Long Position quantity allowed has been reached or would be exceeded with new order. Max. Position allowed: 1. Resulting Position without working orders: 2. Resulting Position with all working orders except exits: 2. Resulting Position with Market working orders: 2 | 2023-03-13 05:15:00.365, and Auto-trade: F.US.CA6M23[M] 15 Min #2 | CA6 - H11-Z22 - 1545ADX-2 Cont | BuyEntry | Bar start date-time: 2023-03-13 05:30:00.000 | BuyEntry signal is ignored because maximum Long Position quantity allowed has been reached or would be exceeded with new order. Max. Position allowed: 1. Resulting Position without working orders: 2. Resulting Position with all working orders except exits: 2. Resulting Position with Market working orders: 2 | 2023-03-13 05:30:00.396 When I replay the chart, I can only get the “Auto-Entry at 2023-03-13 05:00:35.284” to return a Signal, which is good because it meets the formula criteria. Again using Replay “Calculate At Every Tick/Trade (High CPU Usage). I’ve tried a variety of different speeds to get the other 2 to signal and they don’t and, according to the formulas in my spreadsheet, they shouldn’t. So, like the case at “04:08:11.097103”, in Replay “05:15:00.365” and “05:30:00.396” don’t signal and shouldn’t, yet when Live the System sent or attempts to send orders. |