Login Page - Create Account

Support Board


Date/Time: Fri, 03 May 2024 02:24:07 +0000



[User Discussion] - OHLC Overlay has Brief Zeroes on Bar Change

View Count: 875

[2016-08-23 13:16:19]
User791263 - Posts: 151
All Zeroes in top spreadsheet line of OHLC is only seen when running SLOW SIM (0.2 speed or less), only on OHLC Overlay at Bar change.

Over 6 months, I've seen this a few times, but tried to ignore it.
I lately traced rare unwanted autotrade orders to this brief condition lasting part of 1-second.
See Attached picture from Spreadsheet.

I use 1-second updates, intraday spreadsheet-autotrade, on change of 30-sec bar.

Unlke Study Overlay, OHLC has no "Fill Blank Values with last Value" setting (which should be default).
See attached pic.

Shouldn't zeroing-out fields not be done? (because data can be delayed due to computing Avg HLC, etc)
Instead, just overwrite prior OHLC values with new?
The data lag to see this might only occur with large systems (like my 47 charts+ several spreadsheets).

I mentioned this about 5 months ago, but more-needed a slower SIM, which you added (which helped discover this).
imageSpreadShtVeryBriefZerosInRow1-02.jpg / V - Attached On 2016-08-23 13:15:48 UTC - Size: 361.24 KB - 251 views
[2016-08-23 13:27:12]
User791263 - Posts: 151
Note: I allow Intrabar trades:

Multiple entries same direction YES
Signal Once Per Bar YES
Allow Entry with Working Orders YES
Signal Only on Bar Close NO

The rare "ghost" order due to OHLC zeroes at bar change might not appear when using Signal Only on Bar Close.
[2016-08-23 13:49:39]
User791263 - Posts: 151
This seems to occur ONLY on OHLC of a Few Studies, mainly Sum Charts from List
(and a very-similar Custom Study I have).

Attached: better picture showing Name of Study being OHLC Overlayed
imageSpreadShtVeryBriefZerosInRow1-03.jpg / V - Attached On 2016-08-23 13:49:07 UTC - Size: 395.65 KB - 220 views
[2016-08-23 13:53:03]
Sawtooth - Posts: 3992
You could create you own 'fill blanks with last value' using a spare Formula Column with a formula like this, e.g. in P3:
=IF(ID10.SG1@3>0,ID10.SG1@3,P4)
[2016-08-23 20:03:40]
User791263 - Posts: 151
Good idea,but for all 7 OHLC fields that requires 14+ temp fields, and may not write again to top line until next update data event or chart update/write interval (ie: 480 msec).

I have a different work-around, but others might want "Sum Charts from List" to behave like other OHLC Overlay studies, at bar change.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account