Support Board
Date/Time: Fri, 10 Jan 2025 23:03:34 +0000
Bug? Spreadsheet OHLC Overlay LAST Chart Last
View Count: 1028
| [2016-09-29 16:01:13] |
| User791263 - Posts: 151 |
|
That Title above left out symbols "<>"; Should read Spreadsheet OHLC LAST NOT EQUAL to Chart LAST I just renewed my non-broker SC acct.. Hope helps get this worked on (I also have credit on broker acct.(for services)) V-1457, Spreadsheet trading. I've developed over a year,daily,& know SC well; I never noticed this; because OHLC Overlay is usually Correct on Spreadsheet. I saw this only because the pertinent bar was near the spreadsheet columns as I was about to tweak it (pausing a LIVE Market date feed). ERROR: LAST on Chart bar= CORRECT. HLC Average in Spreadsheet= CORRECT. LAST in Sprdsht = HIGH. Confirmed by 1) Calculate: Average of Chart Bar 2 Compare to: Average HLC in Spreadsheet Result: Those MATCH & are Correct in relation to price+indicators also. But LAST in the Spreadsheet displays HIGH . I don't know how to reproduce this; It may be rare. Source of OHLC Overlay is a 4-Second chart receiving from Col-AC of 28-sec Target chart. ie: 20-Column Work Columns- Col-19=AC feeds 4 Sec Chart which feeds back to original Source as OHLC Overlay. (I do this elsewhere, works fine). Attached is Picture of this. Note in such pic, in the Chart OHLC study just above the subject one, the Spreadsheet does match the Chart. It feeds from a different Source Chart (synched to same Source chart above) via a different fast chart. This may imply: Having the same source sheet also as the final target of the OHLC could be the unique condition of this (as well has having an exact sub-multiple time frame: 28/4). Note: The subsequent OPEN of 2163.717 is near correct Chart Last of 64.68, so the Correct LAST is always kept in the program & the Chart, just not written to the spreadsheet. There is no timing issue between the Source-Target-Target: The 4-sec chart matches target chart open, movement & next bar open values exactly, to the second. Date Time Of Last Edit: 2016-09-29 17:41:10
|
Private File |
| [2016-09-29 19:52:32] |
| User791263 - Posts: 151 |
|
I've been watching second-by-second updates. (1-sec Update setting). When LIVE feed is a bit fast(today), the HIGH in the Spreadsheet (Not the Chart!) drops back from actual Chart HIGH (it drops back down in spreadsheet, tracking LAST).. SOMETIMES for 2 to 4 updates. ie: The compare to prior-update-high in spreadsheet lags. Chart updating has Processing priority versus compare spreadsheet high vs prior-update-high. Yesterday on Simulation at 10X speed, I noticed every bar on study above this one end at 0, not actual Last. I thought I broke my system, but slowed to 3X, it was perfect. Maybe all of this is due to SC Processing priorities in a large system like mine (49 charts, half with 20-40 studies, 9 spreadsheets, many overlayed studies. - - - Pls suggest what to trim or change first to help this lag. Tell me if my guess on processing Priority is correct. I've always followed SC PERFORMANCE-Page suggestions. Chart drawing is high-priority, largest resource. My updates are 320 to 480ms. 1 sec Storage. 8000 Time&Sales records on 1 Symbol. Total 20 Symbols. No Chart Depth (2 depth studies) Normal Spreadsheet lines 800-1600. 4 Sheets use 120+ columns 5 Volume at Price studies looking back 30-60 bars. I could hide a few more Charts and/or studies. I can't remove any studies at this complexity of precedence, overlays, sheets & formulas. Date Time Of Last Edit: 2016-09-29 20:42:47
|
| [2016-09-30 04:28:16] |
| |
|
There is no way at all we can possibly understand the vast majority of what you are saying. It is mostly meaningless. This would have to be a paid support request to analyze this in detail, and we really do not have time to get into this unless we believe there is a clear and straightforward issue to resolve. It is not likely we can even schedule this until about six months to a year from now and the cost estimate would be about 150 USD based upon a simple working example. Otherwise, this could cost in the thousands and it is not something we would want to get involved with anyway. If you think this might be the problem: Maybe all of this is due to SC Processing priorities in a large system like mine
Then you might want to use Controlled Order Chart Updating: General Settings Window: Use Controlled Order Chart Updating (Global Settings >> General Settings >> Charts >> Charts) Pls suggest what to trim or change first to help this lag. Using ACSIL instead of spreadsheets will be the most efficient:Advanced Custom Study Interface and Language (ACSIL) 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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2016-09-30 04:48:24
|
| [2016-09-30 15:31:26] |
| User791263 - Posts: 151 |
|
Thanks for that estimate. I'll study Controlled Order updating. I trimmed Spreadsheet records back,Time-Sales, Chart size, Hid 2 more charts. --seems to help; Precedence & Resources trimming looks like the solution. Last Question, on SC Resource Priorities: Please guess: How do these compare on resource use? 1) Hide Studies vs. 2) Hiding entire chart? ie: Do you think setting 4 of 8 studies to Hide (preferable) might ease resources around 1/3 as much as Hiding the Chart? (or a much smaller effect, like 10% ?) You say spreadsheets take a lot, so I'll cut # of records to: 2x longest study ((2 X Moving Avg. Length) +10% ) should make the next biggest difference. Date Time Of Last Edit: 2016-09-30 21:09:29
|
| [2016-09-30 20:06:57] |
| User791263 - Posts: 151 |
|
I tried Controlled order Updating. As it warned, the interfaced froze up a lot. But I noticed a General Setting: Use Non-Chart Data from Remote Instances. That might be useful in this manner: Normally multiple instances use 2 broker accounts, right? Have you considered any way to use a broker-instance as server to a non-Broker (SC) "client" instance, where one might do controlled-order and the other be the faster charts & trade execution? |
To post a message in this thread, you need to log in with your Sierra Chart account: