Support Board
Date/Time: Sun, 22 Mar 2026 01:25:19 +0000
Post From: Calculation Question in Spreadsheet Study Past cell values wrong
| [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. |
| |
