Login Page - Create Account

Support Board


Date/Time: Sat, 11 Jan 2025 14:56:55 +0000



VAP, BVAP, AVAP spreadsheet functions

View Count: 1994

[2016-12-12 18:00:32]
Sawtooth - Posts: 4148
Would you be able to find the time to add VAP, BVAP, AVAP to be able to be used as Spreadsheet Functions?
These are special functions currently only available for Alerts.
Please and thanks in advance.
[2016-12-12 18:14:12]
Sierra Chart Engineering - Posts: 104368
This is not possible because those are designed to reference the chart bar data and the Spreadsheet functions do not have direct access to that.

The closest that is available is this:
Spreadsheet Study Inputs: Output Volume at Price Data
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2016-12-12 19:24:02]
Sawtooth - Posts: 4148
Then can you create new spreadsheet functions that output VAP, BVAP, AVAP values?
For example:
=BVAP(C3) would output the bid volume at the high of the current bar.
[2016-12-12 22:22:18]
Sierra Chart Engineering - Posts: 104368
There is no straightforward way to accomplish this because a Spreadsheet does not have direct access to the underlying chart values.

We really would rather not get involved in this and even if we did, it would not be until later next year.

At this point we recommend using ACSIL instead which has access to this data:
Advanced Custom Study Interface and Language (ACSIL)
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2016-12-12 22:23:20

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

Login

Login Page - Create Account