Login Page - Create Account

Support Board


Date/Time: Tue, 26 Aug 2025 23:14:06 +0000



Post From: auto trading signal is not recognized

[2025-05-15 11:24:44]
User546613 - Posts: 12
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