Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 11:43:09 +0000



Spreadsheet formula study discrepancies

View Count: 894

[2019-08-22 12:52:19]
User132748 - Posts: 159
There are big discrepancies when using Spreadsheet formula study with Depthbars study on live data. After reloading chart those discrepancies disappear.

Screenshot BEFORE show original depthbars study as light gray fat candles, and overlayed hollow candles above them is simple spreadsheet study using straight OHLC values of depthbars study.

Screenshot AFTER is the same chart after reloading.

What is the reason of those discrepancies? Spreadsheet study has "Very Low Precedence" and Depthbars study has "Standard Precedence", so spreadsheet formula shouldnt have different values!
Date Time Of Last Edit: 2019-08-22 12:53:28
imagebefore.jpg / V - Attached On 2019-08-22 12:52:08 UTC - Size: 74.46 KB - 318 views
imageafter.jpg / V - Attached On 2019-08-22 12:52:14 UTC - Size: 70.42 KB - 305 views
[2019-08-22 17:43:18]
Sierra Chart Engineering - Posts: 104368
This will be solved in the next release.
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
[2019-08-26 10:55:33]
User132748 - Posts: 159
I see you made an update addressing this issue. Unfortunately the solution is rather dirty, cause you recalculate previous bar after new bar is already being ploted. Markets dont go backwards right?

Nevertheless problem of wrong values being used by spreadsheet formula is still present when there are other studies on the chart.

First screenshot is clean chart just with only Depthbars study and Spreadsheet formula study. Spreadsheet study seems correct (despite the fact that recalculation after new bar is already plotted...)

But second screen is the same chart with just Volume study added. All gets messed up again as it was in previous builds and spreadsheet study still has wrong values! Even though that delayed recalculation.

After recalculating the chart all gets to normal - third screenshot. The problem is only with live data.
Date Time Of Last Edit: 2019-08-26 11:00:19
imagenostudy.jpg / V - Attached On 2019-08-26 10:51:49 UTC - Size: 76.66 KB - 244 views
imagewithotherstudy.jpg / V - Attached On 2019-08-26 10:51:57 UTC - Size: 110.44 KB - 292 views
imageafterrecalc.jpg / V - Attached On 2019-08-26 10:59:40 UTC - Size: 90.86 KB - 303 views
[2019-08-27 02:31:41]
Sierra Chart Engineering - Posts: 104368
This will be resolved in the next release and was due to a low level problem with determining calculations to start at an earlier index that has been there all along which occurs under certain circumstances.
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: 2019-08-27 02:31:54
[2019-09-02 08:58:45]
User132748 - Posts: 159
New update gets all spreadsheet study being updated with correct chart values which is nice, but historical depthbars are still being reploted.

PLease look at screenshot. At first bar #1 is wide range bar that is obviously closed, because bar #2 is already plotted having OPEN value -748. Then out of sudden bar #1 gets reploted and becomes a spikey pinbar and also bar #2 OPEN value is CHANGED from -748 to -799.

As I said earlier, markets dont go backwards, so I guess you shouldnt be reploting historical bars too right? Thanks
imagehistorical bars being reploted.jpg / V - Attached On 2019-09-02 08:54:55 UTC - Size: 83.19 KB - 271 views

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account