Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 16:50:10 +0000



Post From: Alert - VBP - chart values on profile?

[2022-11-10 16:06:35]
John - SC Support - Posts: 36238
The Numbers Bars study will display the data per bar for whatever bar period you have.

With regards to the Cumulative data, there are a number of options if you want to accumulate the data since the start of the trading day - such as Cumulative Delta Bars - Up/Down Tick or Cumulative Sum of Study. But, since you just wan the last 10 bars, you would need to do this using either the Spreadsheet Study or the Spreadsheet Formula study. Which one you choose is really a matter of preference.

In the Spreadsheet Study you would enter the following into row 3 of one of the calculation columns (K-Z by default):
=SUM(ID1.SG1@3:ID1.SG1@12)

Where ID1 is the ID number of the Numbers Bars Calculated Values study and SG1 is the Ask Volume Bid Volume Difference subgraph. The @3 and @12 tells the spreadsheet to start at row 3 and sum the data through row 12 (10 bars of data).

In the Spreadsheet Formula, you would have to do the following:
=ID1.SG1 + ID1.SG1[-1] + ID1.SG1[-2] + ID1.SG1[-3] ...

Where ID1 is the ID number of Numbers Bars Calculated values study and SG1 is the Ask Volume Bid Volume Difference subgraph. The ... would be replace by your repeating the pattern out to ten bars.

Refer to the information for these items at the following links:
Using the Spreadsheet Study

Spreadsheet Formula
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing