Support Board
Date/Time: Thu, 12 Nov 2026 05:29:59 +0000
[Programming Help] - I need some help please.
View Count: 373
| [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. |
| [2026-09-27 14:42:41] |
| Sawtooth - Posts: 4361 |
|
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?
This could happen if the intrabar signal only occurred at the close of bar.IOW, no intrabar signal occurred during the formation of the bar. This is likely due to references to formula Columns L-Z, where you have Signal Only On Bar Close set to Yes. If this is the case, columns L,N can be isolated by using formulas referencing row 4, instead of row 3, (after setting Signal Only On Bar Close (Columns L-Z) to No). Date Time Of Last Edit: 2026-09-27 14:51:01
|
| [2026-10-29 06:43:17] |
| User301181 - Posts: 2 |
|
I am looking for a programmer for a project in c++ on Sierra, if interested please reply. David Dressel |
| [2026-10-29 13:38:10] |
| Sawtooth - Posts: 4361 |
|
I am looking for a programmer for a project in c++ on Sierra, if interested please reply.
https://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php
|
| [2026-10-29 13:41:03] |
| ForgivingComputers.com - Posts: 1251 |
|
I am looking for a programmer for a project in c++ on Sierra, if interested please reply.
I am interested: brad@forgivingcomputers.com. |
To post a message in this thread, you need to log in with your Sierra Chart account: