Login Page - Create Account

Support Board


Date/Time: Sun, 21 Oct 2018 20:03:41 +0000



Crossfrombelow

Support Request:
[2017-12-05 05:33:36]
toews&kane - Posts: 176
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: 176
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 login with your Sierra Chart account:

Login


Login Page - Create Account