Login Page - Create Account

Support Board

Date/Time: Fri, 07 Aug 2020 10:00:12 +0000

[User Discussion] - Question about formula for attached orders

[2015-07-10 16:36:23]
User911705 - Posts: 89 | Ending Date: 2015-07-03 [Expired]

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]
Sierra Chart Engineering - Posts: 88421 | Ending Date: 2021-04-05
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. If possible please keep your questions brief and to the point. Please be aware of support policy:

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2015-07-11 01:33:23]
tomgilb - Posts: 2633 | Ending Date: 2020-12-03
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 | Ending Date: 2015-07-03 [Expired]
Dear tomgilb,

Thank you for your further clarification; very much appreciated!

To post a message in this thread, you need to login with your Sierra Chart account:


Login Page - Create Account