Login Page - Create Account

Support Board

Date/Time: Sun, 01 Oct 2023 11:44:40 +0000

[Programming Help] - LRS value in Spreadsheet lags Correct Chart by 1 bar

View Count: 353

[2021-07-22 07:18:01]
User791263 - Posts: 147
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: 147
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:


Login Page - Create Account