Support Board
Date/Time: Mon, 25 Nov 2024 12:17:12 +0000
[User Discussion] - Spreadsheet question
View Count: 134
| [2024-03-04 20:48:01] |
| User744218 - Posts: 15 |
|
Greetings. I am not sure where I am going wrong. 1) I want a Buy open and Buy Close as shown in the picture but its not working. I read the documentation and forums and updated them, but still... 2) The intent is to open an order if the value is below 112 3.5/32 and Close at 112 14.5/32 3) AA3 is the value from a indicator Thanks so much! Date Time Of Last Edit: 2024-03-04 20:48:42
|
 buy limt SC.jpg / V - Attached On 2024-03-04 20:47:31 UTC - Size: 1.19 MB - 54 views |
| [2024-03-04 23:51:38] |
| Sawtooth - Posts: 4120 |
|
I am not sure where I am going wrong.
Signals are in columns K3-N3 Prices are in J22-J25 Order types are in J71-J74 Columns K-N are the signal columns and need a non-zero value at the bar/row where you want the signal, not in every row. A TRUE signal must follow a FALSE signal. Create a formula in Column O or higher, and then reverence it with another formula in K3 that goes TRUE when you want. Where is price when the value is below 112 3.5/32 ? If price is below the value, use a Buy Stop, if it's above the value, use a Buy Limit. If it could be either, use a conditional IF statement in cell J71. If you are entering/exiting a position intrabar, be sure to set 'Signal Only On Bar Close' to No. If you have 'Signal Only Once Per Bar' set to Yes, be aware of this: Spreadsheet Systems, Alerts and Automated Trading: Signal Only Once per Bar |
To post a message in this thread, you need to log in with your Sierra Chart account: