Support Board
Date/Time: Mon, 04 May 2026 23:36:06 +0000
[Programming Help] - Spreadsheet Trading Buy Entry Has a 1 and get no Trade Execution
View Count: 189
| [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. Update: I kept adding one piece of my buy formula at a time until one of them caused the formula not to work. Here is the offending formula: =(C3-D3) > 1.2 * AVERAGE(C4-D4, C5-D5, C6-D6, C7-D7, C8-D8, C9-D9, C10-D10, C11-D11, C12-D12, C13-D13, C14-D14, C15-D15, C16-D16, C17-D17, C18-D18, C19-D19, C20-D20, C21-D21, C22-D22, C23-D23) I am going to shorten the formula with the use of another helper column and then try this instead: =IF(S4 > 1.2 * AVERAGE(S5:S24),1,0) Date Time Of Last Edit: 2026-03-11 00:40:35
|
| [2026-03-11 03:08:24] |
| Sawtooth - Posts: 4328 |
|
Try these: - Rearrange the studies in the Studies to Graph list so that they are in calc order. - Experiment with the ln:12 and ln:13 settings in the Study/Price Overlay study. - Temporarily remove the reference to the Study/Price Overlay study in your entry formula. Date Time Of Last Edit: 2026-03-11 03:11:24
|
To post a message in this thread, you need to log in with your Sierra Chart account: