Support Board
Date/Time: Wed, 27 Nov 2024 04:41:03 +0000
VbP and Numbers Bars in Spreadsheet
View Count: 512
| [2023-09-23 12:06:16] |
| User347921 - Posts: 39 |
|
Hello, I'm testing SC since 10 days or so and I was wondering if there was a simple way to export VbP and Numbers Bars data into a "Spreadsheet System/Alert". I've read this old thread How to Export Numbers Bar Calculated Values to Spreadsheet which says it is possible, then I've found this thread which recommends using ACSIL How to Export Numbers Bar Calculated Values to Spreadsheet which is not simple for those who are new to SC. I've tried method 1 but it exports only PoC, VAH, VAL, VWAP, and a couple of columns from Numbers Bars chart as you can see on the screenshot, despite the fact that I've set Column 1 NB Text to "Bid Vol x Asl Vol" and Column 2 NB Text to "Ask Vol Bid Vol Difference" (as you can see on the screenshot). Is this because I've a " free trial" account or am I missing something? The second thread references Studies8.cpp, which I was able to locate and open, but I didn't find a way to display this study on my chart. How can I display it on a chart please? Thank you and have a nice week-end ahead. |
 Screenshot 2023-09-23 135501.png / V - Attached On 2023-09-23 12:05:06 UTC - Size: 420.27 KB - 112 views Screenshot 2023-09-23 140239.png / V - Attached On 2023-09-23 12:05:13 UTC - Size: 278.69 KB - 93 views |
| [2023-09-25 14:57:47] |
| John - SC Support - Posts: 36309 |
|
There are limited items you can get from a Volume by Price profile and nothing from the Numbers Bars studies into a Spreadsheet. From the VbP, as you have seen, you can get the POC, VAH, VAL, and VWAP. You can also get the Volume at Price data for a period in the Spreadsheet- refer to the following: Spreadsheet Study Inputs: Output Volume at Price Data The references you had found were for the "Numbers Bars Calculated Values", not the "Numbers Bars" study itself. You can get the Numbers Bars Calculated Values in a spreadsheet. Those occur normally, although you may need to adjust some of the outputs depending on the output you are trying to get. Otherwise, to get the underlying VbP and Numbers Bars information, you have to use a Custom Study. Refer to the following: How to Build an Advanced Custom Study from Source Code 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: