Support Board
Date/Time: Mon, 12 May 2025 13:53:10 +0000
[User Discussion] - Spreadsheet Last on OHLC not matching Chart
View Count: 938
| [2017-02-08 19:37:24] |
| User931283 - Posts: 55 |
|
I've seen this before, not often: Would appreciate suggestions of possible cause(s). A copy of spreadsheet would do you no good: 50 charts+ 8 Spreadsheets feed this last sheet. Spreadsheet "Last" at End of Bar doesn't match Chart EndofBar (Indicator, Subgrph 2). See pictures. Bar 28 or 30 seconds Bar = 8:24:00AM High is = 3.26 Sheet Last = 3.23 Chart last = 1.92 (Black window shows prior bar, 8:23:32) This is my main Master Chart, sheet & Subchart. Measure of Pullback from OHLC high is Crucial. I've tweaked update timing for a year; Most all else seems on time & accurate. Global update setting is 498ms (Quote board=700,I dont use) 50 charts funnel down to this main one, set 324ms. Fast (1-2 Second) charts feed intermediates, like this one. (I mention timing as possibly relevant to issue). Intraday, intrabar 1 sec Storage unit. PC is at limit for scalping, but does not lag. This occurs in Accurate Back Test (not sure if does in live feed). Guessing possibilities? 1) Maybe fast charts (1-2 seconds) feeding this OHLC need speeding up to about X .4 of this sheet (150ms), or or 2) 1-Second Storage unit may be making sub-bar timing inaccurate on testing (but this 28-sec bar should work), or 3) An old overlooked SC priority bug between chart vs spreadsheet updates, that rarely occurs. - - - - UPDATED Thurs. I now recall seeing this 8 or 10 months ago. On another test occurrance (in SIM) I see the Spreadsheet holding the HIGH reading in the LAST field, but the chart again shows correct actual LAST. The subsequent bar's fields are fine, LAST matching the chart in the spreadsheet. The Chart is always correct & matches the data. Date Time Of Last Edit: 2017-02-10 01:43:21
|
 SpreadSht-LastNoMatchChartOHLC-020817.jpg / V - Attached On 2017-02-08 19:35:24 UTC - Size: 127.79 KB - 297 views SpreadSht-LastNoMatchChartOHLC-020817-Chart-Different-Ahead.jpg / V - Attached On 2017-02-08 19:35:39 UTC - Size: 97.18 KB - 338 views |
| [2017-02-08 19:40:46] |
| User931283 - Posts: 55 |
|
Maybe I could test when in the 28-sec bar the divergence of Last from High in each occurs, by watching both in slow motion, 0.1 speed.
|
To post a message in this thread, you need to log in with your Sierra Chart account: