Support Board
Date/Time: Mon, 25 Nov 2024 06:30:06 +0000
With new versions shifting I,J cells in spread sheet studies - how to reference J cells?
View Count: 288
| [2024-03-20 10:54:56] |
| pkhst958 - Posts: 57 |
|
As I have noticed, with new versions SC has started the habit of shifting the rows of the I and J cells in the spread sheet studies. I reference these like (Attached Order Stop Offset with J85). Consequently with each new version of SC I am in a mess. Can I reference the values in the J cells using a name instead eg J85?
|
| [2024-03-20 16:23:33] |
| John - SC Support - Posts: 36238 |
|
Pick the version you want to use, either the new or old. There is an Input for this on the Spreadsheet Studies named "Use Column I and J Values Version 2". Spreadsheet Study Inputs: Use Column I and J Values Version 2 Also refer to the Input just below the one above. This will clear out the Column I values if you changed the previous setting. Worst case, you can also delete all the values in columns I and J and then select "Chart >> Reload and Recalculate" and this will repopulate those cells based on the version that is set to use. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-03-21 08:34:30] |
| pkhst958 - Posts: 57 |
|
Thanks :)!! So there are only 2 lay outs, not a new one per update. Where do I find the setting for "Spreadsheet Study Inputs: Use Column I and J Values Version 2". I have followed the link, but was unable to locate the setting in sc.
|
| [2024-03-21 08:47:17] |
| Sierra_Chart Engineering - Posts: 17172 |
|
Of course this is not changing per version. That would not make sense. Over a span of 15 years there has only been two different configurations. The second one only came recently. If you do not see this new Input, it means the version you have does not support it. 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: 2024-03-21 08:47:34
|
| [2024-03-21 15:54:52] |
| John - SC Support - Posts: 36238 |
|
The order of the information in our documentation is the order of the Inputs on the settings for the study. So the Input for "Use Column I and J Values Version 2" would be located just under the Input for "Minimum Chart Bars Required For Entry Exit Cell Evaluation". As noted in the previous post, if you do not have this option, then you are not on a version that supports the new format. In which case, you should not have any issue with the layout changing. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-03-22 10:21:21] |
| pkhst958 - Posts: 57 |
|
Thanks, got it!
|
To post a message in this thread, you need to log in with your Sierra Chart account: