Login Page - Create Account

Support Board


Date/Time: Fri, 10 Jan 2025 16:17:01 +0000



How to create simple buy order in spreadsheet trading?

View Count: 808

[2016-08-18 14:09:27]
User600819 - Posts: 43
I'm trading a 5 minute bar chart. The signal is ID3.SG3 for Long Entry and ID3.SG4 for Short Entry. How do I create the syntax in spreadsheet trading to say "go long at next bar open after previous bar gives ID3.SG3 signal?". I've attached a screenshot. I want to go long after the red volume bar. I can't seem to figure it out.

Thanks!
Private File
[2016-08-18 17:54:25]
Sierra Chart Engineering - Posts: 104368
You need to set this Spreadsheet System for Trading study Input to Yes:
http://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#SignalOnlyonBarClose
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, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2016-09-16 19:43:02
[2016-09-16 19:34:59]
User600819 - Posts: 43
I am still unclear how to create a buy signal. I understand inputting yes so the trade initiates after the close of the previous bar. From the attachment my signals are based on volume which are highlighted. What do I put in the spreadsheet trading to say go long after volume bar turns red? IG3.SG3 is a red volume bar. I know how to initiate entries for moving average crosses or if price crosses a level but I don't know how to enter entries based on when volume turns a specific color. Thanks so much
[2016-09-16 19:44:48]
Sierra Chart Engineering - Posts: 104368
There was a slight mistake in post #2, it was meant to say:
You need to set this Spreadsheet System for Trading study Input to Yes:
http://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#SignalOnlyonBarClose

You can only work with actual numeric values. Not colors.
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, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2016-09-16 19:45:16

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

Login

Login Page - Create Account