Support Board
Date/Time: Tue, 10 Mar 2026 19:45:34 +0000
[Programming Help] - Spreadsheet Trading Buy Entry Has a 1 and get no Trade Execution
View Count: 20
| [2026-03-10 16:39:10] |
| Czubdaddy - Posts: 9 |
|
I have been debugging this for a week, on and off. I've read through the troubleshooting guide but I am missing something. My buy formula looks like this: =AND( $J$10=0, ID8.SG1@3=1,ID7.SG1@3 > ID7.SG1@6, ID3.SG1@3 > ID3.SG1@6, ID2.SG1@3 > ID3.SG1@3, E3 > ID5.SG1@3,C3 > C4,V3=1) All my helper columns have a 1 in them and Column K Buy Entry for a long has a one. There is an up arrow on my chart (and I know this doesn't guarantee an entry) I've done all of this: Send Orders to Trade Service" must be "Yes": In the Spreadsheet System for Trading study settings, ensure that "Send Orders to Trade Service" is set to Yes Turn off Simulation Mode: Trade >> Trade Simulation Mode On Enable Global Auto Trading: Go to Trade >> Auto Trading Enabled Enable Chart Auto Trading: Ensure Trade >> Auto Trading Enabled Verify Trading Account: Ensure you are connected to your live trading account Ensure all formulas in your spreadsheet are calculated before the Spreadsheet System for Trading study tries to read them I can complete a trade using the chart. I have simplified my formula to go in and out using a simple moving average slope, and the trade executes fine. I have rebuilt my entire spreadsheet from scratch I get no message about a failed trade in trade service log or Message Log Simulated trading works fine. Signal Only Once Per Bar is set to Yes Reset Condition On New Bar set to Yes I really want to enter the trade on a tick level. What am I missing? What other steps can I take to debug? I have enhanced logging on now to see if I can find something. The only thing I found so far is: 2026-03-10 11:34:35.345 | MNQH26_FUT_CME [CBV][M] 1 Min #1 | AITrading | Not evaluating trade signals because is full recalculation. I do have a price overlay study on my 1 min chart referencing my 15 min chart. I wonder how often it is recalculated. It would be a fluke if it were recalculating during a buy signal. But the fact that I have missed multiple buy signals can't be all due to a recalculation. Date Time Of Last Edit: 2026-03-10 16:48:38
|
To post a message in this thread, you need to log in with your Sierra Chart account: