Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 14:51:16 +0000



[Programming Help] - Spreadsheet Swing Hi Lo issue

View Count: 204

[2023-12-01 11:41:15]
Nkrastins - Posts: 34
Hello,

I am having an issue with the spreadsheet logic.

I want to go long when the current close closes lower than the last 20 bar low,

my long command is: E3<AK4 (AK column is for Swing Low)

for exits, I use defined profit and stop targets.

But it doesn't pick any signals, any ideas?

Thanks
[2023-12-01 16:50:00]
Sawtooth - Posts: 4120
The Swing High and Low study only outputs a value at the swing high or swing low, and it only does it n bars after the fact.
So if you have the Length set to 20, it will 'repaint' that signal 20 bars ago.

But if that is still where you want the entry signal, you'll need to use a Formula Column to make the Swing Low persistent, like this in P3:
=IF(AK3>0,AK3,P4)

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

Login

Login Page - Create Account