Support Board
Date/Time: Mon, 25 Nov 2024 22:26:11 +0000
Feature request for Spreadsheet Formula Study
View Count: 403
| [2023-10-11 21:16:00] |
| AndyB - Posts: 101 |
|
I would like to propose a feature request for the Spreadsheet Formula Study that would allow "Number of Bars To Calculate (ln:2)" to also accept formulas. I prefer using multiple spreadsheet formula studies as opposed to the "Spreadsheet Study" for a variety of reasons. Letting this input accept a formula would allow one to reference another study (perhaps a separate spreadsheet) the same way the formula input does, to dictate the number of bars calculated for some, or even all, spreadsheets they have working off of each other. I do my building of systems on a pretty short calculation number, and then actual analysis on longer calcs. For 1. it would be a heck of a lot quicker to change one number rather than going through all of them (could even over lay that parent study onto other charts with spreadsheet studies as well), and 2. admittedly when changing this input, sometimes I miss one or two of them. I'm not sure if this easy to do or even possible, but I thought that would be a nice addition. Of course, a custom study is the answer here, but there's a lot of rabbit holes that lead to nothing, and hashing out ideas through the study is much more convenient, especially for those of us who aren't quick coders. Thank you. Side question: any tips for improving the latency of "Study/Price Overlay"? often times these are updating >500ms and it throws off some calculations on my parent chart if I'm overlaying something like the depth study from a chart with a higher number of levels to build the book. Advice is appreciated! |
| [2023-10-12 14:22:40] |
| John - SC Support - Posts: 36283 |
|
With any feature request, we can not say when (or if) we will get to it. We understand the requests, but due to the number of items we are working on, we simply can not say when it will occur. With regards to the Study/Price Overlay, we recommend setting the option for "Global Settings >> General Settings >> Charts >> Use Controlled Order Chart Updating" to "Yes". There is not a way to improve the time for the Study/Price Overlay calculation, but enabling this option should resolve the particular issue you are having. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-02-02 03:20:01] |
| Sierra_Chart Engineering - Posts: 17175 |
|
Regarding the feature request, you can accomplish all of this with ACSIL because you can evaluate spreadsheet formulas with this function: sc.EvaluateGivenAlertConditionFormulaAsDouble() This is very hard for us to analyze: Side question: any tips for improving the latency of "Study/Price Overlay"? often times these are updating >500ms and it throws off some calculations on my parent chart if I'm overlaying something like the depth study from a chart with a higher number of levels to build the book. Advice is appreciated!
Best you create your own custom study to do exactly what you need.
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: