Support Board
Date/Time: Wed, 15 Jan 2025 21:58:58 +0000
Exit Position on at Close of Bar in Spreadsheet Trading
View Count: 2207
| [2017-09-14 02:18:27] |
| User119315 - Posts: 11 |
|
In Spreadsheet System for Trading, I'm trying to make my Buy and Sell Exit triggers be the Close of the current bar (open of next bar would be acceptable, but not preferred). That's it. This is a frustrating one, because it is probably a simple solution. Thanks to anyone who can give me a hand on this! |
| [2017-09-14 17:09:40] |
| User29926 - Posts: 92 |
|
Spreadsheet Systems, Alerts and Automated Trading: Spreadsheet Calculations and Spreadsheet Study Processing of Spreadsheet Data or a quick search of the site: https://www.sierrachart.com/index.php?page=doc%2FGoogleSearch.php&q=close+of+bar Date Time Of Last Edit: 2017-09-14 17:14:51
|
| [2017-09-14 18:09:28] |
| |
|
Set this Input with the Spreadsheet System for Trading study to Yes: http://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.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: 2017-09-14 20:46:53
|
| [2017-09-14 18:57:14] |
| User119315 - Posts: 11 |
|
Thanks for the replies. I may not have been clear. I want the exit trigger to be the close of the bar itself, no other condition is involved. In a search, I found another user who was trying to accomplish the same thing suggest this: Buy Exit =$J$5>0 Sell Exit =$J$5<0 I have not had success I do have "Signal Only on Bar Close" set to Yes |
| [2017-09-14 19:14:57] |
| User29926 - Posts: 92 |
|
Have you tried "Reset Condition On New Bar" to "Yes"?
|
| [2017-09-14 20:47:36] |
| |
|
The link we gave previously was not correct. This is the link we meant to give: http://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.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 |
| [2017-09-14 21:10:27] |
| User119315 - Posts: 11 |
|
Okay I finally got this. I really appreciate the help from you two. In case anyone needs this info later on, this is what I have. Signal Only on Bar Close columns L, N-Z changed to YES Reset Condition On New Bar to YES The Buy and Sell Exit signal just need to be any TRUE statement, such as =B3>0 |
To post a message in this thread, you need to log in with your Sierra Chart account: