Support Board
Date/Time: Wed, 15 Jan 2025 21:14:42 +0000
No trades when Signal Only On Bar Close (Columns K, M)is set to Yes.
View Count: 1321
| [2017-09-05 19:29:39] |
| User29926 - Posts: 92 |
|
No trades are placed when "Signal Only On Bar Close" is set to Yes, even tho a "1" shows in cell 3. I also have "Reset Condition On New Bar" set to Yes. Trade Service Logs says: Buy Entry | Signal ignored because current Alert Condition is FALSE | Bar start date-time: 2017-08-04 10:11:57 | 2017-09-05 15:18:56 Spreadsheet will only place a trade if "Signal Only On Bar Close" is set to No. |
| [2017-09-05 19:32:59] |
| |
|
Refer to the documentation here: Spreadsheet Systems, Alerts and Automated Trading: Ignored Signals With Spreadsheet Systems or Alerts You need to look at row 4. Not 3. 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-05 20:35:55] |
| User29926 - Posts: 92 |
|
You need to look at row 4. Not 3.
Row 4 of what column?This is my entry buy signal and its not complicated. =AND (H54 <>0, $J$8 =0, H64 = 1,(H54 - H56) < $H$68, $E$3> H54) The "H" cells hold values from an indicator and they don't change until the next trading session Date Time Of Last Edit: 2017-09-05 20:40:32
|
| [2017-09-05 20:52:46] |
| |
|
The column will be whatever column is containing the formula but this would need to be column K, L, M or N.
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-05 21:05:01] |
| Sawtooth - Posts: 4153 |
|
Your references to cells in column H will need to be absolute references, using the $. For example, H54 will be H55 in row 4, which is the row used for close-of-bar entries. This is why when Signal Only On Bar Close is No you get entries and when Yes you do not. |
| [2017-09-06 19:44:58] |
| User29926 - Posts: 92 |
|
Thanks tomgilb. I added the "$" and that worked. Being so frustrated with trying to get the spreadsheet to work correctly. I overlooked that. Dumb me. Much appreciated for your assistance. Date Time Of Last Edit: 2017-09-06 19:47:20
|
To post a message in this thread, you need to log in with your Sierra Chart account: