Support Board
Date/Time: Thu, 13 Feb 2025 08:01:57 +0000
[Programming Help] - How to Use Slope for Trade Signal
View Count: 517
| [2020-11-21 05:58:30] |
| User440656 - Posts: 14 |
|
Hello, I have a spreadsheet study that I would like to generate a sell entry when the time is greater than 07:00:00 Pacific time and the 21 period EMA is sloping downward. This is what I have for the sell entry: =AND(FRACTIME(MROUND(A3,1/86400))>TIMEVALUE("07:00:00"),SLOPE(E3:E12,AA3:AA12)<0) However, it does not work. The sell entry is always executed at 07:00:00. How should I change it so that entry does not occur until the 21 period EMA is sloping down? Please let me know. Thank you. |
Attachment Deleted.  buyclose.scss - Attached On 2020-11-21 05:56:49 UTC - Size: 4.58 KB - 372 views ExampleChartbook.cht - Attached On 2020-11-21 05:56:59 UTC - Size: 3.9 KB - 348 views |
| [2020-11-21 13:24:56] |
| Sawtooth - Posts: 4173 |
|
Try this: =AND(FRACTIME(MROUND(A3,1/86400))>TIMEVALUE("07:00:00"),SLOPE(AA3:AA4,A3:A4)<0) This will give you lots of entry arrows. To only plot the first time it occurs/recurs: =AND(FRACTIME(MROUND(A3,1/86400))>TIMEVALUE("07:00:00"),SLOPE(AA3:AA4,A3:A4)<0,SLOPE(AA4:AA5,A4:A5)>0) This finds each time the slope changes from + to - |
| [2020-11-23 17:59:24] |
| User440656 - Posts: 14 |
|
Thank you. That is working for me.
|
To post a message in this thread, you need to log in with your Sierra Chart account: