Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 12:32:38 +0000



No column for close

View Count: 1066

[2014-02-13 15:53:42]
Tonkadad - Posts: 235
How do I reference the close of a bar in the spreadsheet system/alert.

I want an arrow every time the close of a bar is above moving average.
[2014-02-13 17:24:56]
Sawtooth - Posts: 3976
Try this:

=AND(E4<AA4,E3>AA3)

where AA is the moving avg

This will alert on the first crossing.
[2014-02-13 17:45:28]
Tonkadad - Posts: 235
Thanks Tom, the last is the same as the close?
[2014-02-13 18:47:16]
Sierra Chart Engineering - Posts: 104368
Use the E column.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2014-02-13 20:38:14]
Sawtooth - Posts: 3976
Thanks Tom, the last is the same as the close?
Yes

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

Login

Login Page - Create Account