Support Board
Date/Time: Sat, 21 Mar 2026 23:50:19 +0000
Calculation Question in Spreadsheet Study Past cell values wrong
View Count: 157
| [2026-02-01 17:29:15] |
| TopGunTrader - Posts: 285 |
|
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 - 38 views |
| [2026-02-01 17:35:42] |
| User509533 - Posts: 97 |
|
Please let us know your Sierra Chart version and operating system.
|
| [2026-02-01 17:51:49] |
| TopGunTrader - Posts: 285 |
|
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 - 31 views |
| [2026-02-01 21:00:57] |
| TopGunTrader - Posts: 285 |
|
Windows 10 Sierra version 2871.
|
| [2026-02-01 21:07:00] |
| TopGunTrader - Posts: 285 |
|
Just downloaded newest 2873 it works now thanks for fixing!
|
| [2026-02-02 16:14:43] |
| Sierra_Chart Engineering - Posts: 23288 |
|
Post #1 is impossible for us to understand, unless we get the spreadsheet, and we just need one example of what cell is incorrect and we will check it. We did not do anything: Just downloaded newest 2873 it works now thanks for fixing!
Also maybe the issue is related to this: Chart Studies: Study Calculation Precedence And Related Issues And we are renaming this thread. There is not a major bug. This would be very very unlikely. Essentially next to impossible. 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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2026-02-02 16:21:36
|
To post a message in this thread, you need to log in with your Sierra Chart account: