Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 18:25:31 +0000



Overlaying the non-zero subgraph from one numbers bar chart to another

View Count: 308

[2023-10-30 10:39:58]
User588795 - Posts: 5
Hi SC,
I'm trying to overlay the non-zero subgraph of the numbers bars study from one chart onto another. They're both essentially the same chart - same symbol, same bar period, etc the only difference is that one chart has double the tick size of the other (0.5 vs 0.25). I'm primarily looking at the chart with the 0.5 tick size, but I much prefer knowing when the non-zero highlight pops off on the 0.25 tick sized chart (I find it more relevant to how I trade).

Thus far I'm unable to get the subgraph to display on the 0.5 chart (I'm using 'study/price overlay'). Appreciate any pointers on how I can set this up properly.

To summarize:
Chart A has 0.25 tick size
Chart B has 0.5 tick size, and where I'd like to view Chart A's non-zero highlight whenever they occur

If it helps with finding a solution, pls know that I don't need the highlight to appear on the bar itself as it normally does on the numbers bars - all I need is a visual guide eg a dot appearing above or below the bar depending on which end it occurs.

Due to lack of screen real estate, I can't have both charts at the foreground of the screen at the same time.
[2023-10-30 16:08:35]
John - SC Support - Posts: 36300
There is not a way to get this information from the Numbers Bars study to another chart using the built-in tools. The Subgraph for that item is there just to set the colors, the data itself for the highlight is not available.

You would have to use two copies of the Spreadsheet Formula on your .25 tick chart to start and use this to find your non-zero volumes at the High/Low. Your formula to test the high would look like the following:
=IF(AND(BVAP(H, 0) <> 0, AVAP(H, 0) <> 0), H, 0)

The reason to use the IF statement is to have the result be the high price so you can put a marker at that level using the Spreadsheet Formula.

You would then use the "Study/Price Overlay" to overlay that result to the .5 tick chart.

Refer to the following:
Study/Chart Alerts And Scanning: Special Functions

Spreadsheet Formula

Study/Price Overlay Study
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing

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

Login

Login Page - Create Account