Login Page - Create Account

Support Board


Date/Time: Tue, 30 Apr 2024 02:07:49 +0000



Crossfrombelow

View Count: 1076

[2017-12-05 05:33:36]
toews&kane - Posts: 209
Hi,

I need a cell value to return TRUE when the price crosses a horizontal line such as period high.
How do I do this?


Cheers
[2017-12-05 06:11:06]
toews&kane - Posts: 209
O nevermind, found a old post by Tom from google
good to close for now

tomgilb - Posts: 1743
Try using formulas like these:

For a cross from below:
=AND(AC4>AA4,AA3>AC3)
For a cross from above:
=AND(AC4<AA4,AA3<AC3)
where AC is the horizontal line and AA is the moving average.
Notice that the only difference is the comparison operators.

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

Login

Login Page - Create Account