Support Board
Date/Time: Mon, 25 Nov 2024 14:49:37 +0000
Post From: Spreadsheet question
| [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 |