Support Board
Date/Time: Sun, 02 Feb 2025 06:41:12 +0000
Spreadsheet formula study discrepancies
View Count: 971
| [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
|
 before.jpg / V - Attached On 2019-08-22 12:52:08 UTC - Size: 74.46 KB - 342 views |
| [2019-08-22 17:43:18] |
| |
|
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
|
| nostudy.jpg / V - Attached On 2019-08-26 10:51:49 UTC - Size: 76.66 KB - 264 views withotherstudy.jpg / V - Attached On 2019-08-26 10:51:57 UTC - Size: 110.44 KB - 315 views afterrecalc.jpg / V - Attached On 2019-08-26 10:59:40 UTC - Size: 90.86 KB - 327 views |
| [2019-08-27 02:31:41] |
| |
|
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 |
| historical bars being reploted.jpg / V - Attached On 2019-09-02 08:54:55 UTC - Size: 83.19 KB - 296 views |
To post a message in this thread, you need to log in with your Sierra Chart account: