Support Board
Date/Time: Wed, 05 Feb 2025 17:03:18 +0000
[User Discussion] - Spreadsheet filled when condition not met. Alert Mgr
View Count: 143
| [2025-01-07 15:40:57] |
| User484096 - Posts: 19 |
|
I am using version 2726 and I ran into a phantom filled today. When I review the alert manager, it stated "Formula: Buy Entry at Row 4 is true" I am using the Trading Evaluator account when this happened today. I tried to reproduce with reply chart but unable to reproduce it. O3: =AND($J$8 = 0, AND(FRACTIME(J41) >= TIMEVALUE("10:30:00"), FRACTIME(J41) < TIMEVALUE("15:30:00"))) K3 (buy entry): =AND(O3, Q3, AD3, AF3, T3, U3) Study | MNQH25[M] 5 Min #3 | FuturesNQ5Test | CWAlgo | Alert - Chart: MNQH25[M] 5 Min #3 | Study: CWAlgo | Formula: Buy Entry at Row 4 is true. | Last Price: 21602.50 | Bar start: 2025-01-07 10:00:00.000 | Bar end: 2025-01-07 10:04:59.990 | No alert sound/email. | 2025-01-07 10:05:00 |
| [2025-01-07 16:46:09] |
| John - SC Support - Posts: 37753 |
|
Our recommendation is to start the replay just before the time when the order was put in and step forward one trade at a time to see what exactly was occurring in your Spreadsheet. Refer to the following: Replaying Charts: Jump For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-01-08 01:05:27] |
| User484096 - Posts: 19 |
|
Stepped through 1 trade at a time and unable to reproduce in reply. What is strange is it stated "Formula: Buy Entry at Row 4 is true" I thought only row 3 condition get execute? |
| [2025-01-08 13:57:11] |
| Sawtooth - Posts: 4167 |
|
You must use an absolute reference for any column J references: =AND($J$8 = 0, AND(FRACTIME($J$41) >= TIMEVALUE("10:30:00"), FRACTIME($J$41) < TIMEVALUE("15:30:00"))) |
| [2025-01-18 22:58:21] |
| User370531 - Posts: 59 |
|
Have you found the issue? I also had a phantom fill, and see that the log stated "Formula: Buy Entry at Row 4 is true", which is strange because for the most recent (expected) fill before that, it said "Formula: Buy Entry at Row 3 is true", so I'm confused which it's checking.
|
| [2025-01-19 02:06:04] |
| User484096 - Posts: 19 |
|
No, I was unable to reproduce the issue in SIMS. I did what Sawtooth asked and make sure to use absolute reference for any column J references. |
| [2025-01-19 03:08:55] |
| Sawtooth - Posts: 4167 |
|
What is strange is it stated "Formula: Buy Entry at Row 4 is true"
If 'Signal Only On Bar Close' is set to Yes, row 4 is monitored.I thought only row 3 condition get execute? Spreadsheet Systems, Alerts and Automated Trading: Signal Only on Bar Close Also, it is helpful when troubleshooting to use the Details button in the upper right corner of the spreadsheet sheet. |
| [2025-01-19 09:11:42] |
| User370531 - Posts: 59 |
|
But then why would the most recent entry before that have said "Formula: Buy Entry at Row 3 is true"? Does that mean its monitoring both? I had 'Signal Only on Bar Close' for K-M set to No, but 'Strict Signal Only On Bar Close Evaluation' set to Yes. For what it's worth, my spreadsheet Buy Entry in column K is referencing another spreadsheet for another chart's data. |
| [2025-01-19 14:15:45] |
| Sawtooth - Posts: 4167 |
|
I had 'Signal Only on Bar Close' for K-M set to No, but 'Strict Signal Only On Bar Close Evaluation' set to Yes.
The latter is intended to work with the former set to Yes.The latter is used to assure rows 5 and greater are not ever monitored. IMO, the latter should only be set to Yes in very rare situations. Spreadsheet Systems, Alerts and Automated Trading: Strict Signal Only On Bar Close Evaluation |
| [2025-01-19 14:40:32] |
| User370531 - Posts: 59 |
|
I'm still not understanding why I got a signal with a log "Formula: Buy Entry at Row 3 is true", and then later got a signal with a log "Formula: Buy Entry at Row 4 is true". This suggests that both are being monitored. What am I missing?
|
| [2025-01-19 15:04:42] |
| Sawtooth - Posts: 4167 |
|
I'm still not understanding why I got a signal with a log "Formula: Buy Entry at Row 3 is true", and then later got a signal with a log "Formula: Buy Entry at Row 4 is true". This suggests that both are being monitored. What am I missing?
I don't know, but it could be because you have 'Strict Signal Only On Bar Close Evaluation' set to Yes.Set 'Strict Signal Only On Bar Close Evaluation' to No, and see if it happens again. Date Time Of Last Edit: 2025-01-19 15:21:28
|
| [2025-01-29 16:40:53] |
| User484096 - Posts: 19 |
|
SC support please look into this. I am running into this "Row 4 is true" issue when I am testing this in SIMS. The alert triggered when the 10:30 plotted (=AND($J$8 = 0, AND(FRACTIME($J$41) >= TIMEVALUE("10:30:00"), FRACTIME($J$41) < TIMEVALUE("15:30:00")))), but the beginning of the 10:30 would not trigger a trade on Row 3. Study | Replay 5.00X: MNQH25[M] 5 Min #3 | FuturesNQ5Test | CWAlgo | Alert - Chart: Replay 5.00X: MNQH25[M] 5 Min #3 | Study: CWAlgo | Formula: Sell Entry at Row 4 is true. | Last Price: 21367.50 | Bar start: 2025-01-27 10:25:00.000 | Bar end: 2025-01-27 10:29:59.995 | No alert sound/email. | 2025-01-29 11:32:15 I have attached the screenshots of the spreadsheet trading. Date Time Of Last Edit: 2025-01-29 16:45:37
|
 SpreadsheetSettings1.png / V - Attached On 2025-01-29 16:37:44 UTC - Size: 19.04 KB - 2 views SpreadsheetSettings2.png / V - Attached On 2025-01-29 16:37:46 UTC - Size: 15.94 KB - 3 views SpreadsheetSettings3.png / V - Attached On 2025-01-29 16:37:48 UTC - Size: 11.76 KB - 2 views |
To post a message in this thread, you need to log in with your Sierra Chart account: