Support Board
Date/Time: Sat, 26 Sep 2026 18:57:30 +0000
Post From: I need some help please.
| [2026-09-26 16:27:09] |
| Jedi Skywalker - Posts: 1 |
|
Hello there. Currently I am using SIERRACHART Version 2953. Here is my question. Subject: Live Buy/Sell Entry order firing from Row 4 despite Signal Only On Bar Close (K,M) = No I have a Spreadsheet System study (based on DefaultSpreadsheetSystemForTradingStudy.scss) on a 5-minute MNQZ26 chart doing automated entries/exits with martingale position sizing. My entry logic lives in K3 (Buy Entry) and M3 (Sell Entry); exits live in L3 (Buy Exit) and N3 (Sell Exit). Study settings for reference: Signal Only On Bar Close (Columns K, M) = No Signal Only On Bar Close (Columns L-Z) = Yes Reset Condition On New Bar = Yes Allow Multiple Entries in Same Direction = No Signal Only Once Per Bar = Yes I understand from your documentation and Support Board Thread #40985 that the spreadsheet automatically copies formulas from row 3 down into subsequent rows (row 4, row 5, etc.) as new bars form, and that this is standard, intentional behavior — not something I should try to prevent by clearing those rows. My question is about which row actually triggers a live order. My Trade Activity Log shows entries like this (real, filled orders — not just chart arrows): 2026-09-25 06:00:00.017 SellEntry Formula: Sell Entry at Row 4 is true. Bar start date-time: 2026-09-25 05:55:00.000 Quantity 2 Open -2 Given that Signal Only On Bar Close is set to No for columns K and M, my understanding was that only the current/live row (row 3) should be able to trigger a live Buy/Sell Entry order, and that row 4's copy of the K/M formulas would just be historical/cosmetic. But the log clearly shows a real position being opened with the formula explicitly attributed to "Row 4." Can you clarify: Under what circumstances can a live Buy Entry / Sell Entry order actually be triggered from a row other than row 3, when Signal Only On Bar Close (Columns K, M) is set to No? Is there a setting that restricts live order placement strictly to row 3 for the K/M columns, so that only one row can ever be the source of a real entry order? This matters because I have separate fixes applied to K3/M3 (a blackout/trading-window filter) that I need to be certain are the only formulas capable of placing live entries — I want to rule out row 4 acting as an independent, un-filtered source of entries. Thanks for your help. |