Home >> Support Board

Support Board

Date/Time: Fri, 07 Feb 2025 18:16:04 +0000

How to Post a Message for Support

Spreadsheet System/Alert

View Count: 500

[2023-06-03 22:30:53] #1 [Go To First Post]
Nicolas Leclercq - Posts: 22
Hi, 1. I made an Alert formula in a Color Bar Based on Alert Condition study,thats great its work ^^ : it is dispayed the SG1 2. I want to add this Alert in a spreadsheet SystemAlert, in order to detect when the SG1 of the ColorBarBasedonAlertCondition displayed on Chart, because i want to implement the column K : "Buy Entry" with the SG1 displayed 3. The trade will be begin with this Buy Entry Question: In the spreadsheet, thers is no value in the column "SG1 Color Bar", i thought to see 0 (for false=SG1 no displayed) // 1 (for true=SG1 displayed on the chart) I need help please Thanks Nico


SharedScreenshot.jpg / V - Attached On 2023-06-03 22:29:47 UTC - Size: 58.76 KB - 135 views Attachment Deleted.

[2023-06-04 13:59:19] #2 [Go To First Post]
j4ytr4der_ - Posts: 946
This is hard to troubleshoot just from your description alone. Would help a lot to see whatever formulas you are using currently. Alert Formula syntax is slightly different from Spreadsheet syntax, so that's a consideration as well. Make sure also that the study you want to include has the "include in Spreadsheet" box ticked, and the subgraph is not set to ignore, if you also use the "Do not output studies set to ignore" option in the spreadsheet (which I always do, personally)

[2023-06-05 06:42:08] #3 [Go To First Post]
Nicolas Leclercq - Posts: 22
Hi j4ytr4der_, Thanks for replying, it works with "Do not output studies set to ignore" to YES ^^ I've got another question: i want to automate my spreadsheet alert with "Spreadsheet for Trading"...my Buy/Sell Entry works with the good syntax in K3 and M3, and want to trade out with the Trade Window (with stop and BE strategy) But when I replay, the order doesnt fill (but in my spreadsheet Trading: I see K3=1 or M3=1) sees screenshot Thnks for your help Nico


Attachment Deleted. TradeWindow.png / V - Attached On 2023-06-05 06:41:59 UTC - Size: 150.35 KB - 95 views

[2023-06-05 08:37:31] #4 [Go To First Post]
Sierra_Chart Engineering - Posts: 18330
Do you still need help with this: Question: In the spreadsheet, thers is no value in the column "SG1 Color Bar", i thought to see 0 (for false=SG1 no displayed) // 1 (for true=SG1 displayed on the chart) Scroll down through that column to see if you see any data because the Color Bar Based on Alert Condition study does not calculate from the very beginning of the chart. It has a Number of Bars to Calculate input.: Color Bar Based on Alert Condition: Number of Bars to Calculate Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account: