Login Page - Create Account

Support Board


Date/Time: Thu, 27 Feb 2020 06:14:17 +0000



[User Discussion] - Help: Contradictory signal between the chart and the spreadsheet

[2020-01-20 08:22:55]
sourdubber - Posts: 47 | Ending Date: 2019-11-06 [Expired]
I got a sell signal on the chart tonight but no signal was indicated for that time in the spreadsheet. In fact, it doesn't conform to the rule and it shouldn't have been there. Please see the attached pics. I really would like an explanation.
Date Time Of Last Edit: 2020-01-20 08:25:24
imagechart.jpg / V - Attached On 2020-01-20 08:20:35 UTC - Size: 22.6 KB - 39 views
imagespreadsheet.jpg / V - Attached On 2020-01-20 08:25:19 UTC - Size: 52.32 KB - 35 views
[2020-01-20 18:03:28]
tomgilb - Posts: 2384 | Ending Date: 2020-02-29
Do you have 'Signal Only On Bar Close, (Columns K,M)' set to No?
[2020-01-20 20:48:36]
sourdubber - Posts: 47 | Ending Date: 2019-11-06 [Expired]
Do you have 'Signal Only On Bar Close, (Columns K,M)' set to No?

Correct, it's set to no, because I want to enter at open.
[2020-01-20 21:17:51]
tomgilb - Posts: 2384 | Ending Date: 2020-02-29
Correct, it's set to no, because I want to enter at open
Then the conditions were true at some point intrabar but not at the close of the bar.
All arrows are relative to the Last of the current bar, or the close of previous bars.

With 'Signal Only On Bar Close set to No, the signal will be the first occurrence intrabar, not necessarily exactly at the open.

If you want an entry exactly at the open of a bar, set 'Signal Only On Bar Close, (Columns K,M)' to Yes, and write formulas that reference row 3, not row 4.
This puts the arrow on the bar where the signal was true at the close, but the entry is at the open of the subsequent bar.

https://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.php#SignalOnlyonBarClose
[2020-01-20 22:03:58]
sourdubber - Posts: 47 | Ending Date: 2019-11-06 [Expired]
If you want an entry exactly at the open of a bar, set 'Signal Only On Bar Close, (Columns K,M)' to Yes, and write formulas that reference row 3, not row 4.
This puts the arrow on the bar where the signal was true at the close, but the entry is at the open of the subsequent bar.

Thanks for the explanation. I don't believe I had any problem with this up till now.

There is one issue however. I am using a displaced moving average in my formula. Because of this, I am using both row 4 and row 3. Could the displacement be the cause of the problem?


Edit: I just ran the replay from last night but I do not see the sell signal. I believe I will go insane before all this is done. :)
Date Time Of Last Edit: 2020-01-20 22:13:30

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

Login

Login Page - Create Account