Guest User | Sign In

Knowledge Base

Anchored VWAP function - AVWAP()

Use the AVWAP() function to create a scan for price crossing above or below an anchored VWAP line. The VWAP anchor can be based off a rolling period, eg last month or change the Look Back Type to Fixed and select a specific date from the calendar.

Blog post: Scripting and Anchored VWAPs

Here's crossing below the AVWAP over the last month:
CLOSE() CrossesBelow AVWAP(BACKTYPE=Month)

To set the anchoring to a specific date:
CLOSE() Crosses AVWAP(BACKTYPE=Fixed, DATE=2020-03-01)

image

To automatically draw the AVWAP from the year's high in a Show Plot tool:

//Define starting date as first trading day of the year;
Start = (BARDATE() == STRDATE(DATE=2020-01-02));
//Find where date matches the Highest High since Dec 31st;
Sig = HIGH() == HIGHESTSINCE(Start);
//Remove Non Zero results to show date of high as latest value;
$DATE = BarDate(NonZero(Sig));
//Calculate VWAP from High Date;
AVWAP(BACKTYPE=Fixed, DATE=$DATE)

Please Wait!

Please wait... it will take a second!