Login Page - Create Account

Support Board


Date/Time: Thu, 19 Sep 2024 01:44:48 +0000



Post From: VWAP Rolling not updating

[2017-05-04 11:13:15]
psavi73 - Posts: 39
As regards the problem of updating the values of the rolling VWAP far from where they should be, I've made some tests with a 1 minute bar period and the following input data for the function:
Input Data: Last
Base On Underlying Data: Yes
Time Period Type: Days - Trading Days
Time Period Lenght=Number of Days to Calculate= from 1 to 7
Exclude Weekends in Date Look Back: No
Minimum Required Time Period as Percent for Skip Days: 25
Standard Deviation Bands are ignored, i.e. only VWAP is plotted.

Chart1- Time Period Lenght=Number of Days to Calculate= 1
http://www.sierrachart.com/image.php?Image=1493896202623.png
Rolling VWAP is correctly plotted (every point is where it should be).

Chart2- Time Period Lenght=Number of Days to Calculate= 2
http://www.sierrachart.com/image.php?Image=1493896226993.png
Rolling VWAP is correctly plotted (every point, i.e. minute, is present).

Chart3- Time Period Lenght=Number of Days to Calculate= 3
http://www.sierrachart.com/image.php?Image=1493896252237.png
Rolling VWAP is correctly plotted (every point is where it should be).

Chart4- Time Period Lenght=Number of Days to Calculate= 4
http://www.sierrachart.com/image.php?Image=1493896275456.png
Rolling VWAP is correctly plotted (every point is where it should be).

Chart5- Time Period Lenght=Number of Days to Calculate= 5
http://www.sierrachart.com/image.php?Image=1493896302690.png
The points are plotted far from where they should be.

Chart6- Time Period Lenght=Number of Days to Calculate= 6
http://www.sierrachart.com/image.php?Image=1493896330398.png
The points are plotted far from where they should be.

Chart7- Time Period Lenght=Number of Days to Calculate= 7
http://www.sierrachart.com/image.php?Image=1493896357243.png
The points are plotted far from where they should be.

From theese results (failures starts when the time period is => 5 days) I can suppose that the problem is due to weekends (the results are the same also with "Exclude Weekends in Date Look Back"= Yes).