Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 17:59:27 +0000



Market Depth Data Recalculate

View Count: 533

[2021-06-23 01:53:50]
User355030 - Posts: 163
Is there a way to recalculate the market depth data after making an update to a formula within a spreadsheet. The only way I can see those calculations of the market depth data (once an update has been made) is if I run the chart in replay. Of course it will start to capture the new calculations going forward, but I would like the old calculations to become visible as well.

@SCE
@tomgilb
[2021-06-23 02:32:41]
Sierra Chart Engineering - Posts: 104368
We need to know specifically what recalculation you are referring to. All chart level market depth data does not require a recalculation.

If you want to recalculate studies that can be done with Chart >> Recalculate.
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: 2021-06-23 02:32:52
[2021-06-23 13:00:33]
User355030 - Posts: 163
@SCE "Chart >> Recalculate" does not do what I am looking for. When I create a custom calculation in a spreadsheet based off of market depth data, anytime a change is made (e.g. changed the plot from "line" to "dash") the calculations of the historical data based off the market depth data clear.
[2021-06-23 14:29:22]
John - SC Support - Posts: 31355
We are not really understanding the particular issue you are trying to convey. If you make a change to something on the Spreadsheet it is going to redo the calculations for all the bars and redisplay that information.

The only thing we can think that you may be referencing is that you may have had older information displayed while new bars were added, but then when the system recalculates the entire spreadsheet, those older data are removed and only the data that matches the number of rows in the Spreadsheet are displayed. This is correct and proper operation. The older data is only there since there has not been any call to redraw that data, therefore it is still present until there is a need to redraw it.

If the above is your issue, then the resolution is to increase the number of rows for the data in the Spreadsheet. Refer to the following:
Spreadsheet Study Inputs: Number of Rows
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-06-23 18:22:08]
User355030 - Posts: 163
@SCE john - let's jump on a phone call.... I can recreate the issue every single time.
[2021-06-23 19:13:55]
John - SC Support - Posts: 31355
When is a good time for us to call?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-06-23 19:28:52]
User355030 - Posts: 163
can you talk right now? @SCE
[2021-06-23 19:40:09]
John - SC Support - Posts: 31355
Calling now via Skype.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-06-23 20:13:09]
John - SC Support - Posts: 31355
Called and talked with customer and explained that the data is not being calculated for all the bars in the chart, only the current bar is being calculated, and when it triggers a true value, that information is displayed until a full recalculation is done.
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:

Login

Login Page - Create Account