Support Board
Date/Time: Mon, 25 Nov 2024 14:55:59 +0000
No column for close
View Count: 1121
| [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: 4120 |
|
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] |
| |
|
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: 4120 |
|
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: