Support Board
Date/Time: Sun, 02 Feb 2025 08:56:29 +0000
Post From: Spreadsheet formula study discrepancies
| [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 - 265 views withotherstudy.jpg / V - Attached On 2019-08-26 10:51:57 UTC - Size: 110.44 KB - 316 views afterrecalc.jpg / V - Attached On 2019-08-26 10:59:40 UTC - Size: 90.86 KB - 328 views |