Login Page - Create Account

Support Board


Date/Time: Sat, 20 Apr 2024 07:35:56 +0000



BVAP inconsistent result

View Count: 214

[2022-11-21 13:23:18]
PhiX - Posts: 34
=BVAP(L + TICKSIZE * 1, 0) >50 * AVAP(L + TICKSIZE * 1, 0)

This (below) should alert the bar AFTER the above alert...correct?

=BVAP(L + TICKSIZE * 1, -1) >50 * AVAP(L + TICKSIZE * 1, -1)

It doesn't. See pics.
Attachment Deleted.
imageoffset.jpg / V - Attached On 2022-11-21 13:20:25 UTC - Size: 122.56 KB - 49 views
imageNo offset.jpg / V - Attached On 2022-11-21 13:20:31 UTC - Size: 127.65 KB - 48 views
[2022-11-21 18:53:34]
John - SC Support - Posts: 30976
We had to do some tests to figure out what is occurring, but it turns out that the Offset does not work in the way that you are thinking. It does give the volume value at the previous bar, but the price level is the level of the current bar, not the offset bar.

For example, if the low of the current bar is 3950.00 and you have a Bid volume of 20, when you put in the offset of -1, it does not return the Bid volume at the low of the previous bar, rather it returns the Bid volume at the price of 3950.00 at the previous bar.

In order to do what you are wanting - you need to reference the Low of the previous bar by adding a [-1] to the L. So your formula would look like the following:
=BVAP(L[-1] + TICKSIZE * 1, -1) >50 * AVAP(L[-1] + TICKSIZE * 1, -1)
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-11-21 19:07:21]
PhiX - Posts: 34
Thanks...about an hour after posting a light bulb went off and I suspected that's what was happening.
I tested and that's the answer.

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

Login

Login Page - Create Account