Support Board
Date/Time: Wed, 12 Feb 2025 18:55:50 +0000
Difference between Spreadsheet system for Trading Vs Spreadsheet system for Alert
View Count: 691
| [2020-10-26 19:17:25] |
| User837393 - Posts: 140 |
|
Hello, I'm wondering what is the difference between the two mentionned spreadsheets in the subject title. They both seem to have a buy and sell entry possibility. As a side note, I'm using the Spreadsheet System for Trading and I'm trying to implement a formula for an Alert on Colomn "O". The formula seems to work and returns either a "0" or "1". On the chart I can see in top right that the red highlighted spreadsheet name that the alert gets triggered, but I can not see on the chart the draw style that I've chosen for Colomn "O" in the Spreadsheet system for trading in the subgraph settings. Thank you for the assistance. Best regards. |
| [2020-10-26 22:21:59] |
| John - SC Support - Posts: 37910 |
|
As their titles state, the one is meant for trading and the other is meant for Alerts. There are some small differences in the data that is available within each one of them. As to why you are not seeing the information from your spreadsheet, you need to set the Input for Draw Zeros to Yes. This way you will have two values from which the scale can be set. Refer to the information here: Spreadsheet Study Inputs: Draw Zero Values For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-10-27 05:59:02] |
| |
|
Refer to the documentation here for these: Spreadsheet Systems, Alerts and Automated Trading: General Information but I can not see on the chart the draw style that I've chosen for Colomn "O" in the Spreadsheet system for trading in the subgraph settings. Check the Draw Style for that particular Subgraph:Chart Studies: Subgraphs Tab >> Draw Style 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: 2020-10-27 06:00:29
|
| [2020-10-27 13:36:37] |
| User837393 - Posts: 140 |
|
I'm not sure what I'm doing wrong but it still doesn't work. In the Spreadsheet system for Trading, Draw Zeros is set to Yes. Draw Style at (SG5 i.e. "O") is set to X with a font. Column "O" Returns 1 or 0 as per the following formula : = IF(ABS((BJ23)-(BL23)) >(7*0.5), 1, 0) Anything else I should check? EDIT : One thing I forgot to mention. If I set the Study Settings (ln:34) Column "O" to "Alert 1" rather then "No Alert Sound" I can hear the sound when the condition are met. That tels me the formula works as intended, but I don't understand why the Subgraph Draw style is not happening Date Time Of Last Edit: 2020-10-27 19:54:36
|
| [2020-10-28 04:41:05] |
| |
|
So you do not see anything displayed at all? Refer to: Spreadsheet Systems, Alerts and Automated Trading: Other Columns 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 |
| [2020-10-28 11:33:44] |
| User837393 - Posts: 140 |
|
Correct. I do not see anything. Strangely, like I said earlier, if I set the column O with Alert1, for example, I can hear the sound associated with Alert 1. Another strange thing, is when implement the same formula in Column L, then the draw style is displayed. |
| [2020-10-28 13:29:29] |
| John - SC Support - Posts: 37910 |
|
Is Column L set to draw as an "Arrow Up", or as an "X"? If you change it to "X" do you still see it? The only other thing we can think is that the color of X for Column O is set to be the same as your background color. Make sure that it is different. Also, make sure that you increase the Size of the subgraph. Make sure it is set to at least 10 to ensure that you are able to see it. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-10-28 15:03:12] |
| User837393 - Posts: 140 |
|
Problem solved!! Column O (and probably subsequent columns) are outputing a true value i.e if the result in one of the cell of Column O is 1 or 0 it will plot the draw style on the chart exactly at 0 or 1 on the Y axis for a given time frame (i.e. draw style will be located at the very bottom of the chart). It will not be plotted immediatly under the bar like it is for the K L M N column. ...probably a misunderstanding on my end. Thank you all for the support. |
| [2020-10-29 13:06:56] |
| John - SC Support - Posts: 37910 |
|
They are all being drawn at the same level, but when it is an arrow pointing Up or Down, the tip of the arrow is at the value, whereas the X has the center of the X drawn at the value.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-10-30 18:53:14] |
| User837393 - Posts: 140 |
|
I'm not sure if we're saying the same thing, but what I've noticed is that : Column K L M N when it returns 0 or 1 draw style is drawn at the candle bar. Column O and above, whichever value it returns the draw style is drawn at that value. So if value is 1 or 2 or 3 ... the draw style will be at the very bottom of the chart. |
| [2020-10-30 20:01:19] |
| John - SC Support - Posts: 37910 |
|
Sorry, you are correct. There is special handling for the Spreadsheet System for Trading and the Spreadsheet System for Alerts for columns K, L, M, and N where it draws these at the Low of the bar rather than at the actual value of the spreadsheet cell.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-11-02 22:51:12] |
| |
|
This is explained here: 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, *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: