Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 20 Apr 2024 10:46:59 +0000
[User Discussion] - Question about formula for attached orders
View Count: 717
| [2015-07-10 16:36:23] |
| User911705 - Posts: 89 |
|
Hello, I have a question that is best exhibited by giving you a scenario. I have a spreadsheet study for trading. The entry and the attached orders are based on bar close. For a short trade, the stop offset is the upper bollinger band minus the last price. I have this set for the formula in J81 (Attached Order Stop Offset). The question is about what row I should be referencing. If I want the offset to be based on a calculation from the same bar as the entry signal AND considering the signal is end of bar; then does that mean I actually need to do the formula based on row 4? I think that might be the case because according to the documentation, the entry for a end of bar signal is actually looking at row 4, not row 3. |
| [2015-07-10 18:02:53] |
| |
|
You could use row 4 and your understanding is correct about this, but Sierra Chart will always fill orders using the latest trade price.
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 |
| [2015-07-11 01:33:23] |
| Sawtooth - Posts: 3976 |
|
For close of bar signals in columns K-Z...BR: If Signal Only On Bar Close is set to No, reference row 4. If Signal Only On Bar Close is set to Yes, reference row 3. For close of bar signals, formulas in column J must always reference row 4, regardless of the above setting. Date Time Of Last Edit: 2015-07-11 01:43:07
|
| [2015-07-11 13:57:26] |
| User911705 - Posts: 89 |
|
Dear tomgilb, Thank you for your further clarification; very much appreciated! |
To post a message in this thread, you need to log in with your Sierra Chart account: