Support Board
Date/Time: Mon, 16 Jun 2025 01:11:47 +0000
auto trading signal is not recognized
View Count: 261
| [2025-05-15 11:24:44] |
| User546613 - Posts: 10 |
|
Hello Sierra Chart Support, I am building a very basic spreadsheet-based trading bot using the “Spreadsheet System for Trading”. Everything seems correctly configured, but the system does not execute any trades even though the entry signal (K1 = 1) is visibly triggered. Here is what I’ve confirmed: ✅ Configuration: Spreadsheet Name: ResetMiniBot_Trigger Formula in K1: =IF(BA3 >= AB1, 1, 0) Trigger value in AB1: e.g. 5899 Price in BA3 updates correctly and exceeds the trigger K1 becomes 1 (visibly) Auto-Trading is enabled: Global and Per Chart Study Settings: Use Column I and J Values Version 2 = Yes Signal Only On Bar Close = No Send Orders to Trade Service = Yes Order Quantity in Chart: 1 No open position No error or message appears in the “Auto Trade System Information” window No trade is executed No arrow appears in the chart ❗ Problem: Even though K1 = 1, and all settings appear correct, the system does not react: No buy order is submitted No trade log entry No visual signal (arrow) No feedback in Auto Trade System Info ❓Question: Can you please help me understand: Why Sierra Chart is not recognizing K1 = 1 as a Buy Entry signal? Could there be a hidden conflict or technical condition (e.g. Spreadsheet not linked properly to the chart)? Is there a diagnostic or log I can use to confirm if the study is correctly responding to the spreadsheet signals? Thank you very much for your support. Best regards, Markus Hirsbrunner |
| [2025-05-15 12:50:54] |
| Sawtooth - Posts: 4227 |
|
K3 is the trigger cell, not K1. Put your formula in K3: =IF(BA3 >= AB1, 1, 0) Also, you don't need to use the IF statement for a boolean result: =BA3 >= AB1 |
To post a message in this thread, you need to log in with your Sierra Chart account: