Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 23 Apr 2024 18:56:14 +0000
[User Discussion] - Help: Contradictory signal between the chart and the spreadsheet
View Count: 528
| [2020-01-20 08:22:55] |
| sourdubber - Posts: 52 |
|
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
|
 spreadsheet.jpg / V - Attached On 2020-01-20 08:25:19 UTC - Size: 52.32 KB - 239 views |
| [2020-01-20 18:03:28] |
| Sawtooth - Posts: 3976 |
|
Do you have 'Signal Only On Bar Close, (Columns K,M)' set to No?
|
| [2020-01-20 20:48:36] |
| sourdubber - Posts: 52 |
|
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] |
| Sawtooth - Posts: 3976 |
|
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. Spreadsheet Systems, Alerts and Automated Trading: Signal Only on Bar Close |
| [2020-01-20 22:03:58] |
| sourdubber - Posts: 52 |
|
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 log in with your Sierra Chart account: