Support Board
Date/Time: Thu, 27 Feb 2025 22:24:10 +0000
[Programming Help] - LRS value in Spreadsheet lags Correct Chart by 1 bar
View Count: 541
| [2021-07-22 07:18:01] |
| User791263 - Posts: 151 |
|
V2276 Sheet has no unusual nor "signal only on bar close" nor "reset on new bar" settings. Same sheet and settings as 14 charts using that spreadsheet. In 4 years, I may have only once or twice seen this 1 bar lag in sheet vs correct value in subchart (older versions). Pics of chart compared to highlighted sheet line show this better: The EW column, LR Slope, shows .410 at 14:33:10, but the chart is correct giving new down slope -0.077 marked in orange of subject region-2 white dot-dash line peak (3 period slope). On chart, the teal-gold stair step near bottom I marked at correct down tick 33:10. (white crosshair is on prior bar 33:08) LRS, like Lin Reg Channel, calculates after subject line draw. That LRS on the chart is right on. Date Time Of Last Edit: 2021-07-22 13:15:43
|
Private File Private File |
| [2021-07-22 15:24:05] |
| User791263 - Posts: 151 |
|
Diagnostic update: chart update 233 msec, bar size 1 sec: values in Spreadsheet change 3 times per second, but operators/studies applied (here to column AK) operate only upon prior spreadsheet (result in AK) line. I have not yet checked if all studies do that. AK is a weighted sum of AI (an average) and AJ (short summation). Subgraph Multiply, add and LRS all incorrectly operate on prior line. I tried putting AI average (1 of 2 components of AK) to start at prior bar instead of current bar. result: Did not fix the studies lag by 1 bar. Workaround Solution: In the formula columns, I added a LRSlope as SLOPE function against same 3 bars period, as in SE Engineering post Need Example of SLOPE Function for Spreadsheet Column K-X formulas SS Function SLOPE worked great using index reference, and is correct (on-time/ same bar) and that slope (in AN) is exactly 1 bar ahead of the lag-problem LRS study. Proof is: the SLOPE and LRS values are identical, just 1 row off. This proves the 3 studies I looked at operating on a simple (2 component simple formula) are lagging by 1 bar when bars are 1 second. It also proves that a short range summation, or current bar part of avg.-- is not the cause. Date Time Of Last Edit: 2021-07-22 15:42:17
|
To post a message in this thread, you need to log in with your Sierra Chart account: