Support Board
Date/Time: Fri, 10 Jan 2025 22:57:30 +0000
Post From: Bug? Spreadsheet OHLC Overlay LAST Chart Last
| [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 |