Support Board
Date/Time: Wed, 04 Mar 2026 22:19:09 +0000
Horizontal Lines study additional feature request
View Count: 29
| [2026-03-04 17:54:33] |
| Tooth Fairy - Posts: 84 |
|
I'm currently using this study to display SXP level on my SPX chart using SPX_CGI symbol. It would be very nice to display these levels on an ES chart w/ appropriate level conversion & the differences between SPX & ES can be approximated by using the existed Differences study. To do so, this Horizontal Lines study only needs to add 2 more settings 1) Allowed to copy to other chart. if true, then levels displayed are modified by offset below. 2) Offset. To be manually entered as a constant. Using on ES chart w/ SPX levels entered: All SPX levels will be converted w/ offset. There are a lot of traders using SPX levels to trade in ES futures/options etc. I'm using SC for a longtime, currently using TradingView along w/ SC because ease of access to studies/indicators related to SPX. It's nice if this basic need could be provided by SC. Thank you. |
| [2026-03-04 20:03:01] |
| John - SC Support - Posts: 44944 |
|
What you are asking for is easily done by using two additional studies. The first study is the "Spreadsheet Study". This will allow you to set the offset you want and then adjust the lines. You can set the offset in cell K3 and then use a formula like the following in cells L and beyond depending on how many lines you have: =ID1.SG1@3 + $K$3 Where ID1 is the ID of the Horizontal Lines Study, ID1 is the first subgraph, and @3 indicates row 3 within the Spreadsheet study. Refer to the following: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study You will need to adjust the subgraphs in the Spreadsheet Study to set Column K to "Ignore" and the other columns where you have the lines to "Line". This ensures that the Study/Price Overlay will follow that setup. You can ignore everything, but then you need to specifically set the Study/Price Overlay to allow for changes to the subgraphs and then setup those subgraphs. It really doesn't matter, you just need to understand to ensure you set this up correctly. Then use the "Study/Price Overlay" to overlay the offset lines to the chart you want. Refer to the following: Study/Price Overlay Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-03-04 20:58:08] |
| Tooth Fairy - Posts: 84 |
|
Thanks John for your suggestion but I think it's pretty cumbersome because the levels are mathematically generated based on distribution model so sometime it has a lot of details (a lot of levels) and sometime it has much less details (less levels). It would be much easier & less prone to mistakes by going ONLY into the horizontal line study than instead of doing the changes in Horiz, Spreadsheet & Overlay studies, every day. Unless I misunderstood you. BTW, I'm not the one providing the models so I have no clue how many will be generated the next day in addition to the weekly models. So ease of the change of data is a must. Thank you. |
| [2026-03-04 22:18:18] |
| John - SC Support - Posts: 44944 |
|
Given what you are stating, we would recommend NOT using the Horizontal Lines study, but instead using the Spreadsheet Study. The only downside in this case is that you will be limited to a total of 30 lines - 30 for the SPX and 30 for ES, where the ES lines are offset by the amount you specify. So you would set the Input for "Number of Formula Columns" to be "60". Then columns K through AN would be where you would enter the levels determined for the SPX. Then columns AM through BR would be for the offset lines that you would copy to the ES chart. You could put your "offset" value in cell J3. Then set the "Study/Price Overlay" to only display the lines for columns AM through BR. Each day you would update your lines in columns K through AN for the given levels, setting any column that does not have a line to be blank. This would reflect in the offset columns and hence to your ES chart. -- We do understand why you would want to have an offset in the Horizontal Lines study as well. The above is a workaround that we think would be easier than the horizontal lines study actually. We have set this as a Feature Request to add an offset item to the "Horizontal Lines" study that will add the amount to the entered values to give you the result in the actual subgraphs for that study. But this would mean that you would not have a way to view the original values as lines anywhere. For the most reliable, advanced, and zero cost futures order routing, use 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: