Support Board
Date/Time: Sat, 19 Apr 2025 08:48:28 +0000
Post From: HOW TO REFERENCE A PREVIOUS SUBGRAPH?
[2025-03-31 17:48:00] |
John - SC Support - Posts: 39362 |
Assuming that you are using multiple profiles in a single Volume by Price study, the discontinuity in the data is what you need to find the previous value. To do this for the Value Area High, add the Spreadsheet Study to the chart and in cell K3 enter the following formula: =IF(ID1.SG3@3 <> ID1.SG3@4, ID1.SG3@4, 0) Then enter the following in cell L3: =MOSTRECENTNONZEROVALUE($K$3:$K$1000) Where ID1 is the ID of the Volume by Price study and SG3 is the Volume Area Area High subgraph. This now gives you the value of the previous Value Area High in cell L3. You can then use this as you want. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |