Login Page - Create Account

Support Board


Date/Time: Wed, 30 Apr 2025 11:08:16 +0000



Post From: Overlay on DOM

[2025-04-24 17:18:03]
John - SC Support - Posts: 39559
The general issue is that you need to get the data you are wanting to view to be displayed at the current bar.

If you are not getting what you want by setting the Study/Price Overlay Input for Match Source Bars to Destination Bars to No, then you would need to use the Spreadsheet Study to get the information to the most current bar.

To do this, you would use a formula like the following:
=MOSTRECENTNONZEROVALUE(ID1.SG1@$3:ID1.SG1@$2000)

There ID1.SG1 is the High (or Low) of the "High/Low for Time Period" study that is covering the overnight session. The "@$3" and @$2000" specify that you are looking within that data from the most current bar (row 3) to the bar at row 2000.

Refer to the following:
Spreadsheet Systems, Alerts and Automated Trading

https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#MOSTRECENTNONZEROVALUE_Function

Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study

Working with Spreadsheets: Relative and Absolute References
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing