Support Board
Date/Time: Mon, 02 Feb 2026 07:58:14 +0000
Major Bug in Spreadsheet Study Past cell values wrong
View Count: 44
| [2026-02-01 17:29:15] |
| TopGunTrader - Posts: 274 |
|
Hi, I'm creating stats on how far various bars move here is a 60m bar. I put those stat values in column K to W and use those to plot the levels on chart. I noticed when I scrolled back on chart the values are totally wrong! Column K is BIGGER than Column L so when I add those values to Column B the bar's open the result in AA should always be bigger than column AB. It's not! K@3 = 120.92 L@3 = 111 Notice AA@3 is correct and is bigger than AB@3 like it should. Every row below SHOULD have a larger value in column AA than AB but somehow columns after the first are all wrong. Column AA should be B@3+K@3 and Column AB is B@3+L@3. Wrong value show up in every cell I'm looking at. |
 Capture.PNG / V - Attached On 2026-02-01 17:22:26 UTC - Size: 84.29 KB - 7 views |
| [2026-02-01 17:35:42] |
| User509533 - Posts: 90 |
|
Please let us know your Sierra Chart version and operating system.
|
| [2026-02-01 17:51:49] |
| TopGunTrader - Posts: 274 |
|
Here is the chart just one chart and its spreadsheet. Look at Column AA and AB AA should always be high. This might work and be accurate for the first row but rest all appear totally wrong!
|
 SpreadsheetChart.Cht - Attached On 2026-02-01 17:50:51 UTC - Size: 10.51 KB - 3 views |
| [2026-02-01 21:00:57] |
| TopGunTrader - Posts: 274 |
|
Windows 10 Sierra version 2871.
|
| [2026-02-01 21:07:00] |
| TopGunTrader - Posts: 274 |
|
Just downloaded newest 2873 it works now thanks for fixing!
|
To post a message in this thread, you need to log in with your Sierra Chart account: