Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 10:46:24 +0000



How to print spreadsheet alert/system columns o-z drawings near current price and not at 1.0000

View Count: 862

[2014-11-28 09:43:40]
4646ed - Posts: 230
I put a spreadsheet system/alert on a chart of the EURUSD, put formulas in columns K thru N -- their drawings display correctly above or below the highs or lows. I put formulas in column "O" or "P" and they display down at 1.000. How do I change this?
I already changed the value format setting to .0001 for all the studies involved, but that doesn't help either.
[2014-11-28 10:09:11]
Sierra Chart Engineering - Posts: 104368
What you need to do is have the formula return the High or Low for the bar.

For example you can use a formula similar to the following to put an arrow on the high:
=IF(E3 >1.3000, C3, FALSE)
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
Date Time Of Last Edit: 2014-11-28 10:10:03
[2014-11-28 21:05:08]
Sierra Chart Engineering - Posts: 104368
The documentation will be updated to explain this.
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

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

Login

Login Page - Create Account