Support Board
Date/Time: Thu, 28 Nov 2024 03:52:18 +0000
spreadsheet formula multiple graph
View Count: 328
| [2023-06-07 12:42:20] |
| User278398 - Posts: 291 |
|
hello, i need in spreadsheet formula study get formula i have write as a graph (=av-bv) and get another line (value is 0) in the same spreadsheet formula study how can i do it ? |
1.png| [2023-06-07 12:45:28] |
| User278398 - Posts: 291 |
|
if there is no option for it, maybe there is option to get a horizontal line on value 0 at "left side scale" ? regards |
| [2023-06-07 12:49:58] |
| User278398 - Posts: 291 |
|
sorry about that... beside line on level 0, i need more horizontal line at other values if it can (like on level 10000 ) |
| [2023-06-07 14:16:19] |
| John - SC Support - Posts: 36350 |
|
If you are wanting additional lines in the same region as the Spreadsheet Formula, then you just need to add these as additional studies that are in the same region. For instance, you can add the "Horizontal Lines" study and define additional lines at various levels. Just make sure the "Region" is set to the same region as the Spreadsheet Formula and that the Scale is either set to "Automatic" or "Same as Region". Refer to the following: Chart Studies: Settings and Inputs Tab >> Chart Region Chart Scale and Scale Adjusting: Automatic (Scale Range) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-06-08 09:16:18] |
| User278398 - Posts: 291 |
|
hi, the problem that i really have is that: in region 1 (where is the main chart), i "active spreadsheet formula" study which give in this region another chart that i want (=av-bv), i mange it by: scale with "use left scale" in the settings chart and also with changing in the setting study in the "scale" tab, "use in left side scale".... so far so good. now, i want to add some lines which "move" with this left scale which connect to the "spreadsheet formula" study, and i cant make it happen. how can i make line connect to this left scale which connect to this spreadsheet formula study? regards. |
| [2023-06-08 09:23:09] |
| User278398 - Posts: 291 |
|
when i take "Horizontal Lines" and i check the "use in left side scale" (n the "scale" tsb), it still corresponding to the right scale (as main chart) and not to the left scale as i want (as "spreadsheet formula" study) |
| [2023-06-08 18:04:33] |
| John - SC Support - Posts: 36350 |
|
You can only have 1 study that is tied to the Left Side scale. There is no support for exactly what you are wanting to do, except to put the information in a different region, then you can set all the studies to Automatic and they will move with each other using the right-side scale. Refer to the following: Chart Scale and Scale Adjusting: Use In Left Side Scale 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: 2023-06-08 18:05:40
|
| [2023-06-09 08:09:44] |
| User278398 - Posts: 291 |
|
:(
|
To post a message in this thread, you need to log in with your Sierra Chart account: