Support Board
Date/Time: Sun, 25 May 2025 15:26:09 +0000
Value on High or Low From Spreadsheet Alert Study
View Count: 1495
| [2014-09-17 03:52:34] |
| User29419 - Posts: 19 |
|
I am using a spreadsheet alert study to display TICK or NISS at swing highs or lows on the main price graph. I have 2 questions. 1. When using display value on low or high in the spreadsheet alert study is there a way to offset the value so is doesn't cover the high or low (offest a tick or two higher/lower)? 2. In the spreadsheet study I have the numbers formatted with 0 decimal places, but when the value is displayed on the price graph it displays with 2 decimals. How do I remove the decimal places in the chart display. Thanks |
| [2014-09-17 05:57:49] |
| Sawtooth - Posts: 4220 |
|
1. When using display value on low or high in the spreadsheet alert study is there a way to offset the value so is doesn't cover the high or low (offest a tick or two higher/lower)? +1 |
| [2014-09-18 02:29:44] |
| User29419 - Posts: 19 |
|
+1 to what? If the value of NISS-SP is 27 and I add +1 to that value, how does it change being printed at the high of bar showing the price of ES at 1993?
|
| [2014-09-18 03:29:22] |
| |
|
The prior post was from a user. Not from Sierra Chart Support.
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-09-18 05:12:13] |
| |
|
1. We will look into this. 2. You need to set the Value Format for the Spreadsheet Study: Changing the Price/Value Display Format 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 |
| [2022-05-01 20:19:46] |
| John M - Posts: 171 |
|
Hello Sierra Engineering, Have you come to any conclusion about adjusting the offset for an alert indicator from a spreadsheet alert, per the OPs original inquiry? ******************** I am using a spreadsheet alert study to display TICK or NISS at swing highs or lows on the main price graph. I have 2 questions. 1. When using display value on low or high in the spreadsheet alert study is there a way to offset the value so is doesn't cover the high or low (offest a tick or two higher/lower)? ******************** It would be really great if there was, thank you! |
| [2022-05-06 12:13:07] |
| Sierra_Chart Engineering - Posts: 19695 |
|
Yes you have full control over this. Refer to: Spreadsheet Systems, Alerts and Automated Trading: Controlling the Location of Arrows or Subgraph Values 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2022-05-06 12:13:40
|
| [2022-05-06 17:13:50] |
| Sawtooth - Posts: 4220 |
|
Yes you have full control over this
Actually, the user can only use a spreadsheet formula to offset arrows and other non-zero markers, not the values returned by the formula.... is there a way to offset the value ... a tick or two higher/lower?
You can use the Study Subgraph Above/Below Bar As Text study, referencing the spreadsheet column/subgraph.
Date Time Of Last Edit: 2022-05-06 19:35:22
|
| [2023-05-28 16:33:29] |
| user_xyz - Posts: 481 |
|
#1 - In regards to OP #2 - Is it possible to display two different decimal place signals on same chart. 1a. Column S signals an alert and displays 72.87 (crude oil) 1b. Column T counts numbers of signals and want to display '6' for qty of signals triggered. Currently can only get '6.00' #2 - In 1a example is it possible to include Draw Style Diamond and Text Value on every alert? If I select Diamond and enable Value Label the text only displays latest value and previous text gets removed. #3 - Is vertical displacement of any signals (character or text) possible in Spreadsheet Studies? Date Time Of Last Edit: 2023-05-28 16:35:20
|
To post a message in this thread, you need to log in with your Sierra Chart account: